search

lter / LTER-core-metabase

RDB model, based on the GCE LTER Metabase, with adaptations from other LTER sites
https://lter.github.io/LTER-core-metabase/
GNU General Public License v3.0
11 stars 4 forks source link

Snake case conversion script #67

Open kf8a opened 5 years ago

kf8a commented 5 years ago

Added a util directory with a ruby script to rename columns and tables to snake_case

gastil commented 5 years ago

Sven wrote this so he can have a mb install in snake_case, for comparison to his metadata database. He will run this as a post-installation script. We can offer this as an option to others... although be aware this may cause (the dreaded phenomenon of) divergence. So, use responsibly. Note this is view-safe, since (1) it operates only on the lter_metbase schema which does not have views, and the alter statements, executed live, will cascade into the views in other schemas such as mb2eml. select A as B will only have A affected, not B. Looks good to me.