Subversion Repositories SmartDukaan

Rev

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

Rev 870 Rev 963
Line 9... Line 9...
9 
from sqlalchemy.types import Integer, Binary
 9 
from sqlalchemy.types import Integer, Binary
10 
from elixir.relationships import OneToMany, ManyToOne
 10 
from elixir.relationships import OneToMany, ManyToOne
11 
import datetime
 11 
import datetime
12 
import elixir
 12 
import elixir
13 
 
 13 
 
14 
class BestSellers(Entity):
 - 
 
15 
    manufacturer_name = Field(String(100), primary_key=True)
 - 
 
16 
    model_number = Field(String(50), primary_key=True)
 - 
 
17 
    color = Field(String(20), primary_key=True)
 - 
 
18 
    rank = Field(Integer)
 - 
 
19 
    using_options(shortnames=True)
 - 
 
20 
    using_table_options(mysql_engine="InnoDB")
 - 
 
21 
 
 - 
 
22 
class Warehouse(Entity):
 14 
class Warehouse(Entity):
23 
    id = Field(Integer, primary_key=True, autoincrement=True)
 15 
    id = Field(Integer, primary_key=True, autoincrement=True)
24 
    displayName = Field(String(50))
 16 
    displayName = Field(String(50))
25 
    location = Field(String(200))
 17 
    location = Field(String(200))
26 
    status = Field(Integer)
 18 
    status = Field(Integer)
Line 50... Line 42...
50 
    using_options(shortnames=True)
 42 
    using_options(shortnames=True)
51 
    using_table_options(mysql_engine="InnoDB")
 43 
    using_table_options(mysql_engine="InnoDB")
52
44
53 
class Item(Entity):
 45 
class Item(Entity):
54 
    id = Field(Integer, primary_key=True, autoincrement=True)
 46 
    id = Field(Integer, primary_key=True, autoincrement=True)
55 
    manufacturer_name = Field(String(100))
 47 
    product_group = Field(String(100))
- 
 
 48 
    brand = Field(String(100))
56 
    model_number = Field(String(50))
 49 
    model_number = Field(String(50))
57 
    model_name = Field(String(50))
 50 
    model_name = Field(String(50))
58 
    color = Field(String(20))
 51 
    color = Field(String(20))
59 
    category = Field(Integer)
 52 
    category = Field(Integer)
60 
    comments = Field(String(200))
 53 
    comments = Field(String(200))