SQLAlchemy 2.0 中文文档与参考指南 - Python ORM 数据库工具完整技能

sqlalchemy by bankkroll/skills-builder

1 周安装量

1 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/bankkroll/skills-builder --skill sqlalchemy

Python Web框架数据库技术文档

🇨🇳中文介绍

Sqlalchemy

官方文档：https://docs.sqlalchemy.org/en/20/

概述

此技能提供 sqlalchemy 的完整文档。

总引用文件数： 117 个文件（约 1,424,225 个词元）

涵盖主题： 080b2、代理到基于字典的集合、后端特定的 UPPERCASE 数据类型、对 psycopg 3（又名 psycopg）的方言支持、1110、标记隐式生成的值时间戳和触发列、行为变更（向后不兼容）、自定义版本计数器类型、标量关系、覆盖反射列、select SQL 表达式构造、类型系统变更...

参考文件

仅加载与用户问题相关的参考文件：

_Modules

SQLAlchemy 2.0 文档及更多（约 7,719 个词元）
SQLAlchemy 2.0 文档及更多（约 7,528 个词元）
SQLAlchemy 2.0 文档及更多（约 7,546 个词元）
SQLAlchemy 2.0 文档及更多（约 7,980 个词元）
SQLAlchemy 2.0 文档及更多（约 3,328 个词元）

变更日志

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

Sqlalchemy

Official documentation: https://docs.sqlalchemy.org/en/20/

Overview

This skill provides comprehensive documentation for sqlalchemy.

Total references: 117 files (~1,424,225 tokens)

Topics covered: 080b2, Proxying to Dictionary Based Collections, Backend-specific UPPERCASE datatypes, Dialect support for psycopg 3 aka psycopg, 1110, Marking Implicitly Generated Values timestamps and Triggered Columns, Behavioral Changes Backwards Incompatible, Custom Version Counters Types, Scalar Relationships, Overriding Reflected Columns, The select SQL Expression Construct, Type System Changes...

Reference Files

Load only the reference files relevant to the user's question:

_Modules

SQLAlchemy 2.0 Documentation and more (~7,719 tokens)
SQLAlchemy 2.0 Documentation and more (~7,528 tokens)
SQLAlchemy 2.0 Documentation and more (~7,546 tokens)
SQLAlchemy 2.0 Documentation and more (~7,980 tokens)
SQLAlchemy 2.0 Documentation and more (~3,328 tokens)

Changelog

SQLAlchemy 2.0 Documentation and more (~7,828 tokens)
- Topics: 017, 016, 015
SQLAlchemy 2.0 Documentation (~11,321 tokens)
- Topics: 0311, 0310, 039
SQLAlchemy 2.0 Documentation (~17,582 tokens)
- Topics: 048, 047p1, 047
SQLAlchemy 2.0 Documentation (~15,424 tokens)
- Topics: 059, 058, 057
SQLAlchemy 2.0 Documentation (~25,207 tokens)
- Topics: 069, 068, 067
SQLAlchemy 2.0 Documentation (~20,140 tokens)
- Topics: 0711, 0710, 079
SQLAlchemy 2.0 Documentation (~19,892 tokens)

Core

SQLAlchemy 2.0 Documentation and more (~2,837 tokens)
- Topics: Synopsis, Dialect-specific compilation rules, Compiling sub-elements of a custom expression construct
SQLAlchemy 2.0 Documentation (~44,025 tokens)
- Topics: Basic Usage, Using Transactions, Setting Transaction Isolation Levels including DBAPI Autocommit
SQLAlchemy 2.0 Documentation (~15,926 tokens)
- Topics: Defining Foreign Keys, UNIQUE Constraint, CHECK Constraint
SQLAlchemy 2.0 Documentation (~10,435 tokens)
- Topics: Overriding Type Compilation, Augmenting Existing Types, TypeDecorator Recipes
SQLAlchemy 2.0 Documentation (~5,159 tokens)
- Topics: Custom DDL, Controlling DDL Sequences, Using the built-in DDLElement Classes
SQLAlchemy 2.0 Documentation (~8,390 tokens)

Dialects

SQLAlchemy 2.0 Documentation (~702 tokens)
- Topics: Included Dialects, External Dialects
SQLAlchemy 2.0 Documentation (~11,761 tokens)
- Topics: DBAPI Support, External Dialects, Auto Increment Behavior IDENTITY Columns
SQLAlchemy 2.0 Documentation (~13,592 tokens)
- Topics: DBAPI Support, Supported Versions and Features, Connection Timeouts and Disconnects
SQLAlchemy 2.0 Documentation (~15,479 tokens)
- Topics: DBAPI Support, Auto Increment Behavior, Transaction Isolation Level Autocommit
SQLAlchemy 2.0 Documentation (~28,713 tokens)
- Topics: DBAPI Support, SequencesSERIALIDENTITY, Server Side Cursors
SQLAlchemy 2.0 Documentation (~11,111 tokens)
- Topics: DBAPI Support, Date and Time Types, SQLite Auto Incrementing Behavior

Faq

SQLAlchemy 2.0 Documentation and more (~5,749 tokens)
- Topics: How do I configure logging, How do I pool database connections Are my connections pooled, How do I pass custom connect arguments to my database API
SQLAlchemy 2.0 Documentation and more (~6,572 tokens)
- Topics: How do I map a table that has no primary key, How do I configure a Column that is a Python reserved word or similar, How do I get a list of all columns relationships mapped attributes etc given a mapped class
SQLAlchemy 2.0 Documentation (~4,680 tokens)
- Topics: Im re-loading data with my Session but it isnt seeing changes that I committed elsewhere, This Sessions transaction has been rolled back due to a previous exception during flush or similar, How do I make a Query that always adds a certain filter to every query
SQLAlchemy 2.0 Documentation and more (~3,829 tokens)
- Topics: How do I render SQL expressions as strings possibly with bound parameters inlined, Why are percent signs being doubled up when stringifying SQL statements, Im using op to generate a custom operator and my parenthesis are not coming out correctly

General

SQLAlchemy 2.0 Documentation (~863 tokens)
- Topics: Indices and tables
SQLAlchemy 2.0 Documentation (~14,066 tokens)
- Topics: Connections and Transactions, DBAPI Errors, SQL Expression Language
SQLAlchemy 2.0 Documentation (~10,496 tokens)
SQLAlchemy 2.0 Documentation and more (~2,817 tokens)
- Topics: Documentation Overview, Code Examples, Installation Guide

Orm

SQLAlchemy 2.0 Documentation and more (~7,668 tokens)
- Topics: Backref Default Arguments, Specifying Backref Arguments, Declarative vs Imperative Forms
SQLAlchemy 2.0 Documentation (~5,634 tokens)
- Topics: save-update, delete, delete-orphan
SQLAlchemy 2.0 Documentation (~8,162 tokens)
- Topics: Customizing Collection Access, Custom Collection Implementations, Collection API
SQLAlchemy 2.0 Documentation (~3,113 tokens)
- Topics: Working with Mapped Composite Column Types, Other mapping forms for composites, Using Legacy Non-Dataclasses
SQLAlchemy 2.0 Documentation (~11,905 tokens)
- Topics: Implicit Method Access, Thread-Local Scope, Using Thread-Local Scope with Web Applications
SQLAlchemy 2.0 Documentation and more (~7,995 tokens)

Tutorial

SQLAlchemy 2.0 Documentation and more (~2,675 tokens)
- Topics: The insert SQL Expression Construct, Executing the Statement, INSERT usually generates the values clause automatically
SQLAlchemy 2.0 Documentation (~12,148 tokens)
- Topics: The select SQL Expression Construct, Setting the COLUMNS and FROM clause, The WHERE clause
SQLAlchemy 2.0 Documentation and more (~7,582 tokens)
- Topics: The update SQL Expression Construct, The delete SQL Expression Construct, Getting Affected Row Count from UPDATE DELETE
SQLAlchemy 2.0 Documentation (~5,051 tokens)
- Topics: Setting up MetaData with Table objects, Using ORM Declarative Forms to Define Table Metadata, Table Reflection
SQLAlchemy 2.0 Documentation (~4,325 tokens)
- Topics: Inserting Rows using the ORM Unit of Work pattern, Updating ORM Objects using the Unit of Work pattern, Deleting ORM Objects using the Unit of Work pattern
SQLAlchemy 2.0 Documentation (~4,878 tokens)

Usage Guidelines

Identify relevant sections - Match the user's question to the appropriate reference file(s)
Load minimally - Only read files directly relevant to the question to conserve context
Cite sources - Reference specific sections when answering
Combine knowledge - For complex questions, you may need multiple reference files

When to use each reference:

_Modules : _Modules-related features and documentation
Changelog : Changelog-related features and documentation
Core : Core-related features and documentation
Dialects : Dialects-related features and documentation
Faq : Faq-related features and documentation
General : General documentation, overview, and getting started
Orm : Orm-related features and documentation
Tutorial : Tutorial-related features and documentation

Weekly Installs

Repository

bankkroll/skills-builder

GitHub Stars

First Seen

1 day ago

Security Audits

SocketFail SnykPass

Installed on

zencoder1

amp1

cline1

openclaw1

opencode1

cursor1

Claude技能创建器指南：构建模块化AI技能包，优化工作流与工具集成

5,700 周安装

Topics: 087, 086, 085

SQLAlchemy 2.0 Documentation (~28,199 tokens)

Topics: 0910, 099, 098

SQLAlchemy 2.0 Documentation (~29,711 tokens)

Topics: 1019, 1018, 1017

SQLAlchemy 2.0 Documentation (~16,766 tokens)

Topics: 1118, 1117, 1116

SQLAlchemy 2.0 Documentation (~21,928 tokens)

Topics: 1219, 1218, 1217

SQLAlchemy 2.0 Documentation (~26,369 tokens)

Topics: 1325, 1324, 1323

SQLAlchemy 2.0 Documentation (~62,316 tokens)

Topics: 1455, 1454, 1453

SQLAlchemy 2.0 Documentation (~58,618 tokens)

Topics: 2047, 2046, 2045

SQLAlchemy 2.0 Documentation and more (~4,111 tokens)

Topics: Current Migration Guide, Change logs, Older Migration Guides

SQLAlchemy 2.0 Documentation (~4,186 tokens)

Topics: Major Documentation Changes, Deprecations Source, Requirements Changes

SQLAlchemy 2.0 Documentation (~7,710 tokens)

Topics: Platform Support, New Dialect System, Expression Language Changes

SQLAlchemy 2.0 Documentation (~8,149 tokens)

Topics: Introduction, New Features, Behavioral Changes Backwards Compatible

SQLAlchemy 2.0 Documentation (~7,818 tokens)

Topics: Introduction, Platform Support, New ORM Features

SQLAlchemy 2.0 Documentation (~11,385 tokens)

Topics: Introduction, Platform Support, Behavioral Changes - ORM

SQLAlchemy 2.0 Documentation (~16,373 tokens)

Topics: Introduction, New Features and Improvements - ORM, New Features and Improvements - Core

SQLAlchemy 2.0 Documentation (~18,629 tokens)

Topics: Introduction, Platform Installer Changes, New Features and Improvements - ORM

SQLAlchemy 2.0 Documentation (~10,644 tokens)

Topics: Introduction, Platform Support, New Features and Improvements - ORM

SQLAlchemy 2.0 Documentation (~11,516 tokens)

Topics: Introduction, General, New Features and Improvements - ORM

SQLAlchemy 2.0 Documentation (~24,601 tokens)

Topics: Major API changes and features - General, API and Behavioral Changes - Core, New Features - ORM

SQLAlchemy 2.0 Documentation (~14,986 tokens)

Topics: The 14-20 Migration Path, 1x - 2x Migration Overview, 20 Migration - Core Connection Transaction

SQLAlchemy 2.0 Documentation (~14,599 tokens)

Topics: New Typing Support in Core and ORM - Stubs Extensions no longer used, Optimized ORM bulk insert now implemented for all backends other than MySQL, ORM-enabled Insert Upsert Update and Delete Statements with ORM RETURNING

Topics: Scalar Defaults, Python-Executed Functions, Client-Invoked SQL Expressions

SQLAlchemy 2.0 Documentation (~8,492 tokens)

Topics: DML Foundational Constructors, DML Class Documentation Constructors

SQLAlchemy 2.0 Documentation (~10,299 tokens)

Topics: Supported Databases, Database URLs, Engine Creation API

SQLAlchemy 2.0 Documentation and more (~3,016 tokens)

Topics: Event Registration, Named Argument Styles, Targets

SQLAlchemy 2.0 Documentation (~11,178 tokens)

Topics: Connection Pool Events, SQL Execution and Connection Events, Schema Events

SQLAlchemy 2.0 Documentation and more (~6,173 tokens)

Topics: Function API, Selected Known Functions, Available Inspection Targets

SQLAlchemy 2.0 Documentation (~33,902 tokens)

SQLAlchemy 2.0 Documentation (~26,566 tokens)

Topics: Accessing Tables and Columns, Creating and Dropping Database Tables, Altering Database Objects through Migrations

SQLAlchemy 2.0 Documentation (~3,129 tokens)

Topics: Comparison Operators, IN Comparisons, Identity Comparisons

SQLAlchemy 2.0 Documentation (~11,250 tokens)

Topics: Connection Pool Configuration, Switching Pool Implementations, Using a Custom Connection Function

SQLAlchemy 2.0 Documentation (~11,385 tokens)

Topics: Overriding Reflected Columns, Reflecting Views, Reflecting All Tables at Once

SQLAlchemy 2.0 Documentation (~49,969 tokens)

Topics: Selectable Foundational Constructors, Selectable Modifier Constructors, Selectable Class Documentation

SQLAlchemy 2.0 Documentation (~37,293 tokens)

Topics: Column Element Foundational Constructors, Column Element Modifier Constructors, Column Element Class Documentation

SQLAlchemy 2.0 Documentation (~24,572 tokens)

Topics: The CamelCase datatypes, The UPPERCASE datatypes, Backend-specific UPPERCASE datatypes

Topics: Declarative Dataclass Mapping, Applying ORM Mappings to an existing dataclass legacy dataclass use, Applying ORM mappings to an existing attrs class

SQLAlchemy 2.0 Documentation and more (~6,138 tokens)

Topics: Augmenting the Base, Mixing in Columns, Mixing in Relationships

SQLAlchemy 2.0 Documentation (~12,335 tokens)

Topics: Declarative Table withmapped_column, ORM Annotated Declarative - Complete Guide, Declarative with Imperative Table aka Hybrid Declarative

SQLAlchemy 2.0 Documentation (~18,903 tokens)

Topics: Session Events, Mapper Events, Instance Events

SQLAlchemy 2.0 Documentation and more (~5,228 tokens)

Topics: Mapping Recipes, Inheritance Mapping Recipes, Special APIs

SQLAlchemy 2.0 Documentation (~29,911 tokens)

Topics: Simplifying Scalar Collections, Simplifying Association Objects, Proxying to Dictionary Based Collections

SQLAlchemy 2.0 Documentation (~24,793 tokens)

Topics: Asyncio Platform Installation Notes Including Apple M1, Synopsis - Core, Synopsis - ORM

SQLAlchemy 2.0 Documentation (~5,889 tokens)

Topics: Basic Use, Generating Mappings from an Existing MetaData, Generating Mappings from Multiple Schemas

SQLAlchemy 2.0 Documentation and more (~7,992 tokens)

Topics: Synopsis, Performance, Rationale

SQLAlchemy 2.0 Documentation and more (~7,542 tokens)

Topics: Defining Expression Behavior Distinct from Attribute Behavior, Usinginplaceto create pep-484 compliant hybrid properties, Defining Setters

SQLAlchemy 2.0 Documentation and more (~5,933 tokens)

Topics: API Reference, Establishing Mutability on Scalar Column Values, Establishing Mutability on Composites

SQLAlchemy 2.0 Documentation and more (~5,951 tokens)

Topics: Installation, What the Plugin Does, Usage

SQLAlchemy 2.0 Documentation (~7,242 tokens)

Topics: Joined Table Inheritance, Single Table Inheritance, Concrete Table Inheritance

SQLAlchemy 2.0 Documentation (~19,596 tokens)

SQLAlchemy 2.0 Documentation (~7,737 tokens)

Topics: Handling Multiple Join Paths, Specifying Alternate Join Conditions, Creating Custom Foreign Conditions

SQLAlchemy 2.0 Documentation (~6,719 tokens)

Topics: Write Only Relationships, Dynamic Relationship Loaders, Setting RaiseLoad

SQLAlchemy 2.0 Documentation and more (~6,242 tokens)

Topics: Simple Validators, Using Custom Datatypes at the Core Level, Using Descriptors and Hybrids

SQLAlchemy 2.0 Documentation (~17,654 tokens)

SQLAlchemy 2.0 Documentation and more (~5,892 tokens)

Topics: ORM Mapping Styles, Mapped Class Essential Components, Mapped Class Behavior

SQLAlchemy 2.0 Documentation (~5,933 tokens)

Topics: Embedding SQL InsertUpdate Expressions into a Flush, Using SQL Expressions with Sessions, Forcing NULL on a column with a default

SQLAlchemy 2.0 Documentation (~7,221 tokens)

Topics: ORM Loader Options, ORM Execution Options

SQLAlchemy 2.0 Documentation (~6,717 tokens)

Topics: Limiting which Columns Load with Column Deferral, Configuring Column Deferral on Mappings, Loading Arbitrary SQL Expressions onto Objects

SQLAlchemy 2.0 Documentation (~8,349 tokens)

Topics: ORM Bulk INSERT Statements, ORM Bulk UPDATE by Primary Key, ORM UPDATE and DELETE with Custom WHERE Criteria

SQLAlchemy 2.0 Documentation (~1,066 tokens)

SQLAlchemy 2.0 Documentation (~7,126 tokens)

Topics: SELECTing from the base class vs specific sub-classes, Using selectin_polymorphic, Using with_polymorphic

SQLAlchemy 2.0 Documentation (~11,610 tokens)

Topics: The Query Object, ORM-Specific Query Constructs

SQLAlchemy 2.0 Documentation (~11,703 tokens)

Topics: Summary of Relationship Loading Styles, Configuring Loader Strategies at Mapping Time, Relationship Loading with Loader Options

SQLAlchemy 2.0 Documentation (~6,977 tokens)

Topics: Selecting ORM Entities and Attributes, Joins, Relationship WHERE Operators

SQLAlchemy 2.0 Documentation (~3,071 tokens)

Topics: Declare Models, Create an Engine, Emit CREATE TABLE DDL

SQLAlchemy 2.0 Documentation (~6,171 tokens)

SQLAlchemy 2.0 Documentation and more (~4,852 tokens)

Topics: Rows that point to themselves Mutually Dependent Rows, Mutable Primary Keys Update Cascades, Composite Adjacency Lists

SQLAlchemy 2.0 Documentation (~16,599 tokens)

Topics: Session and sessionmaker, Session Utilities, Attribute and State Management Utilities

SQLAlchemy 2.0 Documentation (~8,052 tokens)

Topics: What does the Session do, Basics of Using a Session, Session Frequently Asked Questions

SQLAlchemy 2.0 Documentation (~4,703 tokens)

Topics: Execute Events, Persistence Events, Object Lifecycle Events

SQLAlchemy 2.0 Documentation (~4,843 tokens)

Topics: Quickie Intro to Object States, Session Attributes, Session Referencing Behavior

SQLAlchemy 2.0 Documentation and more (~6,090 tokens)

Topics: Managing Transactions, Joining a Session into an External Transaction such as for test suites, Simple Version Counting

Topics: Persisting and Loading Relationships, Loading Relationships, Using Relationships in Queries

SQLAlchemy 2.0 中文文档与参考指南 - Python ORM 数据库工具完整技能

🇨🇳中文介绍

Sqlalchemy

概述

参考文件

_Modules

变更日志

相关 Skills

Core

方言

常见问题

通用

Orm

🇺🇸English

Sqlalchemy

Overview

Reference Files

_Modules

Changelog

Core

Dialects

Faq

General

Orm

Tutorial

Usage Guidelines

When to use each reference:

最新 Skills