libgda.cs 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318
  1. //
  2. // System.Data.OleDb.libgda
  3. //
  4. // Authors:
  5. // Rodrigo Moya ([email protected])
  6. // Tim Coleman ([email protected])
  7. //
  8. // Copyright (C) Rodrigo Moya, 2002
  9. // Copyright (C) Tim Coleman, 2002
  10. //
  11. using System.Data;
  12. using System.Data.Common;
  13. using System.Runtime.InteropServices;
  14. namespace System.Data.OleDb
  15. {
  16. internal enum GdaConnectionOptions {
  17. ReadOnly = 1 << 0
  18. };
  19. internal enum GdaCommandOptions {
  20. IgnoreErrors = 1,
  21. StopOnErrors = 1 << 1,
  22. BadOption = 1 << 2,
  23. };
  24. internal enum GdaCommandType {
  25. Sql = 0,
  26. Xml = 1,
  27. Procedure = 2,
  28. Table = 3,
  29. Schema = 4,
  30. Invalid = 5
  31. };
  32. internal enum GdaTransactionIsolation {
  33. Unknown,
  34. ReadCommitted,
  35. ReadUncommitted,
  36. RepeatableRead,
  37. Serializable
  38. };
  39. internal enum GdaValueType {
  40. Null = 0,
  41. Bigint = 1,
  42. Binary = 2,
  43. Boolean = 3,
  44. Date = 4,
  45. Double = 5,
  46. GeometricPoint = 6,
  47. Integer = 7,
  48. List = 8,
  49. Numeric = 9,
  50. Single = 10,
  51. Smallint = 11,
  52. String = 12,
  53. Time = 13,
  54. Timestamp = 14,
  55. Tinyint = 15,
  56. Type = 16,
  57. Unknown = 17
  58. };
  59. [StructLayout(LayoutKind.Sequential)]
  60. internal class GdaDate
  61. {
  62. public short year;
  63. public ushort month;
  64. public ushort day;
  65. }
  66. [StructLayout(LayoutKind.Sequential)]
  67. internal class GdaTime
  68. {
  69. public ushort hour;
  70. public ushort minute;
  71. public ushort second;
  72. public long timezone;
  73. }
  74. [StructLayout(LayoutKind.Sequential)]
  75. internal class GdaTimestamp
  76. {
  77. public short year;
  78. public ushort month;
  79. public ushort day;
  80. public ushort hour;
  81. public ushort minute;
  82. public ushort second;
  83. public ulong fraction;
  84. public long timezone;
  85. }
  86. [StructLayout(LayoutKind.Sequential)]
  87. internal class GdaList
  88. {
  89. public IntPtr data;
  90. public IntPtr next;
  91. public IntPtr prev;
  92. }
  93. sealed internal class libgda
  94. {
  95. private static IntPtr gdaClient = IntPtr.Zero;
  96. public static IntPtr GdaClient
  97. {
  98. get {
  99. if (gdaClient == IntPtr.Zero)
  100. gdaClient = gda_client_new ();
  101. return gdaClient;
  102. }
  103. }
  104. [DllImport("gobject-2.0",
  105. EntryPoint="g_object_unref")]
  106. public static extern void FreeObject (IntPtr obj);
  107. [DllImport("gda-2")]
  108. public static extern void gda_init (string app_id, string version, int nargs, string[] args);
  109. [DllImport("gda-2")]
  110. public static extern GdaValueType gda_value_get_type (IntPtr value);
  111. [DllImport("gda-2")]
  112. public static extern long gda_value_get_bigint (IntPtr value);
  113. [DllImport("gda-2")]
  114. public static extern bool gda_value_get_boolean (IntPtr value);
  115. [DllImport("gda-2")]
  116. public static extern IntPtr gda_value_get_date (IntPtr value);
  117. [DllImport("gda-2")]
  118. public static extern double gda_value_get_double (IntPtr value);
  119. [DllImport("gda-2")]
  120. public static extern int gda_value_get_integer (IntPtr value);
  121. [DllImport("gda-2")]
  122. public static extern float gda_value_get_single (IntPtr value);
  123. [DllImport("gda-2")]
  124. public static extern int gda_value_get_smallint (IntPtr value);
  125. [DllImport("gda-2")]
  126. public static extern string gda_value_get_string (IntPtr value);
  127. [DllImport("gda-2")]
  128. public static extern IntPtr gda_value_get_time (IntPtr value);
  129. [DllImport("gda-2")]
  130. public static extern IntPtr gda_value_get_timestamp (IntPtr value);
  131. [DllImport("gda-2")]
  132. public static extern byte gda_value_get_tinyint (IntPtr value);
  133. [DllImport("gda-2")]
  134. public static extern bool gda_value_is_null (IntPtr value);
  135. [DllImport("gda-2")]
  136. public static extern string gda_value_stringify (IntPtr value);
  137. [DllImport("gda-2")]
  138. public static extern IntPtr gda_parameter_list_new ();
  139. [DllImport("gda-2")]
  140. public static extern string gda_type_to_string (GdaValueType type);
  141. [DllImport("gda-2")]
  142. public static extern int gda_data_model_get_n_rows (IntPtr model);
  143. [DllImport("gda-2")]
  144. public static extern int gda_data_model_get_n_columns (IntPtr model);
  145. [DllImport("gda-2")]
  146. public static extern IntPtr gda_data_model_get_value_at (IntPtr model, int col, int row);
  147. [DllImport("gda-2")]
  148. public static extern string gda_data_model_get_column_title (IntPtr model, int col);
  149. [DllImport("gda-2")]
  150. public static extern IntPtr gda_data_model_describe_column (IntPtr model, int col);
  151. [DllImport("gda-2")]
  152. public static extern int gda_data_model_get_column_position (IntPtr model, string name);
  153. [DllImport("gda-2")]
  154. public static extern void gda_field_attributes_free (IntPtr fa);
  155. [DllImport("gda-2")]
  156. public static extern string gda_field_attributes_get_name (IntPtr fa);
  157. [DllImport("gda-2")]
  158. public static extern GdaValueType gda_field_attributes_get_gdatype (IntPtr fa);
  159. [DllImport("gda-2")]
  160. public static extern long gda_field_attributes_get_defined_size (IntPtr fa);
  161. [DllImport("gda-2")]
  162. public static extern long gda_field_attributes_get_scale (IntPtr fa);
  163. [DllImport("gda-2")]
  164. public static extern bool gda_field_attributes_get_allow_null (IntPtr fa);
  165. [DllImport("gda-2")]
  166. public static extern bool gda_field_attributes_get_primary_key (IntPtr fa);
  167. [DllImport("gda-2")]
  168. public static extern bool gda_field_attributes_get_unique_key (IntPtr fa);
  169. [DllImport("gda-2")]
  170. public static extern IntPtr gda_client_new ();
  171. [DllImport("gda-2")]
  172. public static extern IntPtr gda_client_open_connection (IntPtr client, string dsn,
  173. string username, string password,
  174. GdaConnectionOptions options);
  175. [DllImport("gda-2")]
  176. public static extern IntPtr gda_client_open_connection_from_string (IntPtr client,
  177. string provider,
  178. string cnc_string,
  179. GdaConnectionOptions options);
  180. [DllImport("gda-2")]
  181. public static extern bool gda_connection_is_open (IntPtr cnc);
  182. [DllImport("gda-2")]
  183. public static extern bool gda_connection_close (IntPtr cnc);
  184. [DllImport("gda-2")]
  185. public static extern string gda_connection_get_server_version (IntPtr cnc);
  186. [DllImport("gda-2")]
  187. public static extern string gda_connection_get_database (IntPtr cnc);
  188. [DllImport("gda-2")]
  189. public static extern string gda_connection_get_dsn (IntPtr cnc);
  190. [DllImport("gda-2")]
  191. public static extern string gda_connection_get_cnc_string (IntPtr cnc);
  192. [DllImport("gda-2")]
  193. public static extern string gda_connection_get_provider (IntPtr cnc);
  194. [DllImport("gda-2")]
  195. public static extern string gda_connection_get_username (IntPtr cnc);
  196. [DllImport("gda-2")]
  197. public static extern string gda_connection_get_password (IntPtr cnc);
  198. [DllImport("gda-2")]
  199. public static extern bool gda_connection_change_database (IntPtr cnc, string name);
  200. [DllImport("gda-2")]
  201. public static extern IntPtr gda_transaction_new (string name);
  202. [DllImport("gda-2")]
  203. public static extern IntPtr gda_transaction_get_name (IntPtr xaction);
  204. [DllImport("gda-2")]
  205. public static extern IntPtr gda_transaction_set_name (IntPtr xaction, string name);
  206. [DllImport("gda-2")]
  207. public static extern GdaTransactionIsolation gda_transaction_get_isolation_level (IntPtr xaction);
  208. [DllImport("gda-2")]
  209. public static extern void gda_transaction_set_isolation_level (IntPtr xaction,
  210. GdaTransactionIsolation level);
  211. [DllImport("gda-2")]
  212. public static extern bool gda_connection_begin_transaction (IntPtr cnc, IntPtr xaction);
  213. [DllImport("gda-2")]
  214. public static extern bool gda_connection_commit_transaction (IntPtr cnc, IntPtr xaction);
  215. [DllImport("gda-2")]
  216. public static extern bool gda_connection_rollback_transaction (IntPtr cnc, IntPtr xaction);
  217. [DllImport("gda-2")]
  218. public static extern IntPtr gda_connection_execute_command (IntPtr cnc, IntPtr cmd, IntPtr parameterList);
  219. [DllImport("gda-2")]
  220. public static extern int gda_connection_execute_non_query (IntPtr cnc, IntPtr command, IntPtr parameterList);
  221. [DllImport("gda-2")]
  222. public static extern IntPtr gda_connection_execute_single_command (IntPtr cnc, IntPtr command, IntPtr parameterList);
  223. [DllImport("gda-2")]
  224. public static extern IntPtr gda_connection_get_errors (IntPtr cnc);
  225. [DllImport("gda-2")]
  226. public static extern IntPtr gda_command_new (string text, GdaCommandType type, GdaCommandOptions options);
  227. [DllImport("gda-2")]
  228. public static extern void gda_command_set_text (IntPtr cmd, string text);
  229. [DllImport("gda-2")]
  230. public static extern void gda_command_set_command_type (IntPtr cmd, GdaCommandType type);
  231. [DllImport("gda-2")]
  232. public static extern string gda_error_get_description (IntPtr error);
  233. [DllImport("gda-2")]
  234. public static extern long gda_error_get_number (IntPtr error);
  235. [DllImport("gda-2")]
  236. public static extern string gda_error_get_source (IntPtr error);
  237. [DllImport("gda-2")]
  238. public static extern string gda_error_get_sqlstate (IntPtr error);
  239. }
  240. }