cl-mgr is a migration system like Ruby on Rails.γIt is easy to alter your database.
Bases on cl-dbi
;; connect your database
(mgr:connect-db :driver "mysql" :name "database-name" :username "username" :password "password")
;; create migration file.
(mgr:create "create_users")
;; execute migration file
(mgr:migrate! "full migration-file path")
;; if you want to rollback
(mgr:rollback! "full migration-file path")
ex) create users migration file
(in-package :cl-user)
(defpackage :3770156273_create_users
(:use :cl
:mgr))
(in-package :3770156273_create_users)
(defup
(create-table "users")
(add-column :table "users" :column-name "name" :datatype "varchar(255)")
)
(defdown
(drop-table "users")
)
(asdf:load-system :mgr)
- Masayuki Suzuki ([email protected])
Copyright (c) 2019 Masayuki Suzuki ([email protected])
Licensed under the MIT License.