Axel Gustav AxelTheGerman
AxelTheGerman
/ my_uploader.rb
Created
June 4, 2019 22:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class MyUplaoder | |
| end |
AxelTheGerman
/ gist:931262b522412396c93565b7fd320820
Created
June 27, 2019 14:52
PG user availability
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ createdb demo | |
| $ psql demo | |
| demo=# CREATE TABLE users (id SERIAL PRIMARY KEY, timezone VARCHAR); | |
| demo=# CREATE TABLE timeslots (id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL, days INTEGER[] NOT NULL, start_time TIME NOT NULL, end_time TIME NOT NULL); | |
| demo=# CREATE TABLE chats (id SERIAL PRIMARY KEY, host_user_id INTEGER NOT NULL, guest_user_id INTEGER NOT NULL, start_time TIMESTAMP NOT NULL, end_time TIMESTAMP NOT NULL); | |
| demo=# INSERT INTO users (timezone) VALUES ('America/Los_Angeles'); | |
| demo=# INSERT INTO users (timezone) VALUES ('America/New_York'); | |
| demo=# INSERT INTO timeslots (user_id, days, start_time, end_time) VALUES (1, '{3}', '10:00', '15:00'); | |
| demo=# INSERT INTO chats (host_user_id, guest_user_id, start_time, end_time) VALUES (1, 2, '2019-06-26 11:30:00', '2019-06-26 12:30:00'); | |
| demo=# WITH time_range AS ( |