mono/mcs/class/System.Data/System.Data.OleDb/libgda.cs

//
// System.Data.OleDb.libgda
//
// Authors:
//   Rodrigo Moya ([email protected])
//   Tim Coleman ([email protected])
//
// Copyright (C) Rodrigo Moya, 2002
// Copyright (C) Tim Coleman, 2002
//

//
// Copyright (C) 2004 Novell, Inc (http://www.novell.com)
//
// 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.Data;
using System.Data.Common;
using System.Runtime.InteropServices;

namespace System.Data.OleDb
{
	internal enum GdaConnectionOptions {
		ReadOnly = 1 << 0
	};
	
	internal enum GdaCommandOptions {
		IgnoreErrors = 1,
		StopOnErrors = 1 << 1,
		BadOption = 1 << 2,
	};

	internal enum GdaCommandType {
		Sql = 0,
		Xml = 1,
		Procedure = 2,
		Table = 3,
		Schema = 4,
		Invalid = 5
	};

	internal enum GdaTransactionIsolation {
		Unknown,
		ReadCommitted,
		ReadUncommitted,
		RepeatableRead,
		Serializable
	};
	
	internal enum GdaValueType {
		Null = 0,
		Bigint = 1,
		Binary = 2,
		Boolean = 3,
		Date = 4,
		Double = 5,
		GeometricPoint = 6,
		Integer = 7,
		List = 8,
		Numeric = 9,
		Single = 10,
		Smallint = 11,
		String = 12,
		Time = 13,
		Timestamp = 14,
		Tinyint = 15,
		Type = 16,
		Unknown = 17
	};

	[StructLayout(LayoutKind.Sequential)]
	internal class GdaDate
	{
		public short year;
		public ushort month;
		public ushort day;
	}

	[StructLayout(LayoutKind.Sequential)]
	internal class GdaTime
	{
		public ushort hour;
		public ushort minute;
		public ushort second;
		public long timezone;
	}
	
	[StructLayout(LayoutKind.Sequential)]
	internal class GdaTimestamp
	{
		public short year;
		public ushort month;
		public ushort day;
		public ushort hour;
		public ushort minute;
		public ushort second;
		public ulong fraction;
		public long timezone;
	}
	
	[StructLayout(LayoutKind.Sequential)]
	internal class GdaList
	{
		public IntPtr data;
		public IntPtr next;
		public IntPtr prev;
	}
	
	sealed internal class libgda
	{
		private static IntPtr gdaClient = IntPtr.Zero;

		public static IntPtr GdaClient
		{
			get {
				if (gdaClient == IntPtr.Zero)
					gdaClient = gda_client_new ();

				return gdaClient;
			}
		}

		[DllImport("gobject-2.0",
			   EntryPoint="g_object_unref")]
		public static extern void FreeObject (IntPtr obj);

		[DllImport("gda-2")]
		public static extern void gda_init (string app_id, string version, int nargs, string[] args);

		[DllImport("gda-2")]
		public static extern GdaValueType gda_value_get_type (IntPtr value);

		[DllImport("gda-2")]
		public static extern long gda_value_get_bigint (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern bool gda_value_get_boolean (IntPtr value);

		[DllImport("gda-2")]
		public static extern IntPtr gda_value_get_date (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern double gda_value_get_double (IntPtr value);

		[DllImport("gda-2")]
		public static extern int gda_value_get_integer (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern float gda_value_get_single (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern int gda_value_get_smallint (IntPtr value);

		[DllImport("gda-2")]
		public static extern string gda_value_get_string (IntPtr value);

		[DllImport("gda-2")]
		public static extern IntPtr gda_value_get_time (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern IntPtr gda_value_get_timestamp (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern byte gda_value_get_tinyint (IntPtr value);

		[DllImport("gda-2")]
		public static extern bool gda_value_is_null (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern string gda_value_stringify (IntPtr value);
		
		[DllImport("gda-2")]
		public static extern IntPtr gda_parameter_list_new ();

		[DllImport("gda-2")]
		public static extern string gda_type_to_string (GdaValueType type);
		
		[DllImport("gda-2")]
		public static extern int gda_data_model_get_n_rows (IntPtr model);

		[DllImport("gda-2")]
		public static extern int gda_data_model_get_n_columns (IntPtr model);

		[DllImport("gda-2")]
		public static extern IntPtr gda_data_model_get_value_at (IntPtr model, int col, int row);

		[DllImport("gda-2")]
		public static extern string gda_data_model_get_column_title (IntPtr model, int col);

		[DllImport("gda-2")]
		public static extern IntPtr gda_data_model_describe_column (IntPtr model, int col);

		[DllImport("gda-2")]
		public static extern int gda_data_model_get_column_position (IntPtr model, string name);
		
		[DllImport("gda-2")]
		public static extern void gda_field_attributes_free (IntPtr fa);

		[DllImport("gda-2")]
		public static extern string gda_field_attributes_get_name (IntPtr fa);
		
		[DllImport("gda-2")]
		public static extern GdaValueType gda_field_attributes_get_gdatype (IntPtr fa);

		[DllImport("gda-2")]
		public static extern long gda_field_attributes_get_defined_size (IntPtr fa);

		[DllImport("gda-2")]
		public static extern long gda_field_attributes_get_scale (IntPtr fa);

		[DllImport("gda-2")]
		public static extern bool gda_field_attributes_get_allow_null (IntPtr fa);
		
		[DllImport("gda-2")]
		public static extern bool gda_field_attributes_get_primary_key (IntPtr fa);
		
		[DllImport("gda-2")]
		public static extern bool gda_field_attributes_get_unique_key (IntPtr fa);
		
		[DllImport("gda-2")]
		public static extern IntPtr gda_client_new ();

		[DllImport("gda-2")]
		public static extern IntPtr gda_client_open_connection (IntPtr client, string dsn,
									string username, string password,
									GdaConnectionOptions options);

		[DllImport("gda-2")]
		public static extern IntPtr gda_client_open_connection_from_string (IntPtr client,
										    string provider,
										    string cnc_string,
										    GdaConnectionOptions options);

		[DllImport("gda-2")]
		public static extern bool gda_connection_is_open (IntPtr cnc);
		
		[DllImport("gda-2")]
		public static extern bool gda_connection_close (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_server_version (IntPtr cnc);
		
		[DllImport("gda-2")]
		public static extern string gda_connection_get_database (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_dsn (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_cnc_string (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_provider (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_username (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern string gda_connection_get_password (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern bool gda_connection_change_database (IntPtr cnc, string name);
		
		[DllImport("gda-2")]
		public static extern IntPtr gda_transaction_new (string name);

		[DllImport("gda-2")]
		public static extern IntPtr gda_transaction_get_name (IntPtr xaction);

		[DllImport("gda-2")]
		public static extern IntPtr gda_transaction_set_name (IntPtr xaction, string name);

		[DllImport("gda-2")]
		public static extern GdaTransactionIsolation gda_transaction_get_isolation_level (IntPtr xaction);

		[DllImport("gda-2")]
		public static extern void gda_transaction_set_isolation_level (IntPtr xaction,
									       GdaTransactionIsolation level);
		
		[DllImport("gda-2")]
		public static extern bool gda_connection_begin_transaction (IntPtr cnc, IntPtr xaction);

		[DllImport("gda-2")]
		public static extern bool gda_connection_commit_transaction (IntPtr cnc, IntPtr xaction);

		[DllImport("gda-2")]
		public static extern bool gda_connection_rollback_transaction (IntPtr cnc, IntPtr xaction);

		[DllImport("gda-2")]
		public static extern IntPtr gda_connection_execute_command (IntPtr cnc, IntPtr cmd, IntPtr parameterList);
		
		[DllImport("gda-2")]
		public static extern int gda_connection_execute_non_query (IntPtr cnc, IntPtr command, IntPtr parameterList);

		[DllImport("gda-2")]
		public static extern IntPtr gda_connection_execute_single_command (IntPtr cnc, IntPtr command, IntPtr parameterList);

		[DllImport("gda-2")]
		public static extern IntPtr gda_connection_get_errors (IntPtr cnc);

		[DllImport("gda-2")]
		public static extern IntPtr gda_command_new (string text, GdaCommandType type, GdaCommandOptions options);

		[DllImport("gda-2")]
		public static extern void gda_command_set_text (IntPtr cmd, string text);

		[DllImport("gda-2")]
		public static extern void gda_command_set_command_type (IntPtr cmd, GdaCommandType type);

		[DllImport("gda-2")]
		public static extern string gda_error_get_description (IntPtr error);

		[DllImport("gda-2")]
		public static extern long gda_error_get_number (IntPtr error);

		[DllImport("gda-2")]
		public static extern string gda_error_get_source (IntPtr error);
		
		[DllImport("gda-2")]
		public static extern string gda_error_get_sqlstate (IntPtr error);
		
	}
}