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 jsc2f

CLI Usage Example

• download will save the JSON string from the SQL cell to a nicely formatted file for editing.
• upload will update the cell with the JSON file
• --where is 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)