Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
commands [2025/11/06 01:39] – created agnescommands [2025/11/12 00:19] (current) agnes
Line 3: Line 3:
 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