WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py



    part_number = Field(String(255))
    ean = Field(String(255))
    upc = Field(String(255))
    fbaPrice = Field(Float)
    fbbPrice = Field(Float)
    fbgPrice = Field(Float)
    sellingPrice = Field(Float)
    isFba = Field(Boolean)
    isNonFba = Field(Boolean)
    isFbb = Field(Boolean)
    isFbg = Field(Boolean)
    isInventoryOverride = Field(Boolean)
    otherCost = Field(Float, default=0.0, server_default="0.0")
    color = Field(String(255))
    category = Field(String(255))
    handlingTime = Field(Integer)

    category_code = Field(Integer, default=0, server_default="0")
    fbbListedOn = Field(DateTime)
    mfnPriceLastUpdatedOn = Field(DateTime)
    fbaPriceLastUpdatedOn = Field(DateTime)
    fbbPriceLastUpdatedOn = Field(DateTime)
    fbgPriceLastUpdatedOn = Field(DateTime)
    mfnPriceLastUpdatedOnSc = Field(DateTime)
    fbaPriceLastUpdatedOnSc = Field(DateTime)
    fbbPriceLastUpdatedOnSc = Field(DateTime)
    fbgPriceLastUpdatedOnSc = Field(DateTime)
    suppressMfnPriceUpdate = Field(Boolean)
    suppressFbaPriceUpdate = Field(Boolean)
    suppressFbbPriceUpdate = Field(Boolean)
    suppressFbgPriceUpdate = Field(Boolean)
    taxCode = Field(String(255))
    fbbtaxCode = Field(String(255))
    fbgtaxCode = Field(String(255))
    overrrideWanlc = Field(Boolean)
    exceptionalWanlc = Field(Float)
    autoDecrement = Field(Boolean)
    autoIncrement = Field(Boolean)
    autoFavourite = Field(Boolean)
    manualFavourite = Field(Boolean)
    fbaPromoPrice = Field(Float, default=0.0, server_default="0.0")
    fbbPromoPrice = Field(Float, default=0.0, server_default="0.0")
    fbgPromoPrice = Field(Float, default=0.0, server_default="0.0")
    fbaPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbaPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbbPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbbPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbgPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbgPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
    fbaPromotionActive = Field(Boolean)
    fbbPromotionActive = Field(Boolean)
    fbgPromotionActive = Field(Boolean)
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")
    
class PageViewEvents(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)

def initialize(dbname='catalog', db_hostname="localhost"):
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
    metadata.bind = cengine
    metadata.bind.echo = True
    setup_all(True)
 
if __name__=="__main__":
    initialize()

Rev 12843	Rev 12888
Line 249...	Line 249...
249	`part_number = Field(String(255))`	249	`part_number = Field(String(255))`
250	`ean = Field(String(255))`	250	`ean = Field(String(255))`
251	`upc = Field(String(255))`	251	`upc = Field(String(255))`
252	`fbaPrice = Field(Float)`	252	`fbaPrice = Field(Float)`
253	`fbbPrice = Field(Float)`	253	`fbbPrice = Field(Float)`
-		254	`fbgPrice = Field(Float)`
254	`sellingPrice = Field(Float)`	255	`sellingPrice = Field(Float)`
255	`isFba = Field(Boolean)`	256	`isFba = Field(Boolean)`
256	`isNonFba = Field(Boolean)`	257	`isNonFba = Field(Boolean)`
257	`isFbb = Field(Boolean)`	258	`isFbb = Field(Boolean)`
-		259	`isFbg = Field(Boolean)`
258	`isInventoryOverride = Field(Boolean)`	260	`isInventoryOverride = Field(Boolean)`
259	`otherCost = Field(Float, default=0.0, server_default="0.0")`	261	`otherCost = Field(Float, default=0.0, server_default="0.0")`
260	`color = Field(String(255))`	262	`color = Field(String(255))`
261	`category = Field(String(255))`	263	`category = Field(String(255))`
262	`handlingTime = Field(Integer)`	264	`handlingTime = Field(Integer)`
Line 264...	Line 266...
264	`category_code = Field(Integer, default=0, server_default="0")`	266	`category_code = Field(Integer, default=0, server_default="0")`
265	`fbbListedOn = Field(DateTime)`	267	`fbbListedOn = Field(DateTime)`
266	`mfnPriceLastUpdatedOn = Field(DateTime)`	268	`mfnPriceLastUpdatedOn = Field(DateTime)`
267	`fbaPriceLastUpdatedOn = Field(DateTime)`	269	`fbaPriceLastUpdatedOn = Field(DateTime)`
268	`fbbPriceLastUpdatedOn = Field(DateTime)`	270	`fbbPriceLastUpdatedOn = Field(DateTime)`
-		271	`fbgPriceLastUpdatedOn = Field(DateTime)`
269	`mfnPriceLastUpdatedOnSc = Field(DateTime)`	272	`mfnPriceLastUpdatedOnSc = Field(DateTime)`
270	`fbaPriceLastUpdatedOnSc = Field(DateTime)`	273	`fbaPriceLastUpdatedOnSc = Field(DateTime)`
271	`fbbPriceLastUpdatedOnSc = Field(DateTime)`	274	`fbbPriceLastUpdatedOnSc = Field(DateTime)`
-		275	`fbgPriceLastUpdatedOnSc = Field(DateTime)`
272	`suppressMfnPriceUpdate = Field(Boolean)`	276	`suppressMfnPriceUpdate = Field(Boolean)`
273	`suppressFbaPriceUpdate = Field(Boolean)`	277	`suppressFbaPriceUpdate = Field(Boolean)`
274	`suppressFbbPriceUpdate = Field(Boolean)`	278	`suppressFbbPriceUpdate = Field(Boolean)`
-		279	`suppressFbgPriceUpdate = Field(Boolean)`
275	`taxCode = Field(String(255))`	280	`taxCode = Field(String(255))`
276	`fbbtaxCode = Field(String(255))`	281	`fbbtaxCode = Field(String(255))`
-		282	`fbgtaxCode = Field(String(255))`
277	`overrrideWanlc = Field(Boolean)`	283	`overrrideWanlc = Field(Boolean)`
278	`exceptionalWanlc = Field(Float)`	284	`exceptionalWanlc = Field(Float)`
279	`autoDecrement = Field(Boolean)`	285	`autoDecrement = Field(Boolean)`
280	`autoIncrement = Field(Boolean)`	286	`autoIncrement = Field(Boolean)`
281	`autoFavourite = Field(Boolean)`	287	`autoFavourite = Field(Boolean)`
282	`manualFavourite = Field(Boolean)`	288	`manualFavourite = Field(Boolean)`
283	`fbaPromoPrice = Field(Float, default=0.0, server_default="0.0")`	289	`fbaPromoPrice = Field(Float, default=0.0, server_default="0.0")`
284	`fbbPromoPrice = Field(Float, default=0.0, server_default="0.0")`	290	`fbbPromoPrice = Field(Float, default=0.0, server_default="0.0")`
-		291	`fbgPromoPrice = Field(Float, default=0.0, server_default="0.0")`
285	`fbaPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`	292	`fbaPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
286	`fbaPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`	293	`fbaPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
287	`fbbPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`	294	`fbbPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
288	`fbbPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`	295	`fbbPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
-		296	`fbgPromoStartDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
-		297	`fbgPromoEndDate = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')`
289	`fbaPromotionActive = Field(Boolean)`	298	`fbaPromotionActive = Field(Boolean)`
290	`fbbPromotionActive = Field(Boolean)`	299	`fbbPromotionActive = Field(Boolean)`
-		300	`fbgPromotionActive = Field(Boolean)`
291	`using_options(shortnames=True)`	301	`using_options(shortnames=True)`
292	`using_table_options(mysql_engine="InnoDB")`	302	`using_table_options(mysql_engine="InnoDB")`
293		303
294	`class PageViewEvents(Entity):`	304	`class PageViewEvents(Entity):`
295	`id = Field(Integer, primary_key=True, autoincrement=True)`	305	`id = Field(Integer, primary_key=True, autoincrement=True)`
Line 716...	Line 726...
716	`def initialize(dbname='catalog', db_hostname="localhost"):`	726	`def initialize(dbname='catalog', db_hostname="localhost"):`
717	`#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.`	727	`#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.`
718	`#metadata.bind = 'mysql://root:shop2020@localhost/catalog'`	728	`#metadata.bind = 'mysql://root:shop2020@localhost/catalog'`
719	`cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)`	729	`cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)`
720	`metadata.bind = cengine`	730	`metadata.bind = cengine`
721	`metadata.bind.echo = False`	731	`metadata.bind.echo = True`
722	`setup_all(True)`	732	`setup_all(True)`
723		733
724	`if __name__=="__main__":`	734	`if __name__=="__main__":`
725	`initialize()`	735	`initialize()`

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py – Rev 12843 → 12888