Mercurial > repos > greg > update_stag_database
comparison update_stag_database.py @ 5:c34d08494c35 draft
Uploaded
author | greg |
---|---|
date | Wed, 26 Aug 2020 13:50:13 -0400 |
parents | 852b9fd0e3cd |
children | 75ae6c480918 |
comparison
equal
deleted
inserted
replaced
4:852b9fd0e3cd | 5:c34d08494c35 |
---|---|
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 import dateutil.parser | |
7 import os | 6 import os |
8 import psycopg2 | |
9 import string | |
10 import subprocess | 7 import subprocess |
11 import sys | 8 import sys |
12 | 9 |
10 import dateutil.parser | |
11 | |
12 import psycopg2 | |
13 | |
13 from six.moves import configparser | 14 from six.moves import configparser |
14 | 15 |
16 from sqlalchemy import MetaData | |
15 from sqlalchemy import create_engine | 17 from sqlalchemy import create_engine |
16 from sqlalchemy import MetaData | |
17 from sqlalchemy.engine.url import make_url | 18 from sqlalchemy.engine.url import make_url |
18 | 19 |
19 now = datetime.datetime.utcnow | 20 now = datetime.datetime.utcnow |
20 metadata = MetaData() | 21 metadata = MetaData() |
21 | 22 |
40 d = {} | 41 d = {} |
41 config_parser = configparser.ConfigParser() | 42 config_parser = configparser.ConfigParser() |
42 config_parser.read(config_file) | 43 config_parser.read(config_file) |
43 for key, value in config_parser.items(section): | 44 for key, value in config_parser.items(section): |
44 if section == 'defaults': | 45 if section == 'defaults': |
45 d[string.upper(key)] = value | 46 d[key.upper()] = value |
46 else: | 47 else: |
47 d[key] = value | 48 d[key] = value |
48 return d | 49 return d |
49 | 50 |
50 | 51 |