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