WingMan – Diff between revs 32 and 36

Subversion Repositories:
Rev:
Show entire file – Ignore whitespace
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