WingMan – Diff between revs 32 and 36
?pathlinks?
Rev 32 | Rev 36 | |||
---|---|---|---|---|
Line 122... | Line 122... | |||
122 | { |
122 | { |
|
123 | using (var sqliteConnection = |
123 | using (var sqliteConnection = |
|
124 | new SqliteConnection($"URI=file:{"Autocomplete.db"}")) |
124 | new SqliteConnection($"URI=file:{"Autocomplete.db"}")) |
|
125 | { |
125 | { |
|
126 | await sqliteConnection.OpenAsync(CancellationToken); |
126 | await sqliteConnection.OpenAsync(CancellationToken); |
|
- | 127 | |
||
- | 128 | // Create table if it does not exist. |
||
- | 129 | using (var sqliteCommand = |
||
- | 130 | new SqliteCommand($"CREATE TABLE IF NOT EXISTS {name} (data text UNIQUE NOT NULL)", |
||
- | 131 | sqliteConnection)) |
||
- | 132 | { |
||
- | 133 | using (var dbtransaction = sqliteConnection.BeginTransaction()) |
||
- | 134 | { |
||
- | 135 | try |
||
- | 136 | { |
||
- | 137 | await sqliteCommand.ExecuteReaderAsync(CancellationToken); |
||
- | 138 | |
||
- | 139 | dbtransaction.Commit(); |
||
- | 140 | } |
||
- | 141 | catch |
||
- | 142 | { |
||
- | 143 | dbtransaction.Rollback(); |
||
- | 144 | throw; |
||
- | 145 | } |
||
- | 146 | } |
||
- | 147 | } |
||
- | 148 | |
||
127 | using (var sqliteCommand = |
149 | using (var sqliteCommand = |
|
128 | new SqliteCommand($"SELECT data FROM {name}", sqliteConnection)) |
150 | new SqliteCommand($"SELECT data FROM {name}", sqliteConnection)) |
|
129 | { |
151 | { |
|
130 | using (var dbtransaction = sqliteConnection.BeginTransaction()) |
152 | using (var dbtransaction = sqliteConnection.BeginTransaction()) |
|
131 | { |
153 | { |
|
Line 163... | Line 185... | |||
163 | new AutoCompletionFailedEventArgs(AutoCompletionFailedType.Load, name, ex)), CancellationToken, |
185 | new AutoCompletionFailedEventArgs(AutoCompletionFailedType.Load, name, ex)), CancellationToken, |
|
164 | TaskContinuationOptions.None, TaskScheduler); |
186 | TaskContinuationOptions.None, TaskScheduler); |
|
165 | } |
187 | } |
|
166 | } |
188 | } |
|
167 | } |
189 | } |
|
168 | } |
- | ||
169 | |
190 | } |
|
- | 191 | |