Differential analysis of sqlite files
Project description
Description
Differential analysis of sqlite files
Detects changes between versions of sqlite files:
- Database Tables
- Table created
- Table deleted
- Table Entry
- Entry created
- Entry modified
- Entry deleted
Installation
pip install sqlitediff
Usage
From command line:
python -m sqlitediff --pathBefore PATHBEFORE --pathAfter PATHAFTER
Option | Short | Type | Default | Description |
---|---|---|---|---|
--pathBefore | -b | String | - | Path to sqlite file before action |
--pathAfter | -a | String | - | Path to sqlite file after action |
Example
python -m sqlitediff -b path/to/before.db -a path/to/after.db
################################################################################
sqlitediff by 5f0
Differential analysis of sqlite files
Current working directory: path/to/sqlitediff
Sqlite file before action:
--> Path: path/to/before.db
--> MD5: d7e88c55c4ec6ed7cd7fa6c6cb8b0b45
--> SHA256: 19722a52443837b2cc7ac77fa806da6f2e1f307707ac8a2fdfe6a5c097758faf
Sqlite file after action:
--> Path: path/to/after.sqlite
--> MD5: 305d12c0b2b49b149a508d9d4cb7d573
--> SHA256: 3073be75fb6b0ace2ffc94332c2c77e1fe12c6f618c840c122112a61ee63585a
Datetime: 01/01/1970 11:12:13
################################################################################
Tables before Action: ['fish', 'people', 'dog']
Tables after Action: ['fish', 'snowman']
Deleted Tables: ['people', 'dog']
Created Tables: ['snowman']
################################################################################
Execution Time: 0.010948 sec
License
MIT
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlitediff-0.1.0.tar.gz
(5.9 kB
view hashes)
Built Distribution
Close
Hashes for sqlitediff-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a6471024479d5963061dae8c560639c61d08bd0c42233a89e346751e674ba56 |
|
MD5 | 3953c87d3e3fecf97307bad15fa6e089 |
|
BLAKE2b-256 | 9d9416f436cb43bf82560e14cbbb7a794f7e3b1b31e4ab83cc2a448eac491a1d |