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' )
