Sqlalchemy 简明教程

SQLAlchemy Tutorial

SQLAlchemy 是一款流行的 SQL 工具包和 Object Relational Mapper 。它使用 Python 编写，为应用程序开发人员提供了 SQL 的全部功能和灵活性。它是一个在 MIT 许可下发布的 open source 和 cross-platform software 。SQLAlchemy 因其对象关系映射器 (ORM) 而闻名，使用该映射器可将类映射到数据库中，从而允许对象模型和数据库架构最初から以一种明确解耦的方式进行开发。

SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using which classes can be mapped to the database, thereby allowing the object model and database schema to develop in a cleanly decoupled way from the beginning.

Audience

本教程专为所有希望使用 SQLAlchemy 及其 API 了解 ORM 框架的 Python 程序员而设计。

This tutorial is designed for all those Python programmers who would like to understand the ORM framework with SQLAlchemy and its API.

Prerequisites

在继续本教程之前，我们假设您对 Python 编程语言有很好的理解。要理解本教程，还需要对关系数据库、DB-API 和 SQL 有基本的了解。

Before you start proceeding with this tutorial, we assume you have a good understanding of the Python programming language. A basic understanding of relational databases, DB-API, and SQL is desired to understand this tutorial.