diff options
| author | Christian Grothoff <christian@grothoff.org> | 2022-03-05 16:16:38 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2022-03-05 16:16:38 +0100 |
| commit | 57470e4c0891e2a98fd33fec0ed9b49da4997c2a (patch) | |
| tree | 644dd9e727301b762ee2756edf62418a36eaff37 /src/exchangedb/plugin_exchangedb_postgres.c | |
| parent | 5fa977cc05daca469044711ffb6a497287094c70 (diff) | |
-more work on global_fees
Diffstat (limited to 'src/exchangedb/plugin_exchangedb_postgres.c')
| -rw-r--r-- | src/exchangedb/plugin_exchangedb_postgres.c | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c index cdc383bf..fe06634f 100644 --- a/src/exchangedb/plugin_exchangedb_postgres.c +++ b/src/exchangedb/plugin_exchangedb_postgres.c @@ -2116,6 +2116,14 @@ prepare_statements (struct PostgresClosure *pg) " LIMIT 1;", 0), GNUNET_PQ_make_prepare ( + "select_serial_by_table_global_fee", + "SELECT" + " global_fee_serial AS serial" + " FROM global_fee" + " ORDER BY global_fee_serial DESC" + " LIMIT 1;", + 0), + GNUNET_PQ_make_prepare ( "select_serial_by_table_recoup", "SELECT" " recoup_uuid AS serial" @@ -2437,6 +2445,29 @@ prepare_statements (struct PostgresClosure *pg) " ORDER BY wire_fee_serial ASC;", 1), GNUNET_PQ_make_prepare ( + "select_above_serial_by_table_global_fee", + "SELECT" + " global_fee_serial AS serial" + ",start_date" + ",end_date" + ",history_fee_val" + ",history_fee_frac" + ",kyc_fee_val" + ",kyc_fee_frac" + ",account_fee_val" + ",account_fee_frac" + ",purse_fee_val" + ",purse_fee_frac" + ",purse_timeout" + ",kyc_timeout" + ",history_expiration" + ",purse_account_limit" + ",master_sig" + " FROM global_fee" + " WHERE global_fee_serial > $1" + " ORDER BY global_fee_serial ASC;", + 1), + GNUNET_PQ_make_prepare ( "select_above_serial_by_table_recoup", "SELECT" " recoup_uuid AS serial" @@ -2728,6 +2759,28 @@ prepare_statements (struct PostgresClosure *pg) "($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);", 11), GNUNET_PQ_make_prepare ( + "insert_into_table_global_fee", + "INSERT INTO global_fee" + "(global_fee_serial" + ",start_date" + ",end_date" + ",history_fee_val" + ",history_fee_frac" + ",kyc_fee_val" + ",kyc_fee_frac" + ",account_fee_val" + ",account_fee_frac" + ",purse_fee_val" + ",purse_fee_frac" + ",purse_timeout" + ",kyc_timeout" + ",history_expiration" + ",purse_account_limit" + ",master_sig" + ") VALUES " + "($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16);", + 16), + GNUNET_PQ_make_prepare ( "insert_into_table_recoup", "INSERT INTO recoup" "(recoup_uuid" |