Subversion Repositories SmartDukaan

Rev

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

Rev 738 Rev 746
Line 8... Line 8...
8 
from elixir.entity import Entity
 8 
from elixir.entity import Entity
9 
from elixir.fields import Field
 9 
from elixir.fields import Field
10 
from sqlalchemy.types import Integer
 10 
from sqlalchemy.types import Integer
11 
from elixir.relationships import OneToMany, ManyToOne
 11 
from elixir.relationships import OneToMany, ManyToOne
12 
import datetime
 12 
import datetime
- 
 
 13 
import elixir
13 
 
 14 
 
14 
 
 15 
 
15 
 
 16 
 
16 
#===============================================================================
 17 
#===============================================================================
17 
# Different entities in the model
 18 
# Different entities in the model
18 
#===============================================================================
 19 
#===============================================================================
19 
 
 20 
 
20 
def initialize():
 21 
def initialize():
21 
    metadata.bind = "sqlite:///Transactionsnew.sqlite"
 22 
    #metadata.bind = "sqlite:///Transactionsnew.sqlite"
- 
 
 23 
    metadata.bind = 'mysql://root:shop2020@localhost/transaction'
22 
    metadata.bind.echo = True
 24 
    metadata.bind.echo = True
23 
    setup_all(True)
 25 
    setup_all(True)
24 
 
 26 
 
25 
 
 27 
 
26 
if __name__=="__main__":
 28 
if __name__=="__main__":
Line 39... Line 41...
39 
    unit_price = Field(Float)
 41 
    unit_price = Field(Float)
40 
    unit_weight = Field(Float)
 42 
    unit_weight = Field(Float)
41 
    total_price = Field(Float)
 43 
    total_price = Field(Float)
42 
    total_weight = Field(Float)
 44 
    total_weight = Field(Float)
43 
    order = ManyToOne("Order")
 45 
    order = ManyToOne("Order")
- 
 
 46 
    using_options(shortnames=True)
- 
 
 47 
    using_table_options(mysql_engine="InnoDB")
44 
 
 48
45 
class Order(Entity):
 49 
class Order(Entity):
46 
    id = Field(Integer, primary_key=True, autoincrement=True)
 50 
    id = Field(Integer, primary_key=True, autoincrement=True)
47 
    warehouse_id = Field(Integer)
 51 
    warehouse_id = Field(Integer)
48 
    logistics_provider_id = Field(Integer)
 52 
    logistics_provider_id = Field(Integer)
49 
    airwaybill_no = Field(String(50))
 53 
    airwaybill_no = Field(String(50))
Line 70... Line 74...
70 
    shipping_timestamp = Field(DateTime)
 74 
    shipping_timestamp = Field(DateTime)
71 
    delivery_timestamp = Field(DateTime)
 75 
    delivery_timestamp = Field(DateTime)
72 
    lineitems = OneToMany("LineItem")
 76 
    lineitems = OneToMany("LineItem")
73 
    transaction = ManyToOne("Transaction")
 77 
    transaction = ManyToOne("Transaction")
74 
    jacket_number = Field(Integer)
 78 
    jacket_number = Field(Integer)
- 
 
 79 
    using_options(shortnames=True)
- 
 
 80 
    using_table_options(mysql_engine="InnoDB")
75 
 
 81 
 
76 
class Transaction(Entity):
 82 
class Transaction(Entity):
77 
    id = Field(Integer, primary_key=True, autoincrement=True)
 83 
    id = Field(Integer, primary_key=True, autoincrement=True)
78 
    createdOn = Field(DateTime)
 84 
    createdOn = Field(DateTime)
79 
    status = Field(Integer)
 85 
    status = Field(Integer)
80 
    status_message = Field(String(100))
 86 
    status_message = Field(String(100))
81 
    customer_id = Field(Integer)
 87 
    customer_id = Field(Integer)
82 
    shopping_cart_id = Field(Integer)
 88 
    shopping_cart_id = Field(Integer)
83 
    orders = OneToMany("Order")
 89 
    orders = OneToMany("Order")
- 
 
 90 
    using_options(shortnames=True)
- 
 
 91 
    using_table_options(mysql_engine="InnoDB")
84
92
85 
class Alerts(Entity):
 93 
class Alerts(Entity):
86 
    id = Field(Integer, primary_key=True, autoincrement=True)
 94 
    id = Field(Integer, primary_key=True, autoincrement=True)
87 
    order_id = Field(Integer)
 95 
    order_id = Field(Integer)
88 
    valid = Field(Boolean)
 96 
    valid = Field(Boolean)
89 
    type = Field(Integer)
 97 
    type = Field(Integer)
90 
    time_set = Field(DateTime)
 98 
    time_set = Field(DateTime)
91 
    comment = Field(String(100))
 99 
    comment = Field(String(100))
92 
    time_unset = Field(DateTime)
 - 
 
93 

            100
            
    time_unset = Field(DateTime)

          

          

            -
            
 

            101
            
    using_options(shortnames=True)

          

          

            -
            
 

            102
            
    using_table_options(mysql_engine="InnoDB")

          

          

            -
            
 

            103
            

          

          

            94
            

            104