import random import time import datetime import calendar import MySQLdb from app import Config Config.load_app_config() g_conn = MySQLdb.connect( host = Config.database['host'], user = Config.database['user'], passwd = Config.database['passwd'], db = Config.database['schema'], charset = 'utf8', use_unicode = True) g_conn.autocommit(False) g_cur = g_conn.cursor() def db_get_pronto_list( cutoff_date_start, cutoff_date_end ): sql = """SELECT problem_id, created, closed, type, severity FROM problem_report LEFT JOIN severity ON problem_report.severity_id = severity.id WHERE created <= %s AND ( `closed` IS NULL OR %s <= `closed` )""" params = ( cutoff_date_end, cutoff_date_start ) g_cur.execute( sql, params )
def goodConfig(): Config.load_app_config('appconftest.conf')
import pytest from app import Config Config.load_app_config("appconftest.conf") from app.utils import ldap_utils def test_get_user_from_ldap(): with pytest.raises(ldap_utils.BoardLDAPConnectionError): ldap_utils.get_user_from_ldap("nouser", "nopass")
import pytest from app import Config Config.load_app_config('appconftest.conf') from app.db import db def goodConfig(): Config.load_app_config('appconftest.conf') def badConfig(): Config.database['host'] = 'badhost' Config.database['port'] = '0000' Config.database['user'] = '******' Config.database['passwd'] = 'badpass' Config.database['schema'] = 'bad_db' def test_DBConnection_good(): goodConfig() dbcm = db._DBConnectionManager() dbc = dbcm.get_connection( 'unittest_database' ) assert dbc.conn is not None with pytest.raises(db.BoardDbConfigurationError): dbcm.get_connection( 'unittest_baddatabase' )