Subversion Repositories SmartDukaan

Rev

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 
 
238 ashish 9 
#flag = False
10 
 
144 ashish 11 
class PhoneItem(Entity):
12 
    url = Field(String(1000))
13 
    name = Field(String(50))
14 
    price = Field(Integer)
15 
    source = Field(String(100))
16 
    is_crawled = Field(Boolean)
17 
    phones = ManyToOne("Phones")
18 
 
19 
    def __repr__(self):
20 
        return "%s %s" %(self.url, self.name)
21 
 
22 
class Phones(Entity):
23 
    vendor = Field(String(100))
24 
    base_url = Field(String(1000))
25 
    items = OneToMany("PhoneItem")
26 
 
27 
class Vendor(Entity):
28 
    v_name = Field(String(100))
29 
    v_url = Field(String(1000))
30 
 
31 
class infibeam_data(Entity):
32 
    name = Field(String(100))
33 
    shown_price = Field(Integer)
34 
    final_price = Field(Integer)
150 ashish 35 
 
36 
class univercell_data(Entity):
37 
    v_name = Field(String(100))
38 
    v_site = Field(String(1000))
39 
 
40 
class univercell_items(Entity):
41 
    p_title = Field(String(100))
42 
    p_shown_price = Field(Integer)
43 
    p_final_price = Field(Integer)
173 ashish 44 
 
45 
class indiaplaza_data(Entity):
46 
    v_name = Field(String(100))
47 
    v_site = Field(String(1000))
150 ashish 48 
 
173 ashish 49 
class indiaplaza_items(Entity):
50 
    p_name = Field(String(100))
51 
    p_shown_price = Field(Integer)
52 
    p_final_price = Field(Integer)
53 
    p_guaranteeinfo = Field(String(100))
54 
    p_shipinfo = Field(String(100))
55 
 
56 
class themobilestoreurls(Entity):
57 
    url = Field(String(1000))
58 
 
59 
class themobilestorephones(Entity):
60 
    name = Field(String(100))
61 
    shown_price = Field(Integer)
62 
    final_price = Field(Integer)
63 
 
238 ashish 64 
class themobilestorephones_new(Entity):
65 
    name = Field(String(100))
66 
    shown_price = Field(Integer)
67 
    final_price = Field(Integer)
68 
    extra_info = Field(String(1000))
69 
 
70 
 
71 
class extra_vars(Entity):
72 
    var = Field(String(100))
73 
    val = Field(String(100))
74 
    desc = Field(String(1000))
75 
 
76 
class pricesbolourls(Entity):
77 
    url = Field(String(1000))
78 
 
79 
class pricesbolophones(Entity):
80 
    name = Field(String(100))
81 
    shown_price = Field(Integer)
82 
    final_price = Field(Integer)
83 
 
173 ashish 84 
class naaptolurls(Entity):
85 
    url = Field(String(1000))
86 
 
87 
class morenaaptolurls(Entity):
88 
    url = Field(String(1000))
89 
 
90 
class naaptolphones(Entity):
91 
    name = Field(String(100))
92 
    range = Field(String(100))
93 
 
94 
class ntonlinesp(Entity):
95 
    nid = Field(Integer)
96 
    name = Field(String(100))
97 
    price = Field(Integer)
98 
 
99 
class ntofflinesp(Entity):
100 
    nid = Field(Integer)
101 
    name = Field(String(100))
102 
    price = Field(Integer)
103 
 
238 ashish 104 
class babuchak_urls(Entity):
105 
    url = Field(String(100))
106 
    no_pages = Field(Integer)
173 ashish 107 
 
238 ashish 108 
class babuchak_phoneurls(Entity):
109 
    url = Field(String(100))
110 
 
111 
class babuchak_phones(Entity):
112 
    name = Field(String(100))
113 
    shown_price = Field(Integer)
114 
    final_price = Field(Integer)
115 
 
173 ashish 116 
class suppliers(Entity):
117 
    name = Field(String(100))
118 
    site = Field(String(100))
119 
    last_crawled = Field(DATE(100))
120 
 
121 
class models(Entity):
122 
    brand = Field(String(100))
123 
    model = Field(String(100))
124 
 
125 
class guarantee_info(Entity):
126 
    mid = Field(Integer)
127 
    guaranteeinfo = Field(String(100))
128 
    shipinfo = Field(String(100))
129 
 
130 
 
131 
class prices(Entity):
132 
    supplier_id = Field(Integer)
133 
    mobile_id = Field(Integer)
134 
    quoted_price = Field(Integer)
135 
    final_price = Field(Integer)
136 
    extra_info = Field(String(1000))
203 ashish 137 
 
173 ashish 138 
 
144 ashish 139 
def init():
173 ashish 140 
    #metadata.bind = "sqlite:///phones.sqlite"
141 
    metadata.bind = "mysql://root@localhost/phonecrawler"
144 ashish 142 
    metadata.bind.echo = True
143 
    setup_all(True)
173 ashish 144 
    pass
144 ashish 145 
 
146 
 
147 
if __name__ == "__main__":
148 
   init()