| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| commands [2025/11/06 04:09] – agnes | commands [2025/11/12 00:19] (current) – agnes |
|---|
| recreate site for updates to show up | recreate site for updates to show up |
| |
| sudo docker compose up -d web --force-recreate --removeorphans | sudo docker compose up -d web --force-recreate --remove-orphans |
| |
| reload elasticsearch: | reload elasticsearch: |
| |
| sudo docker compose exec -it web bash bin/reload_elastic | sudo docker compose exec -it web bash bin/reload_elastic |
| |
| mysql client login command: | mysql client login command: |
| |
| mysql -P 3306 --protocol tcp -u root -p | mysql -P 3306 --protocol tcp -u root -p |
| |
| insert tags: | insert tags: |
| |
| insert into tags (name, canonical, created_at, updated_at, type, sortable_name) | insert into tags (name, canonical, created_at, updated_at, type, sortable_name) values('Anime & Manga', 1, NOW(), NOW(), 'Media', 'Anime and Manga'); |
| 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)): | 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) | 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()); |
| |
| 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_admin", 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) | insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "archivist", null, null, NOW(), NOW()); |
| values("int(16) auto_increment", "translator_admin", null, null, NOW(), NOW()); | |
| |
| insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) | insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) values("int(16) auto_increment", "opendoors", null, null, NOW(), NOW()); |
| values("int(16) auto_increment", "archivist", null, null, NOW(), NOW()); | |
| | rails console |
| |
| insert into roles (id, name, authorizable_type, authorizable_id, created_at, updated_at) | |
| values("int(16) auto_increment", "opendoors", null, null, NOW(), NOW()); | |
| | docker compose run web bundle exec rails c |
| |