gorm - Where is the appropriate place for SQL scripts in a Grails project -
i've got grails plugin exports domain objects several applications can share same schema. have few sql scripts setting complex triggers, views , other functions don't belong in gorm/hibernate, @ least not elegantly. i'd store scripts inside same project. "scripts" folder (the 1 containing _[un]install/upgrade.groovy) best place this? saw stackoverflow answer building catalog scripts stored in grails-app/conf/sql. i'm not trying execute them within project.
the absolute best solution database related use database migration plugin. way can ensure database application pointed (dev, test, prod, etc.) have same information/schema/functions/procedures etc.
Comments
Post a Comment