def UPPER(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
string = str(string)
string = string.upper()
return m(string)
def LOWER(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
string = str(string)
string = string.lower()
return m(string)
def CHR(n):
if ISNULL(n):
return NULL()
value = extract_value(n)
if isinstance(value, str):
value = int(value)
value = chr(value)
return m(value)
def TO_NUMBER(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = float(value)
if value.is_integer():
value = int(value)
return m(value)
def FETCH(self, *args):
data = self.cursor.fetchone()
self.found = data is not None
if not self.found:
return
for i, arg in enumerate(args):
value = data[i]
if value is None:
value = NULL()
arg <<= m(value)
def REPLACE(char, search, replacement=None):
if replacement is None:
replacement = NULL()
if ISNULL(char) or ISNULL(search):
return char
char: str = extract_value(char)
search: str = extract_value(search)
if not ISNULL(replacement):
replacement = extract_value(replacement)
else:
replacement = ""
value = char.replace(search, replacement)
return m(value)
def SUBSTR(string, position, length=None):
if ISNULL(string) or ISNULL(position):
return NULL()
string = extract_value(string)
position = extract_value(position)
length = extract_value(length)
if position == 0:
position = 1
if position > 0:
position -= 1
if length is not None:
value = string[position:position+length]
else:
value = string[position:]
return m(value)
def padstr(to_left: bool, value, count, fill):
if ISNULL(value) or ISNULL(count) or ISNULL(fill) or count <= m(0):
return NULL()
if fill is None:
fill = m(' ')
value = extract_value(value)
count = extract_value(count)
fill = extract_value(fill)
valuelen = len(value)
if count <= valuelen:
value = value[:count]
return value
charsleft = count - valuelen
filllen = len(fill)
charsfill = fill * int(charsleft / filllen)
charsfill += fill[:(charsleft % filllen)]
if to_left:
value = charsfill + value
else:
value = value + charsfill
return value
def LENGTH(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
return len(string)
def RTRIM(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = value.rstrip(" ")
return m(value)
def TO_CHAR(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = str(value)
return m(value)
class PLGLOBALS:
@staticmethod
def CHR(n):
if ISNULL(n):
return NULL()
value = extract_value(n)
if isinstance(value, str):
value = int(value)
value = chr(value)
return m(value)
@staticmethod
def INSTR(st, sub):
st: str = extract_value(st)
sub: str = extract_value(sub)
index = st.find(sub)
return m(index + 1)
class LOGIN_DENIED(_PL_EXCEPTION):
pass
@staticmethod
def LENGTH(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
return len(string)
@staticmethod
def LOWER(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
string = str(string)
string = string.lower()
return m(string)
@staticmethod
def MOD(n, mod):
n = extract_value(n)
mod = extract_value(mod)
return m(n % mod)
@staticmethod
def NVL(expr, replacement):
if ISNULL(expr):
return replacement
return expr
OTHERS = _PL_EXCEPTION
@staticmethod
def EXCEPTION():
return _USER_EXCEPTION
@staticmethod
def RAISE_APPLICATION_ERROR(error_number, message):
error_number = extract_value(error_number)
message = extract_value(message)
message = f"ORA{error_number}: {message}"
PLGLOBALS.SQLCODE = m(error_number)
PLGLOBALS.SQLERRM = m(message)
raise _PL_EXCEPTION
@staticmethod
def REPLACE(char, search, replacement=None):
if replacement is None:
replacement = NULL()
if ISNULL(char) or ISNULL(search):
return char
char: str = extract_value(char)
search: str = extract_value(search)
if not ISNULL(replacement):
replacement = extract_value(replacement)
else:
replacement = ""
value = char.replace(search, replacement)
return m(value)
SQL = PLCURSOR
SQLCODE = m(0)
SQLERRM = NULL()
@staticmethod
def SUBSTR(string, position, length=None):
if ISNULL(string) or ISNULL(position):
return NULL()
string = extract_value(string)
position = extract_value(position)
length = extract_value(length)
if position == 0:
position = 1
if position > 0:
position -= 1
if length is not None:
value = string[position:position+length]
else:
value = string[position:]
return m(value)
@staticmethod
def SYS_CONTEXT(namespace, parameter):
cursor = PLCURSOR.CURSOR('select sys_context(:NAMESPACE, :PARAMETER) from dual', ['NAMESPACE', 'PARAMETER'], [])
cursor.OPEN([], {'NAMESPACE': namespace, 'PARAMETER': parameter})
value = m()
cursor.FETCH(value)
cursor.CLOSE()
return value
@staticmethod
def TO_CHAR(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = str(value)
return m(value)
@staticmethod
def TO_NUMBER(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = float(value)
if value.is_integer():
value = int(value)
return m(value)
@staticmethod
def TRIM(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = value.strip(" ")
return m(value)
@staticmethod
def LTRIM(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = value.lstrip(" ")
return m(value)
@staticmethod
def RTRIM(value):
if ISNULL(value):
return NULL()
value = extract_value(value)
value = value.rstrip(" ")
return m(value)
@staticmethod
def padstr(to_left: bool, value, count, fill):
if ISNULL(value) or ISNULL(count) or ISNULL(fill) or count <= m(0):
return NULL()
if fill is None:
fill = m(' ')
value = extract_value(value)
count = extract_value(count)
fill = extract_value(fill)
valuelen = len(value)
if count <= valuelen:
value = value[:count]
return value
charsleft = count - valuelen
filllen = len(fill)
charsfill = fill * int(charsleft / filllen)
charsfill += fill[:(charsleft % filllen)]
if to_left:
value = charsfill + value
else:
value = value + charsfill
return value
@staticmethod
def LPAD(value, count, fill=None):
return PLGLOBALS.padstr(True, value, count, fill)
@staticmethod
def RPAD(value, count, fill=None):
return PLGLOBALS.padstr(False, value, count, fill)
@staticmethod
def UPPER(string):
if ISNULL(string):
return NULL()
string = extract_value(string)
string = str(string)
string = string.upper()
return m(string)
def FOUND(self):
if self.found is None:
return m(NULL())
return m(self.found)
def PRIOR(self, index):
index = extract_value(index)
if index == 1:
return NULL()
return m(index - 1)
def NEXT(self, index):
index = extract_value(index)
if index >= len(self.inner_list):
return NULL()
return m(index + 1)