camallen

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)

amy-langley

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

amy-langley

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

adammcmaster

"""
    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='',

camallen

# 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

camallen

# 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'
)

camallen

# 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

dleske

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:

camallen

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;

troyharvey

# 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