PostgREST/postgrest

Pattern Findings

148 matches across 8 categories. Click a row to expand file-level details.

Hyper-Verbose Identifiers108 hits · 78 pts

Severity	File	Line	Snippet
LOW	test/io/config.py	37	def get_admin_host_and_port_from_config(config):
LOW	test/io/test_auth.py	24	def test_read_secret_from_file(secretpath, defaultenv):
LOW	test/io/test_auth.py	41	def test_read_secret_from_stdin(defaultenv):
LOW	test/io/test_auth.py	57	def test_read_secret_from_stdin_dbconfig(defaultenv):
LOW	test/io/test_auth.py	163	def test_fail_with_invalid_password(defaultenv):
LOW	test/io/test_auth.py	194	def test_jwt_aud_in_role_claim_key(jwtaudroleclaim, defaultenv):
LOW	test/io/test_auth.py	257	def test_jwt_secret_external_file_reload(tmp_path, defaultenv):
LOW	test/io/test_auth.py	308	def test_jwt_cache_server_timing(defaultenv):
LOW	test/io/test_auth.py	344	def test_jwt_cache_without_server_timing(defaultenv):
LOW	test/io/test_auth.py	365	def test_jwt_cache_without_exp_claim(defaultenv):
LOW	test/io/test_auth.py	392	def test_invalidate_jwt_cache_when_secret_changes(tmp_path, defaultenv):
LOW	test/io/util.py	63	def parse_server_timings_header(header):
LOW	test/io/test_io.py	1739	def test_function_setting_statement_timeout_fails(defaultenv):
LOW	test/io/test_io.py	1752	def test_function_setting_statement_timeout_passes(defaultenv):
LOW	test/io/test_io.py	1762	def test_function_setting_work_mem(defaultenv):
LOW	test/io/test_io.py	60	def test_read_dburi_from_stdin_without_eol(dburi, defaultenv):
LOW	test/io/test_io.py	73	def test_read_dburi_from_stdin_with_eol(dburi, defaultenv):
LOW	test/io/test_io.py	86	def test_app_settings_flush_pool(defaultenv):
LOW	test/io/test_io.py	110	def test_flush_pool_no_interrupt(defaultenv):
LOW	test/io/test_io.py	132	def test_graceful_shutdown_waits_for_in_flight_request(defaultenv):
LOW	test/io/test_io.py	153	def test_termination_unix_signal_logging(defaultenv):
LOW	test/io/test_io.py	179	def test_so_reuseport_zero_downtime_handover(defaultenv):
LOW	test/io/test_io.py	294	def test_db_schema_notify_reload(defaultenv):
LOW	test/io/test_io.py	349	def test_max_rows_notify_reload(defaultenv):
LOW	test/io/test_io.py	380	def test_invalid_role_claim_key_notify_reload(defaultenv):
LOW	test/io/test_io.py	422	def test_db_prepared_statements_enable(defaultenv):
LOW	test/io/test_io.py	430	def test_db_prepared_statements_disable(defaultenv):
LOW	test/io/test_io.py	468	def test_change_statement_timeout(defaultenv, metapostgrest):
LOW	test/io/test_io.py	541	def test_pool_acquisition_timeout(level, defaultenv, metapostgrest):
LOW	test/io/test_io.py	572	def test_pool_acquisition_timeout_logs_are_debounced(defaultenv):
LOW	test/io/test_io.py	620	def test_change_statement_timeout_held_connection(defaultenv, metapostgrest):
LOW	test/io/test_io.py	681	def test_admin_ready_w_channel(defaultenv):
LOW	test/io/test_io.py	694	def test_listener_query_is_visible_in_pg_stat_activity(defaultenv):
LOW	test/io/test_io.py	1452	def test_schema_cache_query_timings_log(level, timezone_enabled, defaultenv):
LOW	test/io/test_io.py	1483	def test_get_pgrst_version_with_uri_connection_string(dburi_type, dburi, defaultenv):
LOW	test/io/test_io.py	1505	def test_get_pgrst_version_with_keyval_connection_string(defaultenv):
LOW	test/io/test_io.py	1523	def test_log_postgrest_version(defaultenv):
LOW	test/io/test_io.py	1536	def test_log_postgrest_host_and_port(host, defaultenv):
LOW	test/io/test_io.py	1556	def test_succeed_w_role_having_superuser_settings(defaultenv):
LOW	test/io/test_io.py	1568	def test_get_granted_superuser_setting(defaultenv):
LOW	test/io/test_io.py	1586	def test_fail_with_invalid_dbname_and_automatic_recovery_disabled(defaultenv):
LOW	test/io/test_io.py	1601	def test_fail_with_automatic_recovery_disabled_and_terminated_using_query(defaultenv):
LOW	test/io/test_io.py	1621	def test_preflight_request_with_cors_allowed_origin_config(defaultenv):
LOW	test/io/test_io.py	1644	def test_preflight_request_with_empty_cors_allowed_origin_config(defaultenv):
LOW	test/io/test_io.py	1702	def test_db_error_logging_to_stderr(level, defaultenv, metapostgrest):
LOW	test/io/test_io.py	1776	def test_multiple_func_settings(defaultenv):
LOW	test/io/test_io.py	1794	def test_first_hoisted_setting_is_applied(defaultenv):
LOW	test/io/test_io.py	1810	def test_second_hoisted_setting_is_applied(defaultenv):
LOW	test/io/test_io.py	1841	def test_admin_metrics_include_ghc_runtime_metrics(defaultenv):
LOW	test/io/test_io.py	1855	def test_admin_metrics_exclude_ghc_runtime_metrics_by_default(defaultenv):
LOW	test/io/test_io.py	1865	def test_schema_cache_startup_load_with_in_db_config(defaultenv, metapostgrest):
LOW	test/io/test_io.py	1901	def test_log_error_when_empty_schema_cache_on_startup_to_stderr(defaultenv):
LOW	test/io/test_io.py	1922	def test_no_double_schema_cache_reload_on_empty_schema(defaultenv):
LOW	test/io/test_io.py	1945	def test_log_pool_req_observation(level, defaultenv):
LOW	test/io/test_io.py	1991	def test_allow_configs_to_be_set_to_empty(defaultenv):
LOW	test/io/test_io.py	2004	def test_schema_cache_error_observation(defaultenv):
LOW	test/io/test_io.py	2024	def test_log_listener_connection_errors(defaultenv):
LOW	test/io/test_io.py	2042	def test_log_listener_connection_start(defaultenv):
LOW	test/io/test_io.py	2061	def test_db_pre_config_with_pg_reserved_words(defaultenv):
LOW	test/io/test_io.py	2087	def test_server_timing_transaction_duration(defaultenv, metapostgrest):
48 more matches not shown…

Cross-Language Confusion4 hits · 22 pts

Severity	File	Line	Snippet
HIGH	test/io/test_io.py	1748	== '{"code":"57014","details":null,"hint":null,"message":"canceling statement due to statement timeout"}'
HIGH	test/io/test_io.py	1896	log_message = '{"code":"PGRST001","details":"no connection to the server\\n","hint":null,"message":"Database cli
HIGH	test/io/test_io.py	1917	log_err_message = '{"code":"PGRST002","details":null,"hint":null,"message":"Could not query the database for the
HIGH	test/io/test_io.py	2081	'Failed to query database settings for the config parameters.{"code":"42883","details":null,"hint":"No funct

Over-Commented Block22 hits · 22 pts

Severity	File	Line	Snippet
LOW	.stylish-haskell.yaml	1	# stylish-haskell configuration file
LOW	.stylish-haskell.yaml	21	- simple_align:
LOW	.stylish-haskell.yaml	41	# Default: global.
LOW	.stylish-haskell.yaml	61	# > import qualified Data.List as List
LOW	.stylish-haskell.yaml	81	# > init, last, length)
LOW	.stylish-haskell.yaml	101	# > , singleton
LOW	.stylish-haskell.yaml	121
LOW	.stylish-haskell.yaml	141	# functions.
LOW	.stylish-haskell.yaml	161	# Default: false
LOW	.stylish-haskell.yaml	181	#
LOW	.stylish-haskell.yaml	201	# A common setting is the number of columns (parts of) code will be wrapped
LOW	test/io/test_io.py	181
LOW	docs/conf.py	1	# -- coding: utf-8 --
LOW	docs/conf.py	61	# The language for content autogenerated by Sphinx. Refer to documentation
LOW	docs/conf.py	81	# default_role = None
LOW	docs/conf.py	121	# The name for this set of Sphinx documents.
LOW	docs/conf.py	141
LOW	docs/conf.py	161	# html_additional_pages = {}
LOW	docs/conf.py	181	# If true, an OpenSearch description file will be output, and all pages will
LOW	docs/conf.py	201	# implements a search results scorer. If empty, the default will be used.
LOW	docs/conf.py	221	# (source start file, target name, title,
LOW	docs/conf.py	241	# Documents to append as an appendix to all manuals.

Excessive Try-Catch Wrapping7 hits · 11 pts

Severity	File	Line	Snippet
LOW	nix/tools/generate_targets.py	163	except Exception as exc: # broad exception to capture parsing errors
MEDIUM	nix/tools/generate_targets.py	199	print(f"Error writing to {args.targets_path}: {e}", file=sys.stderr)
MEDIUM	nix/tools/gen_rsa_materials.py	40	print(f"Error writing to {args.jwk_path}:{e}", file=sys.stderr)
MEDIUM	nix/tools/gen_rsa_materials.py	47	print(f"Error writing to {args.private_key_path}:{e}", file=sys.stderr)
LOW	test/io/util.py	17	except Exception as e:
MEDIUM	test/io/util.py	14	def run(self):
LOW	test/io/test_io.py	217	except Exception as exc:

Decorative Section Separators1 hit · 3 pts

Severity	File	Line	Snippet
MEDIUM	.stylish-haskell.yaml	2	# ==================================

Self-Referential Comments1 hit · 3 pts

Severity	File	Line	Snippet
MEDIUM	docs/conf.py	6	# This file is execfile()d with the current directory set to its

Deep Nesting3 hits · 2 pts

Severity	File	Line
LOW	test/io/test_io.py	858
LOW	test/io/test_io.py	921
LOW	test/io/postgrest.py	92

Fake / Example Data2 hits · 2 pts

Severity	File	Line	Snippet
LOW	test/load/put.json	3	"name": "John Doe",
LOW	test/load/fixtures.sql	14	INSERT INTO test.actors VALUES (1, 'John Doe');

Score History

Severity Breakdown

Pattern Findings