diff options
author | louiz’ <louiz@louiz.org> | 2018-02-05 22:53:36 +0100 |
---|---|---|
committer | louiz’ <louiz@louiz.org> | 2018-02-05 22:53:36 +0100 |
commit | 56651cb5c29cc50ddf3c62c37167fa0b9389bfde (patch) | |
tree | ca652963cafeb02b0c6c7504b1cfbc27abdafe0b /scripts | |
parent | ad1e0f8d52189e18df2d5a39228e255798a9de70 (diff) | |
parent | e0d1a0b44add408504e428d6ce4a8a2121ea7a00 (diff) | |
download | biboumi-56651cb5c29cc50ddf3c62c37167fa0b9389bfde.tar.gz biboumi-56651cb5c29cc50ddf3c62c37167fa0b9389bfde.tar.bz2 biboumi-56651cb5c29cc50ddf3c62c37167fa0b9389bfde.tar.xz biboumi-56651cb5c29cc50ddf3c62c37167fa0b9389bfde.zip |
Merge branch 'master' into debian
Diffstat (limited to 'scripts')
-rwxr-xr-x | scripts/dump_sqlite3.sh | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/scripts/dump_sqlite3.sh b/scripts/dump_sqlite3.sh new file mode 100755 index 0000000..88f3097 --- /dev/null +++ b/scripts/dump_sqlite3.sh @@ -0,0 +1,21 @@ +#!/bin/sh + +sqlite3_args=$@ + +function dump_table { + table=$1 + columns=$2 + echo ".mode insert $table +.output $table.sql +select $columns from $table;" | sqlite3 $sqlite3_args +} + +dump_table "roster" "local, remote" + +dump_table "ircserveroptions_" "id_, owner_, server_, pass_, afterconnectioncommand_, tlsports_, ports_, username_, realname_, verifycert_, trustedfingerprint_, encodingout_, encodingin_, maxhistorylength_" + +dump_table "ircchanneloptions_" "id_, owner_, server_, channel_, encodingout_, encodingin_, maxhistorylength_, persistent_, recordhistory_" + +dump_table "globaloptions_" "id_, owner_, maxhistorylength_, recordhistory_, persistent_" + +dump_table "muclogline_" "id_, uuid_, owner_, ircchanname_, ircservername_, date_, body_, nick_" |