Subversion Repositories SmartDukaan

Rev

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

Rev 18672 Rev 19329
Line 653... Line 653...
653
    product_input = Field (String(256))
653
    product_input = Field (String(256))
654
    pricing_input = Field(Float) 
654
    pricing_input = Field(Float) 
655
    created = Field(DateTime,default=func.now())
655
    created = Field(DateTime,default=func.now())
656
    using_options(shortnames=True)
656
    using_options(shortnames=True)
657
    using_table_options(mysql_engine="InnoDB")
657
    using_table_options(mysql_engine="InnoDB")
-
 
658
 
-
 
659
class user_accounts(Entity):
-
 
660
    id =  Field(Integer(unsigned=True), primary_key=True)
-
 
661
    user_id =  Field(Integer(unsigned=True))
-
 
662
    account_type = Field(Enum('saholic','gcm_regid','cartId'))
-
 
663
    account_key = Field(String(128))
-
 
664
    using_options(shortnames=True)
-
 
665
    using_table_options(mysql_engine="InnoDB")
658
    
666
    
659
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
667
def initialize(dbname='dtr', db_hostname="localhost", echo=True, setup=True):
660
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
668
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
661
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
669
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
662
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
670
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
663
    metadata.bind = cengine
671
    metadata.bind = cengine
664
    metadata.bind.echo = echo
672
    metadata.bind.echo = echo
665
    setup_all(True)
673
    setup_all(setup)
666
 
674
 
667
if __name__=="__main__":
675
if __name__=="__main__":
668
    initialize()
676
    initialize()
669
677