diff --git a/tests/p_sqlite/sqlite_1-create_db_table.sh b/tests/p_sqlite/sqlite_1-create_db_table.sh new file mode 100755 index 0000000..85e2b71 --- /dev/null +++ b/tests/p_sqlite/sqlite_1-create_db_table.sh @@ -0,0 +1,8 @@ +#!/bin/sh +# Author: Athmane Madjoudj + +t_Log "Running $0 - check that sqlite can create database and tables." + +sqlite3 /tmp/tf_test.db 'create table tf_table(text, id INTEGER);' + +t_CheckExitStatus $? diff --git a/tests/p_sqlite/sqlite_2-insert_table.sh b/tests/p_sqlite/sqlite_2-insert_table.sh new file mode 100755 index 0000000..20c93e8 --- /dev/null +++ b/tests/p_sqlite/sqlite_2-insert_table.sh @@ -0,0 +1,8 @@ +#!/bin/sh +# Author: Athmane Madjoudj + +t_Log "Running $0 - check that sqlite can insert into table." + +sqlite3 /tmp/tf_test.db "insert into tf_table values ('tf_sample_text',1);" + +t_CheckExitStatus $? diff --git a/tests/p_sqlite/sqlite_create_db_table.sh b/tests/p_sqlite/sqlite_create_db_table.sh deleted file mode 100755 index b7daf61..0000000 --- a/tests/p_sqlite/sqlite_create_db_table.sh +++ /dev/null @@ -1,8 +0,0 @@ -#!/bin/sh -# Author: Athmane Madjoudj - -t_Log "Running $0 - check that sqlite can database and tables." - -sqlite3 /tmp/tf_test.db 'create table tf_table(text, id INTEGER);' - -t_CheckExitStatus $? diff --git a/tests/p_sqlite/sqlite_insert_table.sh b/tests/p_sqlite/sqlite_insert_table.sh deleted file mode 100755 index 20c93e8..0000000 --- a/tests/p_sqlite/sqlite_insert_table.sh +++ /dev/null @@ -1,8 +0,0 @@ -#!/bin/sh -# Author: Athmane Madjoudj - -t_Log "Running $0 - check that sqlite can insert into table." - -sqlite3 /tmp/tf_test.db "insert into tf_table values ('tf_sample_text',1);" - -t_CheckExitStatus $?