| Line 19... |
Line 19... |
| 19 |
mobile_number = Field(String(15))
|
19 |
mobile_number = Field(String(15))
|
| 20 |
referral_url = Field(String(256))
|
20 |
referral_url = Field(String(256))
|
| 21 |
referrer = Field(String(32))
|
21 |
referrer = Field(String(32))
|
| 22 |
password_reset = Field(String(64))
|
22 |
password_reset = Field(String(64))
|
| 23 |
activation_code = Field(String(40))
|
23 |
activation_code = Field(String(40))
|
| - |
|
24 |
address_line_1 = Field(String(128))
|
| - |
|
25 |
address_line_2 = Field(String(128))
|
| - |
|
26 |
city = Field(String(128))
|
| - |
|
27 |
state = Field(String(64))
|
| - |
|
28 |
pincode = Field(String(6))
|
| 24 |
activated = Field(Boolean)
|
29 |
activated = Field(Boolean)
|
| 25 |
group_id = Field(Integer(unsigned=True), default=1, server_default='1')
|
30 |
group_id = Field(Integer(unsigned=True), default=1, server_default='1')
|
| 26 |
status = Field(Boolean, default=True, server_default='1')
|
31 |
status = Field(Boolean, default=True, server_default='1')
|
| 27 |
utm_campaign = Field(String(128))
|
32 |
utm_campaign = Field(String(128))
|
| 28 |
activation_time = Field(DateTime)
|
33 |
activation_time = Field(DateTime)
|
| Line 363... |
Line 368... |
| 363 |
user_id = Field(Integer, primary_key= True)
|
368 |
user_id = Field(Integer, primary_key= True)
|
| 364 |
using_options(shortnames=True)
|
369 |
using_options(shortnames=True)
|
| 365 |
using_table_options(mysql_engine="InnoDB")
|
370 |
using_table_options(mysql_engine="InnoDB")
|
| 366 |
|
371 |
|
| 367 |
|
372 |
|
| - |
|
373 |
class User_addresses(Entity):
|
| - |
|
374 |
id = Field(Integer, primary_key= True)
|
| - |
|
375 |
user_id = Field(Integer(unsigned=True))
|
| - |
|
376 |
store_name = Field(String(128))
|
| - |
|
377 |
address = Field(String(256))
|
| - |
|
378 |
city = Field(String(64))
|
| - |
|
379 |
pincode = Field(String(6))
|
| - |
|
380 |
state = Field(String(48))
|
| - |
|
381 |
created = Field(DateTime,default=func.now())
|
| - |
|
382 |
using_options(shortnames=True)
|
| - |
|
383 |
using_table_options(mysql_engine="InnoDB")
|
| 368 |
|
384 |
|
| - |
|
385 |
class All_user_addresses(Entity):
|
| - |
|
386 |
id = Field(Integer, primary_key= True)
|
| - |
|
387 |
user_id = Field(Integer(unsigned=True))
|
| - |
|
388 |
address = Field(String(256))
|
| - |
|
389 |
store_name = Field(String(128))
|
| - |
|
390 |
city = Field(String(64))
|
| - |
|
391 |
pincode = Field(String(6))
|
| - |
|
392 |
state = Field(String(48))
|
| - |
|
393 |
source = Field(Enum('retailer_crm_edited', 'retailer_master', 'fos_crm', 'user_profile'))
|
| - |
|
394 |
created = Field(DateTime,default=func.now())
|
| - |
|
395 |
using_options(shortnames=True)
|
| - |
|
396 |
using_table_options(mysql_engine="InnoDB")
|
| 369 |
|
397 |
|
| 370 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
398 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
| 371 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
399 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 372 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
400 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 373 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
401 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|