This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
import argparse | |
import psycopg2 | |
import psycopg2.extras | |
import csv | |
from getpass import getpass, getuser | |
def main(args): | |
''' | |
Inserts a TSV into table in postgresql |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
BOOT2DOCKER_CERTS_DIR=/var/lib/boot2docker/certs | |
CERTS_DIR=/etc/ssl/certs | |
CAFILE=${CERTS_DIR}/ca-certificates.crt | |
for cert in $(/bin/ls -1 ${BOOT2DOCKER_CERTS_DIR}); do | |
SRC_CERT_FILE=${BOOT2DOCKER_CERTS_DIR}/${cert} | |
CERT_FILE=${CERTS_DIR}/${cert} | |
HASH_FILE=${CERTS_DIR}/$(/usr/local/bin/openssl x509 -noout -hash -in ${SRC_CERT_FILE} 2>/dev/null) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
''' | |
glider_days.py | |
Determines the glider days for a thredds catalog | |
''' | |
from dateutil.parser import parse | |
from datetime import datetime | |
from thredds_crawler.crawl import Crawl |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- get_bulk_qc_flags(site_code, start_time, end_time) | |
SELECT | |
DISTINCT ON (o.measure_ts, v.actual_name, l.elevation) | |
o.measure_ts, | |
s.site_code, | |
v.actual_name, | |
u.netcdf, | |
l.elevation, | |
o.obs_value, | |
qc.qa_code as "Primary QC", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
import sys | |
def main(args): | |
return 0 | |
if __name__ == '__main__': | |
from argparse import ArgumentParser |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
set -e | |
echo "Creating new OpenSSL Certificate Authority" | |
echo -n "Enter path to CA [.]: " | |
read ca_path | |
ca_path=${ca_path:-$PWD} | |
if [[ "$ca_path" != /* ]]; then | |
ca_path="$PWD/$ca_path" |
OlderNewer