Index

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

A

add_comma() (in module qal.sql.utils)
add_comma_rs() (in module qal.sql.utils)
add_limit() (qal.sql.sql.VerbSelect method)
add_operator() (in module qal.sql.utils)
add_xml_subitem() (in module qal.common.resources)
alias (qal.sql.sql.ParameterField attribute)
(qal.sql.sql.ParameterSource attribute)
and_or (qal.sql.sql.ParameterCondition attribute)
and_or() (in module qal.sql.types)
append_field_identifier() (qal.sql.sql.VerbDelete method)
(qal.sql.sql.VerbSelect method)
apply_modifications() (qal.tools.merge.Merge method)
apply_new_data() (qal.dataset.custom.CustomDataset method)
as_sql() (qal.dataset.custom.CustomDataset method)
(qal.dataset.matrix.MatrixDataset method)
(qal.sql.base.ParameterBase method)
(qal.sql.base.SqlList method)
(qal.sql.sql.ParameterAssignment method)
(qal.sql.sql.ParameterCondition method)
(qal.sql.sql.ParameterConditions method)
as_xml_node() (qal.common.mapping.Mapping method)
(qal.common.resources.Resource method)
(qal.common.resources.Resources method)
(qal.common.transform.Cast method)
(qal.common.transform.CustomTransformation method)
(qal.common.transform.IfEmpty method)
(qal.common.transform.Replace method)
(qal.common.transform.ReplaceRegex method)
(qal.common.transform.Trim method)
(qal.tools.merge.Merge method)
assignments (qal.sql.sql.VerbUpdate attribute)

B

base_path (qal.common.resources.Resource attribute)
(qal.common.resources.Resources attribute)
(qal.sql.xml.SQL_XML attribute)
binary_int_to_bool() (in module qal.common.strings)
bool_to_binary_int() (in module qal.common.strings)
boolean() (in module qal.sql.types)
builtin_substitutions (qal.common.substitution.Substitution attribute)

C

caption (qal.common.resources.Resource attribute)
Cast (class in qal.common.transform)
cast_text_to_type() (qal.dataset.custom.CustomDataset method)
check_for_param_content() (in module qal.sql.utils)
check_list_column() (qal.tools.tests.test_meta_queries.TestSQL_Meta_queries method)
check_not_null() (in module qal.sql.utils)
checkconditions (qal.sql.sql.ParameterConstraint attribute)
CI_index() (in module qal.common.listhelper)
citate() (in module qal.sql.utils)
class_SQL_Meta_XML_Test (class in qal.sql.tests.test_xml)
clear_log() (qal.dataset.custom.CustomDataset method)
(qal.tools.merge.Merge method)
close() (qal.dal.dal.DatabaseAbstractionLayer method)
cmp_key_columns() (in module qal.common.diff)
column_identifiers (qal.sql.sql.VerbInsert attribute)
columnnames (qal.sql.sql.VerbCreateIndex attribute)
columns (qal.sql.sql.VerbCreateTable attribute)
comma_separate() (in module qal.sql.utils)
commit() (qal.dal.dal.DatabaseAbstractionLayer method)
compare() (in module qal.common.diff)
compiled_regex (qal.common.transform.ReplaceRegex attribute)
condition_part() (in module qal.sql.types)
conditions (qal.sql.sql.ParameterSource attribute)
(qal.sql.sql.ParameterWhen attribute)
(qal.sql.sql.VerbUpdate attribute)
connect_to_db() (qal.dal.dal.DatabaseAbstractionLayer method)
connected (qal.dal.dal.DatabaseAbstractionLayer attribute)
constraint_type (qal.sql.sql.ParameterConstraint attribute)
constraint_types() (in module qal.sql.types)
constraints (qal.sql.sql.VerbCreateTable attribute)
copy_to_table() (in module qal.sql.macros)
create_table_skeleton() (in module qal.sql.macros)
csv_dialect (qal.dataset.flatfile.FlatfileDataset attribute)
curr_datetime() (in module qal.sql.utils)
curr_user() (in module qal.sql.utils)
CustomDataset (class in qal.dataset.custom)
CustomTransformation (class in qal.common.transform)

D

dal (qal.dataset.matrix.MatrixDataset attribute)
(qal.dataset.rdbms.RDBMSDataset attribute)
DAL_tests (class in qal.dal.tests.test_dal)
data (qal.common.resources.Resource attribute)
(qal.sql.sql.VerbInsert attribute)
data_source (qal.sql.sql.ParameterDataset attribute)
data_source_types() (in module qal.sql.types)
data_table (qal.dataset.custom.CustomDataset attribute)
data_types() (in module qal.sql.types)
DatabaseAbstractionLayer (class in qal.dal.dal)
dataset_from_resource() (in module qal.dataset.factory)
dataset_to_sql() (qal.sql.sql.ParameterDataset method)
datatype (qal.sql.sql.ParameterCast attribute)
(qal.sql.sql.ParameterColumndefinition attribute)
(qal.sql.sql.ParameterParameter attribute)
datatype_to_parameter() (in module qal.sql.utils)
db_autocommit (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_connection (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_databasename (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_driver (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_instance (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_password (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_port (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_server (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_specific_datatype() (in module qal.sql.utils)
db_specific_datatype_parse_length() (in module qal.sql.utils)
db_specific_object_reference() (in module qal.sql.utils)
db_specific_operator() (in module qal.sql.utils)
db_type (qal.dal.dal.DatabaseAbstractionLayer attribute)
db_type_to_string() (in module qal.dal.types)
db_types() (in module qal.dal.types)
db_username (qal.dal.dal.DatabaseAbstractionLayer attribute)
debuglevel (qal.common.xml_utils.XML_Translation attribute)
default (qal.sql.sql.ParameterColumndefinition attribute)
default_dal() (in module qal.dal.tests.framework)
delete (qal.tools.merge.Merge attribute)
delimiter (qal.dataset.flatfile.FlatfileDataset attribute)
dest_reference (qal.common.mapping.Mapping attribute)
dest_type (qal.common.transform.Cast attribute)
destination (qal.tools.merge.Merge attribute)
destination_identifier (qal.sql.sql.VerbInsert attribute)
destination_log_level (qal.tools.merge.Merge attribute)
diff_files() (in module qal.common.diff)
diff_strings() (in module qal.common.diff)
Diff_test (class in qal.common.tests.test_diff)
diff_to_text() (in module qal.common.diff)
direction (qal.sql.sql.ParameterOrderByItem attribute)
discover_database_servers() (in module qal.tools.discover)
discover_services() (in module qal.tools.discover)
do_on_done() (qal.common.transform.CustomTransformation method)

E

else_statement (qal.sql.sql.ParameterCase attribute)
empty_if_none() (in module qal.common.strings)
empty_when_none() (in module qal.common.strings)
encoding (qal.common.xml_utils.XML_Translation attribute)
(qal.sql.xml.SQL_XML attribute)
error_on_blank() (in module qal.sql.utils)
escape_character (qal.sql.sql.ParameterString attribute)
escapechar (qal.dataset.flatfile.FlatfileDataset attribute)
execute() (qal.dal.dal.DatabaseAbstractionLayer method)
(qal.tools.merge.Merge method)
executemany() (qal.dal.dal.DatabaseAbstractionLayer method)
expression (qal.sql.sql.ParameterCast attribute)
(qal.sql.sql.ParameterField attribute)
(qal.sql.sql.ParameterSource attribute)
expression_item_types() (in module qal.sql.types)
expressionitems (qal.sql.sql.ParameterExpression attribute)
external_resources_callback (qal.common.resources.Resources attribute)

F

field_names (qal.dal.dal.DatabaseAbstractionLayer attribute)
(qal.dataset.custom.CustomDataset attribute)
(qal.dataset.flatfile.FlatfileDataset attribute)
(qal.dataset.spreadsheet.SpreadsheetDataset attribute)
field_types (qal.dal.dal.DatabaseAbstractionLayer attribute)
(qal.dataset.custom.CustomDataset attribute)
field_xpaths (qal.dataset.xpath.XpathDataset attribute)
fields (qal.sql.sql.VerbSelect attribute)
filename (qal.dataset.flatfile.FlatfileDataset attribute)
(qal.dataset.spreadsheet.SpreadsheetDataset attribute)
(qal.dataset.xpath.XpathDataset attribute)
find_child_node() (in module qal.common.xml_utils)
find_class() (in module qal.sql.meta)
find_next_match() (in module qal.common.listhelper)
find_previous_match() (in module qal.common.listhelper)
FlatfileDataset (class in qal.dataset.flatfile)
format_string (qal.common.transform.Cast attribute)

G

gen_complex_conditions() (in module qal.sql.tests.test_sql)
gen_complex_expression() (in module qal.sql.tests.test_sql)
gen_complex_function() (in module qal.sql.tests.test_sql)
gen_simple_case() (in module qal.sql.tests.test_sql)
gen_simple_cast() (in module qal.sql.tests.test_sql)
gen_simple_condition_1() (in module qal.sql.tests.test_sql)
gen_simple_condition_2() (in module qal.sql.tests.test_sql)
gen_simple_conditions() (in module qal.sql.tests.test_sql)
gen_simple_create() (in module qal.sql.tests.test_sql)
gen_simple_expression_2() (in module qal.sql.tests.test_sql)
gen_simple_field_1() (in module qal.sql.tests.test_sql)
gen_simple_field_2() (in module qal.sql.tests.test_sql)
gen_simple_function() (in module qal.sql.tests.test_sql)
gen_simple_insert() (in module qal.sql.tests.test_sql)
gen_simple_select() (in module qal.sql.tests.test_sql)
gen_simple_source_1() (in module qal.sql.tests.test_sql)
gen_simple_source_2() (in module qal.sql.tests.test_sql)
gen_simple_update() (in module qal.sql.tests.test_sql)
gen_simpleexpression_1() (in module qal.sql.tests.test_sql)
generate_schema() (qal.sql.xml.SQL_XML method)
get() (qal.common.settings.UBPMSettings method)
get_default_dal() (in module qal.dal.tests.framework)
get_first_and_or() (qal.sql.sql.ParameterConditions method)
get_post_statements() (qal.sql.sql.VerbCreateTable method)
get_python_versions() (in module qal.tools.discover)
get_resource() (qal.common.resources.Resources method)
get_root_node() (qal.common.xml_utils.XML_Translation method)

H

handle_temp_table_ref() (in module qal.sql.utils)
has_header (qal.dataset.flatfile.FlatfileDataset attribute)
(qal.dataset.spreadsheet.SpreadsheetDataset attribute)

I

identifier (qal.sql.sql.ParameterIdentifier attribute)
IfEmpty (class in qal.common.transform)
import_error_to_help() (in module qal.tools.discover)
in_types() (in module qal.sql.types)
in_values (qal.sql.sql.ParameterIn attribute)
index_type (qal.sql.sql.VerbCreateIndex attribute)
index_types() (in module qal.sql.types)
init_base_to_node() (qal.common.transform.CustomTransformation method)
insert (qal.tools.merge.Merge attribute)
is_key (qal.common.mapping.Mapping attribute)

J

join_type (qal.sql.sql.ParameterSource attribute)
join_types() (in module qal.sql.types)

K

key_fields (qal.tools.merge.Merge attribute)

L

left (qal.sql.sql.ParameterAssignment attribute)
(qal.sql.sql.ParameterCondition attribute)
lineterminator (qal.dataset.flatfile.FlatfileDataset attribute)
list_class_properties() (in module qal.sql.meta)
list_parameter_classes() (in module qal.sql.meta)
list_verb_classes() (in module qal.sql.meta)
load() (qal.dataset.custom.CustomDataset method)
(qal.dataset.flatfile.FlatfileDataset method)
(qal.dataset.matrix.MatrixDataset method)
(qal.dataset.rdbms.RDBMSDataset method)
(qal.dataset.spreadsheet.SpreadsheetDataset method)
(qal.dataset.xpath.XpathDataset method)
load_field_mappings_from_xml_node() (qal.tools.merge.Merge method)
load_from_xml_node() (qal.common.mapping.Mapping method)
(qal.common.transform.Cast method)
(qal.common.transform.CustomTransformation method)
(qal.common.transform.IfEmpty method)
(qal.common.transform.Replace method)
(qal.common.transform.ReplaceRegex method)
(qal.common.transform.Trim method)
(qal.tools.merge.Merge method)
load_mappings_from_xml_node() (qal.tools.merge.Merge method)
load_settings_from_xml_node() (qal.tools.merge.Merge method)
load_xls() (qal.dataset.spreadsheet.SpreadsheetDataset method)
load_xlsx() (qal.dataset.spreadsheet.SpreadsheetDataset method)
load_xml() (in module qal.dataset.tests.test_flatfile)
(in module qal.dataset.tests.test_rdbms)
(in module qal.dataset.tests.test_spreadsheet)
(in module qal.dataset.tests.test_xpath)
local_resources (qal.common.resources.Resources attribute)
log_delete() (qal.dataset.custom.CustomDataset method)
log_insert() (qal.dataset.custom.CustomDataset method)
log_load() (qal.dataset.custom.CustomDataset method)
log_save() (qal.dataset.custom.CustomDataset method)
log_update_row() (qal.dataset.custom.CustomDataset method)

M

make_cast() (qal.sql.sql.ParameterCast method)
make_column_definitions() (in module qal.sql.macros)
make_column_identifiers() (in module qal.sql.macros)
make_columns() (qal.sql.sql.VerbCreateTable method)
make_constraints() (qal.sql.sql.VerbCreateTable method)
make_delete_skeleton() (in module qal.sql.macros)
make_function() (in module qal.sql.utils)
make_insert_sql_with_parameters() (in module qal.sql.macros)
make_operator() (in module qal.sql.utils)
make_path_absolute() (in module qal.common.strings)
make_transformation_array_from_xml_node() (in module qal.common.transform)
make_transformations_xml_node() (in module qal.common.transform)
make_update_skeleton() (in module qal.sql.macros)
makeIdentifiers() (qal.sql.sql.VerbInsert method)
Mapping (class in qal.common.mapping)
mappings (qal.tools.merge.Merge attribute)
match_all_columns() (in module qal.common.diff)
MatrixDataset (class in qal.dataset.matrix)
max (qal.common.transform.Replace attribute)
(qal.common.transform.ReplaceRegex attribute)
maxDiff (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test attribute)
Merge (class in qal.tools.merge)
Merge_test (class in qal.tools.tests.test_merge)
Meta_Queries (class in qal.tools.meta_queries)
MySQL_GEOMETRY (in module qal.dal.conversions)
mysql_type_to_SQL_type() (in module qal.dal.conversions)

N

name (qal.sql.sql.ParameterColumndefinition attribute)
(qal.sql.sql.ParameterConstraint attribute)
(qal.sql.sql.ParameterFunction attribute)
(qal.sql.sql.VerbCreateIndex attribute)
(qal.sql.sql.VerbCreateTable attribute)
(qal.sql.sql.VerbDropTable attribute)
namespace (qal.common.xml_utils.XML_Translation attribute)
nestinglevel (qal.common.xml_utils.XML_Translation attribute)
new (qal.common.transform.Replace attribute)
(qal.common.transform.ReplaceRegex attribute)
none_as_sql() (in module qal.sql.utils)
none_to_zero() (in module qal.dataset.spreadsheet)
notnull (qal.sql.sql.ParameterColumndefinition attribute)
numeric_value (qal.sql.sql.ParameterNumeric attribute)

O

old (qal.common.transform.Replace attribute)
on_connect (qal.dal.dal.DatabaseAbstractionLayer attribute)
on_done (qal.common.transform.CustomTransformation attribute)
operator (qal.sql.base.ParameterExpressionItem attribute)
(qal.sql.sql.ParameterCondition attribute)
oracle_add_escape() (in module qal.sql.utils)
oracle_all_sequences() (qal.tools.meta_queries.Meta_Queries static method)
oracle_create_auto_increment() (in module qal.sql.utils)
order (qal.common.transform.CustomTransformation attribute)
order_by (qal.sql.sql.VerbSelect attribute)

P

parameter_test (class in qal.sql.tests.test_sql)
ParameterAssignment (class in qal.sql.sql)
ParameterBase (class in qal.sql.base)
ParameterCase (class in qal.sql.sql)
ParameterCast (class in qal.sql.sql)
ParameterColumndefinition (class in qal.sql.sql)
ParameterCondition (class in qal.sql.sql)
ParameterConditions (class in qal.sql.sql)
ParameterConstraint (class in qal.sql.sql)
ParameterDataset (class in qal.sql.sql)
ParameterDDL (class in qal.sql.sql)
ParameterExpression (class in qal.sql.sql)
ParameterExpressionItem (class in qal.sql.base)
ParameterField (class in qal.sql.sql)
ParameterFunction (class in qal.sql.sql)
ParameterIdentifier (class in qal.sql.sql)
ParameterIn (class in qal.sql.sql)
ParameterNumeric (class in qal.sql.sql)
ParameterOrderByItem (class in qal.sql.sql)
ParameterParameter (class in qal.sql.sql)
ParameterRemotable (class in qal.sql.remotable)
parameters (qal.sql.sql.ParameterFunction attribute)
ParameterSet (class in qal.sql.sql)
ParameterSource (class in qal.sql.sql)
ParameterString (class in qal.sql.sql)
ParameterWhen (class in qal.sql.sql)
parenthesise() (in module qal.sql.utils)
parse_balanced_delimiters() (in module qal.common.strings)
parse_description() (in module qal.dal.conversions)
parse_xml() (qal.common.resources.Resources method)
pattern (qal.common.transform.ReplaceRegex attribute)
perform_transformations() (in module qal.common.transform)
platform_to_int() (in module qal.tools.discover)
post_execute_sql (qal.tools.merge.Merge attribute)
prefix (qal.sql.sql.ParameterIdentifier attribute)
prefix_own (qal.common.xml_utils.XML_Translation attribute)
prefix_schema (qal.common.xml_utils.XML_Translation attribute)
prefix_xml (qal.common.xml_utils.XML_Translation attribute)
pretty_list() (in module qal.common.listhelper)
python_type_to_SQL_type() (in module qal.dal.conversions)

Q

qal (module)
qal.common (module)
qal.common.diff (module)
qal.common.listhelper (module)
qal.common.mapping (module)
qal.common.resources (module)
qal.common.settings (module)
qal.common.strings (module)
qal.common.substitution (module)
qal.common.tests (module)
qal.common.tests.resources (module)
qal.common.tests.test_diff (module)
qal.common.tests.test_resources (module)
qal.common.tests.test_strings (module)
qal.common.tests.test_transform (module)
qal.common.transform (module)
qal.common.xml_utils (module)
qal.dal (module)
qal.dal.conversions (module)
qal.dal.dal (module)
qal.dal.tests (module)
qal.dal.tests.framework (module)
qal.dal.tests.test_dal (module)
qal.dal.types (module)
qal.dataset (module)
qal.dataset.custom (module)
qal.dataset.factory (module)
qal.dataset.flatfile (module)
qal.dataset.matrix (module)
qal.dataset.rdbms (module)
qal.dataset.spreadsheet (module)
qal.dataset.tests (module)
qal.dataset.tests.resources (module)
qal.dataset.tests.test_flatfile (module)
qal.dataset.tests.test_rdbms (module)
qal.dataset.tests.test_spreadsheet (module)
qal.dataset.tests.test_xpath (module)
qal.dataset.xpath (module)
qal.sql (module)
qal.sql.base (module)
qal.sql.macros (module)
qal.sql.meta (module)
qal.sql.remotable (module)
qal.sql.sql (module)
qal.sql.tests (module)
qal.sql.tests.resources (module)
qal.sql.tests.test_macros (module)
qal.sql.tests.test_meta (module)
qal.sql.tests.test_sql (module)
qal.sql.tests.test_xml (module)
qal.sql.types (module)
qal.sql.utils (module)
qal.sql.xml (module)
qal.tools (module)
qal.tools.discover (module)
qal.tools.merge (module)
qal.tools.meta_queries (module)
qal.tools.tests (module)
qal.tools.tests.resources (module)
qal.tools.tests.test_merge (module)
qal.tools.tests.test_meta_queries (module)
query (qal.dataset.rdbms.RDBMSDataset attribute)
query() (qal.dal.dal.DatabaseAbstractionLayer method)
quotechar (qal.dataset.flatfile.FlatfileDataset attribute)
quoting (qal.dataset.flatfile.FlatfileDataset attribute)
quoting_types() (in module qal.sql.types)

R

RDBMSDataset (class in qal.dataset.rdbms)
read_ini_settings() (qal.dal.dal.DatabaseAbstractionLayer method)
read_resource_settings() (qal.dal.dal.DatabaseAbstractionLayer method)
(qal.dataset.custom.CustomDataset method)
(qal.dataset.flatfile.FlatfileDataset method)
(qal.dataset.rdbms.RDBMSDataset method)
(qal.dataset.spreadsheet.SpreadsheetDataset method)
(qal.dataset.xpath.XpathDataset method)
references (qal.sql.sql.ParameterConstraint attribute)
reload() (qal.common.settings.UBPMSettings method)
Replace (class in qal.common.transform)
ReplaceRegex (class in qal.common.transform)
Resource (class in qal.common.resources)
resource_types() (in module qal.common.resources)
resource_uuid (qal.sql.remotable.ParameterRemotable attribute)
Resources (class in qal.common.resources)
resources (qal.tools.merge.Merge attribute)
result (qal.sql.sql.ParameterWhen attribute)
right (qal.sql.sql.ParameterAssignment attribute)
(qal.sql.sql.ParameterCondition attribute)
rollback() (qal.dal.dal.DatabaseAbstractionLayer method)
rows_xpath (qal.dataset.xpath.XpathDataset attribute)

S

save() (qal.dataset.custom.CustomDataset method)
(qal.dataset.flatfile.FlatfileDataset method)
(qal.dataset.matrix.MatrixDataset method)
(qal.dataset.rdbms.RDBMSDataset method)
(qal.dataset.spreadsheet.SpreadsheetDataset method)
(qal.dataset.xpath.XpathDataset method)
save_xls() (qal.dataset.spreadsheet.SpreadsheetDataset method)
save_xlsx() (qal.dataset.spreadsheet.SpreadsheetDataset method)
schema_uri (qal.common.xml_utils.XML_Translation attribute)
select_all_skeleton() (in module qal.sql.macros)
set_identity() (qal.common.substitution.Substitution method)
set_max_identities_for_mappings() (qal.tools.merge.Merge method)
set_operator (qal.sql.sql.ParameterSet attribute)
set_operator() (in module qal.sql.types)
setUp() (qal.sql.tests.test_macros.Test method)
sheet_name (qal.dataset.spreadsheet.SpreadsheetDataset attribute)
skipinitialspace (qal.dataset.flatfile.FlatfileDataset attribute)
source (qal.tools.merge.Merge attribute)
sources (qal.sql.sql.VerbDelete attribute)
(qal.sql.sql.VerbSelect attribute)
SpreadsheetDataset (class in qal.dataset.spreadsheet)
sql_db2 (qal.sql.sql.VerbCustom attribute)
sql_for_all_databases() (in module qal.sql.tests.test_xml)
sql_mysql (qal.sql.sql.VerbCustom attribute)
sql_oracle (qal.sql.sql.VerbCustom attribute)
sql_postgresql (qal.sql.sql.VerbCustom attribute)
sql_property_to_type() (in module qal.sql.types)
sql_property_to_xml_type() (in module qal.sql.xml)
sql_sqlserver (qal.sql.sql.VerbCustom attribute)
sql_structure_to_xml() (qal.sql.xml.SQL_XML method)
SQL_XML (class in qal.sql.xml)
SqlList (class in qal.sql.base)
src_datatype (qal.common.mapping.Mapping attribute)
src_reference (qal.common.mapping.Mapping attribute)
start() (qal.dal.dal.DatabaseAbstractionLayer method)
string_to_bool() (in module qal.common.strings)
string_to_db_type() (in module qal.dal.types)
string_value (qal.sql.sql.ParameterString attribute)
subsets (qal.sql.sql.ParameterSet attribute)
substitute() (qal.common.substitution.Substitution method)
Substitution (class in qal.common.substitution)
substitution (qal.common.mapping.Mapping attribute)
(qal.common.transform.CustomTransformation attribute)

T

table_identifier (qal.sql.sql.VerbUpdate attribute)
table_info() (qal.tools.meta_queries.Meta_Queries static method)
table_list_by_database_name() (qal.tools.meta_queries.Meta_Queries static method)
table_list_by_schema() (qal.tools.meta_queries.Meta_Queries static method)
table_name (qal.dataset.rdbms.RDBMSDataset attribute)
tablename (qal.sql.sql.VerbCreateIndex attribute)
tabular_expression_item_types() (in module qal.sql.types)
tabular_source_to_sql() (in module qal.sql.utils)
Test (class in qal.common.tests.test_resources)
(class in qal.common.tests.test_strings)
(class in qal.dataset.tests.test_flatfile)
(class in qal.dataset.tests.test_rdbms)
(class in qal.dataset.tests.test_spreadsheet)
(class in qal.dataset.tests.test_xpath)
(class in qal.sql.tests.test_macros)
(class in qal.sql.tests.test_meta)
test_00_ParameterCondition_simple() (qal.sql.tests.test_sql.parameter_test method)
test_01_ParameterCondition_complex() (qal.sql.tests.test_sql.parameter_test method)
test_02_ParameterExpression_simple() (qal.sql.tests.test_sql.parameter_test method)
test_03_ParameterCast_simple() (qal.sql.tests.test_sql.parameter_test method)
test_04_ParameterFunction_simple() (qal.sql.tests.test_sql.parameter_test method)
test_05_ParameterCase() (qal.sql.tests.test_sql.parameter_test method)
test_06_VerbSelect() (qal.sql.tests.test_sql.parameter_test method)
test_07_parameter_create_table() (qal.sql.tests.test_sql.parameter_test method)
test_08_VerbInsert() (qal.sql.tests.test_sql.parameter_test method)
test_09_VerbUpdate() (qal.sql.tests.test_sql.parameter_test method)
test_10_parameter_create_index() (qal.sql.tests.test_sql.parameter_test method)
test_11_parameter_drop_table() (qal.sql.tests.test_sql.parameter_test method)
test_1_apply_new_data() (qal.dataset.tests.test_xpath.Test method)
test_1_create_table_skeleton() (qal.sql.tests.test_macros.Test method)
test_1_generate_xml_Schema() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_1_Load_Save() (qal.dataset.tests.test_flatfile.Test method)
test_1_Load_Save_xls() (qal.dataset.tests.test_spreadsheet.Test method)
test_1_Merge_files() (qal.tools.tests.test_merge.Merge_test method)
test_1_trim() (qal.common.tests.test_transform.Transform_test method)
test_1_XML_parsing() (qal.common.tests.test_resources.Test method)
(qal.common.tests.test_strings.Test method)
test_2_create_table() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_2_empty_if_none() (qal.common.tests.test_strings.Test method)
test_2_IfEmpty() (qal.common.tests.test_transform.Transform_test method)
test_2_Load_Save_xlsx() (qal.dataset.tests.test_spreadsheet.Test method)
test_2_make_insert_sql_with_parameters() (qal.sql.tests.test_macros.Test method)
test_2_Merge_tables() (qal.tools.tests.test_merge.Merge_test method)
test_3_copy_to_temp_table() (qal.sql.tests.test_macros.Test method)
test_3_make_path_absolute() (qal.common.tests.test_strings.Test method)
test_3_Merge_to_nonexisting() (qal.tools.tests.test_merge.Merge_test method)
test_3_replace() (qal.common.tests.test_transform.Transform_test method)
test_3_select() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_4_insert() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_4_replace_regex() (qal.common.tests.test_transform.Transform_test method)
test_4_select_all_skeleton() (qal.sql.tests.test_macros.Test method)
test_5_cast() (qal.common.tests.test_transform.Transform_test method)
test_5_create_index() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_5_select_all_skeleton_columns() (qal.sql.tests.test_macros.Test method)
test_6_insert_matrix_csv() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_7_delete() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_8_update() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_9_resource() (qal.sql.tests.test_xml.class_SQL_Meta_XML_Test method)
test_connect_DB_DB2() (qal.dal.tests.test_dal.DAL_tests method)
test_connect_DB_MYSQL() (qal.dal.tests.test_dal.DAL_tests method)
test_connect_DB_ORACLE() (qal.dal.tests.test_dal.DAL_tests method)
test_connect_DB_POSTGRESQL() (qal.dal.tests.test_dal.DAL_tests method)
test_connect_DB_SQLSERVER() (qal.dal.tests.test_dal.DAL_tests method)
test_diff() (qal.common.tests.test_diff.Diff_test method)
TestSQL_Meta_queries (class in qal.tools.tests.test_meta_queries)
top_limit (qal.sql.sql.VerbSelect attribute)
transform() (qal.common.transform.CustomTransformation method)
Transform_test (class in qal.common.tests.test_transform)
Trim (class in qal.common.transform)
type (qal.common.resources.Resource attribute)

U

UBPMSettings (class in qal.common.settings)
unenumerate() (in module qal.common.listhelper)
(in module qal.dal.types)
update (qal.tools.merge.Merge attribute)
uuid (qal.common.resources.Resource attribute)

V

value (qal.common.transform.IfEmpty attribute)
(qal.common.transform.Trim attribute)
VerbCreateIndex (class in qal.sql.sql)
VerbCreateTable (class in qal.sql.sql)
VerbCustom (class in qal.sql.sql)
VerbDelete (class in qal.sql.sql)
VerbDropTable (class in qal.sql.sql)
VerbInsert (class in qal.sql.sql)
verbs() (in module qal.sql.types)
VerbSelect (class in qal.sql.sql)
VerbUpdate (class in qal.sql.sql)

W

when_statements (qal.sql.sql.ParameterCase attribute)
write_resource_settings() (qal.dal.dal.DatabaseAbstractionLayer method)
(qal.dataset.custom.CustomDataset method)
(qal.dataset.flatfile.FlatfileDataset method)
(qal.dataset.rdbms.RDBMSDataset method)
(qal.dataset.spreadsheet.SpreadsheetDataset method)
(qal.dataset.xpath.XpathDataset method)

X

x_offset (qal.dataset.spreadsheet.SpreadsheetDataset attribute)
xml_base_type_value() (in module qal.common.xml_utils)
xml_file_to_sql() (qal.sql.xml.SQL_XML method)
xml_find_non_text_child() (in module qal.common.xml_utils)
xml_get_allowed_value() (in module qal.common.xml_utils)
xml_get_boolean() (in module qal.common.xml_utils)
xml_get_numeric() (in module qal.common.xml_utils)
xml_get_text() (in module qal.common.xml_utils)
xml_isnone() (in module qal.common.xml_utils)
xml_set_cdata() (in module qal.common.xml_utils)
xml_to_sql_structure() (qal.sql.xml.SQL_XML method)
XML_Translation (class in qal.common.xml_utils)
xpath_data_format (qal.dataset.xpath.XpathDataset attribute)
xpath_data_formats() (in module qal.dataset.xpath)
XpathDataset (class in qal.dataset.xpath)

Y

y_offset (qal.dataset.spreadsheet.SpreadsheetDataset attribute)