def test_concat(self):
avond_net_nummer = Ora.nvl(None, '')
avond_abonnee_nummer = Ora.nvl('0612345678', '')
avond_nummer = avond_net_nummer + avond_abonnee_nummer
if avond_nummer:
print Ora.decode(avond_nummer.startswith('06'), True, 'Mobiel', 'Prive')
print avond_nummer
def test_decode(self):
s = ''
decode = Ora.decode(s, 'COM', 'Organisatie')
self.assertEqual(decode, None, 'expected None was ' + str(decode))
s = 'COM'
decode = Ora.decode(s, 'COM', 'Organisatie')
self.assertEqual(decode, 'Organisatie', 'expected Organisatie was ' + str(decode))
s = 'PER'
decode = Ora.decode(s, 'COM', 'Organisatie', 'Other')
self.assertEqual(decode, 'Other', 'expected Other was ' + str(decode))
def state(self, queue, message, state):
connection = self.get_connection()
cursor = connection.cursor()
tablename = queue['tablename']
statement = "update " + tablename + " set state=:state, message=:message, backtrace=:backtrace where id=:id"
params = dict()
params['state'] = state
params['message'] = Ora.iif(message, 'message', '')
params['backtrace'] = Ora.iif(message, 'backtrace', '')
params['id'] = message['id']
statement, parameters = self.statement(statement, params)
cursor.execute(statement, parameters)
cursor.close()
connection.commit()
def terminate_by_group(self, group):
lock = self.get_lock()
lock.acquire()
threads = self.get_threads()
for thread in threads:
if Ora.nvl(thread['group'], '-1') == group:
t = thread['thread']
if t.is_alive():
t.terminate()
lock.release()
def remove_by_group(self, group):
lock = self.get_lock()
lock.acquire()
threads = self.get_threads()
results = []
for thread in threads:
if Ora.nvl(thread['group'], '-1') != group:
results.append(thread)
self.set_threads(results)
lock.release()
def list_by_group(self, group):
lock = self.get_lock()
lock.acquire()
threads = self.get_threads()
results = []
for thread in threads:
if Ora.nvl(thread['group'], '-1') == group:
results.append(thread)
lock.release()
return results
def has_group(self, group):
lock = self.get_lock()
lock.acquire()
result = False
threads = self.get_threads()
for thread in threads:
if Ora.nvl(thread['group'], '-1') == group:
result = True
lock.release()
return result
def test_fsdate(self):
datum_sleuteloverdracht = None
gewenste_ingangsdatum_contract = '30102017'
result = Ora.fsdate(Ora.nvl2(datum_sleuteloverdracht, datum_sleuteloverdracht, Ora.fsdate(gewenste_ingangsdatum_contract,'%d%m%Y','%d-%m-%Y')),'%d-%m-%Y', '%Y-%m-%d')
#Ora.fsdate(Ora.nvl2(datum_sleuteloverdracht, datum_sleuteloverdracht, Ora.fsdate(gewenste_ingangsdatum_contract,'%d%m%Y', '%d-%m-%Y'), '%d-%m-%Y', '%Y-%m-%d'))
self.assertEqual(result, '2017-10-30', 'expected 2017-10-30 was ' + result)
def test_nnvl_decode(self):
print Ora.nnvl_decode('', '1', '', '2', '3')
def test_nvl(self):
s = ''
self.assertEqual(Ora.nvl(s, 'PER'), 'PER', 'expected PER was ' + Ora.nvl(s, 'PER'))