| 1 |
#! /bin/bash |
| 2 |
|
| 3 |
set -eu |
| 4 |
|
| 5 |
if [ $# != 1 ] |
| 6 |
then |
| 7 |
echo -e "usage:\nabyss-db-txt SQLite_repository" |
| 8 |
exit 1 |
| 9 |
fi |
| 10 |
|
| 11 |
txt_filename=$1.txt |
| 12 |
rm -f $txt_filename |
| 13 |
|
| 14 |
tableArray=() |
| 15 |
sqlite3 $1 "select name from sqlite_master where type='table' order by rootpage;" > temp |
| 16 |
while read line |
| 17 |
do |
| 18 |
tableArray+=(`echo ${line} | tr " " "\n"`) |
| 19 |
done < temp |
| 20 |
rm -f temp |
| 21 |
|
| 22 |
if [ ${#tableArray[@]} -gt 0 ] |
| 23 |
then |
| 24 |
for table in ${tableArray[@]} |
| 25 |
do |
| 26 |
echo -e "${table}\n" >> $txt_filename |
| 27 |
echo -e ".mode column\n.headers on\n.output ${table}\nselect * from ${table};\n.q" > $table |
| 28 |
sqlite3 $1 < $table |
| 29 |
cat $table >> $txt_filename |
| 30 |
echo -e "\n\n" >> $txt_filename |
| 31 |
rm -f $table |
| 32 |
done |
| 33 |
echo -e "Done! Check ${txt_filename} now." |
| 34 |
exit 0 |
| 35 |
fi |