Subversion Repositories SmartDukaan

Rev

Rev 14921 | Rev 15048 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14921 Rev 15011
Line -... Line 1...
- 
 
 1 
from elixir import *
1 
from elixir import metadata, setup_all
 2 
from elixir import metadata, setup_all, session
2 
from elixir.entity import Entity
 3 
from elixir.entity import Entity
3 
from elixir.fields import Field
 4 
from elixir.fields import Field
4 
from elixir.options import using_options, using_table_options
 5 
from elixir.options import using_options, using_table_options
5 
from sqlalchemy import create_engine
 6 
from sqlalchemy import create_engine
6 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Enum, Text
 7 
from sqlalchemy.types import Integer, String, DateTime, Float, Boolean, Enum, \
- 
 
 8 
    Text
7 
 
 9 
 
8 
 
 10 
 
9 
class Users(Entity):
 11 
class Users(Entity):
10 
    id = Field(Integer(unsigned=True), primary_key=True)
 12 
    id = Field(Integer(unsigned=True), primary_key=True)
11 
    username = Field(String(128))
 13 
    username = Field(String(128))
Line 72... Line 74...
72 
    created = Field(DateTime)
 74 
    created = Field(DateTime)
73 
    isTicketCreated = Field(Boolean, default=False, server_default='0')
 75 
    isTicketCreated = Field(Boolean, default=False, server_default='0')
74 
    using_options(shortnames=True)
 76 
    using_options(shortnames=True)
75 
    using_table_options(mysql_engine="InnoDB")
 77 
    using_table_options(mysql_engine="InnoDB")
76 
 
 78 
 
- 
 
 79 
class Postoffices(Entity):
- 
 
 80 
    id = Field(Integer(10, unsigned=True), primary_key=True)
- 
 
 81 
    name = Field(String(128))
- 
 
 82 
    pincode = Field(Integer(6, unsigned=True))
- 
 
 83 
    deliverystatus = Field(Boolean)
- 
 
 84 
    divisionname = Field(String(128))
- 
 
 85 
    regionname = Field(String(128))
- 
 
 86 
    taluk = Field(String(128))
- 
 
 87 
    district = Field(String(128))
- 
 
 88 
    state = Field(String(128))
- 
 
 89 
    using_options(shortnames=True)
- 
 
 90 
    using_table_options(mysql_engine="InnoDB")
- 
 
 91 
 
- 
 
 92 
class Dealers(Entity):
- 
 
 93 
    id = Field(Integer(10, unsigned=True), primary_key=True)
- 
 
 94 
    identifier = Field(String(128))
- 
 
 95 
    title = Field(String(128))
- 
 
 96 
    contact1 = Field(String(10))
- 
 
 97 
    contact2 = Field(String(10))
- 
 
 98 
    contact3 = Field(String(10))
- 
 
 99 
    address = Field(String(192))
- 
 
 100 
    lat = Field(String(16))
- 
 
 101 
    lng = Field(String(16))
- 
 
 102 
    established = Field(String(16))
- 
 
 103 
    rating = Field(Integer(4, unsigned=True))
- 
 
 104 
    verified = Field(Boolean)
- 
 
 105 
    searchCity=Field(String(128))
- 
 
 106 
    dealerUrl=Field(String(256))
- 
 
 107 
    paginatedUrl=Field(String(256))
- 
 
 108 
    rawhtml = Field(Text)
- 
 
 109 
    using_options(shortnames=True)
- 
 
 110 
    using_table_options(mysql_engine="InnoDB")
- 
 
 111
- 
 
 112 
 
77 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
 113 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
78 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 114 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
79 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 115 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
80 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 116 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
81 
    metadata.bind = cengine
 117 
    metadata.bind = cengine
82 
    metadata.bind.echo = echo
 118 
    metadata.bind.echo = echo
83 
    setup_all(True)
 119 
    setup_all(True)
84 
 
 120 
 
85 
if __name__=="__main__":
 121 
if __name__=="__main__":
86 
    initialize()
 122 
    initialize()
- 
 
 123 
 
- 
 
 124
- 
 
 125