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 StatisticsUser(Entity):

    username = Field(String(30), primary_key=True)

    password = Field(String(30))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Report(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    description = Field(String(100))

    controller = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ReportUser(Entity):

    username = Field(String(30), primary_key=True)

    password = Field(String(30))

    role = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ReportRoleAuthority(Entity):

    report = ManyToOne("Report", primary_key=True)

    role = Field(Integer, primary_key=True)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class UserEmail(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    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")

class CatalogDashboardUser(Entity):

    username = Field(String(30), primary_key=True)

    password =  Field(String(30))

    loggedOn = 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()