GlobalFishingWatch / treniformis

Apache License 2.0
5 stars 6 forks source link

Parameterize table name #21

Closed pwoods25443 closed 7 years ago

pwoods25443 commented 7 years ago

We should consider parameterizing the table names in all of the sql queries and getting the table name from a master config file

bitsofbits commented 7 years ago

I was thinking of switching the SQL queries to using Python style formating, so we could use query = sql.format(**dict_of_values) to pass the date in. This would also make it easy to pass in table names and whatever else we like.

Should that config file be json, or something else?