Subversion Repositories SmartDukaan

'''
Created on 26-Aug-2010

@author: ashish
'''
from sqlalchemy import create_engine
from elixir import *
import elixir


class PaymentGateway(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    name = Field(String(100))
    aliasName = Field(String(100))
    url = Field(String(500))
    responseUrl = Field(String(500))
    errorUrl = Field(String(500))
    status = Field(Integer)
    addedOn = Field(DateTime)
    attributes = OneToMany("GatewayAttribute")
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class GatewayAttribute(Entity):
    payment_gateway = ManyToOne("PaymentGateway", primary_key=True)
    name = Field(String(50), primary_key=True)
    value = Field(String(100))
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class PaymentAttribute(Entity):
    payment = ManyToOne("Payment", primary_key=True)
    name = Field(String(50), primary_key=True)
    value = Field(String(250))
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class Payment(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    gatewayId = Field(Integer)
    gatewayPaymentId = Field(String(50))
    merchantTxnId = Field(Integer)
    gatewayTxnId = Field(String(50))
    amount = Field(Float)
    gatewayTxnStatus = Field(String(20))
    status = Field(Integer)
    userId = Field(Integer)
    errorCode = Field(String(20))
    description = Field(String(200))
    authCode = Field(String(20))
    referenceCode = Field(String(20))
    sessionId = Field(String(50))
    gatewayTxnDate = Field(String(50))
    attributes = OneToMany("PaymentAttribute")
    initTimestamp = Field(DateTime)
    successTimestamp = Field(DateTime)
    errorTimestamp = Field(DateTime)
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class Refund(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    paymentId = Field(Integer)
    gatewayId = Field(Integer)
    orderId = Field(Integer)
    amount = Field(Float)
    gatewayTxnId = Field(String(50))
    attempts = Field(Integer)
    createdAt = Field(DateTime)
    processedAt = Field(DateTime)
    attributes = OneToMany("RefundAttribute")
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")

class RefundAttribute(Entity):
    refund = ManyToOne("Refund", primary_key=True)
    name = Field(String(50), primary_key=True)
    value = Field(String(250))
    using_options(shortnames=True)
    using_table_options(mysql_engine="InnoDB")
    
def initialize(dbname='payment'):
    #metadata.bind = "sqlite:///payment.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()