11 Commits (main)

Author	SHA1	Message	Date
William Perron	1097ce5fce	use table instead of view for better perf	11 months 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.	11 months ago
William Perron	73c327d51b	update provinces table with latest version ... Fixes #10	11 months ago
William Perron	b040694c2a	add basic audit log	12 months 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.	12 months 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