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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
67d18c8ae376e1515dba5a864f0046fc |
User & Date: | mistachkin 2014-05-29 04:52:18.703 |
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 | /// </summary> public abstract class SQLiteConvert { /// <summary> /// The fallback default database type when one cannot be obtained from an /// existing connection instance. /// </summary> | | | 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 | 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" \ | | > | > | | 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 | 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] |
︙ | ︙ | |||
1118 1119 1120 1121 1122 1123 1124 | 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\ | | > | 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 | 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] |
︙ | ︙ |