SQL (Effect's effect/sql): statements built from string literals
with bound parameters, a client with transactions, batched resolvers,
schema-typed queries, migrations, and a SQLite driver on sqlite3. The
PostgreSQL driver, pyfect.sql.pg on psycopg 3, is the pyfect-dev[pg]
extra and is not imported here, as are mysql, mssql, libsql
(libSQL and Turso), clickhouse and d1 (Cloudflare D1).
statement: fragments, helpers and compilersclient:SqlClientandmakefor driversconnection: what a driver implementserror:SqlErrorand its reasonsresolver: batched requests (SqlResolver)schema: queries typed by schemas (SqlSchema)stream: streams from drivers that push rows (SqlStream)migrator: migrationsmodel: repositories ofpyfect.schema.modelclasses (SqlModel)sqlite: the SQLite client (pyfect.sql.sqlite.migratorruns its migrations)
Re-exports#
- From
pyfect.sql.client:BeginTransaction,SafeIntegers,SqlClient,SqlClientService - From
pyfect.sql.connection:Connection,Row - From
pyfect.sql.error:SqlError - From
pyfect.sql.migrator:MigrationError - From
pyfect.sql.resolver:SqlRequest - From
pyfect.sql.statement:Fragment,Statement