Repository navigation
How to access a dynamic table? #2823
Description
I have a bunch of sharded tables with name of the format: table_001, table_002, ... table_999.
The correct table is accessed by key % 1000.
So a query might look as follows:
select * from table_%03s where key=?
Before executing the query I format it with fmt.Sprintf(query, key).
Is there a way to do this in sqlc?
Activity
[-]How to access a dynamic db? [/-][+]How to access a dynamic table/db? [/+][-]How to access a dynamic table/db? [/-][+]How to access a dynamic table? [/+]