11 Commits (main)

Author	SHA1	Message	Date
William Perron	1097ce5fce	use table instead of view for better perf	1 year ago
William Perron	171ef4ee98	Add `claimables` view to database ... Materialize all claimable provinces into a view with a column for the claim type. the `provinc` column contains duplicated rows but each row contains a unique combination of province and claim type. This makes it much easier to search possible conflicts, or to list the availability of provinces.	1 year ago
William Perron	73c327d51b	update provinces table with latest version ... Fixes #10	1 year ago
William Perron	b040694c2a	add basic audit log	1 year ago
William Perron	638083a755	Add absences feature set ... ## Add absences table and basic queries * Add migration scripts * Add queries to add, get and list absences * Add tests for the above * Add function to get the date of the next Monday Also fixes potential bug in the build where the output binary would be written to a file called `./bin` rather than a file named after the source directory in a _directory_ called `./bin`. ## Add /schedule command Adds the Discord slash command to get the schedule for the next few weeks. Also updates the required Go version to 1.21 to benefit from the new `time.DateOnly` format that's gonna be used in the absences table. ## Add scheduled message every Saturday 5pm Adds the `notify.go` file which manages the scheduling of the recurrent message that will ping the group every week about the following game. ## Add /absent command Adds command to register as absent for a specific date. The command takes in one optional parameter for the date, if none is specified, defaults to the next session.	1 year ago
William Perron	aaf569cb69	add golang-migrate	1 year ago
William Perron	84df9458be	Add userid column to claims table ... Fixes #11	2 years ago
William Perron	702f3c9da3	add autocomplete for the claim function	2 years ago
William Perron	89ad6bbe2e	add function to take claim	2 years ago
William Perron	8ecb6ed394	WIP	2 years ago
William Perron	3a8df77e46	project scaffold	2 years ago