Commit Graph

16 Commits

Author SHA1 Message Date
Mohamed Sohail 93d07b8ca3
fix: coalesce null value 2022-11-16 17:21:01 +03:00
Mohamed Sohail f93727925e
patch: prevent multiple rows from inner query
` UNION ALL SELECT address_description FROM sys_accounts WHERE sys_address = transactions.recipient_address`
2022-11-16 17:01:44 +03:00
Mohamed Sohail e158ce28bc
add: MUN to metrics
closes #54
2022-09-29 10:59:23 +03:00
Mohamed Sohail 18020e8451
fix: sql cmr queries 2022-08-26 07:59:14 +00:00
Mohamed Sohail 8456ea78f8
patch: cameroon specific dashboard queries 2022-08-26 07:23:26 +00:00
Mohamed Sohail a2422811cb
feat: add support for archived tokens
- uses token address for archived tokens

others fixes:

increase token name limit
2022-07-13 16:30:28 +03:00
Mohamed Sohail b59c0ba3fc
feat: transaction history (including by voucher) (#24)
* sql: add transaction transaction record queries

- get full tx history
- get latest txs for a specific token

* sql: (fix) add id column to select

* sql: (fix) change column name to identifier

* fix: pagination queries

- refactor keyset pagination query to correctly fecth previous page
- remove pagination from token list
- add fetch latest transactions by token

* tidy: remove dev logs

* feat: (db) add index for desc for pagination
2022-06-16 12:27:18 +03:00
Mohamed Sohail 77f127e14a
feat: add admin/auth api (#22)
* feat: add admin/auth api

- jwt cookie based auth
- /auth
- admin/*

* add: meta proxy

* fix: remove ussd account status from syncer

* add: cookie defaults and nuxt init check route

* add: pin and address handlers
2022-06-02 11:24:58 +03:00
Mohamed Sohail 861af1761d
Sohail/latest token transactions (#21)
* add: latest-token-transactions table

* fix: remove token symbol from query

* fix: move latest tx to dashboard domain
2022-05-26 09:35:39 +03:00
Mohamed Sohail 7bda44c169
add: (feat) individual token stats
- volume chart
- token holders
- token tx count

* minor refactors
2022-05-23 15:41:24 +03:00
Mohamed Sohail f00e97cc94
fix: (sql) exclude system accounts from metrics 2022-05-21 11:03:23 +03:00
Mohamed Sohail 37538c68ff
add (feat) pagination helpers and token endpoint
- see docs for pagination api usage
- added control for syncer/api goroutines
2022-05-19 16:24:26 +03:00
Mohamed Sohail 7d431f1c8f
add: (wip) balances query API 2022-05-14 11:15:45 +03:00
Mohamed Sohail d4506e6303
update: (dashboard-api) cors and sql limits
- add cors for core websites and dev env
- update sql query limit to 2 years
- enabled future cors for auth
2022-05-12 12:32:33 +03:00
Mohamed Sohail 128b15407a
server: init api server
- echo (https://echo.labstack.com/) as web framework
- carbon for auto date-range parsing
- add dashboard sql queries
2022-05-11 16:57:56 +03:00
Mohamed Sohail 6b71657e5b
sohail/update deps structure (#5)
* refactor: syncer structure

- move syncer jobs to internal dir

* refactor: queries struct and pkg updates

- update cic-go to latest
- separate sql queries by logic

* ci: add dependabot
2022-05-11 12:32:11 +03:00