Python - Revision history

Torben: /* Check host:port is reachable */

2026-07-08T08:18:36Z

Check host:port is reachable

← Older revision		Revision as of 10:18, 8 July 2026
Line 2,951:		Line 2,951:
	import socket		import socket
	def check_port_is_reachable(host: str, port: int = 1433, timeout: int = 5) -> bool:		def check_port_is_reachable(host: str, port: int = 1433, timeout: int = 5) -> bool:
	"""Check if a TCP port ~~is open~~ on a given host."""		"""Check if a TCP port on a given host is reachable."""
	try:		try:
	with socket.create_connection((host, port), timeout=timeout):		with socket.create_connection((host, port), timeout=timeout):

2026-07-08T08:18:11Z

Vulture: Search for dead code

← Older revision		Revision as of 10:18, 8 July 2026
Line 2,947:		Line 2,947:
	uv add --dev vulture		uv add --dev vulture
	uv run vulture src/		uv run vulture src/

			==Check host:port is reachable==
			import socket
			def check_port_is_reachable(host: str, port: int = 1433, timeout: int = 5) -> bool:
			"""Check if a TCP port is open on a given host."""
			try:
			with socket.create_connection((host, port), timeout=timeout):
			return True
			except Exception as e: # noqa: BLE001
			return False

2026-06-22T11:30:43Z

Simple Connect

← Older revision		Revision as of 13:30, 22 June 2026
Line 1,934:		Line 1,934:

	===MSSQL===		===MSSQL===
	====Simple Connect====		====Simple Connect using MS mssql-python====
			https://github.com/microsoft/mssql-python
	from mssql_python import connect		from mssql_python import connect
	conn = connect(		conn = connect(

2026-06-22T11:29:19Z

MSSQL

@@ Line 1,934: / Line 1,934: @@
 ===MSSQL===
 ====NTLM Login====
 mssql-python (ODBC Driver 18) has no native NTLM-with-explicit-creds keyword.

2026-06-22T11:28:05Z

NTLM Login

← Older revision		Revision as of 13:28, 22 June 2026
Line 1,935:		Line 1,935:
	===MSSQL===		===MSSQL===
	====NTLM Login====		====NTLM Login====
			mssql-python (ODBC Driver 18) has no native NTLM-with-explicit-creds keyword.
			We impersonate the target Windows account on the current thread via
			LogonUser (LOGON32_LOGON_NEW_CREDENTIALS) and then open the connection
			with `Trusted_Connection=yes` so SSPI uses the impersonated identity.

	from contextlib import contextmanager		from contextlib import contextmanager
	from typing import TYPE_CHECKING, Any		from typing import TYPE_CHECKING, Any

2026-06-22T11:26:53Z

MSSQL

@@ Line 1,934: / Line 1,934: @@
 ===MSSQL===
+====NTLM Login====
 ==Internet Access==

2026-06-22T11:25:16Z

Internet Access

2026-06-19T02:56:09Z

Secrets/Credentials

← Older revision		Revision as of 04:56, 19 June 2026
Line 696:		Line 696:

	==Secrets/Credentials==		==Secrets/Credentials==
			use python-dotenv instead of dotenv
	uv add (--dev) python-dotenv / pip install python-dotenv		uv add (--dev) python-dotenv / pip install python-dotenv

2026-06-19T02:55:23Z

Secrets/Credentials

← Older revision		Revision as of 04:55, 19 June 2026
Line 696:		Line 696:

	==Secrets/Credentials==		==Secrets/Credentials==
	uv add (--dev) dotenv / pip install dotenv		uv add (--dev) python-dotenv / pip install python-dotenv

	from os import getenv		from os import getenv

2026-06-19T02:43:46Z

File Access

← Older revision		Revision as of 04:43, 19 June 2026
Line 694:		Line 694:
	...		...
	case _: # default case		case _: # default case

			==Secrets/Credentials==
			uv add (--dev) dotenv / pip install dotenv

			from os import getenv
			from pathlib import Path
			from dotenv import load_dotenv
			load_dotenv(Path(".env"))
			DB_PASSWORD = getenv("PASSWORD", "")

	==File Access==		==File Access==