Skip to content

Fix for loading via query when column has percent sign #125

Fix for loading via query when column has percent sign

Fix for loading via query when column has percent sign #125

GitHub Actions / Tests succeeded Sep 26, 2024 in 0s

275 passed, 0 failed and 2 skipped

Tests passed successfully

✅ pytestresult.xml

277 tests were completed in 10s with 275 passed, 0 failed and 2 skipped.

Test suite Passed Failed Skipped Time
pytest 275✅ 2⚪ 10s

✅ pytest

plaidcloud.utilities.clean_files
  ✅ utilities.clean_files.clean_email_address_str
plaidcloud.utilities.color
  ✅ utilities.color.HTMLColorToFloat
  ✅ utilities.color.HTMLColorToRGB
  ✅ utilities.color.RGBToFloat
  ✅ utilities.color.colorToHex
  ✅ utilities.color.processColor
  ✅ utilities.color.rgb
plaidcloud.utilities.converter
  ✅ utilities.converter.camelToUnderscore
  ✅ utilities.converter.convert
  ✅ utilities.converter.j2p
  ✅ utilities.converter.p2j
  ✅ utilities.converter.setSettings
  ✅ utilities.converter.setattrs
  ✅ utilities.converter.underscoreToCamel
plaidcloud.utilities.data_helpers
  ✅ utilities.data_helpers.cast_as_float
  ✅ utilities.data_helpers.cast_as_int
  ✅ utilities.data_helpers.cast_as_str
  ✅ utilities.data_helpers.coalesce
  ✅ utilities.data_helpers.remove_all
  ✅ utilities.data_helpers.safe_divide
plaidcloud.utilities.frame_manager
  ✅ utilities.frame_manager.get_formatted_number
  ✅ utilities.frame_manager.sql_from_dtype
plaidcloud.utilities.hasher
  ✅ utilities.hasher.Hasher._prepare_data
  ✅ utilities.hasher.Hasher.get
  ✅ utilities.hasher.Hasher.get_clean
  ✅ utilities.hasher.Hasher.get_consistent
  ✅ utilities.hasher.get_random
plaidcloud.utilities.network_helpers
  ✅ utilities.network_helpers.retry_random_exp
plaidcloud.utilities.pretty_size
  ✅ utilities.pretty_size.pretty_size
  ✅ utilities.pretty_size.pretty_size_disk
plaidcloud.utilities.stringtransforms
  ✅ utilities.stringtransforms.replaceTags
plaidcloud.utilities.tests.test_clean_files.TestShouldClean
  ✅ test_should_clean_new_clean_file
  ✅ test_should_clean_no_clean_file
  ✅ test_should_clean_no_dirty_file
  ✅ test_should_clean_old_clean_file
plaidcloud.utilities.tests.test_frame_manager.TestFrameManager
  ✅ test_count
  ✅ test_count_unique
  ✅ test_describe
  ✅ test_drop_column
  ✅ test_has_data
  ✅ test_inner_join
  ✅ test_left_join
  ✅ test_lookup
  ✅ test_mean
  ✅ test_now
  ✅ test_outer_join
  ✅ test_rename_columns
  ✅ test_replace
  ✅ test_right_join
  ⚪ test_set_column_types
  ✅ test_std
  ✅ test_sum
plaidcloud.utilities.tests.test_frame_manager.TestCoalesce
  ✅ test_consider_null
  ⚪ test_consider_null_cross_type
  ✅ test_cross_type_comparison
  ✅ test_index_mismatch
  ✅ test_numeric_columns
  ✅ test_one_column
  ✅ test_string_columns
  ✅ test_value_preservation
plaidcloud.utilities.tests.test_hasher.TestHasher
  ✅ test_getting_consistent_hash
  ✅ test_getting_dynamic_hash
  ✅ test_object_instantiation
  ✅ test_prepare_data_only_works_on_strings
  ✅ test_prepare_data_retains_all_elements
  ✅ test_prepare_data_sorts_elements_correctly
plaidcloud.utilities.tests.test_sql_expression.TestGetProjectSchema
  ✅ test_adds_anlz
  ✅ test_doesnt_add_anlz_when_already_there
plaidcloud.utilities.tests.test_sql_expression.TestGetAggFn
  ✅ test_agg_count_distinct
  ✅ test_agg_dont_group
  ✅ test_agg_func
  ✅ test_agg_func_null
  ✅ test_agg_group
  ✅ test_agg_none
plaidcloud.utilities.tests.test_sql_expression.TestGetTableRep
  ✅ test_alias
  ✅ test_basic_use_case
  ✅ test_column_key
  ✅ test_metadata
  ✅ test_no_table_id_errors
  ✅ test_works_without_metadata
plaidcloud.utilities.tests.test_sql_expression.TestGetTableRepUsingID
  ✅ test_get_table_rep_using_id
plaidcloud.utilities.tests.test_sql_expression.TestGetColumnTable
  ✅ test_default_is_table1
  ✅ test_search_for_column_name_in_both
  ✅ test_search_for_column_name_in_neither
  ✅ test_search_for_column_name_in_table_1
  ✅ test_search_for_column_name_in_table_2
  ✅ test_source_table1
  ✅ test_source_table2
  ✅ test_source_table_a
  ✅ test_source_table_b
  ✅ test_tableN_dot_column
  ✅ test_table_dot_column
  ✅ test_table_numbering_start
plaidcloud.utilities.tests.test_sql_expression.TestCleanWhere
  ✅ test_cleans_newlines
  ✅ test_doesnt_overclean
  ✅ test_trims
plaidcloud.utilities.tests.test_sql_expression.TestEvalExpression
  ✅ test_basic_use_case
  ✅ test_disable_variables_var_exists
  ✅ test_disable_variables_var_not_exists
  ✅ test_error
  ✅ test_extra_keys
  ✅ test_get_column
  ✅ test_get_column_errors_if_not_found
  ✅ test_table
  ✅ test_tableN
  ✅ test_table_numbering_start
  ✅ test_variables
plaidcloud.utilities.tests.test_sql_expression.TestOnClause
  ✅ test_basic_use_case
  ✅ test_special_null_handling
  ✅ test_two_keys
plaidcloud.utilities.tests.test_sql_expression.TestProcessFn
  ✅ test_agg
  ✅ test_cast
  ✅ test_sort
plaidcloud.utilities.tests.test_sql_expression.TestGetFromClause
  ✅ test_bigserial_is_none
  ✅ test_bigserial_is_row_number
  ✅ test_constant
  ✅ test_constant_disable_variables
  ✅ test_constant_irrelevant_aggregate
  ✅ test_constant_irrelevant_cast
  ✅ test_constant_variables
  ✅ test_errors_when_no_source_expression_or_constant
  ✅ test_expression
  ✅ test_expression_aggregate
  ✅ test_expression_aggregate_false
  ✅ test_expression_irrelevant_cast
  ✅ test_function_application_order
  ✅ test_magic_columns_is_none
  ✅ test_magic_source_table_name
  ✅ test_magic_source_table_name_no_alias
  ✅ test_nonexistent_source_errors
  ✅ test_priority_constant_expression_source
  ✅ test_priority_expression_source
  ✅ test_returns_label_object
  ✅ test_serial_is_none
  ✅ test_serial_is_row_number
  ✅ test_sort_asc
  ✅ test_sort_but_no_sort_columns
  ✅ test_sort_desc
  ✅ test_sort_no_order
  ✅ test_source_cast_false
  ✅ test_source_column_with_dot
  ✅ test_source_count_null
  ✅ test_source_dtype_numeric
  ✅ test_source_dtype_text
  ✅ test_source_table_dot_column
plaidcloud.utilities.tests.test_sql_expression.TestGetCombinedWheres
  ✅ test_get_combined_wheres
plaidcloud.utilities.tests.test_sql_expression.TestGetSelectQuery
  ✅ test_aggregate_false
  ✅ test_basic_use_case
  ✅ test_config
  ✅ test_config_lower_priority
  ✅ test_config_special_falsy_case
  ✅ test_count
  ✅ test_distinct
  ✅ test_distinct_false
  ✅ test_distinct_on_serial_row_number
  ✅ test_dont_distinct_on_constant
  ✅ test_dont_distinct_on_serial
  ✅ test_dont_groupby_constant
  ✅ test_dont_groupby_serial
  ✅ test_dont_sort_serial
  ✅ test_dont_sort_without_ascending_param
  ✅ test_groupby
  ✅ test_groupby_serial_row_number
  ✅ test_having
  ✅ test_limit_defaults
  ✅ test_limit_target_end_not_start
  ✅ test_order
  ✅ test_put_columns_without_order_at_end_of_sort
  ✅ test_serial
  ✅ test_sort
  ✅ test_use_target_slicer
  ✅ test_wheres
plaidcloud.utilities.tests.test_sql_expression.TestSimpleSelectQuery
  ✅ test_basic_use_case
  ✅ test_source_alias
  ✅ test_source_where
plaidcloud.utilities.tests.test_sql_expression.TestModifiedSelectQuery
  ✅ test_default
  ✅ test_errors_when_no_fmt_or_mapping_fn
  ✅ test_fmt
  ✅ test_mapping_fn
plaidcloud.utilities.tests.test_sql_expression.TestApplyOutputFilter
  ✅ test_apply_output_filter
plaidcloud.utilities.tests.test_sql_expression.TestGetInsertQuery
  ✅ test_basic_use_case
  ✅ test_serial
  ✅ test_serial_row_number
plaidcloud.utilities.tests.test_sql_expression.TestGetDeleteQuery
  ✅ test_delete_no_where
  ✅ test_delete_where
plaidcloud.utilities.tests.test_sql_expression.TestImportDataQuery
  ✅ test_basic_use_case
  ✅ test_date_format
  ✅ test_magic_columns
  ✅ test_trailing_negatives
plaidcloud.utilities.tests.test_sql_expression.TestGetUpdateValue
  ✅ test_constant
  ✅ test_dont_include
  ✅ test_expression
  ✅ test_expression_none_returns_empty_string_for_text
  ✅ test_include_because_text
  ✅ test_nullify
plaidcloud.utilities.tests.test_sql_expression.TestGetUpdateQuery
  ✅ test_basic_use_case
  ✅ test_empty_string
  ✅ test_empty_string_no_matter_what
  ✅ test_wheres
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestImportCol
  ✅ test_import_col_interval
  ✅ test_import_col_numeric
  ✅ test_import_col_text
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestImportColDatabend
  ✅ test_import_col_interval
  ✅ test_import_col_numeric
  ✅ test_import_col_text
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestZfill
  ✅ test_zfill
  ✅ test_zfill_char
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestNormalizeWhitespace
  ✅ test_normalize_whitespace
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestLeft
  ✅ test_left
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestSliceString
  ✅ test_slice_string
  ✅ test_slice_string_neg_count
  ✅ test_slice_string_neg_start
  ✅ test_slice_string_neg_start_neg_count
  ✅ test_slice_string_neg_start_none
  ✅ test_slice_string_neg_start_pos_count
  ✅ test_slice_string_none
  ✅ test_slice_string_none_start
  ✅ test_slice_string_none_start_neg_count
  ✅ test_slice_string_none_start_none
  ✅ test_slice_string_none_start_pos_count
  ✅ test_slice_string_pos_count
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestDateAdd
  ✅ test_date_add
  ✅ test_date_add_no_params
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestTransactionTimestamp
  ✅ test_transaction_timestamp
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestStrpos
  ✅ test_strpos
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestStringToArray
  ✅ test_string_to_array
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestToNumber
  ✅ test_to_number
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestLTrim
  ✅ test_ltrim_plain
  ✅ test_ltrim_specific
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestRTrim
  ✅ test_rtrim_plain
  ✅ test_rtrim_specific
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestTrim
  ✅ test_trim_plain
  ✅ test_trim_specific
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestToChar
  ✅ test_to_char_date
  ✅ test_to_char_date_i
  ✅ test_to_char_number
  ✅ test_to_char_time
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestSafeToDate
  ✅ test_to_date
  ✅ test_to_date_specifier
  ✅ test_to_date_specifier_python
plaidcloud.utilities.tests.test_sqlalchemy_functions.TestSafeToDateDB
  ✅ test_to_date
  ✅ test_to_date_specifier
  ✅ test_to_date_specifier_postgres
plaidcloud.utilities.tests.test_sqlalchemy_views.TestDropView
  ✅ test_drop_cascade
  ✅ test_drop_default
  ✅ test_drop_if_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestCreateView
  ✅ test_create_comment
  ✅ test_create_no_replace
  ✅ test_create_with_options
  ✅ test_create_with_replace
  ✅ test_create_with_replace_if_not_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestDropMaterializedView
  ✅ test_drop_cascade
  ✅ test_drop_default
  ✅ test_drop_if_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestCreateMaterializedView
  ✅ test_create_no_replace
  ✅ test_create_with_options
  ✅ test_create_with_replace
  ✅ test_create_with_replace_if_not_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestDropViewStarRocks
  ✅ test_drop_cascade
  ✅ test_drop_default
  ✅ test_drop_if_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestCreateViewStarRocks
  ✅ test_create_comment
  ✅ test_create_no_replace
  ✅ test_create_with_options
  ✅ test_create_with_replace
  ✅ test_create_with_replace_if_not_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestDropMaterializedViewStarRocks
  ✅ test_drop_cascade
  ✅ test_drop_default
  ✅ test_drop_if_exists
plaidcloud.utilities.tests.test_sqlalchemy_views.TestCreateMaterializedViewStarRocks
  ✅ test_create_comment
  ✅ test_create_no_replace
  ✅ test_create_refresh
  ✅ test_create_with_options
  ✅ test_create_with_replace
  ✅ test_create_with_replace_if_not_exists
plaidcloud.utilities.utility
  ✅ utilities.utility.month_to_quarter
plaidcloud.utilities.xray
  ✅ utilities.xray.Xray