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