Skip to content

sui_v1.25.0_1714851727_ci

sui_v1.25.0_1714851727_ci: Add migrations for mysql (#17421)
@sadhansood sadhansood tagged this 04 May 16:42 
## Description 

This PR adds migrations for mysql database. After this we should be able
to use indexer-writer for data ingestion into a mysql database.
## Test plan 

Tested by running locally with:
```
cargo run  --bin sui-indexer --features mysql-feature --no-default-features -- --db-url <> --rpc-client-url <> --fullnode-sync-worker --reset-db

2024-04-30T18:16:06.843439Z  INFO sui_data_ingestion_core::worker_pool: received checkpoint for processing 1420 for workflow workflow
2024-04-30T18:16:06.843456Z  INFO sui_indexer::handlers::checkpoint_handler: Indexing checkpoint data blob checkpoint_seq=1420
2024-04-30T18:16:06.843477Z  INFO sui_indexer::handlers::checkpoint_handler: Resolving Move struct layouts for struct tags of size 1.
2024-04-30T18:16:06.845713Z  INFO sui_indexer::handlers::checkpoint_handler: Indexed one checkpoint. checkpoint_seq=1388
2024-04-30T18:16:06.845739Z  INFO sui_data_ingestion_core::worker_pool: finished checkpoint processing 1388 for workflow workflow in 33.194375ms
2024-04-30T18:16:06.845768Z  INFO sui_data_ingestion_core::worker_pool: received checkpoint for processing 1396 for workflow workflow
2024-04-30T18:16:06.845784Z  INFO sui_indexer::handlers::checkpoint_handler: Indexing checkpoint data blob checkpoint_seq=1396
2024-04-30T18:16:06.845804Z  INFO sui_indexer::handlers::checkpoint_handler: Resolving Move struct layouts for struct tags of size 1.
2024-04-30T18:16:06.848785Z  INFO sui_indexer::handlers::checkpoint_handler: Indexed one checkpoint. checkpoint_seq=1385
2024-04-30T18:16:06.848819Z  INFO sui_data_ingestion_core::worker_pool: finished checkpoint processing 1385 for workflow workflow in 56.440792ms
2024-04-30T18:16:06.848861Z  INFO sui_data_ingestion_core::worker_pool: received checkpoint for processing 1382 for workflow workflow
2024-04-30T18:16:06.848883Z  INFO sui_indexer::handlers::checkpoint_handler: Indexing checkpoint data blob checkpoint_seq=1382
2024-04-30T18:16:06.848912Z  INFO sui_indexer::handlers::checkpoint_handler: Resolving Move struct layouts for struct tags of size 1.
2024-04-30T18:16:06.849557Z  INFO sui_indexer::handlers::checkpoint_handler: Indexed one checkpoint. checkpoint_seq=1383
2024-04-30T18:16:06.849573Z  INFO sui_data_ingestion_core::worker_pool: finished checkpoint processing 1383 for workflow workflow in 39.8655ms

```
Assets 2
Loading