[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libeufin] branch master updated: Add new database tables for report + s
From: |
gnunet |
Subject: |
[libeufin] branch master updated: Add new database tables for report + statement generation |
Date: |
Wed, 19 Aug 2020 12:07:47 +0200 |
This is an automated email from the git hooks/post-receive script.
heng-yeow pushed a commit to branch master
in repository libeufin.
The following commit(s) were added to refs/heads/master by this push:
new 2d99bbd Add new database tables for report + statement generation
2d99bbd is described below
commit 2d99bbd92c0d52a6aec61e79715f60cb4616c0b6
Author: tanhengyeow <E0032242@u.nus.edu>
AuthorDate: Wed Aug 19 18:07:39 2020 +0800
Add new database tables for report + statement generation
---
.../src/main/kotlin/tech/libeufin/sandbox/DB.kt | 32 ++++++++++++++++++++++
1 file changed, 32 insertions(+)
diff --git a/sandbox/src/main/kotlin/tech/libeufin/sandbox/DB.kt
b/sandbox/src/main/kotlin/tech/libeufin/sandbox/DB.kt
index c7a5abe..c5892f7 100644
--- a/sandbox/src/main/kotlin/tech/libeufin/sandbox/DB.kt
+++ b/sandbox/src/main/kotlin/tech/libeufin/sandbox/DB.kt
@@ -302,6 +302,38 @@ class BankAccountEntity(id: EntityID<Int>) : IntEntity(id)
{
var subscriber by EbicsSubscriberEntity referencedOn
BankAccountsTable.subscriber
}
+object BankAccountStatementsTable : IntIdTable() {
+ val statementId = text("statementId")
+ val creationTime = long("creationTime")
+ val xmlMessage = text("xmlMessage")
+ val bankAccount = reference("bankAccount", BankAccountsTable)
+}
+
+class BankAccountStatementsEntity(id: EntityID<Int>) : IntEntity(id) {
+ companion object :
IntEntityClass<BankAccountStatementsEntity>(BankAccountStatementsTable)
+
+ var statementId by BankAccountStatementsTable.statementId
+ var xmlMessage by BankAccountStatementsTable.xmlMessage
+ var creationTime by BankAccountStatementsTable.creationTime
+ var bankAccount by BankAccountEntity referencedOn
BankAccountStatementsTable.bankAccount
+}
+
+object BankAccountReportsTable : IntIdTable() {
+ val reportId = text("reportId")
+ val creationTime = long("creationTime")
+ val xmlMessage = text("xmlMessage")
+ val bankAccount = reference("bankAccount", BankAccountsTable)
+}
+
+class BankAccountReportsTableEntity(id: EntityID<Int>) : IntEntity(id) {
+ companion object :
IntEntityClass<BankAccountReportsTableEntity>(BankAccountReportsTable)
+
+ var reportId by BankAccountReportsTable.reportId
+ var xmlMessage by BankAccountReportsTable.xmlMessage
+ var creationTime by BankAccountReportsTable.creationTime
+ var bankAccount by BankAccountEntity referencedOn
BankAccountReportsTable.bankAccount
+}
+
fun dbCreateTables(dbName: String) {
Database.connect("jdbc:sqlite:${dbName}", "org.sqlite.JDBC")
TransactionManager.manager.defaultIsolationLevel =
Connection.TRANSACTION_SERIALIZABLE
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [libeufin] branch master updated: Add new database tables for report + statement generation,
gnunet <=