Skip to main content

SQLAlachemy migration maker.Generate SQL command to auto migrate

Project description

SQLAlchemy Migration Maker

SQLalchemy 是個 Python 的 Database Library,可以與 Postgres、MySQL 與其他 Database 連結,但是卻缺少了更新 Database 的功能。
受到 Django Database 的啟發,我寫了這套件使更新更輕鬆,把 Database 結構化成特別的 Id,並存到資料庫,透過比較結構來決定需要下哪些 SQL 指令。
此套件需要自行設定

SQLalchemy is a python library that deal with database. Can be used to connect with Postgres, MySQL, etc. But it lack of builtin migrate functionality.
Inspire by django db manager, I write this package to migrate db more easily.
It turn Database structure into special id then store in database.
When there's new version structure, it compares two version then decide what SQL command need to be executed.
This package need to setup yourself

Intall

pip install sqlalchemy-migration-maker

Requiremnt

  • sqlalchemy

Testing

Require psycopg2

In my testing, I use postgres database to execute sql language

Tested Envirment

  • MacOSX
  • Python3

Tested Database

  • Postgres

Example

model.py

from sqlalchemy import Column
from sqlalchemy.types import Integer
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()


class User(Base):
    __tablename__ = "user"

    id = Column(Integer, primary_key=True, autoincrement=True)

    def __repr__(self):
        return f"<User {self.id} {self.create_at}>"

migrate.py

from .model import Base
from migrationmaker import VersionControl

version_ctl = VersionCtrol("{DB_URI}")

# 檢查版本控制是否存在於 DB
# Check version ctrl exist in DB
version_ctl.check_version_ctl_exist()

# 取回舊版本
# Retrieve old version
self.version_ctl.get_latest_version(is_old_metadata=True)

# 指定新版本
# Assign new version
self.version_ctl.new_version(Base.metadata)

if not self.version_ctl.check_same():
    self.version_ctl.migrate()

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy-migration-maker-0.4.tar.gz (7.4 kB view hashes)

Uploaded Source

Built Distribution

sqlalchemy_migration_maker-0.4-py3-none-any.whl (9.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page