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>
Basic scaffold to get started on the go api.
Reviewed-on: #25
Reviewed-by: zephyr <zephyr@noreply.localhost>
Co-authored-by: karitham <kar@karitham.dev>
Co-committed-by: karitham <kar@karitham.dev>
Reviewed-on: #26
Reviewed-by: kar <kar@noreply.localhost>
Co-authored-by: Branden J Brown <zephyrtronium@gmail.com>
Co-committed-by: Branden J Brown <zephyrtronium@gmail.com>
Fixes#14.
Co-authored-by: Hamza Ali <sunturtle@hamza.sh>
Reviewed-on: #20
Reviewed-by: hamza <hamza@noreply.localhost>
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>
Define the initial schemata for emotes, users, and lists.
Fixes#9.
Co-authored-by: Branden J Brown <zephyrtronium@gmail.com>
Reviewed-on: #12
Reviewed-by: hamza <hamza@noreply.localhost>
Reviewed-on: #2
Reviewed-by: snail <snail@noreply.localhost>
Co-authored-by: Hamza Ali <sunturtle@hamza.sh>
Co-committed-by: Hamza Ali <sunturtle@hamza.sh>
