Subversion Repositories SmartDukaan

'''

Created on 28-Apr-2010

@author: ashish

'''

from elixir import *

from elixir.entity import Entity

from elixir.fields import Field

from sqlalchemy import create_engine

from sqlalchemy.types import Integer

from elixir.relationships import OneToMany, ManyToOne

import datetime

import elixir

class SocialService(Entity):

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

    name = Field(String(100))

    handles = OneToMany("SocialHandle")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class SocialHandle(Entity):

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

    handle = Field(String(100))

    service = ManyToOne("SocialService")

    user = ManyToOne("User")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Address(Entity):

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

    line_1 = Field(String(100))

    line_2 = Field(String(100))

    landmark = Field(String(100))

    city = Field(String(100))

    state = Field(String(100))

    pin = Field(String(10))

    country = Field(String(100))

    enabled = Field(Boolean)

    type = Field(Integer)

    added_on = Field(DateTime)

    name = Field(String(100))

    phone = Field(String(20))

    user = ManyToOne("User")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Phone(Entity):

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

    country_code = Field(String(5))

    area_code = Field(String(10))

    number = Field(String(20))

    extension = Field(String(10))

    type = Field(Integer)

    user = ManyToOne("User")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class InternalInfo(Entity):

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

    geo_zone = Field(Integer)

    shipment_zone = Field(Integer)

    tax_zone = Field(Integer)

    rank_score = Field(Float)

    user = ManyToOne("User")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class IPMap(Entity):

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

    timestamp = Field(DateTime)

    ip = Field(String(30))

    user_state = ManyToOne("UserState")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class UserState(Entity):

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

    last_login = Field(DateTime)

    last_logout = Field(DateTime)

    email_verification_sent_on = Field(DateTime)

    sms_verification_sent_on = Field(DateTime)

    is_email_verified = Field(Boolean)

    is_sms_verified =Field(Boolean)

    active_since = Field(DateTime)

    account_status = Field(Integer)

    ip_list = OneToMany("IPMap")

    user = ManyToOne("User")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class User(Entity):

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

    email = Field(String(100))

    password = Field(String(50))

    name = Field(String(150))

    default_address_id = Field(Integer)

    communication_email = Field(String(100))

    active_cart_id = Field(Integer)

    jsession_id = Field(String(64))

    is_anonymous = Field(Boolean)

    date_of_birth = Field(String(20))

    sex = Field(Integer)

    mobile_number = Field(String(20))

    source = Field(String(200))

    source_start_time = Field(DateTime)

    trust_level = Field(Float)

    addresses = OneToMany("Address")

    social_handles = OneToMany("SocialHandle")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Line(Entity):

    cart = ManyToOne("Cart", primary_key=True)

    item_id = Field(Integer, primary_key=True, autoincrement=False)

    quantity = Field(Float)

    line_status = Field(Integer)

    estimate = Field(Integer)

    created_on = Field(DateTime)

    updated_on = Field(DateTime)

    actual_price = Field(Float)

    discounted_price = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Cart(Entity):

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

    user_id = Field(Integer)

    cart_status = Field(Integer)

    address_id = Field(Integer)

    checked_out_on = Field(DateTime)

    created_on = Field(DateTime)

    updated_on = Field(DateTime)

    lines = OneToMany("Line")

    total_price = Field(Float)

    discounted_price = Field(Float)

    coupon_code = Field(String(20))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

#===============================================================================

# Entity generated from Promotion Service

#===============================================================================

class Promotion(Entity):

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

    name = Field(String(200))

    rule_execution_src = Field(String(100))

    start_on = Field(DateTime)

    end_on = Field(DateTime)

    coupons = OneToMany("Coupon")

    created_on = Field(DateTime)

    using_options(shortnames = True)

    using_table_options(mysql_engine = "InnoDB")

class Coupon(Entity):

    coupon_code = Field(String(20))

    promotion = ManyToOne("Promotion")

    arguments = Field(String(200))

    using_options(shortnames = True)

    using_table_options(mysql_engine = "InnoDB")

class PromotionTracker(Entity):

    coupon_code = Field(String(20))

    transaction_id = Field(Integer)

    user_id = Field(Integer)

    applied_on = Field(DateTime)

    using_options(shortnames = True)

    using_table_options(mysql_engine = "InnoDB")

#===============================================================================

# Entity generated from Contact Us form

#===============================================================================

class UserCommunication(Entity):

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

    user_id = Field(Integer)

    communication_type = Field(Integer)

    order_id = Field(Integer)

    airwaybill_no = Field(String(50))

    reply_to = Field(String(50))

    product_name = Field(String(200))

    subject = Field(String(200))

    message = Field(String(600))

    communication_timestamp = Field(DateTime)

    using_options(shortnames = True)

    using_table_options(mysql_engine = "InnoDB")

#===============================================================================

# Different entities for the Widget service

#===============================================================================

class UserWidgetItem(Entity):

    userId = Field(Integer, primary_key=True)

    widgetId = Field(Integer, primary_key=True)

    itemId = Field(Integer, primary_key=True)

    addedOn = Field(DateTime)

    using_options(shortnames=True)    

    using_table_options(mysql_engine="InnoDB")

class MasterAffiliate(Entity):

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

    name = Field(String(100), unique=True)

    added_on = Field(DateTime)

    affiliates = OneToMany("Affiliate")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Affiliate(Entity):

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

    master_affiliate = ManyToOne("MasterAffiliate")

    name = Field(String(100), unique=True)

    url = Field(String(200))

    added_on = Field(DateTime)

    tracklogs = OneToMany("TrackLog")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Tracker(Entity):

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

    affiliate_id = Field(Integer)

    added_on = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class TrackLog(Entity):

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

    added_on = Field(DateTime)

    affiliate = ManyToOne("Affiliate")

    user_id = Field(Integer)

    event = Field(String(100))

    event_id = Field(Integer)

    url = Field(String(200))

    data = Field(String(200))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class UserNote(Entity):

    user_id = Field(Integer)

    entity_id = Field(Integer)

    slide = Field(String(30))

    note = Field(String(500))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

def initialize(dbname='user', db_hostname="localhost"):

    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.

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

    metadata.bind = engine

    metadata.bind.echo = True

    setup_all(True)

if __name__=="__main__":

    initialize()