Subversion Repositories SmartDukaan

from elixir import *

from elixir import metadata, setup_all, session

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, \

    Text

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

class Feedbacks(Entity):

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

    user_id = Field(Integer(unsigned=True))

    email = Field(String(128))

    subject = Field(String(256))

    message = Field(Text)

    created = Field(DateTime)

    isTicketCreated = Field(Boolean, default=False, server_default='0')

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Postoffices(Entity):

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

    name = Field(String(128))

    pincode = Field(Integer(6, unsigned=True))

    deliverystatus = Field(Boolean)

    divisionname = Field(String(128))

    regionname = Field(String(128))

    taluk = Field(String(128))

    district = Field(String(128))

    state = Field(String(128))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Dealers(Entity):

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

    identifier = Field(String(128))

    title = Field(String(128))

    contact1 = Field(String(10))

    contact2 = Field(String(10))

    contact3 = Field(String(10))

    address = Field(String(192))

    lat = Field(String(16))

    lng = Field(String(16))

    established = Field(String(16))

    rating = Field(Integer(4, unsigned=True))

    verified = Field(Boolean)

    searchCity=Field(String(128))

    dealerUrl=Field(String(256))

    paginatedUrl=Field(String(256))

    rawhtml = Field(Text)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Orders(Entity):

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

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

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

    order_url = Field(String(256))

    status = Field(String(32))

    created = Field(DateTime)

    modified = Field(DateTime)

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