System.Data.SQLite
Check-in [56a4359338]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Work in progress on the test for ticket [53633bbe39].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | tkt-53633bbe39
Files: files | file ages | folders
SHA1: 56a4359338799deb7af7068b8b43cc766601e9f4
User & Date: mistachkin 2016-03-21 21:35:09
Context
2016-04-01
00:23
Add tests for ticket [53633bbe39]. check-in: 8b5a097e13 user: mistachkin tags: trunk
2016-03-21
21:35
Work in progress on the test for ticket [53633bbe39]. Closed-Leaf check-in: 56a4359338 user: mistachkin tags: tkt-53633bbe39
16:18
Add preliminary test for ticket [53633bbe39]. check-in: a5653a0674 user: mistachkin tags: tkt-53633bbe39
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to Tests/tkt-53633bbe39.eagle.

34
35
36
37
38
39
40
41
42













43
44
45
46
47
48
49
50
51
52
53
54
55
56
    CREATE TABLE t1(x);
    INSERT INTO t1 (x) VALUES(NULL);
    INSERT INTO t1 (x) VALUES(1);
    INSERT INTO t1 (x) VALUES(2.0);
    INSERT INTO t1 (x) VALUES(3.14159);
  }

  sql execute -execute reader -format list -allownull true $db \
      "SELECT x FROM t1 ORDER BY x;"













} -cleanup {
  cleanupDb $fileName
  restoreSQLiteConvertEnvironment
  restoreSQLiteConnectionEnvironment

  unset -nocomplain db fileName savedEnv
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{{} 1 2.0 3.14159}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue







|
|
>
>
>
>
>
>
>
>
>
>
>
>
>





|

|
<





34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

64
65
66
67
68
    CREATE TABLE t1(x);
    INSERT INTO t1 (x) VALUES(NULL);
    INSERT INTO t1 (x) VALUES(1);
    INSERT INTO t1 (x) VALUES(2.0);
    INSERT INTO t1 (x) VALUES(3.14159);
  }

  set dataReader [sql execute -execute reader -format datareader \
      -alias $db "SELECT x FROM t1 ORDER BY x;"]

  set results [list]

  while {[$dataReader Read]} {
    set result [list]

    lappend result [catch {$dataReader GetString 0} result] $result
    lappend result [catch {$dataReader GetValue 0} result] $result

    lappend results $result
  }

  set results
} -cleanup {
  cleanupDb $fileName
  restoreSQLiteConvertEnvironment
  restoreSQLiteConnectionEnvironment

  unset -nocomplain result results db fileName savedEnv
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result {}}


###############################################################################

runSQLiteTestEpilogue
runTestEpilogue