Changeset 8c1828f in tol for tol_tests

Timestamp:

Nov 9, 2015, 7:16:09 PM (11 years ago)

Author:

Víctor de Buen <vdebuen@…>

Branches:

1941-docker-image-to-test, devel, master

Children:

51bae36

Parents:

9ae89b6

Message:

Refs #1893

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@7012 be4846ae-f051-483a-831f-b64e7d08527f

Location:

tol_tests/tol/database/sqlite

Files:

• test_001/test_sqlite.tol (modified) (2 diffs)
• test_003/test_sqlite.tol (added)

tol_tests/tol/database/sqlite/test_001/test_sqlite.tol

@@ -1 @@
-Real DBOpen("db1","","",[["sqlite","db1.db",""]]);
+Real DBOpen("db_test","","",[["sqlite","../db_test.db",""]]);
 
 //Real DBExecQuery("DROP TABLE student");
 
 Real DBExecQuery("
-DROP TABLE IF EXISTS student;
-CREATE TABLE IF NOT EXISTS student(
-  code VARCHAR,
+DROP TABLE IF EXISTS studQu;
+CREATE TABLE IF NOT EXISTS studQu(
+  code VARCHAR(16),
   qualify FLOAT
 )");
 
 
-Text query.insert = "INSERT INTO student "<<
+Text query.insert = "INSERT INTO studQu "<<
 SetSum(For(1,200,Text(Real k)
 {
@@ -22 +22 @@
 Real DBExecQuery(query.insert);
 
-Set DBTable("SELECT * FROM student");
+Set DBTable("SELECT * FROM studQu");
 
-Real DBClose("db1");
+Real DBClose("db_test");