Subversion Repositories SmartDukaan

Rev

Rev 701 | Rev 743 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 701 Rev 703
Line 14... Line 14...
14
    responseUrl = Field(String(500))
14
    responseUrl = Field(String(500))
15
    errorUrl = Field(String(500))
15
    errorUrl = Field(String(500))
16
    status = Field(Integer)
16
    status = Field(Integer)
17
    addedOn = Field(DateTime)
17
    addedOn = Field(DateTime)
18
    attributes = OneToMany("GatewayAttribute")
18
    attributes = OneToMany("GatewayAttribute")
-
 
19
    using_options(shortnames=True)
19
 
20
 
20
class GatewayAttribute(Entity):
21
class GatewayAttribute(Entity):
21
    payment_gateway = ManyToOne("PaymentGateway", primary_key=True)
22
    payment_gateway = ManyToOne("PaymentGateway", primary_key=True)
22
    name = Field(String(50), primary_key=True)
23
    name = Field(String(50), primary_key=True)
23
    value = Field(String(100))
24
    value = Field(String(100))
-
 
25
    using_options(shortnames=True)
24
 
26
 
25
class PaymentAttribute(Entity):
27
class PaymentAttribute(Entity):
26
    payment = ManyToOne("Payment", primary_key=True)
28
    payment = ManyToOne("Payment", primary_key=True)
27
    name = Field(String(50), primary_key=True)
29
    name = Field(String(50), primary_key=True)
28
    value = Field(String(100))
30
    value = Field(String(100))
-
 
31
    using_options(shortnames=True)
29
 
32
 
30
class Payment(Entity):
33
class Payment(Entity):
31
    id = Field(Integer, primary_key=True, autoincrement=True)
34
    id = Field(Integer, primary_key=True, autoincrement=True)
32
    gatewayId = Field(Integer)
35
    gatewayId = Field(Integer)
33
    gatewayPaymentId = Field(String(50))
36
    gatewayPaymentId = Field(String(50))
34
    merchantTxnId = Field(Integer)
37
    merchantTxnId = Field(Integer)
35
    gatewayTxnId = Field(String(50))
38
    gatewayTxnId = Field(String(50))
36
    amount = Field(Float)
39
    amount = Field(Float)
37
    gatewayTxnStatus = Field(String(20)),
40
    gatewayTxnStatus = Field(String(20))
38
    status = Field(Integer),
41
    status = Field(Integer)
39
    userId = Field(Integer),
42
    userId = Field(Integer)
40
    errorCode = Field(String(20)),
43
    errorCode = Field(String(20))
41
    description = Field(String(50)),
44
    description = Field(String(50))
42
    authCode = Field(String(20)),
45
    authCode = Field(String(20))
43
    referenceCode = Field(String(20)),
46
    referenceCode = Field(String(20))
44
    sessionId = Field(String(50)), 
47
    sessionId = Field(String(50))
45
    gatewayTxnDate = Field(String(50)),
48
    gatewayTxnDate = Field(String(50))
46
    attributes = OneToMany("PaymentAttribute"),
49
    attributes = OneToMany("PaymentAttribute")
47
    initTimestamp = Field(DateTime),
50
    initTimestamp = Field(DateTime)
48
    successTimestamp = Field(DateTime),
51
    successTimestamp = Field(DateTime)
49
    errorTimestamp = Field(DateTime)
52
    errorTimestamp = Field(DateTime)
-
 
53
    using_options(shortnames=True)
50
 
54
 
51
def initialize():
55
def initialize():
52
    metadata.bind = "sqlite:///payment.sqlite" #need to read it from configserver.
56
    metadata.bind = "sqlite:///payment.sqlite" #need to read it from configserver.
53
    metadata.bind.echo = True
57
    metadata.bind.echo = True
54
    setup_all(True)
58
    setup_all(True)
55
 
59
 
56
if __name__=="__main__":
60
if __name__=="__main__":
57
    initialize()
61
    initialize()
58
62