2.2.2 • Published 8 years ago
sqlwatcher v2.2.2
sqlwatcher
Watch SQL files and have them automatically executed on a database. Perfect for handling a set of SQL functions you're working on.
using
First have a directory of SQL files:
├── designer_matching/
│ ├── array_search.sql
│ ├── client_room_score.sql
│ ├── designer_room_score.sql
│ ├── matching_score.sql
│ ├── raw_room_score.sql
│ ├── raw_style_score.sql
│ └── style_score.sql
└── rewrite_activities_for_v2_activities.sql
Each of these designer_matching/
files is a function, view, or table. While working on these functions you'll find yourself wanting to have them update the server's version. This is where sqlwatcher comes in:
$ sqlwatcher adapter:pg pattern:designer_matching/*.sql
Now when you change those files, you'll also be executing those files.