| workflow_ids = [] | |
| subject_set_ids = [] | |
| workflow_ids.map do |wf_id| | |
| subject_set_ids.map do |set_id| | |
| set_subject_ids = SetMemberSubject.where(subject_set_id: set_id).pluck(:subject_id) | |
| # UNCOMMMENT ONE OF THESE, I DO A SANITY CHECK COUNT FIRST, THEN UNRETIRE | |
| # run a count for sanity check | |
| # SubjectWorkflowStatus.where.not(retired_at: nil).where(workflow_id: wf_id, subject_id: set_subject_ids).count | |
| # RUN THE UNRETIRE | |
| SubjectWorkflowStatus.where.not(retired_at: nil).where(workflow_id: wf_id, subject_id: set_subject_ids).update_all(retired_at: nil, retirement_reason: nil) |
| # this assumes the rails console has preloaded the resources; accordingly, | |
| # you should invoke this script as | |
| # | |
| # rails c < move_small.rb | |
| begin | |
| args_list = [] | |
| jobs_list = [] | |
| puts 'finding jobs' | |
| Sidekiq::Queue.new('internal').each do |job| |
| # this assumes the rails console has preloaded the resources; accordingly, | |
| # you should invoke this script as | |
| # | |
| # rails c < move_internal.rb | |
| begin | |
| args_list = [] | |
| jobs_list = [] | |
| puts 'finding jobs' | |
| Sidekiq::Queue.new('internal').each do |job| |
| """ | |
| Requires panoptes-client and (on Python 2) futures. | |
| pip install panoptes-client futures | |
| """ | |
| from panoptes_client import Panoptes, Organization | |
| ORG_ID = 16 | |
| Panoptes.connect( | |
| username='', |
| # ssh onto the redis node in question and run these cmds | |
| # congestion:* keys are for https://github.com/parrish/Sidekiq-Congestion | |
| # uniquejobs:* https://github.com/mhenrixon/sidekiq-unique-jobs | |
| # get a count of the locks | |
| redis-cli -n 0 --scan --pattern 'congestion:*' | wc -l | |
| redis-cli -n 0 --scan --pattern 'uniquejobs:*' | wc -l | |
| # clear them for both key namespaces |
| # https://github.com/ahupp/python-magic#usage | |
| import magic, csv | |
| file_paths = ( | |
| '480_CornellFeeders_20171024_0921_000.mp4', | |
| '480_CornellFeeders_20171024_0921_000.mp4', | |
| '480_CornellFeeders_20171024_0921_001.mp4', | |
| '480_CornellFeeders_20171024_0921_002.mp4' | |
| ) |
| # Manual csv classifications dump | |
| # ensure the config/database.yml is configured to use the read replica database and not the production db. | |
| # | |
| # run via rails runner from the panoptes cmd line via | |
| # rails r project_classifications_csv_dump_export.rb | |
| require 'csv' | |
| PROJECT_ID = 1 |
Hopefully helped another k8s newbie with the following. The question was, how do you update a single key in a secret in k8s? I don't know anything about secrets but I will probably want to know this in the future, so here we go.
First, to create a dummy secret:
apiVersion: v1
kind: Secret
metadata:
name: test-secret
data:
| select relation, pg_size_pretty(total_size), pg_size_pretty(size), pg_size_pretty(total_size - size) as index_size from | |
| (SELECT relname AS "relation", pg_total_relation_size(C.oid) AS "total_size", pg_relation_size(C.oid) AS "size" | |
| FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) | |
| WHERE nspname NOT IN ('pg_catalog', 'information_schema') | |
| ORDER BY pg_relation_size(C.oid) DESC | |
| ) as derived | |
| LIMIT 10; |
| # Use envFrom to load Secrets and ConfigMaps into environment variables | |
| apiVersion: apps/v1beta2 | |
| kind: Deployment | |
| metadata: | |
| name: mans-not-hot | |
| labels: | |
| app: mans-not-hot | |
| spec: | |
| replicas: 1 |