1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
/*
* This file is part of LibEuFin.
* Copyright (C) 2024 Taler Systems S.A.
* LibEuFin is free software; you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation; either version 3, or
* (at your option) any later version.
* LibEuFin is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General
* Public License for more details.
* You should have received a copy of the GNU Affero General Public
* License along with LibEuFin; see the file COPYING. If not, see
* <http://www.gnu.org/licenses/>
*/
package tech.libeufin.nexus.db
import tech.libeufin.nexus.*
import tech.libeufin.common.*
import java.time.Instant
/** Data access logic for incoming & outgoing payments */
class PaymentDAO(private val db: Database) {
/** Outgoing payments registration result */
data class OutgoingRegistrationResult(
val id: Long,
val initiated: Boolean,
val new: Boolean
)
/** Register an outgoing payment reconciling it with its initiated payment counterpart if present */
suspend fun registerOutgoing(paymentData: OutgoingPayment): OutgoingRegistrationResult = db.conn {
val stmt = it.prepareStatement("""
SELECT out_tx_id, out_initiated, out_found
FROM register_outgoing((?,?)::taler_amount,?,?,?,?)
""")
val executionTime = paymentData.executionTime.micros()
stmt.setLong(1, paymentData.amount.value)
stmt.setInt(2, paymentData.amount.frac)
stmt.setString(3, paymentData.wireTransferSubject)
stmt.setLong(4, executionTime)
stmt.setString(5, paymentData.creditPaytoUri)
stmt.setString(6, paymentData.messageId)
stmt.one {
OutgoingRegistrationResult(
it.getLong("out_tx_id"),
it.getBoolean("out_initiated"),
!it.getBoolean("out_found")
)
}
}
/** Incoming payments bounce registration result */
data class IncomingBounceRegistrationResult(
val id: Long,
val bounceId: String,
val new: Boolean
)
/** Register an incoming payment and bounce it */
suspend fun registerMalformedIncoming(
paymentData: IncomingPayment,
bounceAmount: TalerAmount,
now: Instant
): IncomingBounceRegistrationResult = db.conn {
val stmt = it.prepareStatement("""
SELECT out_found, out_tx_id, out_bounce_id
FROM register_incoming_and_bounce((?,?)::taler_amount,?,?,?,?,(?,?)::taler_amount,?)
""")
val refundTimestamp = now.micros()
val executionTime = paymentData.executionTime.micros()
stmt.setLong(1, paymentData.amount.value)
stmt.setInt(2, paymentData.amount.frac)
stmt.setString(3, paymentData.wireTransferSubject)
stmt.setLong(4, executionTime)
stmt.setString(5, paymentData.debitPaytoUri)
stmt.setString(6, paymentData.bankId)
stmt.setLong(7, bounceAmount.value)
stmt.setInt(8, bounceAmount.frac)
stmt.setLong(9, refundTimestamp)
stmt.one {
IncomingBounceRegistrationResult(
it.getLong("out_tx_id"),
it.getString("out_bounce_id"),
!it.getBoolean("out_found")
)
}
}
/** Incoming payments registration result */
data class IncomingRegistrationResult(
val id: Long,
val new: Boolean
)
/** Register an talerable incoming payment */
suspend fun registerTalerableIncoming(
paymentData: IncomingPayment,
reservePub: EddsaPublicKey
): IncomingRegistrationResult = db.conn { conn ->
val stmt = conn.prepareStatement("""
SELECT out_found, out_tx_id
FROM register_incoming_and_talerable((?,?)::taler_amount,?,?,?,?,?)
""")
val executionTime = paymentData.executionTime.micros()
stmt.setLong(1, paymentData.amount.value)
stmt.setInt(2, paymentData.amount.frac)
stmt.setString(3, paymentData.wireTransferSubject)
stmt.setLong(4, executionTime)
stmt.setString(5, paymentData.debitPaytoUri)
stmt.setString(6, paymentData.bankId)
stmt.setBytes(7, reservePub.raw)
stmt.one {
IncomingRegistrationResult(
it.getLong("out_tx_id"),
!it.getBoolean("out_found")
)
}
}
}
|