JSC2F: JSON SQL Cell to File
This module contains functions to save a JSON cell from a MySQL or Mariadb database to a file in a nice and easy to use format. It can also upload JSON files back to the database.
Installation
JSC2FF can be installed by cloning the github repo or from PyPi.
pip install jsc2fCLI Usage Example
-
downloadwill save the JSON string from the SQL cell to a nicely formatted file for editing. -
uploadwill update the cell with the JSON file -
--whereis used as a selector:--where "id == 3"
# Download a cell to a file
jsc2f download \
--db-ip $database_ip \
--db-name $database_name \
--db-password $database_password \
--db-user $database_user \
--filename $file_path \
--table $table_name \
-column $column_name
# Upload a file to a cell
jsc2f upload \
--db-ip $database_ip \
--db-name $database_name \
--db-password $database_password \
--db-user $database_user \
--filename $file_path \
--table $table_name \
-column $column_name# jsc2f --help
Usage: jsc2f [OPTIONS]
Upload/Download JSON SQL Cell from/to a local file
Options:
--where TEXT
--table TEXT [required]
--column TEXT [required]
--db-name TEXT [required]
--db-password TEXT [required]
--db-user TEXT [required]
--db-port INTEGER
--db-ip TEXT [required]
--filename TEXT [required]
--upload / --download Upload or download [required]
--help Show this message and exit.Python Module Usage Example
import jsc2f.lib as jsc2f
# Get data from SQL cell and write it to JSON file
jsc2f.save_to_file(filename=filename, host=db_ip, user=db_user,
password=db_password, database=db_name, column=column,
table=table, where=where, port=db_port)
# Get JSON from file and write it to SQL cell
jsc2f.update_from_file(filename=filename, host=db_ip, user=db_user,
password=db_password, database=db_name,
column=column, table=table, where=where,
port=db_port)
