Debian Codegraph @

DataBase/abyss-db-txt

raw
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