Skip to content

Latest commit

 

History

History

sql_test_files

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
error_arbitrary_SQL_expressions_as_function_arguments_are_not_supported.sql
error_arbitrary_SQL_expressions_as_function_arguments_are_not_supported.sql
 
 
error_cookie_component_cannot_be_used_after_data_has_already_been_sent.sql
error_cookie_component_cannot_be_used_after_data_has_already_been_sent.sql
 
 
error_failed_to_import_the_csv.sql
error_failed_to_import_the_csv.sql
 
 
error_invalid_json_in_dynamic_component.sql
error_invalid_json_in_dynamic_component.sql
 
 
error_single_shell_per_page.sql
error_single_shell_per_page.sql
 
 
error_the_dynamic_component_requires_a_property_named.sql
error_the_dynamic_component_requires_a_property_named.sql
 
 
error_too_many_nested_inclusions.sql
error_too_many_nested_inclusions.sql
 
 
error_unknown_field.sql
error_unknown_field.sql
 
 
it_works_basic_auth_password.sql
it_works_basic_auth_password.sql
 
 
it_works_basic_auth_username.sql
it_works_basic_auth_username.sql
 
 
it_works_case_variables.sql
it_works_case_variables.sql
 
 
it_works_client_ip.sql
it_works_client_ip.sql
 
 
it_works_coalesce_eval.sql
it_works_coalesce_eval.sql
 
 
it_works_columns_component_json_nomssql_nopostgres.sql
it_works_columns_component_json_nomssql_nopostgres.sql
 
 
it_works_concat_str_in_pseudofunction.sql
it_works_concat_str_in_pseudofunction.sql
 
 
it_works_cookie.sql
it_works_cookie.sql
 
 
it_works_create_table.sql
it_works_create_table.sql
 
 
it_works_decimal.sql
it_works_decimal.sql
 
 
it_works_deeply_nested_dynamic_components.sql
it_works_deeply_nested_dynamic_components.sql
 
 
it_works_default_component.sql
it_works_default_component.sql
 
 
it_works_delayed_function_call.sql
it_works_delayed_function_call.sql
 
 
it_works_dynamic_nested.sql
it_works_dynamic_nested.sql
 
 
it_works_dynamic_repeated_properties.sql
it_works_dynamic_repeated_properties.sql
 
 
it_works_dynamic_run_sql_include.sql
it_works_dynamic_run_sql_include.sql
 
 
it_works_dynamic_shell.sql
it_works_dynamic_shell.sql
 
 
it_works_dynamic_toplevel.sql
it_works_dynamic_toplevel.sql
 
 
it_works_env_var_empty.sql
it_works_env_var_empty.sql
 
 
it_works_exec.sql
it_works_exec.sql
 
 
it_works_fetch_post.sql
it_works_fetch_post.sql
 
 
it_works_fetch_simple.sql
it_works_fetch_simple.sql
 
 
it_works_fetch_with_meta_error.sql
it_works_fetch_with_meta_error.sql
 
 
it_works_fetch_with_meta_simple.sql
it_works_fetch_with_meta_simple.sql
 
 
it_works_hash_password.sql
it_works_hash_password.sql
 
 
it_works_hash_password_null.sql
it_works_hash_password_null.sql
 
 
it_works_header.sql
it_works_header.sql
 
 
it_works_headers.sql
it_works_headers.sql
 
 
it_works_link.sql
it_works_link.sql
 
 
it_works_lower.sql
it_works_lower.sql
 
 
it_works_markdown_in_table.sql
it_works_markdown_in_table.sql
 
 
it_works_native_json_array_impl.sql
it_works_native_json_array_impl.sql
 
 
it_works_nested_sqlpage_functions.sql
it_works_nested_sqlpage_functions.sql
 
 
it_works_path.sql
it_works_path.sql
 
 
it_works_postgres_cast_syntax.sql
it_works_postgres_cast_syntax.sql
 
 
it_works_protocol.sql
it_works_protocol.sql
 
 
it_works_query_string.sql
it_works_query_string.sql
 
 
it_works_random_string.sql
it_works_random_string.sql
 
 
it_works_read_file_as_data_url.sql
it_works_read_file_as_data_url.sql
 
 
it_works_read_file_as_text.sql
it_works_read_file_as_text.sql
 
 
it_works_request_method.sql
it_works_request_method.sql
 
 
it_works_run_sql.sql
it_works_run_sql.sql
 
 
it_works_run_sql_from_database.sql
it_works_run_sql_from_database.sql
 
 
it_works_run_sql_variable_access.sql
it_works_run_sql_variable_access.sql
 
 
it_works_set_variable.sql
it_works_set_variable.sql
 
 
it_works_set_variable_numeric.sql
it_works_set_variable_numeric.sql
 
 
it_works_set_variable_to_null.sql
it_works_set_variable_to_null.sql
 
 
it_works_set_variable_to_sqlpage_function.sql
it_works_set_variable_to_sqlpage_function.sql
 
 
it_works_set_variable_to_sqlpage_post_function.sql
it_works_set_variable_to_sqlpage_post_function.sql
 
 
it_works_shell_search.sql
it_works_shell_search.sql
 
 
it_works_simple.sql
it_works_simple.sql
 
 
it_works_sqlite_unicode_upper.sql
it_works_sqlite_unicode_upper.sql
 
 
it_works_temp_table_accessible_in_run_sql_nomssql.sql
it_works_temp_table_accessible_in_run_sql_nomssql.sql
 
 
it_works_text_markdown.sql
it_works_text_markdown.sql
 
 
it_works_text_unsafe_markdown.sql
it_works_text_unsafe_markdown.sql
 
 
it_works_uploaded_file_is_null.sql
it_works_uploaded_file_is_null.sql
 
 
it_works_url_encode.sql
it_works_url_encode.sql
 
 
it_works_varchar_nomysql.sql
it_works_varchar_nomysql.sql
 
 
it_works_variables_function.sql
it_works_variables_function.sql
 
 
it_works_variables_function_get_and_post.sql
it_works_variables_function_get_and_post.sql
 
 
it_works_without_a_shell.sql
it_works_without_a_shell.sql
 
 

README.md

The sql files in this folder are all tested automatically.

it_works_ files

Files with names starting with it_works should all return a page that contains the text "It works !" and does not contain the text "error" (case insensitive) when executed.

If a file name contains nosqlite, nomssql, nopostgres or nomysql, then the test will be ignored when running against the corresponding database. This allows using syntax that is not supported on all databases in some tests.

error_ files

Files with names starting with error should all return a page that contains the text "error" and the rest of the file name when executed.