Mercurial > repos > greg > export_all_sample_date

comparison export_all_sample_data.py @ 2:80880af69fe0 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author greg
date Wed, 26 Aug 2020 13:47:04 -0400
parents 633cb7831526
children
comparison
equal deleted inserted replaced
1:633cb7831526 2:80880af69fe0
1 #!/usr/bin/env python 1 #!/usr/bin/env python
2 2
3 3
4 import argparse 4 import argparse
5 import datetime 5 import datetime
6
6 import psycopg2 7 import psycopg2
7 8
9 from sqlalchemy import MetaData
8 from sqlalchemy import create_engine 10 from sqlalchemy import create_engine
9 from sqlalchemy import MetaData
10 from sqlalchemy.engine.url import make_url 11 from sqlalchemy.engine.url import make_url
11 12
12 metadata = MetaData() 13 metadata = MetaData()
13 14
14 COLUMNS = ["Affymetrix ID", "Sample ID", "User Specimen ID", "Field Call", "Sample Depth", 15 COLUMNS = ["Affymetrix ID", "Sample ID", "User Specimen ID", "Field Call", "Sample Depth",