跳转到主要内容

Agnostic数据库迁移

项目描述

Agnostic数据库迁移

PyPI GitHub Workflow Status (with event) Coverage

概述

Agnostic是一个轻量级、易于学习且灵活的数据库迁移工具,其迁移脚本是用纯SQL编写的。它对数据库、编程语言和对象关系映射器(ORM)都是中立的。

超级快速入门

以下是对Agnostic的极简介绍

~/myapp $ mkdir migrations

~/myapp $ agnostic -t postgres -u myuser -d mydb bootstrap
Migration table created.

~/myapp $ cat > migrations/add_cell_phone.sql
ALTER TABLE customer ADD cell_phone VARCHAR(255);
^D

~/myapp $ cat > migrations/add_nickname.sql
ALTER TABLE customer ADD nickname VARCHAR(255);
^D

~/myapp $ agnostic -t postgres -u myuser -d mydb migrate
Backing up "mydb" to "/tmp/tmpm8glpgaa".
About to run 2 migrations in "mydb":
    * Running migration add_cell_phone (1/2)
    * Running migration add_nickname (2/2)
Migrations completed successfully.
Removing backup "/tmp/tmpm8glpgaa".

要快速入门,请参阅完整文档

支持者