Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the DefaultDbType and DefaultTypeName connection string properties to the SQLiteConnectionStringBuilder class. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
67d18c8ae376e1515dba5a864f0046fc |
| User & Date: | mistachkin 2014-05-29 04:52:18 |
Context
|
2014-05-30
| ||
| 19:36 | Correct the SQLiteLog output formatting when the message originates from within the System.Data.SQLite library itself. check-in: 5ae87a8a66 user: mistachkin tags: trunk | |
|
2014-05-29
| ||
| 04:52 | Add the DefaultDbType and DefaultTypeName connection string properties to the SQLiteConnectionStringBuilder class. check-in: 67d18c8ae3 user: mistachkin tags: trunk | |
|
2014-05-27
| ||
| 18:43 | Expose the 'Uri' and 'FullUri' properties in the design-time dialogs. check-in: 96e1f973fa user: mistachkin tags: trunk | |
Changes
Changes to System.Data.SQLite/SQLiteConnectionStringBuilder.cs.
590 591 592 593 594 595 596 597 598 599 600 601 602 603 |
return (IsolationLevel)value;
}
set
{
this["default isolationlevel"] = value;
}
}
/// <summary>
/// If enabled, use foreign key constraints
/// </summary>
[DisplayName("Foreign Keys")]
[Browsable(true)]
[DefaultValue(false)]
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 |
return (IsolationLevel)value;
}
set
{
this["default isolationlevel"] = value;
}
}
/// <summary>
/// Gets/sets the default database type for the connection.
/// </summary>
[Browsable(true)]
[DefaultValue(SQLiteConvert.FallbackDefaultDbType)]
public DbType DefaultDbType
{
get
{
object value;
TryGetValue("defaultdbtype", out value);
if (value is string)
return (DbType)TypeDescriptor.GetConverter(typeof(DbType)).ConvertFrom(value);
else
return (DbType)value;
}
set
{
this["defaultdbtype"] = value;
}
}
/// <summary>
/// Gets/sets the default type name for the connection.
/// </summary>
[Browsable(true)]
[DefaultValue(null)]
public string DefaultTypeName
{
get
{
object value;
TryGetValue("defaulttypename", out value);
return value.ToString();
}
set
{
this["defaulttypename"] = value;
}
}
/// <summary>
/// If enabled, use foreign key constraints
/// </summary>
[DisplayName("Foreign Keys")]
[Browsable(true)]
[DefaultValue(false)]
|
Changes to System.Data.SQLite/SQLiteConvert.cs.
23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
/// </summary>
public abstract class SQLiteConvert
{
/// <summary>
/// The fallback default database type when one cannot be obtained from an
/// existing connection instance.
/// </summary>
internal static readonly DbType FallbackDefaultDbType = DbType.Object;
/// <summary>
/// The fallback default database type name when one cannot be obtained from
/// an existing connection instance.
/// </summary>
internal static readonly string FallbackDefaultTypeName = String.Empty;
|
| |
23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
/// </summary>
public abstract class SQLiteConvert
{
/// <summary>
/// The fallback default database type when one cannot be obtained from an
/// existing connection instance.
/// </summary>
internal const DbType FallbackDefaultDbType = DbType.Object;
/// <summary>
/// The fallback default database type name when one cannot be obtained from
/// an existing connection instance.
/// </summary>
internal static readonly string FallbackDefaultTypeName = String.Empty;
|
Changes to Tests/basic.eagle.
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
....
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
|
if {$code eq "Ok"} then {
set keys [list null Version Synchronous UseUTF16Encoding Pooling \
BinaryGUID "Data Source" Uri FullUri "Default Timeout" \
Enlist FailIfMissing "Legacy Format" "Read Only" \
Password "Page Size" "Max Page Count" "Cache Size" \
DateTimeFormat DateTimeKind DateTimeFormatString \
BaseSchemaName "Journal Mode" "Default IsolationLevel" \
"Foreign Keys" Flags SetDefaults ToFullPath HexPassword]
set values [list null 3 Normal True False \
True test.db test.db file:test.db 60 \
False True False True \
secret 4096 1024 8192 \
UnixEpoch Utc yyyy-MM-dd sqlite_schema \
Memory Serializable False \
Default False False 736563726574]
set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \
BinaryGUID DataSource Uri FullUri DefaultTimeout \
Enlist FailIfMissing LegacyFormat ReadOnly \
Password PageSize MaxPageCount CacheSize \
DateTimeFormat DateTimeKind DateTimeFormatString \
BaseSchemaName JournalMode DefaultIsolationLevel \
ForeignKeys Flags SetDefaults ToFullPath \
HexPassword]
foreach key $keys value $values propertyName $propertyNames {
set code [catch {
object invoke _Dynamic${id}.Test${id} GetConnectionString \
$key $value $propertyName
} result]
................................................................................
Max Page Count=1024\} 0 \{8192, Cache Size=8192\} 0 \{UnixEpoch,\
DateTimeFormat=UnixEpoch\} 0 \{Utc, DateTimeKind=Utc\} 0 \{yyyy-MM-dd,\
DateTimeFormatString=yyyy-MM-dd\} 0 \{sqlite_schema,\
BaseSchemaName=sqlite_schema\} 0 \{Memory, Journal Mode=Memory\} 0\
\{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\
Keys=False\} 0 \{(?:Default|LogCallbackException),\
Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\
\{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574}$}}
###############################################################################
runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body {
set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \
ToDateTime 2455928.0 Utc]
|
|
>
|
>
|
|
>
|
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
....
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
|
if {$code eq "Ok"} then {
set keys [list null Version Synchronous UseUTF16Encoding Pooling \
BinaryGUID "Data Source" Uri FullUri "Default Timeout" \
Enlist FailIfMissing "Legacy Format" "Read Only" \
Password "Page Size" "Max Page Count" "Cache Size" \
DateTimeFormat DateTimeKind DateTimeFormatString \
BaseSchemaName "Journal Mode" "Default IsolationLevel" \
"Foreign Keys" Flags SetDefaults ToFullPath HexPassword \
DefaultDbType DefaultTypeName]
set values [list null 3 Normal True False \
True test.db test.db file:test.db 60 \
False True False True \
secret 4096 1024 8192 \
UnixEpoch Utc yyyy-MM-dd sqlite_schema \
Memory Serializable False \
Default False False 736563726574 String \
TEXT]
set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \
BinaryGUID DataSource Uri FullUri DefaultTimeout \
Enlist FailIfMissing LegacyFormat ReadOnly \
Password PageSize MaxPageCount CacheSize \
DateTimeFormat DateTimeKind DateTimeFormatString \
BaseSchemaName JournalMode DefaultIsolationLevel \
ForeignKeys Flags SetDefaults ToFullPath \
HexPassword DefaultDbType DefaultTypeName]
foreach key $keys value $values propertyName $propertyNames {
set code [catch {
object invoke _Dynamic${id}.Test${id} GetConnectionString \
$key $value $propertyName
} result]
................................................................................
Max Page Count=1024\} 0 \{8192, Cache Size=8192\} 0 \{UnixEpoch,\
DateTimeFormat=UnixEpoch\} 0 \{Utc, DateTimeKind=Utc\} 0 \{yyyy-MM-dd,\
DateTimeFormatString=yyyy-MM-dd\} 0 \{sqlite_schema,\
BaseSchemaName=sqlite_schema\} 0 \{Memory, Journal Mode=Memory\} 0\
\{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\
Keys=False\} 0 \{(?:Default|LogCallbackException),\
Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\
\{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574} 0\
\{String, DefaultDbType=String\} 0 \{TEXT, DefaultTypeName=TEXT\}$}}
###############################################################################
runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body {
set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \
ToDateTime 2455928.0 Utc]
|