| Line 848... |
Line 848... |
| 848 |
itemCondition = Field(Integer, primary_key=True, autoincrement=False)
|
848 |
itemCondition = Field(Integer, primary_key=True, autoincrement=False)
|
| 849 |
warrantyVal = Field(Integer)
|
849 |
warrantyVal = Field(Integer)
|
| 850 |
warrantyPeriodType = Field(String(1))
|
850 |
warrantyPeriodType = Field(String(1))
|
| 851 |
using_options(shortnames=True)
|
851 |
using_options(shortnames=True)
|
| 852 |
using_table_options(mysql_engine="InnoDB")
|
852 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
853 |
|
| - |
|
854 |
class Tag_Listing(Entity):
|
| - |
|
855 |
id = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
856 |
item_id = Field(Integer)
|
| - |
|
857 |
tag_id = Field(Integer)
|
| - |
|
858 |
selling_price = Field(Float)
|
| - |
|
859 |
created_by = Field(Integer)
|
| - |
|
860 |
active = Field(Boolean)
|
| - |
|
861 |
start_date = Field(DateTime)
|
| - |
|
862 |
create_timestamp = Field(DateTime)
|
| - |
|
863 |
support_price = Field(Float)
|
| - |
|
864 |
mop = Field(Float)
|
| - |
|
865 |
using_options(shortnames=True)
|
| - |
|
866 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
867 |
|
| - |
|
868 |
|
| - |
|
869 |
|
| 853 |
|
870 |
|
| 854 |
def initialize(dbname='catalog', db_hostname="localhost", setup=True):
|
871 |
def initialize(dbname='catalog', db_hostname="localhost", setup=True):
|
| 855 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
872 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 856 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
873 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 857 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
874 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|