diff options
Diffstat (limited to 'src/exchangedb/pg_lookup_serial_by_table.c')
| -rw-r--r-- | src/exchangedb/pg_lookup_serial_by_table.c | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/src/exchangedb/pg_lookup_serial_by_table.c b/src/exchangedb/pg_lookup_serial_by_table.c index 5a0b493bf..500569c14 100644 --- a/src/exchangedb/pg_lookup_serial_by_table.c +++ b/src/exchangedb/pg_lookup_serial_by_table.c @@ -77,6 +77,22 @@ TEH_PG_lookup_serial_by_table (void *cls, " ORDER BY wire_target_serial_id DESC" " LIMIT 1;"); break; + case TALER_EXCHANGEDB_RT_LEGITIMIZATION_PROCESSES: + XPREPARE ("select_serial_by_table_legitimization_processes", + "SELECT" + " legitimization_process_serial_id AS serial" + " FROM legitimization_processes" + " ORDER BY legitimization_process_serial_id DESC" + " LIMIT 1;"); + break; + case TALER_EXCHANGEDB_RT_LEGITIMIZATION_REQUIREMENTS: + XPREPARE ("select_serial_by_table_legitimization_requiremetns", + "SELECT" + " legitimization_requirement_serial_id AS serial" + " FROM legitimization_requirements" + " ORDER BY legitimization_requirement_serial_id DESC" + " LIMIT 1;"); + break; case TALER_EXCHANGEDB_RT_RESERVES: XPREPARE ("select_serial_by_table_reserves", "SELECT" @@ -101,6 +117,30 @@ TEH_PG_lookup_serial_by_table (void *cls, " ORDER BY close_uuid DESC" " LIMIT 1;"); break; + case TALER_EXCHANGEDB_RT_RESERVES_OPEN_REQUESTS: + XPREPARE ("select_serial_by_table_reserves_open_requests", + "SELECT" + " open_request_uuid AS serial" + " FROM reserves_open_requests" + " ORDER BY open_request_uuid DESC" + " LIMIT 1;"); + break; + case TALER_EXCHANGEDB_RT_RESERVES_OPEN_DEPOSITS: + XPREPARE ("select_serial_by_table_reserves_open_deposits", + "SELECT" + " open_request_uuid AS serial" + " FROM reserves_open_deposits" + " ORDER BY open_request_uuid DESC" + " LIMIT 1;"); + break; + case TALER_EXCHANGEDB_RT_RESERVES_CLOSE_REQUESTS: + XPREPARE ("select_serial_by_table_reserves_close_requests", + "SELECT" + " close_request_uuid AS serial" + " FROM reserves_close_requests" + " ORDER BY close_request_uuid DESC" + " LIMIT 1;"); + break; case TALER_EXCHANGEDB_RT_RESERVES_OUT: XPREPARE ("select_serial_by_table_reserves_out", "SELECT" |