Subversion Repositories SmartDukaan

'''
Created on 12-May-2010

@author: gaurav
'''

from elixir import *

class PhoneItem(Entity):
    url = Field(String(1000))
    name = Field(String(50))
    price = Field(Integer)
    source = Field(String(100))
    is_crawled = Field(Boolean)
    phones = ManyToOne("Phones")
    
    def __repr__(self):
        return "%s %s" %(self.url, self.name)
    
class Phones(Entity):
    vendor = Field(String(100))
    base_url = Field(String(1000))
    items = OneToMany("PhoneItem")
   
class Vendor(Entity):
    v_name = Field(String(100))
    v_url = Field(String(1000))

class infibeam_data(Entity):
    name = Field(String(100))
    shown_price = Field(Integer)
    final_price = Field(Integer)

class univercell_data(Entity):    
    v_name = Field(String(100))
    v_site = Field(String(1000))
    
class univercell_items(Entity):    
    p_title = Field(String(100))
    p_shown_price = Field(Integer)
    p_final_price = Field(Integer)
    
def init():
    metadata.bind = "sqlite:///phones.sqlite"
    metadata.bind.echo = True
    setup_all(True)
 

if __name__ == "__main__":
   init()