mysql.h

MySQL的ODBC接口程序源代码

/* Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
   This file is public domain and comes with NO WARRANTY of any kind */

/* defines for libmysql */

#ifndef _mysql_h
#define _mysql_h
#ifdef	__cplusplus
extern "C" {
#endif

#ifndef _global_h				/* If not standard header */
#include <sys/types.h>
typedef char my_bool;
typedef char byte;
typedef char * gptr;
#ifndef Socket_defined
#ifdef __WIN32__
#define Socket SOCKET
#else
typedef int Socket;
#endif
#endif
#endif
#include "mysql_com.h"
#include "mysql_version.h"

extern unsigned int mysql_port;
extern char *mysql_unix_port;

#define IS_PRI_KEY(n)	((n) & PRI_KEY_FLAG)
#define IS_NOT_NULL(n)	((n) & NOT_NULL_FLAG)
#define IS_BLOB(n)	((n) & BLOB_FLAG)
#define IS_NUM(t)	((t) <= FIELD_TYPE_INT24)

typedef struct st_mysql_field {
  char *name;			/* Name of column */
  char *table;			/* Table of column if column was a field */
  char *def;			/* Default value (set by mysql_list_fields) */
  enum enum_field_types type;	/* Type of field. Se mysql_com.h for types */
  unsigned int length;		/* Width of column */
  unsigned int max_length;	/* Max width of selected set */
  unsigned int flags;		/* Div flags */
  unsigned int decimals;	/* Number of decimals in field */
} MYSQL_FIELD;

typedef byte **MYSQL_ROW;		/* return data as array of strings */
typedef unsigned int MYSQL_FIELD_OFFSET; /* offset to current field */

typedef struct st_mysql_rows {
  struct st_mysql_rows *next;		/* list of rows */
  MYSQL_ROW data;
} MYSQL_ROWS;

typedef MYSQL_ROWS *MYSQL_ROW_OFFSET;	/* offset to current row */

typedef struct st_mysql_data {
  unsigned int rows;
  unsigned int fields;
  MYSQL_ROWS *data;
  MEM_ROOT alloc;
} MYSQL_DATA;

enum mysql_status { MYSQL_STATUS_READY,MYSQL_STATUS_GET_RESULT,
		    MYSQL_STATUS_USE_RESULT};

typedef struct st_mysql {
  NET		net;			/* Communication parameters */
  char		*host,*user,*passwd,*unix_socket,*server_version,*host_info,
    		*info,*db;
  unsigned int	port,client_flag,server_capabilities;
  unsigned int	protocol_version;
  unsigned int	field_count;
  unsigned long thread_id;		/* Id for connection in server */
  unsigned long affected_rows;
  unsigned long insert_id;		/* id if insert on table with NEXTNR */
  unsigned long extra_info;		/* Used by mysqlshow */
  enum mysql_status status;
  MYSQL_FIELD	*fields;
  MEM_ROOT	field_alloc;
  my_bool	free_me;		/* If free in mysql_close */
  my_bool	reconnect;		/* set to 1 if automatic reconnect */
} MYSQL;


typedef struct st_mysql_res {
  unsigned long row_count;
  unsigned int	field_count, current_field;
  MYSQL_FIELD	*fields;
  MYSQL_DATA	*data;
  MYSQL_ROWS	*data_cursor;
  MEM_ROOT	field_alloc;
  MYSQL_ROW	row;			/* If unbuffered read */
  MYSQL_ROW	current_row;		/* buffer to current row */
  unsigned int	*lengths;		/* column lengths of current row */
  MYSQL		*handle;		/* for unbuffered reads */
  my_bool	eof;			/* Used my mysql_fetch_row */
} MYSQL_RES;


#define mysql_num_rows(res) (res)->row_count
#define mysql_num_fields(res) (res)->field_count
#define mysql_eof(res) (res)->eof
#define mysql_fetch_field_direct(res,fieldnr) ((res)->fields[fieldnr])
#define mysql_fetch_fields(res) (res)->fields
#define mysql_row_tell(res) (res)->data_cursor
#define mysql_field_tell(res) (res)->current_field

#define mysql_affected_rows(mysql) (mysql)->affected_rows
#define mysql_insert_id(mysql) (mysql)->insert_id
#define mysql_error(mysql) (mysql)->net.last_error
#define mysql_errno(mysql) (mysql)->net.last_errno
#define mysql_info(mysql) (mysql)->info
#define mysql_reload(mysql) mysql_refresh((mysql),REFRESH_GRANT)
#define mysql_thread_id(mysql) (mysql)->thread_id

MYSQL		*mysql_connect(MYSQL *mysql, const char *host,
			       const char *user, const char *passwd);
MYSQL		*mysql_real_connect(MYSQL *mysql, const char *host,
				    const char *user, const char *passwd,
				    const char *db,
				    unsigned int port,const char *unix_socket,
				    unsigned int clientflag);
void		mysql_close(MYSQL *sock);
int		mysql_select_db(MYSQL *mysql, const char *db);
int		mysql_query(MYSQL *mysql, const char *q);
int		mysql_real_query(MYSQL *mysql, const char *q,
				 unsigned int length);
int		mysql_create_db(MYSQL *mysql, const char *DB);
int		mysql_drop_db(MYSQL *mysql, const char *DB);
int		mysql_shutdown(MYSQL *mysql);
int		mysql_dump_debug_info(MYSQL *mysql);
int		mysql_refresh(MYSQL *mysql,unsigned int refresh_options);
int		mysql_kill(MYSQL *mysql,unsigned long pid);
char		*mysql_stat(MYSQL *mysql);
char		*mysql_get_server_info(MYSQL *mysql);
char		*mysql_get_client_info(void);
char		*mysql_get_host_info(MYSQL *mysql);
unsigned int	mysql_get_proto_info(MYSQL *mysql);
MYSQL_RES	*mysql_list_dbs(MYSQL *mysql,const char *wild);
MYSQL_RES	*mysql_list_tables(MYSQL *mysql,const char *wild);
MYSQL_RES	*mysql_list_fields(MYSQL *mysql, const char *table,
				   const char *wild);
MYSQL_RES	*mysql_list_processes(MYSQL *mysql);
MYSQL_RES	*mysql_store_result(MYSQL *mysql);
MYSQL_RES	*mysql_use_result(MYSQL *mysql);
void		mysql_free_result(MYSQL_RES *result);
void		mysql_data_seek(MYSQL_RES *mysql,unsigned int offset);
MYSQL_ROW_OFFSET mysql_row_seek(MYSQL_RES *mysql, MYSQL_ROW_OFFSET);
MYSQL_FIELD_OFFSET mysql_field_seek(MYSQL_RES *mysql,MYSQL_FIELD_OFFSET offset);
MYSQL_ROW	mysql_fetch_row(MYSQL_RES *mysql);
unsigned int	*mysql_fetch_lengths(MYSQL_RES *mysql);
MYSQL_FIELD	*mysql_fetch_field(MYSQL_RES *handle);
unsigned int	mysql_escape_string(char *to,char *from,unsigned int length);
void		mysql_debug(char *debug);

/* new api functions */

#define HAVE_MYSQL_REAL_CONNECT

#ifdef	__cplusplus
}
#endif
#endif