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