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 int DoNonQuery (SqliteConnection connection, string command_text)
  40                 {
  41                         SqliteCommand command;
  42                         command = new SqliteCommand ();
  43                         command.Connection = connection;
  44                         command.CommandText = command_text;
  45                         int ret = 0;
  46
  47                         while (true) {
  48                                 try {
  49                                         ret = command.ExecuteNonQuery ();
  50                                         break;
  51                                 } catch (SqliteBusyException ex) {
  52                                         Thread.Sleep (50);
  53                                 }
  54                         }
  55
  56                         command.Dispose ();
  57                         return ret;
  58                 }
  59
  60                 public static int DoNonQuery (SqliteConnection connection, string format, params object [] args)
  61                 {
  62                         return DoNonQuery (connection, String.Format (format, args));
  63                 }
  64
  65                 public static SqliteCommand QueryCommand (SqliteConnection connection, string where_format, params object [] where_args)
  66                 {
  67                         SqliteCommand command;
  68                         command = new SqliteCommand ();
  69                         command.Connection = connection;
  70                         command.CommandText =
  71                                 "SELECT unique_id, directory, filename, last_mtime, last_attrtime, filter_name, filter_version " +
  72                                 "FROM file_attributes WHERE " +
  73                                 String.Format (where_format, where_args);
  74                         return command;
  75                 }
  76
  77                 public static SqliteDataReader ExecuteReaderOrWait (SqliteCommand command)
  78                 {
  79                         SqliteDataReader reader = null;
  80                         while (reader == null) {
  81                                 try {
  82                                         reader = command.ExecuteReader ();
  83                                 } catch (SqliteBusyException ex) {
  84                                         Thread.Sleep (50);
  85                                 }
  86                         }
  87                         return reader;
  88                 }
  89
  90                 public static bool ReadOrWait (SqliteDataReader reader)
  91                 {
  92                         while (true) {
  93                                 try {
  94                                         return reader.Read ();
  95                                 } catch (SqliteBusyException ex) {
  96                                         Thread.Sleep (50);
  97                                 }
  98                         }
  99                 }
 100
 101                 public static string Sanitize (string item)
 102                 {
 103                         return item.Replace ("'", "''");
 104                 }
 105         }
 106 }
 107
 108