Subversion Repositories SmartDukaan

Rev

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

Rev 6511 Rev 6532
Line 101... Line 101...
101 
    name = Field(String(50))
 101 
    name = Field(String(50))
102 
    identifier = Field(String(100))
 102 
    identifier = Field(String(100))
103 
    using_options(shortnames=True)
 103 
    using_options(shortnames=True)
104 
    using_table_options(mysql_engine="InnoDB")
 104 
    using_table_options(mysql_engine="InnoDB")
105
105
106 
class EntityTag(Entity):
 - 
 
107 
    tag = Field(String(100),primary_key=True)
 - 
 
108 
    entityId = Field(Integer, primary_key=True, autoincrement=False)
 - 
 
109 
    using_options(shortnames=True)
 - 
 
110 
    using_table_options(mysql_engine="InnoDB")
 - 
 
111 
 
 - 
 
112 
class SourceItemPricing(Entity):
 106 
class SourceItemPricing(Entity):
113 
    source = ManyToOne('Source', primary_key=True)
 107 
    source = ManyToOne('Source', primary_key=True)
114 
    item = ManyToOne('Item', primary_key=True)
 108 
    item = ManyToOne('Item', primary_key=True)
115 
    mrp = Field(Float)
 109 
    mrp = Field(Float)
116 
    sellingPrice = Field(Float)
 110 
    sellingPrice = Field(Float)
Line 143... Line 137...
143 
 
 137 
 
144 
class OOSTracker(Entity):
 138 
class OOSTracker(Entity):
145 
    itemId = Field(Integer, primary_key=True)
 139 
    itemId = Field(Integer, primary_key=True)
146 
    using_options(shortnames=True)
 140 
    using_options(shortnames=True)
147 
    using_table_options(mysql_engine="InnoDB")
 141 
    using_table_options(mysql_engine="InnoDB")
- 
 
 142 
 
- 
 
 143 
class EntityTag(Entity):
- 
 
 144 
    tag = Field(String(100),primary_key=True)
- 
 
 145 
    entityId = Field(Integer, primary_key=True, autoincrement=False)
- 
 
 146 
    using_options(shortnames=True)
- 
 
 147 
    using_table_options(mysql_engine="InnoDB")
148
148
149 
def initialize(dbname='catalog', db_hostname="localhost"):
 149 
def initialize(dbname='catalog', db_hostname="localhost"):
150 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 150 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
151 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 151 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
152 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 152 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
153 
    metadata.bind = engine
 153 
    metadata.bind = cengine
154 
    metadata.bind.echo = True
 154 
    metadata.bind.echo = True
155 
    setup_all(True)
 155 
    setup_all(True)
156 
 
 156 
 
157 
if __name__=="__main__":
 157 
if __name__=="__main__":
158 
    initialize()
 158 
    initialize()
159 

            159