FilterHtml.cs: Add ExtractText(string) command to extract text out of large html...
[beagle.git] / beagled / SqliteUtils.cs
blob4a8cf10c76c4535ff2fc717f349f76dad7b47a63
1 //
2 // SqliteUtils.cs
3 //
4 // Copyright (C) 2004-2006 Novell, Inc.
5 //
7 //
8 // Permission is hereby granted, free of charge, to any person obtaining a copy
9 // of this software and associated documentation files (the "Software"), to deal
10 // in the Software without restriction, including without limitation the rights
11 // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
12 // copies of the Software, and to permit persons to whom the Software is
13 // furnished to do so, subject to the following conditions:
15 // The above copyright notice and this permission notice shall be included in all
16 // copies or substantial portions of the Software.
18 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
19 // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
20 // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
21 // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
22 // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
23 // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
24 // SOFTWARE.
27 using System;
28 using System.Threading;
30 using Mono.Data.SqliteClient;
32 namespace Beagle.Util {
34 public class SqliteUtils {
36 // static class
37 private SqliteUtils () { }
39 public static void DoNonQuery (SqliteConnection connection, string command_text)
41 SqliteCommand command;
42 command = new SqliteCommand ();
43 command.Connection = connection;
44 command.CommandText = command_text;
46 while (true) {
47 try {
48 command.ExecuteNonQuery ();
49 break;
50 } catch (SqliteBusyException ex) {
51 Thread.Sleep (50);
55 command.Dispose ();
58 public static void DoNonQuery (SqliteConnection connection, string format, params object [] args)
60 DoNonQuery (connection, String.Format (format, args));
63 public static SqliteCommand QueryCommand (SqliteConnection connection, string where_format, params object [] where_args)
65 SqliteCommand command;
66 command = new SqliteCommand ();
67 command.Connection = connection;
68 command.CommandText =
69 "SELECT unique_id, directory, filename, last_mtime, last_attrtime, filter_name, filter_version " +
70 "FROM file_attributes WHERE " +
71 String.Format (where_format, where_args);
72 return command;
75 public static SqliteDataReader ExecuteReaderOrWait (SqliteCommand command)
77 SqliteDataReader reader = null;
78 while (reader == null) {
79 try {
80 reader = command.ExecuteReader ();
81 } catch (SqliteBusyException ex) {
82 Thread.Sleep (50);
85 return reader;
88 public static bool ReadOrWait (SqliteDataReader reader)
90 while (true) {
91 try {
92 return reader.Read ();
93 } catch (SqliteBusyException ex) {
94 Thread.Sleep (50);
99 public static string Sanitize (string item)
101 return item.Replace ("'", "''");