sql.h
3.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
/* GNU Mailutils -- a suite of utilities for electronic mail
Copyright (C) 2004, 2005, 2007 Free Software Foundation, Inc.
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General
Public License along with this library; if not, write to the
Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
Boston, MA 02110-1301 USA */
#ifndef _MAILUTILS_SQL_H
#define _MAILUTILS_SQL_H
/* Loadable Modules Suppert */
#define __s_cat2__(a,b) a ## b
#define __s_cat3__(a,b,c) a ## b ## c
#define RDL_EXPORT(module,name) __s_cat3__(module,_LTX_,name)
typedef int (*mu_rdl_init_t) (void);
typedef void (*mu_rdl_done_t) (void);
#ifdef _HAVE_LIBLTDL //FIXME: Remove leading _ when SQL + ltdl works
# define MU_DECL_SQL_DISPATCH_T(mod) \
mu_sql_dispatch_t RDL_EXPORT(mod,dispatch_tab)
#else
# define MU_DECL_SQL_DISPATCH_T(mod) \
mu_sql_dispatch_t __s_cat2__(mod,_dispatch_tab)
#endif
enum mu_sql_connection_state
{
mu_sql_not_connected,
mu_sql_connected,
mu_sql_query_run,
mu_sql_result_available
};
typedef struct mu_sql_connection *mu_sql_connection_t;
struct mu_sql_connection
{
int interface;
char *server;
int port;
char *login;
char *password;
char *dbname;
void *data;
enum mu_sql_connection_state state;
};
typedef struct mu_sql_dispatch mu_sql_dispatch_t;
struct mu_sql_dispatch
{
char *name;
int port;
int (*init) (mu_sql_connection_t conn);
int (*destroy) (mu_sql_connection_t conn);
int (*connect) (mu_sql_connection_t conn);
int (*disconnect) (mu_sql_connection_t conn);
int (*query) (mu_sql_connection_t conn, char *query);
int (*store_result) (mu_sql_connection_t conn);
int (*release_result) (mu_sql_connection_t conn);
int (*num_tuples) (mu_sql_connection_t conn, size_t *np);
int (*num_columns) (mu_sql_connection_t conn, size_t *np);
int (*get_column) (mu_sql_connection_t conn, size_t nrow, size_t ncol,
char **pdata);
int (*get_field_number) (mu_sql_connection_t conn, const char *fname,
size_t *fno);
const char *(*errstr) (mu_sql_connection_t conn);
};
/* Public interfaces */
int mu_sql_interface_index (char *name);
int mu_sql_connection_init (mu_sql_connection_t *conn, int interface,
char *server, int port, char *login,
char *password, char *dbname);
int mu_sql_connection_destroy (mu_sql_connection_t *conn);
int mu_sql_connect (mu_sql_connection_t conn);
int mu_sql_disconnect (mu_sql_connection_t conn);
int mu_sql_query (mu_sql_connection_t conn, char *query);
int mu_sql_store_result (mu_sql_connection_t conn);
int mu_sql_release_result (mu_sql_connection_t conn);
int mu_sql_num_tuples (mu_sql_connection_t conn, size_t *np);
int mu_sql_num_columns (mu_sql_connection_t conn, size_t *np);
int mu_sql_get_column (mu_sql_connection_t conn, size_t nrow, size_t ncol,
char **pdata);
int mu_sql_get_field (mu_sql_connection_t conn, size_t nrow, char *fname,
char **pdata);
const char *mu_sql_strerror (mu_sql_connection_t conn);
enum mu_password_type
{
password_plaintext, /* Plaintext passwords */
password_scrambled, /* Scrambled MySQL (>=3.21) password */
password_hash, /* MD5 (or DES or whatever) hash */
};
extern enum mu_password_type mu_sql_password_type;
extern char *mu_sql_expand_query (const char *query, const char *ustr);
extern int mu_sql_getpass (const char *username, char **passwd);
extern int mu_check_mysql_scrambled_password (const char *scrambled,
const char *message);
#endif