aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
AgeCommit message (Collapse)Author
2022-03-20add p2p tables from dd13Christian Grothoff
2022-03-19more work on recoup_by_reserve: add new materialized index to avoid hitting ↵Christian Grothoff
all partitions for the query
2022-03-19add missing index, move indices closer to table generationChristian Grothoff
2022-03-18add deposits_by_coin table to speed-up certain queries (in theory)Christian Grothoff
2022-03-18add selection by shard, ignore KYC in revocation test aggregationChristian Grothoff
2022-03-18change table structures again to shard better by coin_pub and not use ↵Christian Grothoff
known_coin_id so much
2022-03-17-remove dead field, return h_commitment_age to auditorChristian Grothoff
2022-03-17-misc fixesChristian Grothoff
2022-03-14attempt to make GRID5K_MARCO_OPT superfluousChristian Grothoff
2022-03-05work on global fee structureChristian Grothoff
2022-03-05refactor /wire to include logic to return the wad fee (for W2W payments)Christian Grothoff
2022-03-03use 32 byte hash for hpayto, use that for joins on queries to better align ↵Christian Grothoff
queries with partitions
2022-03-02include partitioning logic in dbinitMarco Boss
2022-03-01stay with partitions for now - find shards on dev/boss/shardingMarco Boss
2022-03-01tested shard creation locallyMarco Boss
2022-03-01prepare sharding / partitioning initMarco Boss
- create exchange-0001.sql with functions to create all tables and partitions / shards - create exchange-0002.sql for the master db
2022-02-28-work on test_sync.sh, incompleteChristian Grothoff
2022-02-28cleaner sqlMarco Boss
2022-02-28get test-auditor and #7181 to passChristian Grothoff
2022-02-27towards adding shard/partitioning init functionalityMarco Boss
2022-02-26add index on wire_targetsMarco Boss
- better performance on local db - many queries use wire_target_serial_id as join condition -> discussion use this as shard key?
2022-02-24Fix ON CONFLICT statements for distributed tablesMarco Boss
2022-02-24-on conflict exampleChristian Grothoff
2022-02-24-fix aggregator with deferred constraintChristian Grothoff
2022-02-24-unique constraint is crucialChristian Grothoff
2022-02-22[age restriction] progress 16/n - refresh/reveal/link testsÖzgür Kesim
Age restriction works now with withdraw, melt/refresh/reveal and link, including tests. However, there is still a problem with the tests: The melting operation "refresh-melt-failing-age" that should fail (because of conflict), but currently fails for other reasons. I decided to disable that particular test (and the next) and submit the patch I have so far.
2022-02-17-migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS IDENTITY ↵Christian Grothoff
instead of BIGSERIAL
2022-02-17-use age_maskChristian Grothoff
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