Subversion Repositories SmartDukaan

from elixir import metadata, setup_all

from elixir.entity import Entity

from elixir.fields import Field

from elixir.options import using_options, using_table_options

from sqlalchemy import create_engine

from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Enum

class Users(Entity):

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

    username = Field(String(128))

    email = Field(String(128))

    password = Field(String(64))

    first_name = Field(String(64))

    last_name = Field(String(64))

    mobile_number = Field(String(15))

    referral_url = Field(String(256))

    referrer = Field(String(32))

    password_reset = Field(String(64))

    activation_code = Field(String(40))

    group_id = Field(Integer(unsigned=True), default=1, server_default='1')

    status = Field(Boolean, default=True, server_default='1')

    created = Field(DateTime)

    modified = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class user_actions(Entity):

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

    user_id = Field(Integer(unsigned=True))

    store_product_id = Field(Integer(unsigned=True))

    action = Field(Enum('like','dislike'))

    created = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class brand_preferences(Entity):

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

    user_id = Field(Integer(unsigned=True))

    category_id = Field(Integer(unsigned=True))

    brand = Field(String(128))

    status = Field(Enum('show','hide'),default='hide', server_default='hide')

    created = Field(DateTime)

    modified = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class price_preferences(Entity):

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

    user_id = Field(Integer(unsigned=True))

    category_id = Field(Integer(unsigned=True))

    min_price = Field(Float, default=0.0, server_default="0.0")

    max_price = Field(Float, default=0.0, server_default="0.0")

    created = Field(DateTime)

    modified = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Brands(Entity):

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

    name = Field(String(128))

    category_id = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

def initialize(dbname='dtr', db_hostname="localhost", echo=True):

    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.

    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'

    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)

    metadata.bind = cengine

    metadata.bind.echo = echo

    setup_all(True)

if __name__=="__main__":

    initialize()