Git commit 42b75fe4ca02173653b17855088962d74a8e0afd by Jaroslaw Staniek, on=
 behalf of Gilbert Forkel.
Committed on 30/04/2014 at 20:26.
Pushed by staniek into branch 'master'.

Update Kexi tool scripts to work with sqlite3 binaries

CCMAIL:gilbertforkel@gmail.com

M  +3    -3    kexi/tools/add_column/kexi_add_column
M  +3    -3    kexi/tools/delete_column/kexi_delete_column

http://commits.kde.org/calligra/42b75fe4ca02173653b17855088962d74a8e0afd

diff --git a/kexi/tools/add_column/kexi_add_column b/kexi/tools/add_column/=
kexi_add_column
index 11f5957..31f1110 100755
--- a/kexi/tools/add_column/kexi_add_column
+++ b/kexi/tools/add_column/kexi_add_column
@@ -50,7 +50,7 @@ function check {
 	[ -n "$*" ] && exit_with_error "$*"
 }
 =

-ksqlite=3D"ksqlite -noheader"
+ksqlite=3D"sqlite3 -noheader"
 =

 if [ $# -lt 4 ] ; then
 	usage
@@ -86,7 +86,7 @@ msg=3D`echo "DROP TABLE '$table_name';" | $ksqlite "$temp=
_db"`
 check "$msg"
 =

 # 1. Recreate table with new field appended
-msg=3D`echo ".schema '$table_name';" | $ksqlite "$database_name" | grep "^=
CREATE TABLE $table_name " | \
+msg=3D`echo ".schema '$table_name'" | $ksqlite "$database_name" | grep "^C=
REATE TABLE $table_name " | \
  sed -e "s/);/, $new_column_name $new_column_type);/g" | $ksqlite "$temp_d=
b"`
 check "$msg"
 =

@@ -105,7 +105,7 @@ msg=3D`echo "INSERT INTO kexi__fields (t_id, f_type, f_=
name, f_length, f_precision
 check "$msg"
 =

 # 3. Copy the old data
-msg=3D`echo ".dump '$table_name';" | $ksqlite "$database_name" | grep -v "=
^CREATE TABLE " | \
+msg=3D`echo ".dump '$table_name'" | $ksqlite "$database_name" | grep -v "^=
CREATE TABLE " | \
  sed -e "s/\(^INSERT.*\));$/\\1, NULL);/g" | $ksqlite "$temp_db"`
 check "$msg"
 =

diff --git a/kexi/tools/delete_column/kexi_delete_column b/kexi/tools/delet=
e_column/kexi_delete_column
index 0fd654b..56b62b8 100755
--- a/kexi/tools/delete_column/kexi_delete_column
+++ b/kexi/tools/delete_column/kexi_delete_column
@@ -46,8 +46,8 @@ function check {
 	[ -n "$*" ] && exit_with_error "$*"
 }
 =

-ksqlite=3D"ksqlite -noheader"
-ksqlite_header=3D"ksqlite -header"
+ksqlite=3D"sqlite3 -noheader"
+ksqlite_header=3D"sqlite3 -header"
 =

 if [ $# -lt 3 ] ; then
 	usage
@@ -65,7 +65,7 @@ cp "$database_name" "$temp_db" || exit_with_error
 function prepare_new_create_table_statement {
 	# possible problems: typename ( number , number ) may contain ","
 	=

-	schema=3D`echo ".schema '$table_name';" | $ksqlite "$database_name" | \
+	schema=3D`echo ".schema '$table_name'" | $ksqlite "$database_name" | \
 		grep "^CREATE TABLE $table_name " | \
 		sed -e "s/[^(]*(\(.*\));/\1/" || exit_with_error`
 =09