Subversion Repositories SmartDukaan

Rev

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

Rev 194 Rev 304
Line 122... Line 122...
122 
    new_value = Field(String(30))
 122 
    new_value = Field(String(30))
123 
    description = Field(String(100))
 123 
    description = Field(String(100))
124 
    timestamp = Field(DateTime)
 124 
    timestamp = Field(DateTime)
125 
    transaction = ManyToOne("Transaction")
 125 
    transaction = ManyToOne("Transaction")
126
126
- 
 
 127 
class Alerts(Entity):
- 
 
 128 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 129 
    transaction_id = Field(Integer)
- 
 
 130 
    valid = Field(Boolean)
- 
 
 131 
    type = Field(Integer)
- 
 
 132 
    time_set = Field(DateTime)
- 
 
 133 
    comment = Field(String(100))
- 
 
 134 
    time_unset = Field(DateTime)
- 
 
 135
- 
 
 136 
class ExtraItemInfo(Entity):
- 
 
 137 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 138 
    transaction_id = Field(Integer)
- 
 
 139 
    sku_id = Field(Integer)
- 
 
 140 
    model = Field(String(50))
- 
 
 141 
    vendor = Field(String(50))
- 
 
 142 
    colour = Field(String(50))
127 
 
 143 
 
128 
def initialize():
 144 
def initialize():
129 
    metadata.bind = "sqlite:///Transactionsnew-elite.sqlite"
 145 
    metadata.bind = "sqlite:///Transactionsnew-elite.sqlite"
130 
    metadata.bind.echo = True
 146 
    metadata.bind.echo = True
131 
    setup_all(True)
 147 
    setup_all(True)