Category:BikeSaviours

From Traxel Wiki
Jump to navigation Jump to search


https://www.bikesaviours.org/

Random Notes

Database Notes

Updating Sign-Ins

  1. Update the spreadsheet: sign-ins_2021.ods in Marketing > Market Data > Sign-Ins: https://drive.google.com/drive/folders/1WUrkLeC3LK7cjh1Me8UiMOWWSohZLWaU?usp=sharing
  2. Export the month's sheet as a CSV.
  3. $ ./parse-sign-in-csv.pl 2021-12 > sql/2021-12.sql
  4. $ mariadb bsbc < sql/2021-12.sql
  5. $ mariadb bsbc
  6. > -- only safe because we only had one each Shamus, Nicole, Denzel, or Adam
  7. > update bsbc.staff_sign_in i set i.email = 'shamus@bikesaviours.org' where i.short_name = 'Shamus';
  8. > update bsbc.staff_sign_in i set i.email = 'nicole@bikesaviours.org' where i.short_name = 'Nicole';
  9. > update bsbc.staff_sign_in i set i.email = 'intern' where i.short_name = 'Denzel';
  10. > update bsbc.staff_sign_in i set i.email = 'intern' where i.short_name = 'Adam';
  11. > -- this is dangerous
  12. > set @date = '2021-12-02';
  13. > select i.shop_date, i.short_name, i.email from bsbc.staff_sign_in i where i.shop_date = @date;

Pages in category "BikeSaviours"

The following 2 pages are in this category, out of 2 total.