#!/usr/bin/env bash

INPUT_DIR="../split_sqlite"
OUTPUT_DIR="../csv"

mkdir -p $OUTPUT_DIR

for file in $INPUT_DIR/*
do
  fname=$(basename $file)
  fname="${fname%.*}"
  echo $fname
  sqlite3 -header -csv $file "select * from $fname;" > $OUTPUT_DIR"/"$fname.csv
done