Subversion Repositories SmartDukaan

Rev

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

Rev 4873 Rev 4897
Line 7... Line 7...
7 
from elixir.entity import Entity
 7 
from elixir.entity import Entity
8 
from elixir.fields import Field
 8 
from elixir.fields import Field
9 
from elixir.options import using_options, using_table_options
 9 
from elixir.options import using_options, using_table_options
10 
from elixir.relationships import OneToMany, ManyToOne, ManyToMany
 10 
from elixir.relationships import OneToMany, ManyToOne, ManyToMany
11 
from sqlalchemy import create_engine
 11 
from sqlalchemy import create_engine
12 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Text
 12 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Text,\
- 
 
 13 
    Date
13 
import datetime
 14 
import datetime
14 
import elixir
 15 
import elixir
15 
 
 16 
 
16 
class Vendor(Entity):
 17 
class Vendor(Entity):
17 
    id = Field(Integer, primary_key=True, autoincrement=True)
 18 
    id = Field(Integer, primary_key=True, autoincrement=True)
Line 124... Line 125...
124 
    dealerPrice = Field(Float)
 125 
    dealerPrice = Field(Float)
125 
    transfer_price = Field(Float)
 126 
    transfer_price = Field(Float)
126 
    using_options(shortnames=True)
 127 
    using_options(shortnames=True)
127 
    using_table_options(mysql_engine="InnoDB")
 128 
    using_table_options(mysql_engine="InnoDB")
128 
 
 129 
 
- 
 
 130 
#class VendorDetails(Entity):
- 
 
 131 
#    vendor = ManyToOne('Vendor', primary_key=True)
- 
 
 132 
#    type = Field(Integer, primary_key=True)
- 
 
 133 
#    holiday = Field(Integer, primary_key=True)
- 
 
 134 
#    using_options(shortnames=True)
- 
 
 135 
#    using_table_options(mysql_engine="InnoDB")
- 
 
 136 
 
- 
 
 137 
class VendorItemProcurementDelay(Entity):
- 
 
 138 
    vendor = ManyToOne('Vendor', primary_key=True)
- 
 
 139 
    item = ManyToOne('Item', primary_key=True)
- 
 
 140 
    procurementDelay = Field(Integer)
- 
 
 141 
    using_options(shortnames=True)
- 
 
 142 
    using_table_options(mysql_engine="InnoDB")
- 
 
 143 
 
- 
 
 144 
#class VendorHolidays(Entity):
- 
 
 145 
#    vendor = ManyToOne('Vendor', primary_key=True)
- 
 
 146 
#    date = Field(Date, primary_key=True)
- 
 
 147 
#    occasion = Field(String(100))
- 
 
 148 
#    using_options(shortnames=True)
- 
 
 149 
#    using_table_options(mysql_engine="InnoDB")
- 
 
 150
129 
class ItemInfo(Entity):
 151 
class ItemInfo(Entity):
130 
    id = Field(Integer, primary_key=True, autoincrement=True)
 152 
    id = Field(Integer, primary_key=True, autoincrement=True)
131 
    key = Field(String(30))
 153 
    key = Field(String(30))
132 
    value = Field(String(100))
 154 
    value = Field(String(100))
133 
    item = ManyToOne("Item")
 155 
    item = ManyToOne("Item")