Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add more tests for the password connection string property. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
9d136e41e6c98d1d1dfb25c670ebdcc1 |
| User & Date: | mistachkin 2012-09-16 23:06:26 |
Context
|
2012-09-17
| ||
| 03:47 | Add information to the download page concerning the recommended usage of the various downloadable packages. check-in: 26d526a37f user: mistachkin tags: trunk | |
|
2012-09-16
| ||
| 23:06 | Add more tests for the password connection string property. check-in: 9d136e41e6 user: mistachkin tags: trunk | |
| 07:56 | Update known-good test log files to account for the recent changes in the Visual Studio design-time installer. check-in: e5b3e80db7 user: mistachkin tags: trunk | |
Changes
Changes to Tests/basic.eagle.
1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 |
[expr {[$exception(1) Message] eq [$exception(2) Message]}]
} -cleanup {
unset -nocomplain exception stream serializer
} -constraints {eagle SQLite System.Data.SQLite} -result \
[string map [list \n \r\n] {CantOpen {unable to open database file
this is a test} CantOpen {unable to open database file
this is a test} True True}]}
###############################################################################
unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \
testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 |
[expr {[$exception(1) Message] eq [$exception(2) Message]}]
} -cleanup {
unset -nocomplain exception stream serializer
} -constraints {eagle SQLite System.Data.SQLite} -result \
[string map [list \n \r\n] {CantOpen {unable to open database file
this is a test} CantOpen {unable to open database file
this is a test} True True}]}
###############################################################################
runTest {test data-1.35 {open unencrypted database, with password} -setup {
setupDb [set fileName data-1.35.db]
} -body {
sql execute $db "CREATE TABLE t1(x);"
sql execute $db "INSERT INTO t1 (x) VALUES(1);"
cleanupDb $fileName db true false false
setupDb $fileName "" "" "" "" "Password=12345;" true false
set result [list]
lappend result [catch {sql execute -execute scalar $db \
"SELECT COUNT(*) FROM t1;"} error] $error
lappend result [catch {sql execute $db \
"INSERT INTO t1 (x) VALUES(1);"} error] $error
cleanupDb $fileName db true false false
setupDb $fileName "" "" "" "" "" true false
lappend result [catch {sql execute -execute scalar $db \
"SELECT COUNT(*) FROM t1;"} error] $error
set result
} -cleanup {
cleanupDb $fileName
unset -nocomplain error result db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} \
-match regexp -result {^1 \{System\.Data\.SQLite\.SQLiteException\
\(0x80004005\): file is encrypted or is not a database.*?\} 1\
\{System\.Data\.SQLite\.SQLiteException \(0x80004005\): file is encrypted or is\
not a database.*?\} 0 1$}}
###############################################################################
runTest {test data-1.36 {open encrypted database, wrong password} -setup {
setupDb [set fileName data-1.36.db] "" "" "" "" "Password=12345;"
} -body {
sql execute $db "CREATE TABLE t1(x);"
sql execute $db "INSERT INTO t1 (x) VALUES(1);"
cleanupDb $fileName db true false false
setupDb $fileName "" "" "" "" "Password=12346;" true false
set result [list]
lappend result [catch {sql execute -execute scalar $db \
"SELECT COUNT(*) FROM t1;"} error] $error
lappend result [catch {sql execute $db \
"INSERT INTO t1 (x) VALUES(1);"} error] $error
cleanupDb $fileName db true false false
setupDb $fileName "" "" "" "" "Password=12345;" true false
lappend result [catch {sql execute -execute scalar $db \
"SELECT COUNT(*) FROM t1;"} error] $error
set result
} -cleanup {
cleanupDb $fileName
unset -nocomplain error result db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} \
-match regexp -result {^1 \{System\.Data\.SQLite\.SQLiteException\
\(0x80004005\): file is encrypted or is not a database.*?\} 1\
\{System\.Data\.SQLite\.SQLiteException \(0x80004005\): file is encrypted or is\
not a database.*?\} 0 1$}}
###############################################################################
unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \
testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile
###############################################################################
runSQLiteTestEpilogue
runTestEpilogue
|