Subversion Repositories SmartDukaan

Rev

Rev 150 | Rev 203 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 150 Rev 173
Line 37... Line 37...
37
    
37
    
38
class univercell_items(Entity):    
38
class univercell_items(Entity):    
39
    p_title = Field(String(100))
39
    p_title = Field(String(100))
40
    p_shown_price = Field(Integer)
40
    p_shown_price = Field(Integer)
41
    p_final_price = Field(Integer)
41
    p_final_price = Field(Integer)
-
 
42
 
-
 
43
class indiaplaza_data(Entity):    
-
 
44
    v_name = Field(String(100))
-
 
45
    v_site = Field(String(1000))
-
 
46
    
-
 
47
class indiaplaza_items(Entity): 
-
 
48
    p_name = Field(String(100))   
-
 
49
    p_shown_price = Field(Integer)
-
 
50
    p_final_price = Field(Integer)
-
 
51
    p_guaranteeinfo = Field(String(100))
-
 
52
    p_shipinfo = Field(String(100))
-
 
53
    
-
 
54
class themobilestoreurls(Entity):
-
 
55
    url = Field(String(1000))
-
 
56
    
-
 
57
class themobilestorephones(Entity):
-
 
58
    name = Field(String(100))
-
 
59
    shown_price = Field(Integer)
-
 
60
    final_price = Field(Integer)
-
 
61
 
-
 
62
class naaptolurls(Entity):
-
 
63
    url = Field(String(1000))   
-
 
64
 
-
 
65
class morenaaptolurls(Entity):
-
 
66
    url = Field(String(1000)) 
-
 
67
    
-
 
68
class naaptolphones(Entity):      
-
 
69
    name = Field(String(100))
-
 
70
    range = Field(String(100))
-
 
71
    
-
 
72
class ntonlinesp(Entity):
-
 
73
    nid = Field(Integer)
-
 
74
    name = Field(String(100))
-
 
75
    price = Field(Integer)
-
 
76
    
-
 
77
class ntofflinesp(Entity):
-
 
78
    nid = Field(Integer)
-
 
79
    name = Field(String(100))
-
 
80
    price = Field(Integer)
-
 
81
 
-
 
82
            
-
 
83
class suppliers(Entity):
-
 
84
    name = Field(String(100))
-
 
85
    site = Field(String(100))
-
 
86
    last_crawled = Field(DATE(100))
-
 
87
    
-
 
88
class models(Entity):
-
 
89
    brand = Field(String(100))
-
 
90
    model = Field(String(100))
-
 
91
    
-
 
92
class guarantee_info(Entity):
-
 
93
    mid = Field(Integer)
-
 
94
    guaranteeinfo = Field(String(100))
-
 
95
    shipinfo = Field(String(100))
42
    
96
    
-
 
97
  
-
 
98
class prices(Entity):
-
 
99
    supplier_id = Field(Integer)
-
 
100
    mobile_id = Field(Integer)
-
 
101
    quoted_price = Field(Integer)  
-
 
102
    final_price = Field(Integer)
-
 
103
    extra_info = Field(String(1000))
-
 
104
        
43
def init():
105
def init():
44
    metadata.bind = "sqlite:///phones.sqlite"
106
    #metadata.bind = "sqlite:///phones.sqlite"
-
 
107
    metadata.bind = "mysql://root@localhost/phonecrawler"
45
    metadata.bind.echo = True
108
    metadata.bind.echo = True
46
    setup_all(True)
109
    setup_all(True)
-
 
110
    pass
47
 
111
 
48
 
112
 
49
if __name__ == "__main__":
113
if __name__ == "__main__":
50
   init()
114
   init()
51
115