blob: e7cfe98bd6f8d955ce402263d71772aaaba436c2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
#!/bin/sh
# Updates .sql files using .kexi files
# Only .sql file that is older than .kexi file is recreated.
# ksqlite is needed on the PATH
KEXISQL3PATH=../3rdparty/kexisql3/src/.libs/
PATH=$PATH:$KEXISQL3PATH
LD_LIBRARY_PATH=$KEXISQL3PATH:$KEXISQL3PATH
which ksqlite > /dev/null || exit 1
for f in `ls -1 *.kexi` ; do
if test -f $f.sql -a ! $f.sql -ot $f ; then
echo "Local $f.sql is newer than $f - skipping it"
continue
fi
echo -n "Creating $f.sql ... "
echo "vacuum;" | ksqlite $f
echo .dump | ksqlite $f > $f.sql || exit 1
echo "OK"
done
|
