grassrootseconomics/cic-dw
8
0
Fork 0
mirror of https://github.com/GrassrootsEconomics/cic-dw.git synced 2026-11-06 12:38:03 +01:00
Code Issues Projects Releases Wiki Activity
89 Commits 17 Branches 32 Tags
master
Commit Graph
75 Commits
This Branch
This Branch
All Branches
Author SHA1 Message Date
kamikazechaser 93d07b8ca3 fix: coalesce null value 2022-11-16 17:21:01 +03:00
kamikazechaser 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
kamikazechaser e158ce28bc add: MUN to metrics 
closes #54
 2022-09-29 10:59:23 +03:00
kamikazechaser 18020e8451 fix: sql cmr queries 2022-08-26 07:59:14 +00:00
kamikazechaser 7fa1e1a7c0 Merge pull request #44 from grassrootseconomics/dependabot/go_modules/github.com/knadh/koanf-1.4.3 
build(deps): bump github.com/knadh/koanf from 1.4.2 to 1.4.3
 2022-08-26 10:32:07 +03:00
kamikazechaser 11718c6452 Merge pull request #43 from grassrootseconomics/dependabot/go_modules/github.com/ethereum/go-ethereum-1.10.23 
build(deps): bump github.com/ethereum/go-ethereum from 1.10.20 to 1.10.23
 2022-08-26 10:31:29 +03:00
kamikazechaser a8f2d2e189 Merge pull request #41 from grassrootseconomics/dependabot/go_modules/github.com/labstack/echo/v4-4.8.0 
build(deps): bump github.com/labstack/echo/v4 from 4.7.2 to 4.8.0
 2022-08-26 10:29:55 +03:00
kamikazechaser 96c3f85d46 Merge pull request #40 from grassrootseconomics/dependabot/go_modules/github.com/jackc/pgx/v4-4.17.0 
build(deps): bump github.com/jackc/pgx/v4 from 4.16.1 to 4.17.0
 2022-08-26 10:29:45 +03:00
kamikazechaser c6fb53a1b9 Merge pull request #39 from grassrootseconomics/dependabot/go_modules/github.com/golang-module/carbon/v2-2.1.9 
build(deps): bump github.com/golang-module/carbon/v2 from 2.1.8 to 2.1.9
 2022-08-26 10:29:36 +03:00
kamikazechaser c352ebdd2f Merge pull request #37 from grassrootseconomics/dependabot/go_modules/github.com/georgysavva/scany-1.1.0 
build(deps): bump github.com/georgysavva/scany from 1.0.0 to 1.1.0
 2022-08-26 10:29:27 +03:00
kamikazechaser 6ffbe2ff2a ci: docker registry fix 2022-08-26 07:28:40 +00:00
kamikazechaser 8456ea78f8 patch: cameroon specific dashboard queries 2022-08-26 07:23:26 +00:00
kamikazechaser c490f28a96 Merge pull request #33 from grassrootseconomics/sohail/archived-tokens 
feat: add support for archived tokens
 2022-07-13 16:34:23 +03:00
kamikazechaser 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
kamikazechaser a0ba153401 sql: drop uniq on tokens table 
- This change makes token management manual
 2022-07-05 10:14:08 +03:00
kamikazechaser 1e31e1af1c Merge https://github.com/GrassrootsEconomics/cic-dw 2022-07-05 09:48:01 +03:00
kamikazechaser 706eb86550 config: update chain token index 2022-07-05 09:47:39 +03:00
kamikazechaser f9210d6e04 Merge pull request #30 from grassrootseconomics/dependabot/go_modules/github.com/ethereum/go-ethereum-1.10.20 
build(deps): bump github.com/ethereum/go-ethereum from 1.10.19 to 1.10.20
 2022-07-04 18:13:51 +03:00
kamikazechaser c8ecb750bc Merge pull request #27 from grassrootseconomics/dependabot/go_modules/github.com/lmittmann/w3-0.8.1 
build(deps): bump github.com/lmittmann/w3 from 0.8.0 to 0.8.1
 2022-07-04 16:02:40 +03:00
kamikazechaser ea270c0754 Merge pull request #26 from grassrootseconomics/dependabot/go_modules/github.com/knadh/koanf-1.4.2 
build(deps): bump github.com/knadh/koanf from 1.4.1 to 1.4.2
 2022-07-04 16:02:15 +03:00
kamikazechaser 7497d0cd41 fixes: deepsource suggestions 2022-07-04 16:01:44 +03:00
kamikazechaser f20f4ca22d migrations: remove ge community fund 2022-07-04 15:42:21 +03:00
kamikazechaser b6e8898705 docs: update pagination spec 2022-06-16 12:30:40 +03:00
kamikazechaser 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
kamikazechaser f196af0e63 Merge pull request #23 from grassrootseconomics/dependabot/go_modules/github.com/rs/zerolog-1.27.0 
build(deps): bump github.com/rs/zerolog from 1.26.1 to 1.27.0
 2022-06-16 12:26:51 +03:00
kamikazechaser 3697a07357 Merge pull request #25 from grassrootseconomics/dependabot/go_modules/github.com/ethereum/go-ethereum-1.10.19 
build(deps): bump github.com/ethereum/go-ethereum from 1.10.18 to 1.10.19
 2022-06-16 12:25:47 +03:00
kamikazechaser 0fe78049f5 fix: (patch) meta endpoint config loader 2022-06-04 13:27:41 +03:00
kamikazechaser 5319359e88 patch: enable secure cookie 2022-06-02 11:51:19 +03:00
kamikazechaser e19ba9d50c deps: upgraded github.com/georgysavva/scany 
v0.3.0 => v1.0.0
 2022-06-02 11:31:31 +03:00
kamikazechaser a016e295ef Merge pull request #18 from grassrootseconomics/dependabot/go_modules/github.com/golang-module/carbon/v2-2.1.8 
build(deps): bump github.com/golang-module/carbon/v2 from 2.1.6 to 2.1.8
 2022-06-02 11:27:35 +03:00
kamikazechaser 657645f92c Merge pull request #20 from grassrootseconomics/dependabot/go_modules/github.com/lmittmann/w3-0.8.0 
build(deps): bump github.com/lmittmann/w3 from 0.7.0 to 0.8.0
 2022-06-02 11:25:41 +03:00
kamikazechaser 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
kamikazechaser 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
kamikazechaser 3f24894700 Merge pull request #17 from grassrootseconomics/sohail/tokens-api-stats 
add: (feat) individual token stats
 2022-05-23 15:45:03 +03:00
kamikazechaser 7bda44c169 add: (feat) individual token stats 
- volume chart
- token holders
- token tx count

* minor refactors
 2022-05-23 15:41:24 +03:00
kamikazechaser f00e97cc94 fix: (sql) exclude system accounts from metrics 2022-05-21 11:03:23 +03:00
kamikazechaser 642ccdddaa docs: add pagination api 2022-05-19 16:34:24 +03:00
kamikazechaser ef60e1b035 Merge pull request #15 from grassrootseconomics/sohail/tokens-api 
add (feat) pagination helpers and token endpoint
 2022-05-19 16:25:00 +03:00
kamikazechaser 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
kamikazechaser 2548e68c36 Merge pull request #9 from grassrootseconomics/sohail/public-api 
add: (feat) balances query API
 2022-05-19 10:28:41 +03:00
kamikazechaser eb05761a51 fix: error messages 2022-05-19 10:27:51 +03:00
kamikazechaser f0690d62be add: (feat) balances query api 
- add address utils
- return uint64 for balances instead of float
 2022-05-19 09:52:34 +03:00
kamikazechaser 7d431f1c8f add: (wip) balances query API 2022-05-14 11:15:45 +03:00
kamikazechaser 352b89332f docs: fix badges 2022-05-14 11:08:26 +03:00
kamikazechaser 18eafe9694 docs: add description and README 2022-05-14 11:06:42 +03:00
kamikazechaser 8288880c79 Merge branch 'sohail/dashboard-api' 2022-05-12 12:33:04 +03:00
kamikazechaser 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
kamikazechaser bba6e330df docker: fix dir copy 2022-05-11 18:42:02 +03:00
kamikazechaser 801d6d71c9 ci: fix goreleaser 2022-05-11 17:05:11 +03:00
kamikazechaser 9b66f4b2d6 Merge pull request #6 from grassrootseconomics/sohail/dashboard-api 
server: init api server
 2022-05-11 16:59:22 +03:00
kamikazechaser 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
kamikazechaser f5642c0e05 docker: fix new queries path 2022-05-11 12:36:59 +03:00
kamikazechaser 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
kamikazechaser 9882a9ddc6 refactor: move pkg's out 
- to cic_go
 2022-05-06 16:53:57 +03:00
kamikazechaser b4a7668ca4 fix: (redis) parse redis dsn 2022-05-05 19:58:27 +03:00
kamikazechaser 6902033586 project: remove changelog 
- tracked by go releaser
 2022-05-05 19:40:12 +03:00
kamikazechaser a68ae5a9eb fix: (redis) bootstrap connection struct properly 2022-05-05 19:39:25 +03:00
kamikazechaser da66f70bf9 ci: remove uncessary deps build 2022-05-05 16:39:25 +03:00
kamikazechaser 16add59db5 ci: fix yml 2022-05-05 16:37:23 +03:00
kamikazechaser ab7a6ebad8 ci: fix docker login 2022-05-05 16:35:23 +03:00
kamikazechaser 037d709e0e release: v0.1.1 2022-05-05 16:31:01 +03:00
kamikazechaser 342bb98d1b ci: add build 2022-05-05 16:29:29 +03:00
kamikazechaser 2457ee7483 add: license 2022-05-05 15:10:27 +03:00
kamikazechaser 072e5600a0 release: v0.1.0 2022-05-05 15:06:23 +03:00
kamikazechaser 9c6310440c refactor: syncer structure and async bootstrapping 
- asynq bootstrap handlers
- graceful shutdown of goroutines
- remove unnecessary global App struct
- unmarhsal toml/env to koanf struct
 2022-05-05 15:01:34 +03:00
kamikazechaser 4f868d8d94 fix: (pkg) revert to untrimmed address, panic on failed dial 
- TODO: cicnet should be initialized at job handler level
 2022-05-05 14:58:47 +03:00
kamikazechaser 659007e563 fix: (sql) lower case addresses for easier joins 
- add schema docs
 2022-05-05 14:56:22 +03:00
kamikazechaser 1c65a11460 add: ussd and cache syncer tasks 
- no repeat on failure, picked up on next schedule
- enforce uniq on users and tx table to prevent duplicates
 2022-05-03 21:37:48 +03:00
kamikazechaser 05ab865c63 add: token syncer 
core:
- add koanf for runtime config loading
- cicnet connection must dial else panic
- add db connection init
- add goyesql for convenient querying
- add async tasker processor (scheduler, processor)

dev:
- add redis server to dev docker-compose
- update volume to prune-able local
 2022-05-03 18:54:51 +03:00
kamikazechaser d9f42005af fix: (schema) tgrm indexes and cursor init 2022-05-03 18:46:56 +03:00
kamikazechaser a6f24042f5 add: cic-meta client 2022-04-29 17:04:01 +03:00
kamikazechaser e81a505681 fix: (ethClient) handle teardown 2022-04-29 11:12:47 +03:00
kamikazechaser e6651fc911 add: cicnet package 
- query cicnet contracts
 2022-04-29 11:09:25 +03:00
kamikazechaser 18359139e1 fix: migration 
- add cursor descriptions
- enable search extension on indexes
 2022-04-29 11:02:03 +03:00
kamikazechaser b7452778d5 project: init 
- create dw db structure
- write remote syncer queries
 2022-04-25 18:29:38 +03:00