Skip to content

Instantly share code, notes, and snippets.

View DailyDreaming's full-sized avatar
🍃
Don't stop be-leafing.

Lon Blauvelt DailyDreaming

🍃
Don't stop be-leafing.
  • UCSC Genomics Institute
  • Santa Cruz, CA
View GitHub Profile
@DailyDreaming
DailyDreaming / gist:813b5b2dd2e058e3a280b4ccc754d811
Created July 31, 2023 20:43
Script to query UCSC SQL database.
# Copyright 2006-2022 Mark Diekhans
# Modified by Lon Blauvelt 2023
"""Operations for accessing mysql"""
import warnings
import time
import MySQLdb # mysqlclient is required for python 3
from MySQLdb.cursors import DictCursor # noqa: F401
from MySQLdb.cursors import Cursor
import MySQLdb.converters
@DailyDreaming
DailyDreaming / check_picsure_status.py
Last active May 4, 2021 19:43
check_picsure_status
import PicSureClient, PicSureHpdsLib
# Based on: https://github.com/hms-dbmi/pic-sure-python-client
# and: https://terra.biodatacatalyst.nhlbi.nih.gov/#workspaces/biodata-catalyst/BioData%20Catalyst%20PIC-SURE%20API%20Python%20examples/notebooks
#
# +--------------------------------------+------------------------------------------------------+
# | Resource UUID | Resource Name |
# +--------------------------------------+------------------------------------------------------+
# | 02e23f52-f354-4e8b-992c-d37c8b9ba140 | |
import json
import logging
import os
import requests
import uuid
import sevenbridges as sbg
log = logging.getLogger(__name__)
os.environ['SB_API_ENDPOINT'] = 'https://api.sb.biodatacatalyst.nhlbi.nih.gov/v2'
from hca import HCAConfig
from hca.dss import DSSClient
hca_config = HCAConfig()
hca_config['DSSClient'].swagger_url = f'https://dss.dev.data.humancellatlas.org/v1/swagger.json'
dss = DSSClient(config=hca_config)
for i in dss.post_search.iterate(replica='aws', es_query={}):
uuid, version = i['bundle_fqid'].split('.', 1)
try:
s = f'Bundle: {uuid}.{version}\n'
@DailyDreaming
DailyDreaming / gist:f7ada6f1a68309ba98ba060a3a0b1130
Last active February 20, 2019 18:32
Script to test speed of AWS checkout.
#!/usr/bin/env python3
import time
import os
import boto3
from hca import HCAConfig
from hca.dss import DSSClient
"""