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()