Subversion Repositories SmartDukaan

Rev

Rev 150 | Rev 203 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
144 ashish 1 
'''
2 
Created on 12-May-2010
3 
 
4 
@author: gaurav
5 
'''
6 
 
7 
from elixir import *
8 
 
9 
class PhoneItem(Entity):
10 
    url = Field(String(1000))
11 
    name = Field(String(50))
12 
    price = Field(Integer)
13 
    source = Field(String(100))
14 
    is_crawled = Field(Boolean)
15 
    phones = ManyToOne("Phones")
16 
 
17 
    def __repr__(self):
18 
        return "%s %s" %(self.url, self.name)
19 
 
20 
class Phones(Entity):
21 
    vendor = Field(String(100))
22 
    base_url = Field(String(1000))
23 
    items = OneToMany("PhoneItem")
24 
 
25 
class Vendor(Entity):
26 
    v_name = Field(String(100))
27 
    v_url = Field(String(1000))
28 
 
29 
class infibeam_data(Entity):
30 
    name = Field(String(100))
31 
    shown_price = Field(Integer)
32 
    final_price = Field(Integer)
150 ashish 33 
 
34 
class univercell_data(Entity):
35 
    v_name = Field(String(100))
36 
    v_site = Field(String(1000))
37 
 
38 
class univercell_items(Entity):
39 
    p_title = Field(String(100))
40 
    p_shown_price = Field(Integer)
41 
    p_final_price = Field(Integer)
173 ashish 42 
 
43 
class indiaplaza_data(Entity):
44 
    v_name = Field(String(100))
45 
    v_site = Field(String(1000))
150 ashish 46 
 
173 ashish 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))
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 
 
144 ashish 105 
def init():
173 ashish 106 
    #metadata.bind = "sqlite:///phones.sqlite"
107 
    metadata.bind = "mysql://root@localhost/phonecrawler"
144 ashish 108 
    metadata.bind.echo = True
109 
    setup_all(True)
173 ashish 110 
    pass
144 ashish 111 
 
112 
 
113 
if __name__ == "__main__":
114 
   init()