This is a page that outlines all the commands I need for basic maintenance of Sunset and Symphony so I have them all in one easily copy-pastable space.

recreate site for updates to show up

sudo docker compose up -d web --force-recreate --remove-orphans

reload elasticsearch:

sudo docker compose exec -it web bash bin/reload_elastic 

mysql client login command:

mysql -P 3306 --protocol tcp -u root -p

insert tags:

insert into tags (name, canonical, created_at, updated_at, type, sortable_name) values('Anime & Manga', 1, NOW(), NOW(), 'Media', 'Anime and Manga');

add roles (for initial deployments if i ever decide to make a third site (unlikely)):

insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "tag_wrangler", null, null, NOW(), NOW());


insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "translator", null, null, NOW(), NOW());

insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "translator_admin", null, null, NOW(), NOW());

insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "archivist", null, null, NOW(), NOW());

insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "opendoors", null, null, NOW(), NOW());

rails console

  docker compose run web bundle exec rails c