System.Data.SQLite

Check-in [e2e6a0c7f1]
Login

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

Overview
Comment:Add test case for ticket [69cf6e5dc8].
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | tkt-69cf6e5dc8
Files: files | file ages | folders
SHA1: e2e6a0c7f19f1a9813c1f3035352771a219d2859
User & Date: mistachkin 2016-12-05 22:47:50.558
Context
2016-12-06
01:49
Candidate fix for ticket [69cf6e5dc8]. Closed-Leaf check-in: 471c16c617 user: mistachkin tags: tkt-69cf6e5dc8
2016-12-05
22:47
Add test case for ticket [69cf6e5dc8]. check-in: e2e6a0c7f1 user: mistachkin tags: tkt-69cf6e5dc8
2016-11-28
23:05
Add SQLite core library docs for the 'column-name-list' syntax element. check-in: e6c1544623 user: mistachkin tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to Setup/data/verify.lst.
︙︙
819
820
821
822
823
824
825

826
827
828
829
830
831
832

  Tests/tkt-544dba0a2f.eagle
  Tests/tkt-5535448538.eagle
  Tests/tkt-56b42d99c1.eagle
  Tests/tkt-58ed318f2f.eagle
  Tests/tkt-59edc1018b.eagle
  Tests/tkt-6434e23a0f.eagle
  Tests/tkt-647d282d11.eagle

  Tests/tkt-6c6ecccc5f.eagle
  Tests/tkt-71bedaca19.eagle
  Tests/tkt-72905c9a77.eagle
  Tests/tkt-74542e702e.eagle
  Tests/tkt-7714b60d61.eagle
  Tests/tkt-7c151a2f0e.eagle
  Tests/tkt-7e3fa93744.eagle








>








819
820
821
822
823
824
825
826
827
828
829
830
831
832
833

  Tests/tkt-544dba0a2f.eagle
  Tests/tkt-5535448538.eagle
  Tests/tkt-56b42d99c1.eagle
  Tests/tkt-58ed318f2f.eagle
  Tests/tkt-59edc1018b.eagle
  Tests/tkt-6434e23a0f.eagle
  Tests/tkt-647d282d11.eagle
  Tests/tkt-69cf6e5dc8.eagle
  Tests/tkt-6c6ecccc5f.eagle
  Tests/tkt-71bedaca19.eagle
  Tests/tkt-72905c9a77.eagle
  Tests/tkt-74542e702e.eagle
  Tests/tkt-7714b60d61.eagle
  Tests/tkt-7c151a2f0e.eagle
  Tests/tkt-7e3fa93744.eagle
︙︙
Added Tests/tkt-69cf6e5dc8.eagle. 






























































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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

###############################################################################
#
# tkt-69cf6e5dc8.eagle --
#
# Written by Joe Mistachkin.
# Released to the public domain, use at your own risk!
#
###############################################################################

package require Eagle
package require Eagle.Library
package require Eagle.Test

runTestPrologue

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

package require System.Data.SQLite.Test
runSQLiteTestPrologue

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

runTest {test tkt-69cf6e5dc8-1.1 {Julian DateTime precision} -setup {
  setupDb [set fileName tkt-69cf6e5dc8-1.1.db] "" JulianDay Utc \
      BindDateTimeWithKind [appendArgs DateTimeFormatString= \
      [getDateTimeFormat] \;]
} -body {
  sql execute $db {
    CREATE TABLE t1(x);
  }

  set dateTime(0) [object create DateTime 2016 11 20 0 46 3 0 Utc]

  sql execute -execute scalar $db \
      "INSERT INTO t1 (x) VALUES(?);" [list param1 DateTime $dateTime(0)]

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

  while {[$dataReader Read]} {
    lappend result [$dataReader GetValue 0]
    set dateTime(1) [$dataReader -create -alias GetDateTime 0]
    lappend result [$dateTime(1) ToString [getDateTimeFormat]]
  }

  set result
} -cleanup {
  unset -nocomplain dataReader

  cleanupDb $fileName

  unset -nocomplain dateTime result db fileName
} -constraints {eagle command.object monoBug28 monoBug42 command.sql\
compile.DATA SQLite System.Data.SQLite} -result {2457712.53197917 {2016-11-20\
00:46:03Z}}}

# 2457712.53197917 {2016-11-20 00:46:02.999Z}

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

runSQLiteTestEpilogue
runTestEpilogue