This library makes your software to dump and load data in databases with sqlalchemy.
This project has been archived.
The maintainers of this project have marked this project as archived. No new releases are expected.
Project description
sqlalchemy-loadump
This library makes your software to dump and load data in databases with sqlalchemy.
Dependencies
- Python 3.8+
- SQLAlchemy 2.0+
Installation
!!!!! Needs poetry !!!!!
It will install the library from github.
poetry add git+ssh://git@github.com:wintermaples/sqlalchemy-loadump.git
Usage
Commandline
Dump
This command dumps data in the postgresql database to the json file.
You need installing the database adapter before using this command. In below example, you need installing psycopg2.
python -m sqlalchemy_loadump dump \
--dump-file-type=json \
--dump-file-path=dump.json \
--db-url=postgresql+psycopg2://user:password@host:port/database
Load
This command loads data from the json file and inserts it into the postgresql database.
You need installing the database adapter before using this command. In below example, you need installing psycopg2.
python -m sqlalchemy_loadump load \
--dump-file-type=json \
--dump-file-path=dump.json \
--db-url=postgresql+psycopg2://user:password@host:port/database
Supported Dump Formats
- JSON
Supported Databases
- PostgreSQL
- Microsoft SQLServer
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqlalchemy_loadump-0.1.0.tar.gz.
File metadata
- Download URL: sqlalchemy_loadump-0.1.0.tar.gz
- Upload date:
- Size: 9.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.5.1 CPython/3.7.9 Windows/10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
74c29eedfd092a46332a890a87e471497418d5b4684de79fde15ab780f77a610
|
|
| MD5 |
37076d9df78b71bb6e82461273e32adf
|
|
| BLAKE2b-256 |
8f4f648417e3903c39d9684bdb1a1f995baf12245763f45c9d0b454d6eb50054
|
File details
Details for the file sqlalchemy_loadump-0.1.0-py3-none-any.whl.
File metadata
- Download URL: sqlalchemy_loadump-0.1.0-py3-none-any.whl
- Upload date:
- Size: 12.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.5.1 CPython/3.7.9 Windows/10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
36092d47919e186a51178f9dfc437cb0f1165b5df405a8341cdde452576bdab0
|
|
| MD5 |
bfd8b76f2e26f054bc1e752f9316e8f6
|
|
| BLAKE2b-256 |
5ea1f02724b422460a97d8a7b22424a48ca1867d112c04f730378d4974c60faa
|
