# Path: opentaxforms/ut.py
# NL = '\n'
# TAB = '\t'
# def merge(bb1, bb2):
# def numerify(s):
# def compactify(multilineRegex):
#     def crunch(seg):
# def pickle(data, pickleFilePrefix):
# def unpickle(pickleFilePrefix, default=None):
# def flattened(l):
# def hasdups(l, key=None):
# def uniqify(l):
# def uniqify2(l):
# def setupLogging(loggerId, args=None):
# def unsetupLogging():
# def logg(msg, outputs=None):
# def jj(*args, **kw):
# def jdb(*args, **kw):
# def run0(cmd):
# def run(cmd, logprefix='run', loglevel='INFO'):
#     def __init__(self, pkgname, fpath=None):
#     def path(self):
#     def content(self):
#     def keys(cls):
#     def vals(cls):
#     def items(cls):
#     def __init__(self):
#     def __call__(self, **kw):
#     def __init__(self, *maps, **kw):
#     def _getGetitems(self, mapp):
#     def __getitem__(self, key):
#     def __setitem__(self, key, val):
#     def __len__(self):
#     def __call__(self, *keys):
#     def clear(self):
#     def update(self, *maps):
#     def __add__(self, *maps):
#     def __iadd__(self, *maps):
#     def __iter__(self):
#     def iterkeys(self):
#     def keys(self):
#     def values(self):
#     def items(self):
#     def iteritems(self):
#     def get(self, key, dflt=None):
#     def __str__(self):
#     def __repr__(self):
# def notequalpatch(self, o):
#     def fromstring(cls, s):
#     def __hash__(self):
# def playQnty():
# def nth(n):
# def skip(s, substr):
# def until(s, substr):
# def ensure_dir(folder):
# def now(format=None):
# def readImgSize(fname, dirName):
# def asciiOnly(s):
# class NoSuchPickle(Exception):
# class PickleException(Exception):
# class Resource(object):
# class CharEnum(object):
# class ChainablyUpdatableOrderedDict(odict):
# class Bag(object):
# class Qnty(qq):
# 
# Path: opentaxforms/config.py
# def parseCmdline():
# def getFileList(dirName):
# def setLogname(rootForms,cfg):
# def copyStaticDir(appname):
# def setupStaticDir(dirName):
# def setup(**overrideArgs):
# def unsetup():


import os
import six
import sys
        import doctest
from itertools import chain
from sqlalchemy import (
    MetaData, create_engine, select, UniqueConstraint)
from . import ut, config
from .ut import log
from .config import cfg

engine, metadata, conn = None, None, None


def unicodify(dic):
    for k, v in dic.items():
        if isinstance(v, six.binary_type):
            dic[k] = six.text_type(v.decode('utf-8'))
    return dic


def connect(appname, **kw):
    # default values
    user = pw = 'user'
    dbname = appname.lower()
    # optionally override defaults
    user = os.environ.get(appname.upper() + '_DBUSER', user)
    pw = os.environ.get(appname.upper() + '_DBPASS', pw)
    dbname = os.environ.get(appname.upper() + '_DBNAME', dbname)
    global conn
    conn, engine, metadata, md = connect_(user=user, pw=pw, db=dbname, **kw)
    return conn, engine, metadata, md


def connect_(**kw):
    # consumes keys from kw: user pw db
    global conn, engine, metadata
    config.setup(**kw)
    if 'dirName' in kw:
        del kw['dirName']

# Path: opentaxforms/ut.py
# NL = '\n'
# TAB = '\t'
# def merge(bb1, bb2):
# def numerify(s):
# def compactify(multilineRegex):
#     def crunch(seg):
# def pickle(data, pickleFilePrefix):
# def unpickle(pickleFilePrefix, default=None):
# def flattened(l):
# def hasdups(l, key=None):
# def uniqify(l):
# def uniqify2(l):
# def setupLogging(loggerId, args=None):
# def unsetupLogging():
# def logg(msg, outputs=None):
# def jj(*args, **kw):
# def jdb(*args, **kw):
# def run0(cmd):
# def run(cmd, logprefix='run', loglevel='INFO'):
#     def __init__(self, pkgname, fpath=None):
#     def path(self):
#     def content(self):
#     def keys(cls):
#     def vals(cls):
#     def items(cls):
#     def __init__(self):
#     def __call__(self, **kw):
#     def __init__(self, *maps, **kw):
#     def _getGetitems(self, mapp):
#     def __getitem__(self, key):
#     def __setitem__(self, key, val):
#     def __len__(self):
#     def __call__(self, *keys):
#     def clear(self):
#     def update(self, *maps):
#     def __add__(self, *maps):
#     def __iadd__(self, *maps):
#     def __iter__(self):
#     def iterkeys(self):
#     def keys(self):
#     def values(self):
#     def items(self):
#     def iteritems(self):
#     def get(self, key, dflt=None):
#     def __str__(self):
#     def __repr__(self):
# def notequalpatch(self, o):
#     def fromstring(cls, s):
#     def __hash__(self):
# def playQnty():
# def nth(n):
# def skip(s, substr):
# def until(s, substr):
# def ensure_dir(folder):
# def now(format=None):
# def readImgSize(fname, dirName):
# def asciiOnly(s):
# class NoSuchPickle(Exception):
# class PickleException(Exception):
# class Resource(object):
# class CharEnum(object):
# class ChainablyUpdatableOrderedDict(odict):
# class Bag(object):
# class Qnty(qq):
# 
# Path: opentaxforms/config.py
# def parseCmdline():
# def getFileList(dirName):
# def setLogname(rootForms,cfg):
# def copyStaticDir(appname):
# def setupStaticDir(dirName):
# def setup(**overrideArgs):
# def unsetup():


# Path: opentaxforms/db.py
import os
import six
import sys
        import doctest
from itertools import chain
from sqlalchemy import (
    MetaData, create_engine, select, UniqueConstraint)
from . import ut, config
from .ut import log
from .config import cfg


engine, metadata, conn = None, None, None


def unicodify(dic):
    for k, v in dic.items():
        if isinstance(v, six.binary_type):
            dic[k] = six.text_type(v.decode('utf-8'))
    return dic


def connect(appname, **kw):
    # default values
    user = pw = 'user'
    dbname = appname.lower()
    # optionally override defaults
    user = os.environ.get(appname.upper() + '_DBUSER', user)
    pw = os.environ.get(appname.upper() + '_DBPASS', pw)
    dbname = os.environ.get(appname.upper() + '_DBNAME', dbname)
    global conn
    conn, engine, metadata, md = connect_(user=user, pw=pw, db=dbname, **kw)
    return conn, engine, metadata, md


def connect_(**kw):
    # consumes keys from kw: user pw db
    global conn, engine, metadata
    config.setup(**kw)
    if 'dirName' in kw:
        del kw['dirName']

    usepostgres = kw.get('postgres', False) if cfg is None else cfg.postgres