| Line 9... |
Line 9... |
| 9 |
from elixir.fields import Field
|
9 |
from elixir.fields import Field
|
| 10 |
from elixir.options import using_options, using_table_options
|
10 |
from elixir.options import using_options, using_table_options
|
| 11 |
from elixir.relationships import ManyToOne, OneToMany
|
11 |
from elixir.relationships import ManyToOne, OneToMany
|
| 12 |
from sqlalchemy.engine import create_engine
|
12 |
from sqlalchemy.engine import create_engine
|
| 13 |
from sqlalchemy.types import Integer, String, Float, DateTime, Boolean, Enum, \
|
13 |
from sqlalchemy.types import Integer, String, Float, DateTime, Boolean, Enum, \
|
| 14 |
Numeric, BigInteger, LargeBinary,Date
|
14 |
Numeric, BigInteger, LargeBinary, Date
|
| - |
|
15 |
import datetime
|
| 15 |
|
16 |
|
| 16 |
#===============================================================================
|
17 |
#===============================================================================
|
| 17 |
# Different entities in the model
|
18 |
# Different entities in the model
|
| 18 |
#===============================================================================
|
19 |
#===============================================================================
|
| 19 |
|
20 |
|
| Line 636... |
Line 637... |
| 636 |
createdTimestamp = Field(DateTime)
|
637 |
createdTimestamp = Field(DateTime)
|
| 637 |
sequence = Field(Integer, default=0)
|
638 |
sequence = Field(Integer, default=0)
|
| 638 |
invoiceFormat = Field(Integer, default=1)
|
639 |
invoiceFormat = Field(Integer, default=1)
|
| 639 |
using_options(shortnames=True)
|
640 |
using_options(shortnames=True)
|
| 640 |
using_table_options(mysql_engine="InnoDB")
|
641 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
642 |
|
| - |
|
643 |
class Creditors(Entity):
|
| - |
|
644 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| - |
|
645 |
name = Field(String(64))
|
| - |
|
646 |
active = Field(Boolean)
|
| - |
|
647 |
updated = Field(DateTime, onupdate=datetime.datetime.now)
|
| - |
|
648 |
created = Field(DateTime,default = datetime.datetime.now)
|
| - |
|
649 |
using_options(shortnames=True)
|
| - |
|
650 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
651 |
|
| - |
|
652 |
class UserSanctions(Entity):
|
| - |
|
653 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| - |
|
654 |
userId = Field(Integer)
|
| - |
|
655 |
userRefId = String(24)
|
| - |
|
656 |
creditLimit = Field(Float)
|
| - |
|
657 |
creditBlocked = Field(Float)
|
| - |
|
658 |
loanAmount = Field(Float)
|
| - |
|
659 |
active = Field(Boolean)
|
| - |
|
660 |
updated = Field(DateTime, onupdate=datetime.datetime.now)
|
| - |
|
661 |
created = Field(DateTime,default = datetime.datetime.now)
|
| - |
|
662 |
using_options(shortnames=True)
|
| - |
|
663 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
664 |
|
| - |
|
665 |
class CreditHistory(Entity):
|
| - |
|
666 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| - |
|
667 |
userId = Field(Integer)
|
| - |
|
668 |
creditorId = Field(Integer)
|
| - |
|
669 |
paymentId = Field(String)
|
| - |
|
670 |
amount = Field(Float)
|
| - |
|
671 |
type = Field(Enum('BLOCKED', 'BLOCKED_REVERSED', 'LOAN', 'LOAN_PAID', 'DEFAULTED'))
|
| - |
|
672 |
shippingId = Field(String)
|
| - |
|
673 |
loanId = Field(String)
|
| - |
|
674 |
dueDate = Field(DateTime)
|
| - |
|
675 |
updated = Field(DateTime, onupdate=datetime.datetime.now)
|
| - |
|
676 |
created = Field(DateTime,default = datetime.datetime.now)
|
| 641 |
|
677 |
|
| 642 |
class HsOrder(Entity):
|
678 |
class HsOrder(Entity):
|
| 643 |
orderId = Field(Integer, primary_key=True, autoincrement=False)
|
679 |
orderId = Field(Integer, primary_key=True, autoincrement=False)
|
| 644 |
hsOrderNo = Field(String(32))
|
680 |
hsOrderNo = Field(String(32))
|
| 645 |
hsSubOrderNo = Field(String(32))
|
681 |
hsSubOrderNo = Field(String(32))
|