This is an old revision of the document!

---

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 --removeorphans

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());

Edit this page