Subversion Repositories SmartDukaan

'''

Created on 26-Aug-2010

@author: ashish

'''

from elixir import *

class PGateway(Entity):

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

    name = Field(String(100))

    prod_url = Field(String(500))

    staging_url = Field(String(500))

    #pmts = OneToMany("Pmnt")

class Pmnt(Entity):

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

    mid = Field(String(50))

    bid = Field(String(50))

    btxid = Field(String(50))

    amt = Field(Float)

    init_ts = Field(DateTime)

    ba_ts = Field(DateTime)

    ps = Field(Integer)

    msg = Field(String(100))

    user_id = Field(Integer)

    cart_id = Field(Integer)

    gateway = Field(Integer)

    error_code = Field(String(20))

    session_id = Field(String(50))

    post_date = Field(String(20))

    auth_code = Field(String(20))

    ref_code = Field(String(20))

def initialize():

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

    metadata.bind.echo = True

    setup_all(True)

if __name__=="__main__":

    initialize()