Subversion Repositories SmartDukaan

'''
Created on 14-Jul-2010

@author: ashish
'''
from sqlalchemy import create_engine
from elixir import *
import elixir

class Message(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    message_id = Field(Integer)
    message = Field(String(200))
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")
    
class DashboardUser(Entity):
    username = Field(String(30), primary_key=True)
    password =  Field(String(30))
    warehouseId = Field(Integer)
    addedOn = Field(DateTime)
    loggedOn = Field(DateTime)
    status = Field(Integer)
    otherInfo = Field(String(200))
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")
    
class LogisticsUser(Entity):
    username = Field(String(30), primary_key=True)
    password = Field(String(30))
    providerId = Field(Integer)
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class UserEmail(Entity):
    emailTo = Field(String(100))
    emailFrom = Field(String(60))
    subject = Field(String(120))
    body = Field(Text())
    source = Field(String(20))
    emailType = Field(String(40))
    status = Field(Boolean())
    timestamp = Field(DateTime())
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")
    
def initialize(dbname='helper'):
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
    metadata.bind = engine
    metadata.bind.echo = True
    setup_all(True)

if __name__=="__main__":
    initialize()