deploydbΒΆ
Deploy your database objects automatically when the git branch is updated.
Production-ready! βοΈ
Easy-to-use π¨
Customizable π§
InstallationΒΆ
Install the latest package. pip install deploydb
UsageΒΆ
1- Create configuration file ( json file or ``dict`` )
Property |
Description |
---|---|
|
where the local repository will be located |
|
address to be listen |
|
branch to handle changes |
|
a list of server credentials |
Example: config.json
{
"local_path": "",
"https_url": "",
"ssh_url": "",
"target_branch": "main",
"db_creds": {
"driver": "ODBC Driver 17 for SQL Server",
"server": "server-address-or-instance-name",
"user": "your-username",
"passw": "your-password"
}
}
2- Listener will listen every changes with sync
method.
from deploydb import Listener
deploy = Listener('config.json')
deploy.sync(loop=True)
Repo GeneratorΒΆ
If you does not have any existing repository. You can easily export your database objects then create your repository.
from deploydb import RepoGenerator
scripter = RepoGenerator(
config="config.json",
export_path="path-to-export",
includes=[], # Default takes all databases from the given credential if not specified.
excludes=[]
)
scripter.run()
RepoGenerator
will extract objects structure as below.
.
βββ Databases
β βββ Your-Db-Name
β β βββ DDLs
β β βββ DMLs
β β βββ Functions
β β βββ Stored-Procedures
β β βββ Tables
β β βββ Triggers
β β βββ Types
β β βββ Views
β βββ Database-N
βββ README.md
TODOΒΆ
Creating Services for Continuous Integration
Windows Service
Linux Systemd Service
Getting Notifications
Microsoft Teams Webhook Integration
Slack Webhook Integration