From d91bc08737c8d1a461d9aa9f0d707924dc443d1e Mon Sep 17 00:00:00 2001
From: lbsa71
Date: Mon, 2 Feb 2009 11:16:41 +0000
Subject: * Removed the unused Data.Base Framework
---
OpenSim/Data/Base/BaseTableMapper.cs | 399 -----------------------------------
1 file changed, 399 deletions(-)
delete mode 100644 OpenSim/Data/Base/BaseTableMapper.cs
(limited to 'OpenSim/Data/Base/BaseTableMapper.cs')
diff --git a/OpenSim/Data/Base/BaseTableMapper.cs b/OpenSim/Data/Base/BaseTableMapper.cs
deleted file mode 100644
index 28b7ac8..0000000
--- a/OpenSim/Data/Base/BaseTableMapper.cs
+++ /dev/null
@@ -1,399 +0,0 @@
-/*
- * Copyright (c) Contributors, http://opensimulator.org/
- * See CONTRIBUTORS.TXT for a full list of copyright holders.
- *
- * Redistribution and use in source and binary forms, with or without
- * modification, are permitted provided that the following conditions are met:
- * * Redistributions of source code must retain the above copyright
- * notice, this list of conditions and the following disclaimer.
- * * Redistributions in binary form must reproduce the above copyright
- * notice, this list of conditions and the following disclaimer in the
- * documentation and/or other materials provided with the distribution.
- * * Neither the name of the OpenSim Project nor the
- * names of its contributors may be used to endorse or promote products
- * derived from this software without specific prior written permission.
- *
- * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY
- * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
- * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
- * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY
- * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
- * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
- * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
- * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
- * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
- * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
- */
-
-using System;
-using System.Data;
-using System.Data.Common;
-
-namespace OpenSim.Data.Base
-{
- ///
- ///
- ///
- public abstract class BaseTableMapper
- {
- private readonly BaseDatabaseConnector m_database;
- private readonly object m_syncRoot = new object();
-
- ///
- ///
- ///
- ///
- protected void WithConnection(Action action)
- {
- lock (m_syncRoot)
- {
- DbConnection m_connection = m_database.GetNewConnection();
-
- if (m_connection.State != ConnectionState.Open)
- {
- m_connection.Open();
- }
-
- action(m_connection);
-
- if (m_connection.State == ConnectionState.Open)
- {
- m_connection.Close();
- }
- }
- }
-
- private readonly string m_tableName;
- public string TableName
- {
- get { return m_tableName; }
- }
-
- protected BaseSchema m_schema;
- public BaseSchema Schema
- {
- get { return m_schema; }
- }
-
- protected BaseFieldMapper m_keyFieldMapper;
- public BaseFieldMapper KeyFieldMapper
- {
- get { return m_keyFieldMapper; }
- }
-
- ///
- ///
- ///
- ///
- ///
- public BaseTableMapper(BaseDatabaseConnector database, string tableName)
- {
- m_database = database;
- m_tableName = tableName.ToLower(); // Stupid MySQL hack.
- }
-
- ///
- ///
- ///
- ///
- ///
- public string CreateParamName(string fieldName)
- {
- return m_database.CreateParamName(fieldName);
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- ///
- protected DbCommand CreateSelectCommand(DbConnection connection, string fieldName, object primaryKey)
- {
- return m_database.CreateSelectCommand(this, connection, fieldName, primaryKey);
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- ///
- public string CreateCondition(DbCommand command, string fieldName, object key)
- {
- return m_database.CreateCondition(this, command, fieldName, key);
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- public DbCommand CreateInsertCommand(DbConnection connection, object obj)
- {
- return m_database.CreateInsertCommand(this, connection, obj);
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- ///
- public DbCommand CreateUpdateCommand(DbConnection connection, object rowMapper, object primaryKey)
- {
- return m_database.CreateUpdateCommand(this, connection, rowMapper, primaryKey);
- }
-
- ///
- ///
- ///
- ///
- ///
- public object ConvertToDbType(object value)
- {
- return m_database.ConvertToDbType(value);
- }
-
- ///
- ///
- ///
- ///
- ///
- protected virtual BaseDataReader CreateReader(IDataReader reader)
- {
- return m_database.CreateReader(reader);
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- public abstract class BaseTableMapper : BaseTableMapper
- {
- ///
- ///
- ///
- ///
- ///
- public BaseTableMapper(BaseDatabaseConnector database, string tableName)
- : base(database, tableName)
- {
- }
-
-
-
- ///
- /// HACK: This is a temporary function used by TryGetValue().
- /// Due to a bug in mono 1.2.6, delegate blocks cannot contain
- /// a using block. This has been fixed in SVN, so the next
- /// mono release should work.
- ///
- ///
- ///
- ///
- ///
- private void TryGetConnectionValue(DbConnection connection, TPrimaryKey primaryKey, ref TRowMapper result, ref bool success)
- {
- using (
- DbCommand command =
- CreateSelectCommand(connection, KeyFieldMapper.FieldName, primaryKey))
- {
- using (IDataReader reader = command.ExecuteReader())
- {
- if (reader.Read())
- {
- result = FromReader(CreateReader(reader));
- success = true;
- }
- else
- {
- success = false;
- }
- }
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- public bool TryGetValue(TPrimaryKey primaryKey, out TRowMapper value)
- {
- TRowMapper result = default(TRowMapper);
- bool success = false;
-
- WithConnection(delegate(DbConnection connection)
- {
- TryGetConnectionValue(connection, primaryKey, ref result, ref success);
- });
-
- value = result;
-
- return success;
- }
-
- ///
- /// HACK: This is a temporary function used by Remove().
- /// Due to a bug in mono 1.2.6, delegate blocks cannot contain
- /// a using block. This has been fixed in SVN, so the next
- /// mono release should work.
- ///
- ///
- ///
- ///
- protected virtual void TryDelete(DbConnection connection, TPrimaryKey id, ref int deleted)
- {
- using (
- DbCommand command =
- CreateDeleteCommand(connection, KeyFieldMapper.FieldName, id))
- {
- deleted = command.ExecuteNonQuery();
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- public virtual bool Remove(TPrimaryKey id)
- {
- int deleted = 0;
-
- WithConnection(delegate(DbConnection connection)
- {
- TryDelete(connection, id, ref deleted);
- });
-
- if (deleted == 1)
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- ///
- public DbCommand CreateDeleteCommand(DbConnection connection, string fieldName, TPrimaryKey primaryKey)
- {
- string table = TableName;
-
- DbCommand command = connection.CreateCommand();
-
- string conditionString = CreateCondition(command, fieldName, primaryKey);
-
- string query =
- String.Format("delete from {0} where {1}", table, conditionString);
-
- command.CommandText = query;
- command.CommandType = CommandType.Text;
-
- return command;
- }
-
-
-
- ///
- /// HACK: This is a temporary function used by Update().
- /// Due to a bug in mono 1.2.6, delegate blocks cannot contain
- /// a using block. This has been fixed in SVN, so the next
- /// mono release should work.
- ///
- ///
- ///
- ///
- ///
- protected void TryUpdate(DbConnection connection, TPrimaryKey primaryKey, TRowMapper value, ref int updated)
- {
- using (DbCommand command = CreateUpdateCommand(connection, value, primaryKey))
- {
- updated = command.ExecuteNonQuery();
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- ///
- public virtual bool Update(TPrimaryKey primaryKey, TRowMapper value)
- {
- int updated = 0;
-
- WithConnection(delegate(DbConnection connection)
- {
- TryUpdate(connection, primaryKey, value, ref updated);
- });
-
- if (updated == 1)
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- ///
- /// HACK: This is a temporary function used by Add().
- /// Due to a bug in mono 1.2.6, delegate blocks cannot contain
- /// a using block. This has been fixed in SVN, so the next
- /// mono release should work.
- ///
- ///
- ///
- ///
- protected void TryAdd(DbConnection connection, TRowMapper value, ref int added)
- {
- using (DbCommand command = CreateInsertCommand(connection, value))
- {
- added = command.ExecuteNonQuery();
- }
- }
-
- ///
- ///
- ///
- ///
- ///
- public virtual bool Add(TRowMapper value)
- {
- int added = 0;
-
- WithConnection(delegate(DbConnection connection)
- {
- TryAdd(connection, value, ref added);
- });
-
- if (added == 1)
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- public abstract TRowMapper FromReader(BaseDataReader reader);
- }
-}
--
cgit v1.1