search

shift-org / shift-docs

Shift2Bikes: website and calendar for shift and pedalpalooza
https://shift2bikes.org
Other
22 stars 17 forks source link

Add convenience scripts for common db tasks #659

Open carrythebanner opened 7 months ago

carrythebanner commented 7 months ago

For tasks that require updating the database directly, I always have to look up the syntax. I also need to be extra careful to look for typos etc so I don't accidentally edit something I wasn't intending to.

It would be nice to have scripts for common db tasks: unpublishing an event, featuring (highlighting) an event, etc. Ideally they would use SQL variables so the meat of the statement doesn't have to be altered, just the variables at the top of the script. Store them somewhere discoverable, such as services/db/scripts.

ionous commented 7 months ago

one possibility is using npm/node. the 'tooling' branch doing that in app/scripts for creating fake events. granted this particular script is a little ugly, but the nice part is it can work on production, docker, or any local flavor os.

if someone knows how to setup a secure way of handling credentials through https ( via ngnix or node ) you could even take it a step further with a simple admin web page to trigger common scripts.