Merge two magnetico databases - Forked from https://framagit.org/Glandos/magnetico_merge
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
Jeremy Kescher 4682413aef
Merge remote-tracking branch 'origin/kescher/fix-typo'
3 months ago
LICENSE Add LICENSE 2 years ago
README.md Support merging from postgresql into sqlite 3 months ago
magnetico_merge.py Fix typo in magnetico_merge.py 3 months ago
requirements-pg.txt use pgcopy 4 months ago
requirements.txt add requirements 2 years ago

README.md

Merge magnetico databases

Very simple script to merge databases created by magnetico >=0.8

It supports merging SQLite database into SQLite or PostgreSQL, or merging PostgreSQL into SQLite.

Usage: magnetico_merge.py [OPTIONS] MAIN_DB MERGED_DB

Options:
  --fast  Try to go faster, by deleting indices and constraints while
          importing. PostgreSQL only. This can be really slower if your
          databases overlapped a lot.

  --help  Show this message and exit.

The MERGED_DB will be merged into MAIN_DB.

It requires python >= 3.6 and click

If you need to import into or load from PostgreSQL, you need to have psycopg2. Having pgcopy is faster when a lot of rows are in the files table.

Have fun.