| Line 52... |
Line 52... |
| 52 |
isWarehousePreferenceSticky = Field(Boolean)
|
52 |
isWarehousePreferenceSticky = Field(Boolean)
|
| 53 |
preferredVendor = Field(Integer)
|
53 |
preferredVendor = Field(Integer)
|
| 54 |
type = Field(Enum('SERIALIZED', 'NON_SERIALIZED'), default = 'NON_SERIALIZED', server_default='NON_SERIALIZED')
|
54 |
type = Field(Enum('SERIALIZED', 'NON_SERIALIZED'), default = 'NON_SERIALIZED', server_default='NON_SERIALIZED')
|
| 55 |
hasItemNo = Field(Boolean)
|
55 |
hasItemNo = Field(Boolean)
|
| 56 |
clearance = Field(Boolean)
|
56 |
clearance = Field(Boolean)
|
| - |
|
57 |
vatPercentage = Field(Float)
|
| 57 |
using_options(shortnames=True)
|
58 |
using_options(shortnames=True)
|
| 58 |
using_table_options(mysql_engine="InnoDB")
|
59 |
using_table_options(mysql_engine="InnoDB")
|
| 59 |
|
60 |
|
| 60 |
def __repr__(self):
|
61 |
def __repr__(self):
|
| 61 |
return "<Item>%d</item>" % (self.id)
|
62 |
return "<Item>%d</item>" % (self.id)
|
| Line 123... |
Line 124... |
| 123 |
item = ManyToOne('Item', primary_key=True)
|
124 |
item = ManyToOne('Item', primary_key=True)
|
| 124 |
amount = Field(Integer, default=0, server_default="0")
|
125 |
amount = Field(Integer, default=0, server_default="0")
|
| 125 |
using_options(shortnames=True)
|
126 |
using_options(shortnames=True)
|
| 126 |
using_table_options(mysql_engine="InnoDB")
|
127 |
using_table_options(mysql_engine="InnoDB")
|
| 127 |
|
128 |
|
| - |
|
129 |
class CategoryVatMaster(Entity):
|
| - |
|
130 |
categoryId = Field(Integer, primary_key=True)
|
| - |
|
131 |
minVal = Field(Integer, primary_key=True)
|
| - |
|
132 |
maxVal = Field(Integer, primary_key=True)
|
| - |
|
133 |
vatPercent = Field(Float)
|
| - |
|
134 |
using_options(shortnames=True)
|
| - |
|
135 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
136 |
|
| 128 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
137 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
| 129 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
138 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 130 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
139 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 131 |
engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
140 |
engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 132 |
metadata.bind = engine
|
141 |
metadata.bind = engine
|