libgda.cs 8.4 KB

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