grid api refactoring plan

[Omarabdul3ziz]

• unified mapping from chain types to db types
  • define a proper db schema (consider pk/fk/idx)
  • reduce the use of jsonb objects
  • db should return its own types (models)
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/843
  • consider bun/sqlc
• api v2
  • define a proper api schema
  • api client/ routing pkgs
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/57
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/49
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/340
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/50
• testing
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/610
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/338
  • https://github.com/threefoldtech/tfgrid-sdk-go/pull/695
  • revisit the integration tests
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/643
• API server
  • a validation layer for all (filtering/paginating/sorting) key/value
• app structure
  • separate bins for (api-server/node-indexer/chain-processor)
  • separate db client to (query-client/mutate-client) query client used with the server, mutate-client used with processor/indexer
  • support running from config/flags
• docs
  • https://github.com/threefoldtech/tfgrid-sdk-go/issues/217
  • write a developer guide explain each part of the project
  • explain the tricky filters (dedicated/rentable/...)

[Nabil-Salah]

5/11/2024

Worked on listing all mapping happens in

• graphql processor
• gridproxy triggers (Farms, addEvent, Service Contracts, Extra Fee For nodes, Price Stored, Average Price Stored)

[SalmaElsoly]

5/11

Listed events happen and how are they handled with associated triggers:

• Policies
• Nodes
• Twins