Schema: utils

utils

General utilities




Functions

_safe_execute

Safe execute

Parameters:
Name Type Description
sql_code text
sql_result jsonb
error_messages Array.<jsonb>
line_number integer
json_path text
Source:
Returns:
Type
record

_safe_execute_temp

Safe execute temp

Parameters:
Name Type Description
sql_code text
line_number integer
json_path text
Source:
Returns:
Type
jsonb

_update_line_numbers_for_error_messages

Update line numbers for error messages

Parameters:
Name Type Description
function_schema character_varying
function_name character_varying
Source:
Returns:
Type
void

create_table

Create table

Parameters:
Name Type Description
v_schema_name text
v_table_name text
Source:
Returns:
Type
void

execute_ignore

Execute ignore

Parameters:
Name Type Description
sql character_varying
Source:
Returns:
Type
void

function_sizes

Lists functions count and total size of all functions

Properties:
Name Type Description
functions bigint
total bigint
Source:
Returns:
Type
Object

grant_all_privileges_to_user

Grant all privileges to user

Parameters:
Name Type Description
UserName character_varying
SchemaName character_varying
Source:
Returns:
Type
void

import_json

Import json

Parameters:
Name Type Description
Json character_varying
Source:
Returns:
Type
void

import_json_object

Import json object

Parameters:
Name Type Description
ParentTable character_varying
ParentId integer
RecordTable character_varying
RecordJson jsonb
JsonPath text
Source:
Returns:
Type
Array.<jsonb>

import_json_object_temp

Import json object temp

Parameters:
Name Type Description
ParentTable character_varying
ParentId integer
RecordTable character_varying
RecordJson jsonb
JsonPath character_varying
UploadedImages Array.<character_varying>
Source:
Returns:
Type
jsonb

import_json_temp

Import json temp

Parameters:
Name Type Description
Json character_varying
UploadedImages Array.<character_varying>
Source:
Returns:
Type
json

move

Move

Parameters:
Name Type Description
SchemaName character_varying
TableName character_varying
NewSchema character_varying
Source:
Returns:
Type
void

normalize_separators

Normalize separators

Parameters:
Name Type Description
input_text text
Source:
Returns:
Type
text

qualify_fk

Qualify fk

Parameters:
Name Type Description
Att character_varying
Qual character_varying
Source:
Returns:
Type
void

rename_fk

Rename fk

Source:
Returns:
Type
void

replace

Replace

Parameters:
Name Type Description
OldString character_varying
NewString character_varying
Source:
Returns:
Type
void

set_catalog_values

Set catalog values

Parameters:
Name Type Description
v_schema_name text
v_table_name text
names Array.<text>
Source:
Returns:
Type
Array.<integer>

set_catalog_values_1

Set catalog values 1

Parameters:
Name Type Description
p_schema_name text
p_table_name text
p_column_name text
p_csv_string text
Source:
Returns:
Type
void

set_function_owners

Set owner of all functions in the current database to the specified owner

Parameters:
Name Type Description
owner_name text
Source:
Returns:
Type
void

set_table_owners

Set owner of all tables in the current database to the specified owner

Parameters:
Name Type Description
owner_name text
Source:
Returns:
Type
void

table_sizes

Reports table sizes

Properties:
Name Type Description
schema_name character_varying
table_name character_varying
size_pretty character_varying
size bigint
records bigint
Source:
Returns:
Type
Object