Populate the liquidity_pools table with dfk and viperswap pool data
Fixes issues #109 and #110
@antonyip @chuxinh
Tests
[x] Please provide evidence of your successful dbt run / dbt test here
root@e3ec544e8b62:/harmony# dbt run --select liquidity_pools
Running with dbt=0.21.1
Found 45 models, 389 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 12 seed files, 21 sources, 0 exposures
13:15:41 | Concurrency: 4 threads (target='dev')
13:15:41 |
13:15:41 | 1 of 1 START table model DEV.liquidity_pools......................... [RUN]
13:15:49 | 1 of 1 OK created table model DEV.liquidity_pools.................... [SUCCESS 1 in 8.59s]
13:15:49 |
13:15:49 | Finished running 1 table model in 14.90s.
root@e3ec544e8b62:/harmony# dbt test --select liquidity_pools
Running with dbt=0.21.1
Found 45 models, 389 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 12 seed files, 21 sources, 0 exposures
13:05:42 | Concurrency: 4 threads (target='dev')
13:05:42 |
13:05:42 | 1 of 5 START test not_null_liquidity_pools_pool_address.............. [RUN]
13:05:42 | 2 of 5 START test not_null_liquidity_pools_pool_name................. [RUN]
13:05:42 | 3 of 5 START test not_null_liquidity_pools_token0.................... [RUN]
13:05:42 | 4 of 5 START test not_null_liquidity_pools_token1.................... [RUN]
13:05:46 | 4 of 5 PASS not_null_liquidity_pools_token1.......................... [PASS in 3.40s]
13:05:46 | 5 of 5 START test unique_liquidity_pools_pool_address................ [RUN]
13:05:46 | 1 of 5 PASS not_null_liquidity_pools_pool_address.................... [PASS in 3.59s]
13:05:46 | 2 of 5 PASS not_null_liquidity_pools_pool_name....................... [PASS in 3.60s]
13:05:46 | 3 of 5 PASS not_null_liquidity_pools_token0.......................... [PASS in 3.67s]
13:05:48 | 5 of 5 PASS unique_liquidity_pools_pool_address...................... [PASS in 2.78s]
13:05:48 |
13:05:48 | Finished running 5 tests in 9.36s.
Completed successfully
Done. PASS=5 WARN=0 ERROR=0 SKIP=0 TOTAL=5
- [ ] Any comparison between `prod` and `dev` for any schema change
# Checklist
- [x] Follow [dbt style guide](https://github.com/dbt-labs/corp/blob/main/dbt_style_guide.md)
- [x] Tag the person(s) responsible for reviewing proposed changes
- [ ] Notes to deployment, if a `full-refresh` is needed for any table
- [x] Run `dbt docs generate` to update the documentation files if this PR is changing the models in any way.
Description
Populate the liquidity_pools table with dfk and viperswap pool data
Fixes issues #109 and #110
@antonyip @chuxinh
Tests
dbt run
/dbt test
here13:15:41 | Concurrency: 4 threads (target='dev') 13:15:41 | 13:15:41 | 1 of 1 START table model DEV.liquidity_pools......................... [RUN] 13:15:49 | 1 of 1 OK created table model DEV.liquidity_pools.................... [SUCCESS 1 in 8.59s] 13:15:49 | 13:15:49 | Finished running 1 table model in 14.90s.
root@e3ec544e8b62:/harmony# dbt test --select liquidity_pools Running with dbt=0.21.1 Found 45 models, 389 tests, 0 snapshots, 0 analyses, 180 macros, 0 operations, 12 seed files, 21 sources, 0 exposures
13:05:42 | Concurrency: 4 threads (target='dev') 13:05:42 | 13:05:42 | 1 of 5 START test not_null_liquidity_pools_pool_address.............. [RUN] 13:05:42 | 2 of 5 START test not_null_liquidity_pools_pool_name................. [RUN] 13:05:42 | 3 of 5 START test not_null_liquidity_pools_token0.................... [RUN] 13:05:42 | 4 of 5 START test not_null_liquidity_pools_token1.................... [RUN] 13:05:46 | 4 of 5 PASS not_null_liquidity_pools_token1.......................... [PASS in 3.40s] 13:05:46 | 5 of 5 START test unique_liquidity_pools_pool_address................ [RUN] 13:05:46 | 1 of 5 PASS not_null_liquidity_pools_pool_address.................... [PASS in 3.59s] 13:05:46 | 2 of 5 PASS not_null_liquidity_pools_pool_name....................... [PASS in 3.60s] 13:05:46 | 3 of 5 PASS not_null_liquidity_pools_token0.......................... [PASS in 3.67s] 13:05:48 | 5 of 5 PASS unique_liquidity_pools_pool_address...................... [PASS in 2.78s] 13:05:48 | 13:05:48 | Finished running 5 tests in 9.36s.
Completed successfully
Done. PASS=5 WARN=0 ERROR=0 SKIP=0 TOTAL=5