Tool to build postgres databases for development and testing.
Project description
HitchBuildPg
A small, self contained python library for building postgres database locally that, on first run will:
-
Downloads and compiles a specified version of postgres.
-
Builds a database from a series of SQL commands and by restoring a database dump file.
-
Takes a snapshot of the newly built database files by taking a copy of the folder.
On subsequent builds, it will skip the long, expensive steps of downloading, compiling postgres and restoring a database from a .sql file and just overwrite the data files.
import hitchbuildpg
postgres_version = "10.10"
pgapp_dir = "{}/postgres-{}".format(share, postgres_version)
pgapp = hitchbuildpg.PostgresApp(pgapp_dir, postgres_version)
class DataBuild(hitchbuildpg.DataBuild):
def run(self):
self.run_sql_as_root("create user myuser with password 'mypassword';")
self.run_sql_as_root("create database mydb with owner myuser;")
self.load_database_dump(
database="mydb",
username="myuser",
password="mypassword",
filename="dump.sql"
)
pgdata = hitchbuildpg.PostgresDatafiles(
"./myappdata",
pgapp,
DataBuild(),
)
pgdata.ensure_built()
db_service = pgdata.server()
db_service.start()
psql = db_service.psql(
"-U", "myuser", "-p", "15432", "-d", "mydb",
).with_env(PG_PASSWORD="mypassword")
psql("-c", "select name from cities where location = 'GB';").run()
# Prints output of SQL statement
psql("-c", "delete from cities where location = 'GB';").run()
db_service.stop()
Project details
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
hitchbuildpg-0.4.1.tar.gz
(4.7 kB
view details)
File details
Details for the file hitchbuildpg-0.4.1.tar.gz
.
File metadata
- Download URL: hitchbuildpg-0.4.1.tar.gz
- Upload date:
- Size: 4.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.47.0 CPython/3.8.2
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 |
039239aaa51c7303e9dc0245020695f2a7ace341b1bfdf95023d5f525225d309
|
|
MD5 |
60c0245919c1e3a550cd67e97d3ac4c9
|
|
BLAKE2b-256 |
a320063f290b4d84091aae5ede0bdf9aa502bcb299a4e3869422e2cf9f40799a
|