Define the user management, chat management, and moderation API
interfaces. Everything except auth at this point.
Also update config so that mise gen:api in the repository root handles
everything.
For #11.
Reviewed-on: #33
Reviewed-by: snail <snail@noreply.localhost>
Co-authored-by: Branden J Brown <zephyrtronium@gmail.com>
Co-committed-by: Branden J Brown <zephyrtronium@gmail.com>
There are some minor modifications that should be scrutinized, and a change to remove set_id from user_connections to be replaced with a join table of connection_id (new) and set_id
Reviewed-on: #35
Reviewed-by: snail <snail@noreply.localhost>
Reviewed-by: zephyr <zephyr@noreply.localhost>
- Converts the driver to postgres
- Sets up pg pool
- adds river and goose as go tools
- updates the mise job for doing migrations
Reviewed-on: #31
Reviewed-by: zephyr <zephyr@noreply.localhost>
Update TypeSpec to v1.0.0.
Version the API. It will live at api.ligmotes.com/v1.
Change emote sets to include both the emote ID and the file content hash for the 1x scale.
Queries can choose a media type, although currently we only enumerate AVIF.
Reviewed-on: #30
Reviewed-by: smantic <tyler@smantic.dev>
Co-authored-by: Branden J Brown <zephyrtronium@gmail.com>
Co-committed-by: Branden J Brown <zephyrtronium@gmail.com>
- Sets up the go module.
- Sets up goose to use for database migrations.
- Begins setup of some other basic things such as the logger and the http server.
Closes #17 and #8
Reviewed-on: #18
Add emote.color for sorting by color.
Add index on emote.uploader for querying emotes uploaded by a user.
Add user_connection.platform_name for searching users.
Include platform_id in user_connection unique index so a person who uses
multiple Twitch accounts can use a single Ligmotes account to manage all
of them.
Rearrange list_editor from (list, user) to (user, list) since we can
express every editor query we could want in terms of user as input.
Various renamings & index adjustments.
Reviewed-on: #15
Co-authored-by: Branden J Brown <zephyrtronium@gmail.com>
Co-committed-by: Branden J Brown <zephyrtronium@gmail.com>