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 |
|---|---|
local_path |
where the local repository will be located |
https_url or ssh_url |
address to be listen |
target_branch |
branch to handle changes |
servers |
a list of server credentials |
Example: config.json
{
"local_path": "",
"https_url": "",
"ssh_url": "",
"target_branch": "",
"servers": [
{
"driver": "ODBC Driver 17 for SQL Server",
"server": "server-address-or-instance-name",
"server_alias": "Staging",
"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
generator = RepoGenerator(config="config.json", export_path="path-to-export")
generator.run()
RepoGenerator will extract objects structure as below.
path-to-export
│
└───Server-X
│ └───DB-X
│ │ └───Tables
│ │ └───Views
│ │ └───Functions
│ │ └───Stored-Procedures
│ │ └───Triggers
│ │ └───Types
│ │ └───DMLs
│ │ └───DDLs
| |
│ N-Database
N-Server
(TODO) Creating a Windows Service
271 Dec 30, 2022
3 Nov 4, 2022
5 Dec 29, 2022
19 Dec 15, 2022
95 Jan 5, 2023
47 Dec 7, 2022
12 Jan 1, 2023
4 Apr 4, 2022
![halcyon[nouveau]](https://avatars.githubusercontent.com/u/49960726?v=4&s=40)
15 Dec 29, 2022
2 Nov 7, 2022
7 Aug 21, 2022
4.2k Jan 2, 2023
171 Dec 18, 2022
8 Dec 12, 2022
2.3k Jan 6, 2023
6.9k Jan 7, 2023
0 Jul 6, 2022
207 Dec 30, 2022