from pylons import config
from sqlalchemy import Column, MetaData, Table, types
from sqlalchemy.orm import mapper
from sqlalchemy.orm import scoped_session, sessionmaker
from edv.model.inventory import *

Session = scoped_session(sessionmaker(autoflush=True, transactional=True,
                                      bind=config['pylons.g'].sa_engine))

metadata = MetaData()

brands_table = Table('brands', metadata,
    Column('brand_id', types.Integer, primary_key=True),
    Column('brand_name', types.Unicode(50), nullable=False),
    Column('brand_description', types.Unicode(), nullable=False)
)

categories_table = Table('categories', metadata,
    Column('category_id', types.Integer, primary_key=True),
    Column('category_name', types.Unicode(50), nullable=False),
    Column('category_description', types.Unicode(), nullable=False)
)

mapper(Brand, brands_table)
mapper(Category, categories_table)