Example #1
0
 def UPPER(string):
     if ISNULL(string):
         return NULL()
     string = extract_value(string)
     string = str(string)
     string = string.upper()
     return m(string)
Example #2
0
 def LOWER(string):
     if ISNULL(string):
         return NULL()
     string = extract_value(string)
     string = str(string)
     string = string.lower()
     return m(string)
Example #3
0
 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)
Example #4
0
 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)
Example #5
0
 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)
Example #6
0
 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)
Example #7
0
 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)
Example #8
0
 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
Example #9
0
 def LENGTH(string):
     if ISNULL(string):
         return NULL()
     string = extract_value(string)
     return len(string)
Example #10
0
 def RTRIM(value):
     if ISNULL(value):
         return NULL()
     value = extract_value(value)
     value = value.rstrip(" ")
     return m(value)
Example #11
0
 def TO_CHAR(value):
     if ISNULL(value):
         return NULL()
     value = extract_value(value)
     value = str(value)
     return m(value)
Example #12
0
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)
Example #13
0
 def FOUND(self):
     if self.found is None:
         return m(NULL())
     return m(self.found)
Example #14
0
 def PRIOR(self, index):
     index = extract_value(index)
     if index == 1:
         return NULL()
     return m(index - 1)
Example #15
0
 def NEXT(self, index):
     index = extract_value(index)
     if index >= len(self.inner_list):
         return NULL()
     return m(index + 1)