beagled/SqliteUtils.cs

   1 //
   2 // SqliteUtils.cs
   3 //
   4 // Copyright (C) 2004-2006 Novell, Inc.
   5 //
   6
   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:
  14 //
  15 // The above copyright notice and this permission notice shall be included in all
  16 // copies or substantial portions of the Software.
  17 //
  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.
  25 //
  26
  27 using System;
  28 using System.Threading;
  29
  30 using Mono.Data.SqliteClient;
  31
  32 namespace Beagle.Util {
  33
  34         public class SqliteUtils {
  35
  36                 // static class
  37                 private SqliteUtils () { }
  38
  39                 public static void DoNonQuery (SqliteConnection connection, string command_text)
  40                 {
  41                         SqliteCommand command;
  42                         command = new SqliteCommand ();
  43                         command.Connection = connection;
  44                         command.CommandText = command_text;
  45
  46                         while (true) {
  47                                 try {
  48                                         command.ExecuteNonQuery ();
  49                                         break;
  50                                 } catch (SqliteBusyException ex) {
  51                                         Thread.Sleep (50);
  52                                 }
  53                         }
  54
  55                         command.Dispose ();
  56                 }
  57
  58                 public static void DoNonQuery (SqliteConnection connection, string format, params object [] args)
  59                 {
  60                         DoNonQuery (connection, String.Format (format, args));
  61                 }
  62
  63                 public static SqliteCommand QueryCommand (SqliteConnection connection, string where_format, params object [] where_args)
  64                 {
  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;
  73                 }
  74
  75                 public static SqliteDataReader ExecuteReaderOrWait (SqliteCommand command)
  76                 {
  77                         SqliteDataReader reader = null;
  78                         while (reader == null) {
  79                                 try {
  80                                         reader = command.ExecuteReader ();
  81                                 } catch (SqliteBusyException ex) {
  82                                         Thread.Sleep (50);
  83                                 }
  84                         }
  85                         return reader;
  86                 }
  87
  88                 public static bool ReadOrWait (SqliteDataReader reader)
  89                 {
  90                         while (true) {
  91                                 try {
  92                                         return reader.Read ();
  93                                 } catch (SqliteBusyException ex) {
  94                                         Thread.Sleep (50);
  95                                 }
  96                         }
  97                 }
  98
  99                 public static string Sanitize (string item)
 100                 {
 101                         return item.Replace ("'", "''");
 102                 }
 103         }
 104 }
 105
 106