Link Database Tools
Package provides tools to manipulate awesome databases.
Provides awesome database specification
Example of awesome databases:
- https://github.com/rumca-js/Internet-Places-Database
- https://github.com/rumca-js/awesome-database-feeds
- https://github.com/rumca-js/awesome-database-top
Tools
- DbAnalyzer - provides analysis of the DB contents
- DbUpdate - modifies database. Can create missing tables, truncate tables.
- Db2Feeds - converts database to DB of feeds
- Db2JSON - converts database to JSON
- JSON2Db - Converts JSON into datbase
- DbMerge - Merges a database with other databse
- backup.py - create backup of Postgres tables
DbAnalyzer
usage: dbanalyzer.py [-h] [--db DB] [--search SEARCH] [--order-by ORDER_BY] [--asc] [--desc]
[--table TABLE] [--title] [--votes] [--description] [--status] [--tags]
[--social] [--date-published] [--source] [--summary] [--columns] [--rss]
[--channel] [--json] [-i] [-v VERBOSITY]
Data analyzer program
options:
-h, --help show this help message and exit
--db DB DB to be scanned
--search SEARCH Search, with syntax same as the main program / site.
--order-by ORDER_BY order by column.
--asc order ascending
--desc order descending
--table TABLE Table name
--title displays title
--votes displays votes
--description displays description
--status displays status
--tags displays tags
--social displays social data
--date-published displays date-published
--source displays source
--summary displays summary of tables
--columns displays summary of tables column names
--rss displays RSS sources
--channel displays channels
--json JSON format
-i, --ignore-case Ignores case
-v VERBOSITY, --verbosity VERBOSITY
Verbosity level
DbUpdate
usage: dbupdate.py [-h] [--db DB] [--create-tables] [--truncate-tables TRUNCATE_TABLES]
[--trunc-dynamic-data] [--trunc-configuration] [--trunc-search-data]
[--trunc-visits-data] [--delete-non-bookmarked] [--delete-no-votes]
[--delete-redundant] [--no-users] [--obfuscate] [-v VERBOSITY]
DB manipulation program
options:
-h, --help show this help message and exit
--db DB DB to be filtered
--create-tables Creates tables. Even missing ones
--truncate-tables TRUNCATE_TABLES
Truncate table(s). Pass table names
--trunc-dynamic-data Truncates dynamic tables
--trunc-configuration
Removes uneceesary configuration
--trunc-search-data Removes all search data
--trunc-visits-data Removes all visit data
--delete-non-bookmarked
Removes non bookmarked
--delete-no-votes Removes entries without a vote
--delete-redundant Removes entries that are redundant - not bookmarked, no votes
--no-users Prepares for setup with no users
--obfuscate Obfuscates private data
-v VERBOSITY, --verbosity VERBOSITY
Verbosity level
Db2Feeds
usage: db2feeds.py [-h] [--db DB] [--output-db OUTPUT_DB] [--update-rss] [--clean]
[--read-internet-links] [--output-format OUTPUT_FORMAT]
[--crawling-server CRAWLING_SERVER]
Data analyzer program
options:
-h, --help show this help message and exit
--db DB DB to be scanned
--output-db OUTPUT_DB
File to be created
--update-rss Reads RSS to check it's title and properties
--clean If output db exists, then it is removed at start
--read-internet-links
Reads entries to check if contains RSS. Without it only calculated RSS are
returned
--output-format OUTPUT_FORMAT
format of display. LINES, JSON, SQLITE
--crawling-server CRAWLING_SERVER
Remote crawling server
Db2JSON
usage: db2json.py [-h] [--db DB] [--output-dir OUTPUT_DIR] [--rows-max] [-f FORMAT] [-v VERBOSITY]
Data analyzer program
options:
-h, --help show this help message and exit
--db DB DB to be scanned
--output-dir OUTPUT_DIR
Output directory
--rows-max Number of rows per file
-f FORMAT, --format FORMAT
file name format
-v VERBOSITY, --verbosity VERBOSITY
Verbosity level
DbMerge
usage: dbmerge.py [-h] [--input-dbs INPUT_DBS] [--output OUTPUT]
Data analyzer program
options:
-h, --help show this help message and exit
--input-dbs INPUT_DBS
DBs to be scanned. Delim ,
--output OUTPUT DB to be produced
JSON2Db
JSON
Utils
Reflected tools - provides access table definitions. Model - model data. Classes that allow you to modify, read tables
Installation
pip install linkarchivetools
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
linkarchivetools-0.1.109.tar.gz
(58.9 kB
view details)
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 linkarchivetools-0.1.109.tar.gz.
File metadata
- Download URL: linkarchivetools-0.1.109.tar.gz
- Upload date:
- Size: 58.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.1.2 CPython/3.11.2 Linux/6.12.87+rpt-rpi-v8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
24c1c4ab68f9cda043ec5302f1f8de48936a3fcae34ee04dacfe6430cb62f407
|
|
| MD5 |
5ef10169521827d4653c81963dcb87b8
|
|
| BLAKE2b-256 |
0d29744127fa5e9961ddc69c4c7d28bc9169f9962194def159d7b8d01eeb1fb4
|
File details
Details for the file linkarchivetools-0.1.109-py3-none-any.whl.
File metadata
- Download URL: linkarchivetools-0.1.109-py3-none-any.whl
- Upload date:
- Size: 72.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.1.2 CPython/3.11.2 Linux/6.12.87+rpt-rpi-v8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
95f1f2ee226c7352339534616b40b38743d953a7e767402c36ab11aa9b772c6b
|
|
| MD5 |
9eff022dd9f41fc6479a74467ffb0c47
|
|
| BLAKE2b-256 |
73546f6fc724256b0caab401ecae3cf3dd802905bf809cddcf3da334069d6545
|