Subversion Repositories SmartDukaan

Rev

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

Rev 16372 Rev 16374
Line 6... Line 6...
6 
from sqlalchemy.sql.expression import func
 6 
from sqlalchemy.sql.expression import func
7 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Enum, \
 7 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Enum, \
8 
    Text
 8 
    Text
9 
from sqlalchemy.dialects.mysql.base import LONGTEXT
 9 
from sqlalchemy.dialects.mysql.base import LONGTEXT
10 
 
 10 
 
11 
 
 - 
 
- 
 
 11 
CASHBACK_AMOUNT = 'CASHBACK_AMOUNT'
- 
 
 12 
CASHBACK_PERCENTAGE = 'CASHBACK_PERCENTAGE'
12 
class Users(Entity):
 13 
class Users(Entity):
13 
    id = Field(Integer(unsigned=True), primary_key=True)
 14 
    id = Field(Integer(unsigned=True), primary_key=True)
14 
    username = Field(String(128))
 15 
    username = Field(String(128))
15 
    email = Field(String(128))
 16 
    email = Field(String(128))
16 
    password = Field(String(64))
 17 
    password = Field(String(64))
Line 351... Line 352...
351 
    status = Field(String(30))
 352 
    status = Field(String(30))
352 
    createdTime = Field(DateTime)
 353 
    createdTime = Field(DateTime)
353 
    using_options(shortnames=True)
 354 
    using_options(shortnames=True)
354 
    using_table_options(mysql_engine="InnoDB")
 355 
    using_table_options(mysql_engine="InnoDB")
355
356
- 
 
 357 
class paytm_coupons(Entity):
- 
 
 358 
    id = Field(Integer, primary_key= True)
- 
 
 359 
    coupon = Field(String(64))
- 
 
 360 
    min_cart_amount = Field(Integer)
- 
 
 361 
    cart_item_limit = Field(Integer)
- 
 
 362 
    max_cashback_amount = Field(Integer)
- 
 
 363 
    usage_limit = Field(Integer)
- 
 
 364 
    cod_available = Field(Integer)
- 
 
 365 
    valid_upto = Field(DateTime)
- 
 
 366 
    cashback_type = Enum(CASHBACK_AMOUNT, CASHBACK_PERCENTAGE)
- 
 
 367 
    created = Field(DateTime)
- 
 
 368 
    using_options(shortnames=True)
- 
 
 369 
    using_table_options(mysql_engine="InnoDB")
- 
 
 370 
 
- 
 
 371 
class paytm_coupon_usages(Entity):
- 
 
 372 
    id = Field(Integer, primary_key= True)
- 
 
 373 
    user_id = Field(Integer)
- 
 
 374 
    order_id = Field(Integer)
- 
 
 375 
    coupon = Field(String(64))
- 
 
 376 
    cashback = Field(Integer)
- 
 
 377 
    created = Field(DateTime,default=func.now())
- 
 
 378 
    using_options(shortnames=True)
- 
 
 379 
    using_table_options(mysql_engine="InnoDB")
- 
 
 380
- 
 
 381
356 
class NotificationViews(Entity):
 382 
class NotificationViews(Entity):
357 
    id = Field(Integer, primary_key= True)
 383 
    id = Field(Integer, primary_key= True)
358 
    user_id = Field(Integer(unsigned=True))
 384 
    user_id = Field(Integer(unsigned=True))
359 
    notification_rule_id = Field(Integer(unsigned=True))
 385 
    notification_rule_id = Field(Integer(unsigned=True))
360 
    created = Field(DateTime)
 386 
    created = Field(DateTime)