Skip to content

Instantly share code, notes, and snippets.

View kegbot_db - sql queries.sql
# Purpose:
# SELECT: All DRINKS of a specific Keg
# OUTPUT: Drink ID, Day of Week, Date and time (localtime),
# SORTED BY: Volume_ml
select id, substr('SunMonTueWedThuFriSat', 1 + 3*strftime('%w', datetime(time, "localtime")), 3), datetime(time, "localtime"), volume_ml from core_drink where keg_id=61 ORDER BY volume_ml;
# Purpose:
# SELECT: All DRINKS of a specific Keg ONLY if weekday (Mon-Fri)
# OUTPUT: Drink ID, Day of Week, Date and time (localtime)
@dboyd13
dboyd13 / aws-certified-security-specialist-study-notes.txt
Last active Oct 29, 2021
aws-certified-security-specialist-study-notes
View aws-certified-security-specialist-study-notes.txt
___ _____ ___ _ _ __ _ _ ___ _ _ ___ _ _ _
/_\ \ / / __| ___ / __|___ _ _| |_(_)/ _(_)___ __| | / __| ___ __ _ _ _ _(_) |_ _ _ / __|_ __ ___ __(_)__ _| | |_ _ _
/ _ \ \/\/ /\__ \ |___| | (__/ -_) '_| _| | _| / -_) _` | \__ \/ -_) _| || | '_| | _| || | \__ \ '_ \/ -_) _| / _` | | _| || |
/_/ \_\_/\_/ |___/ \___\___|_| \__|_|_| |_\___\__,_| |___/\___\__|\_,_|_| |_|\__|\_, | |___/ .__/\___\__|_\__,_|_|\__|\_, |
|__/ |_| |__/
Notes taken in Mar-2018, from acloud.guru and AWS FAQ
___ _ _ _ __ _
/ __| ___ __ _ _ _ _(_) |_ _ _ / |/ \/ |
@dboyd13
dboyd13 / gist:b1e15425a55279f6a0c34e7cce7e0b55
Created Aug 11, 2019
Micronta (Model: 63-7008) - Set date / time
View gist:b1e15425a55279f6a0c34e7cce7e0b55
For a Micronta (Model: 63-7008). Adjust the date/time as follows:
1) Press and HOLD the 'C / mode' button (bottom right) until 'AL' appears.
2) Press the 'C / mode' button again (Short press)
3) You are now in the set time mode. Move positions by pressing 'X', adjust position value by pressing '-' (minus)
4) Once you've set the time, Move to the calendar positions using the same 'X' key
5) Once complete, press the 'C / mode' button to return to the standard time display.