summaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
AgeCommit message (Collapse)Author
2022-02-17-fix CS nonce reuse check logicChristian Grothoff
2022-02-16[age restriction] progress 14/n - withdraw and depositÖzgür Kesim
Age restriction support for - withdraw is done and tested - deposit is done and tested TODOs: - melt/refresh/reveal - link ------ Added functions - TALER_age_restriction_commit - TALER_age_commitment_derive - TALER_age_commitment_hash - TALER_age_restriction_commitment_free_inside - Hash of age commitment passed around API boundaries Exchangedb adjustments for denominations - all prepared statements re: denominations now handle age_mask - signature parameters adjusted Hash and signature verification of /keys adjusted - Hashes of (normal) denominations and age-restricted denominations are calculated seperately - The hash of the age-restricted ones will then be added to the other hash - The total hash is signed/verified Tests for withdraw with age restriction added - TALER_EXCHANGE_DenomPublickey now carries age_mask - TALER_TESTING_cmd_withdraw_amount* takes age parameter - TALER_TESTING_find_pk takes boolean age_restricted - WithdrawState carries age_commitment and its hash - withdraw_run derives new age commitment, if applicable - Added age parameter to testing (13 as example) Various Fixes and changes - Fixes of post handler for /management/extensions - Fixes for offline tool extensions signing - Slight refactoring of extensions - Age restriction extension simplified - config is now global to extension - added global TEH_age_restriction_enabled and TEH_age_mask in taler-exchange-httpd - helper functions and macros introduced
2022-02-15-correctly implement CS idempotency check on withdrawChristian Grothoff
2022-02-10-fixes to tests, and half-baked fixes for CS-/link (still fails)Christian Grothoff
2022-01-21[age restriction] progress 12/nÖzgür Kesim
- taler-offline-tool now handles extensions - command "extensions" added with subcommands "show" and "sign" - parses extensions from taler config - shows and signs of extensions and their configurations - creates signed set of configurations for upload - added test for retrieval of extension config - simplified signature verification for extensions - remove per-extension signatures, also from DB schema - adjust prepared statements accordingly - adjust DB event handler for extensions - allow NULL for config for extension in DB schema - handler for /management/extensions adjusted to new datastructures - changed test for TALER_denom_blind/TALER_denom_sign_blinded with and without TALER_AgeHash - minor updates and various fixes
2022-01-11The current recoup API is broken. I guess this is another example where ↵Christian Grothoff
"trivial" API changes turn out to have (multiple!) unexpected consequences. The current "/recoup" API does not have clear idempotency semantics, as we've discussed on the phone. This is already bad by itself, as it makes it hard to write down what the API does other than "whatever the implementation does". However, it actually breaks correctness in this (admittedly kinda contrived, but not impossible) case: Say that we have a coin A obtained via withdrawal and a coin B obtained via refreshing coin A. Now the denominations of A gets revoked.. The wallet does a recoup of A for EUR:1. Now the denomination of B also gets revoked. The wallet recoups B (incidentally also for EUR:1) and now A can be recouped again for EUR:1. But now the exchange is in a state where it will refuse a legitimate recoup request for A because the detection for an idempotent request kicks in. This is IMHO bad API design, and the exchange should simply always recoup the maximum amount. Furthermore, we usually follow the principle of "API calls that take up DB space are paid". With the current recoup API, I can do many tiny recoup requests which the exchange then has to store, right? I guess it would not be a big change to remove the "amount" value from the recoup/recoup-refresh request bodies, right? - Florian
2022-01-10fix amount denormalization issueChristian Grothoff
2021-12-25protocol v12 changes (/recoup split, signature changes) plus database ↵Christian Grothoff
sharding plus O(n^2)=>O(n) worst-case complexity reduction on coin balance checks
2021-12-23[age restriction] progress 8/nÖzgür Kesim
More work towards support for extensions and age restriction - updated gana - added handler for DB-Event - added TEH_extensions_init() and _done() - added global for age restriction - added stub for post handler - added SQL-table for extension metadata - added enum type for extensions and other data structures Also: - fixed some warnings -Wmaybe-unitialized
2021-12-19denormalize reserve_pub in reserve tables to enable shardingChristian Grothoff
2021-12-16-fix recoup uglinessChristian Grothoff
2021-12-09introduce stored procedure for coin balance checkChristian Grothoff
2021-12-06improve SQL commentsChristian Grothoff
2021-12-05-add FIXMEsChristian Grothoff
2021-12-05major rework of withdraw transaction to use stored procedure and ↵Christian Grothoff
(presumably) reduce serialization failures by avoiding SELECT before INSERT
2021-11-29try to optimize aggregator queriesChristian Grothoff
2021-11-27sql fixChristian Grothoff
2021-11-27refactor get_ready_deposits query and index to hopefully make query fasterChristian Grothoff
2021-11-16fix oauth_username issueChristian Grothoff
2021-11-15complete oauth logic (in theory)Christian Grothoff
2021-11-07add missing fileChristian Grothoff
2021-11-06sql fixChristian Grothoff
2021-11-06move extension options to external tableChristian Grothoff
2021-11-01introduce invalid key typeChristian Grothoff
2021-11-01fix shardingChristian Grothoff
2021-10-31DB test passes againChristian Grothoff
2021-10-31fixing SQL statementsChristian Grothoff
2021-10-31misc fixesChristian Grothoff
2021-10-30-more dB workChristian Grothoff
2021-10-30-more dB workChristian Grothoff
2021-10-29fix SQLChristian Grothoff
2021-10-27database change -- breaks everythingChristian Grothoff
2021-08-31hyperaggregation schema proposalChristian Grothoff
2021-06-21fixing parallel fakebank to ensure transactions are ordered, fixing ↵Christian Grothoff
indices/constraint preservation after DB update to 0002
2021-01-10remove redundant old_coin_pub from link dataChristian Grothoff
2021-01-08change exchange database to use denominations_serial instead of ↵Christian Grothoff
denom_pub_hash as foreign key
2020-11-24database schema change for #6175Christian Grothoff
2020-07-08introduce known_coin_id, alas not yet usedChristian Grothoff
2020-07-05towards changing timestamp in deposit confirmation (tests failing)Christian Grothoff
2020-03-05new coins => fresh coins, also move comments into the database itselfChristian Grothoff
2020-02-09rename SQL files to make filenames consistent with versioning nameChristian Grothoff