#!/bin/sh
#################
# ZeroC0D3 Team # 
#################

### STEP ###
# 1) Download binary file "sqlite3" from
#    https://www.sqlite.org/
# 2) Extract binary "sqlite3" to your PATH_BIN
# 3) Set your file name in PATH_TARGET_DUMP for all schema & data
# 4) Set your file name in PATH_TARGET_SCHEMA for only schema
# 5) Set your file name in PATH_TARGET_CSV for only csv format
# 6) Run this script in terminal: sh export_sqlite.sh 

PATH_BIN="/home/user/project/bin/";

PATH_SOURCE=$PATH_BIN"db/sample.sqlite3";
PATH_TARGET_DUMP=$PATH_BIN"dump/export_all.db";
PATH_TARGET_SCHEMA=$PATH_BIN"dump/export_schema.db";
PATH_TARGET_CSV=$PATH_BIN"dump/export_csv.csv";

##### DUMP ALL SCHEMA & DATA #####
sqlite3 $PATH_SOURCE .dump > $PATH_TARGET_DUMP;
echo "Done... Export all to: " $PATH_TARGET_DUMP;

#### DUMP SCHEMA (ONLY) #####
sqlite3 $PATH_SOURCE .schema > $PATH_TARGET_SCHEMA;
echo "Done... Export schema (only) to: " $PATH_TARGET_SCHEMA;

#### DUMP TO CSV FILE #####
QUERY="SELECT * FROM table";
# with header 
# sqlite3 -csv -header $PATH_SOURCE $QUERY > $PATH_TARGET_CSV;
# without header
sqlite3 -csv $PATH_SOURCE $QUERY > $PATH_TARGET_CSV;
echo "Done... Export csv file to: " $PATH_TARGET_CSV;

echo "All Done !";