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

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

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

    type = Field(Integer)

    user_id = Field(Integer)

    name = Field(String(100))

    enabled = Field(Boolean)

    items = OneToMany("WidgetItem")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class WidgetItem(Entity):

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

    added_on = Field(DateTime)

    item = ManyToOne("Item")

    widget = ManyToOne("Widget")

    using_options(shortnames=True)    

    using_table_options(mysql_engine="InnoDB")

class Item(Entity):

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

    item_id = Field(Integer)

    enabled = Field(Boolean)

    widget_items=OneToMany("WidgetItem")

    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)

    trackers = OneToMany("Tracker")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Tracker(Entity):

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

    added_on = Field(DateTime)

    affiliate = ManyToOne("Affiliate")

    tracklogs = OneToMany("TrackLog")

    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)

    tracker = ManyToOne("Tracker")

    user_id = Field(Integer)

    event = Field(String(100))

    url = Field(String(200))

    data = Field(String(200))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

def initialize(dbname='user'):

    #metadata.bind = "sqlite:///user.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()

'''

class Ratings(Entity):

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

    item_id = Field(Integer)

    type = Field(Integer)

    rating = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class UserRatings(Entity):

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

    item_id = Field(Integer)

    rating = Field(Float)

    user_id = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

'''