Author: gburt
Date: Thu Feb 14 18:31:27 2008
New Revision: 3238
URL: http://svn.gnome.org/viewvc/banshee?rev=3238&view=rev
Log:
2008-02-14 Gabriel Burt <[EMAIL PROTECTED]>
* src/Libraries/Hyena/Hyena.Data.Sqlite/SqliteUtils.cs: Forgot to svn
add.
Added:
trunk/banshee/src/Libraries/Hyena/Hyena.Data.Sqlite/SqliteUtils.cs
Modified:
trunk/banshee/ChangeLog
Added: trunk/banshee/src/Libraries/Hyena/Hyena.Data.Sqlite/SqliteUtils.cs
==============================================================================
--- (empty file)
+++ trunk/banshee/src/Libraries/Hyena/Hyena.Data.Sqlite/SqliteUtils.cs Thu Feb
14 18:31:27 2008
@@ -0,0 +1,94 @@
+//
+// SqliteUtils.cs
+//
+// Author:
+// Scott Peterson <[EMAIL PROTECTED]>
+//
+// Copyright (C) 2007 Novell, Inc.
+//
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+//
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+//
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
+using System;
+using System.Text;
+
+namespace Hyena.Data.Sqlite
+{
+ internal static class SqliteUtils
+ {
+ public static string GetType (Type type)
+ {
+ if (type == typeof (string)) {
+ return "TEXT";
+ } else if (type == typeof (int) || type == typeof (long)
+ || type == typeof (DateTime) || type == typeof (TimeSpan)) {
+ return "INTEGER";
+ } else {
+ throw new Exception (String.Format (
+ "The type {0} cannot be bound to a database column.",
type.Name));
+ }
+ }
+
+ public static object ToDbFormat (Type type, object value)
+ {
+ if (type == typeof (DateTime)) {
+ value = DateTimeUtil.FromDateTime ((DateTime)value);
+ } else if (type == typeof (TimeSpan)) {
+ value = ((TimeSpan)value).TotalMilliseconds;
+ }
+ return value;
+ }
+
+ public static object FromDbFormat (Type type, object value)
+ {
+ if (type == typeof (DateTime)) {
+ value = DateTimeUtil.ToDateTime ((long)value);
+ } else if (type == typeof (TimeSpan)) {
+ value = TimeSpan.FromMilliseconds ((long)value);
+ }
+ return value;
+ }
+
+ public static string BuildColumnSchema (string type,
+ string name,
+ string default_value,
+ DatabaseColumnConstraints
constraints)
+ {
+ StringBuilder builder = new StringBuilder ();
+ builder.Append (name);
+ builder.Append (' ');
+ builder.Append (type);
+ if ((constraints & DatabaseColumnConstraints.NotNull) > 0) {
+ builder.Append (" NOT NULL");
+ }
+ if ((constraints & DatabaseColumnConstraints.Unique) > 0) {
+ builder.Append (" UNIQUE");
+ }
+ if ((constraints & DatabaseColumnConstraints.PrimaryKey) > 0) {
+ builder.Append (" PRIMARY KEY");
+ }
+ if (default_value != null) {
+ builder.Append (" DEFAULT ");
+ builder.Append (default_value);
+ }
+ return builder.ToString ();
+ }
+ }
+}
_______________________________________________
SVN-commits-list mailing list (read only)
http://mail.gnome.org/mailman/listinfo/svn-commits-list
Want to limit the commits to a few modules? Go to above URL, log in to edit
your options and select the modules ('topics') you want.
Module maintainer? It is possible to set the reply-to to your development
mailing list. Email [EMAIL PROTECTED] if interested.
