| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
|
|
2
|
|
|
|
|
|
|
#ifndef _DBDIMP_H |
|
3
|
|
|
|
|
|
|
#define _DBDIMP_H 1 |
|
4
|
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
#include "SQLiteXS.h" |
|
6
|
|
|
|
|
|
|
#include "sqlite3.h" |
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
#define MY_CXT_KEY "DBD::SQLite::_guts" XS_VERSION |
|
9
|
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
typedef enum { |
|
11
|
|
|
|
|
|
|
DBD_SQLITE_STRING_MODE_PV, |
|
12
|
|
|
|
|
|
|
DBD_SQLITE_STRING_MODE_BYTES, |
|
13
|
|
|
|
|
|
|
|
|
14
|
|
|
|
|
|
|
/* Leave space here so that we can use DBD_SQLITE_STRING_MODE_UNICODE_ANY |
|
15
|
|
|
|
|
|
|
as a means of checking for any unicode mode. */ |
|
16
|
|
|
|
|
|
|
|
|
17
|
|
|
|
|
|
|
DBD_SQLITE_STRING_MODE_UNICODE_NAIVE = 4, |
|
18
|
|
|
|
|
|
|
DBD_SQLITE_STRING_MODE_UNICODE_FALLBACK, |
|
19
|
|
|
|
|
|
|
DBD_SQLITE_STRING_MODE_UNICODE_STRICT, |
|
20
|
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
_DBD_SQLITE_STRING_MODE_COUNT, |
|
22
|
|
|
|
|
|
|
} dbd_sqlite_string_mode_t; |
|
23
|
|
|
|
|
|
|
|
|
24
|
|
|
|
|
|
|
#define DBD_SQLITE_STRING_MODE_UNICODE_ANY DBD_SQLITE_STRING_MODE_UNICODE_NAIVE |
|
25
|
|
|
|
|
|
|
|
|
26
|
|
|
|
|
|
|
typedef struct { |
|
27
|
|
|
|
|
|
|
dbd_sqlite_string_mode_t last_dbh_string_mode; |
|
28
|
|
|
|
|
|
|
} my_cxt_t; |
|
29
|
|
|
|
|
|
|
|
|
30
|
|
|
|
|
|
|
#define PERL_UNICODE_DOES_NOT_WORK_WELL \ |
|
31
|
|
|
|
|
|
|
(PERL_REVISION <= 5) && ((PERL_VERSION < 8) \ |
|
32
|
|
|
|
|
|
|
|| (PERL_VERSION == 8 && PERL_SUBVERSION < 5)) |
|
33
|
|
|
|
|
|
|
|
|
34
|
|
|
|
|
|
|
/* 30 second timeout by default */ |
|
35
|
|
|
|
|
|
|
#define SQL_TIMEOUT 30000 |
|
36
|
|
|
|
|
|
|
|
|
37
|
|
|
|
|
|
|
#ifndef sqlite3_int64 |
|
38
|
|
|
|
|
|
|
#define sqlite3_int64 sqlite_int64 |
|
39
|
|
|
|
|
|
|
#endif |
|
40
|
|
|
|
|
|
|
|
|
41
|
|
|
|
|
|
|
#define DBD_SQLITE_UTF8_DECODE_NAIVE(sv) SvUTF8_on(sv) |
|
42
|
|
|
|
|
|
|
|
|
43
|
|
|
|
|
|
|
#define DBD_SQLITE_UTF8_DECODE_CHECKED(sv, onfail) ( \ |
|
44
|
|
|
|
|
|
|
is_utf8_string((U8*) SvPVX(sv), SvCUR(sv)) \ |
|
45
|
|
|
|
|
|
|
? SvUTF8_on(sv) \ |
|
46
|
|
|
|
|
|
|
: onfail("Received invalid UTF-8 from SQLite; cannot decode!") \ |
|
47
|
|
|
|
|
|
|
) |
|
48
|
|
|
|
|
|
|
|
|
49
|
|
|
|
|
|
|
#define DBD_SQLITE_UTF8_DECODE_WITH_FALLBACK(sv) ( \ |
|
50
|
|
|
|
|
|
|
DBD_SQLITE_UTF8_DECODE_CHECKED(sv, warn) \ |
|
51
|
|
|
|
|
|
|
) |
|
52
|
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
#define DBD_SQLITE_UTF8_DECODE_STRICT(sv) ( \ |
|
54
|
|
|
|
|
|
|
DBD_SQLITE_UTF8_DECODE_CHECKED(sv, croak) \ |
|
55
|
|
|
|
|
|
|
) |
|
56
|
|
|
|
|
|
|
|
|
57
|
|
|
|
|
|
|
#define DBD_SQLITE_PREP_SV_FOR_SQLITE(sv, string_mode) STMT_START { \ |
|
58
|
|
|
|
|
|
|
if (string_mode & DBD_SQLITE_STRING_MODE_UNICODE_ANY) { \ |
|
59
|
|
|
|
|
|
|
sv_utf8_upgrade(sv); \ |
|
60
|
|
|
|
|
|
|
} \ |
|
61
|
|
|
|
|
|
|
else if (string_mode == DBD_SQLITE_STRING_MODE_BYTES) { \ |
|
62
|
|
|
|
|
|
|
sv_utf8_downgrade(sv, 0); \ |
|
63
|
|
|
|
|
|
|
} \ |
|
64
|
|
|
|
|
|
|
} STMT_END |
|
65
|
|
|
|
|
|
|
|
|
66
|
|
|
|
|
|
|
#define DBD_SQLITE_UTF8_DECODE_IF_NEEDED(sv, string_mode) ( \ |
|
67
|
|
|
|
|
|
|
string_mode == DBD_SQLITE_STRING_MODE_UNICODE_NAIVE \ |
|
68
|
|
|
|
|
|
|
? DBD_SQLITE_UTF8_DECODE_NAIVE(sv) \ |
|
69
|
|
|
|
|
|
|
: string_mode == DBD_SQLITE_STRING_MODE_UNICODE_FALLBACK \ |
|
70
|
|
|
|
|
|
|
? DBD_SQLITE_UTF8_DECODE_WITH_FALLBACK(sv) \ |
|
71
|
|
|
|
|
|
|
: string_mode == DBD_SQLITE_STRING_MODE_UNICODE_STRICT \ |
|
72
|
|
|
|
|
|
|
? DBD_SQLITE_UTF8_DECODE_STRICT(sv) \ |
|
73
|
|
|
|
|
|
|
: 0 \ |
|
74
|
|
|
|
|
|
|
) |
|
75
|
|
|
|
|
|
|
|
|
76
|
|
|
|
|
|
|
/* A linked list of statements prepared by this module */ |
|
77
|
|
|
|
|
|
|
typedef struct stmt_list_s stmt_list_s; |
|
78
|
|
|
|
|
|
|
|
|
79
|
|
|
|
|
|
|
struct stmt_list_s { |
|
80
|
|
|
|
|
|
|
sqlite3_stmt * stmt; |
|
81
|
|
|
|
|
|
|
stmt_list_s * prev; |
|
82
|
|
|
|
|
|
|
}; |
|
83
|
|
|
|
|
|
|
|
|
84
|
|
|
|
|
|
|
/* Driver Handle */ |
|
85
|
|
|
|
|
|
|
struct imp_drh_st { |
|
86
|
|
|
|
|
|
|
dbih_drc_t com; |
|
87
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
88
|
|
|
|
|
|
|
}; |
|
89
|
|
|
|
|
|
|
|
|
90
|
|
|
|
|
|
|
/* Database Handle */ |
|
91
|
|
|
|
|
|
|
struct imp_dbh_st { |
|
92
|
|
|
|
|
|
|
dbih_dbc_t com; |
|
93
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
94
|
|
|
|
|
|
|
sqlite3 *db; |
|
95
|
|
|
|
|
|
|
dbd_sqlite_string_mode_t string_mode; |
|
96
|
|
|
|
|
|
|
bool handle_binary_nulls; |
|
97
|
|
|
|
|
|
|
int timeout; |
|
98
|
|
|
|
|
|
|
AV *functions; |
|
99
|
|
|
|
|
|
|
AV *aggregates; |
|
100
|
|
|
|
|
|
|
SV *collation_needed_callback; |
|
101
|
|
|
|
|
|
|
bool allow_multiple_statements; |
|
102
|
|
|
|
|
|
|
bool use_immediate_transaction; |
|
103
|
|
|
|
|
|
|
bool see_if_its_a_number; |
|
104
|
|
|
|
|
|
|
int extended_result_codes; |
|
105
|
|
|
|
|
|
|
stmt_list_s * stmt_list; |
|
106
|
|
|
|
|
|
|
bool began_transaction; |
|
107
|
|
|
|
|
|
|
bool prefer_numeric_type; |
|
108
|
|
|
|
|
|
|
}; |
|
109
|
|
|
|
|
|
|
|
|
110
|
|
|
|
|
|
|
/* Statement Handle */ |
|
111
|
|
|
|
|
|
|
struct imp_sth_st { |
|
112
|
|
|
|
|
|
|
dbih_stc_t com; |
|
113
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
114
|
|
|
|
|
|
|
sqlite3_stmt *stmt; |
|
115
|
|
|
|
|
|
|
/* |
|
116
|
|
|
|
|
|
|
char **results; |
|
117
|
|
|
|
|
|
|
char **coldata; |
|
118
|
|
|
|
|
|
|
*/ |
|
119
|
|
|
|
|
|
|
int retval; |
|
120
|
|
|
|
|
|
|
int nrow; |
|
121
|
|
|
|
|
|
|
AV *params; |
|
122
|
|
|
|
|
|
|
AV *col_types; |
|
123
|
|
|
|
|
|
|
const char *unprepared_statements; |
|
124
|
|
|
|
|
|
|
}; |
|
125
|
|
|
|
|
|
|
|
|
126
|
|
|
|
|
|
|
#define dbd_init sqlite_init |
|
127
|
|
|
|
|
|
|
#define dbd_discon_all sqlite_discon_all |
|
128
|
|
|
|
|
|
|
#define dbd_db_login6 sqlite_db_login6 |
|
129
|
|
|
|
|
|
|
#define dbd_db_commit sqlite_db_commit |
|
130
|
|
|
|
|
|
|
#define dbd_db_rollback sqlite_db_rollback |
|
131
|
|
|
|
|
|
|
#define dbd_db_disconnect sqlite_db_disconnect |
|
132
|
|
|
|
|
|
|
#define dbd_db_destroy sqlite_db_destroy |
|
133
|
|
|
|
|
|
|
#define dbd_db_STORE_attrib sqlite_db_STORE_attrib |
|
134
|
|
|
|
|
|
|
#define dbd_db_FETCH_attrib sqlite_db_FETCH_attrib |
|
135
|
|
|
|
|
|
|
#define dbd_db_last_insert_id sqlite_db_last_insert_id |
|
136
|
|
|
|
|
|
|
#define dbd_st_prepare_sv sqlite_st_prepare_sv |
|
137
|
|
|
|
|
|
|
#define dbd_st_rows sqlite_st_rows |
|
138
|
|
|
|
|
|
|
#define dbd_st_execute sqlite_st_execute |
|
139
|
|
|
|
|
|
|
#define dbd_st_fetch sqlite_st_fetch |
|
140
|
|
|
|
|
|
|
#define dbd_st_finish3 sqlite_st_finish3 |
|
141
|
|
|
|
|
|
|
#define dbd_st_finish sqlite_st_finish |
|
142
|
|
|
|
|
|
|
#define dbd_st_destroy sqlite_st_destroy |
|
143
|
|
|
|
|
|
|
#define dbd_st_blob_read sqlite_st_blob_read |
|
144
|
|
|
|
|
|
|
#define dbd_st_STORE_attrib sqlite_st_STORE_attrib |
|
145
|
|
|
|
|
|
|
#define dbd_st_FETCH_attrib sqlite_st_FETCH_attrib |
|
146
|
|
|
|
|
|
|
#define dbd_bind_ph sqlite_bind_ph |
|
147
|
|
|
|
|
|
|
#define dbd_st_bind_col sqlite_bind_col |
|
148
|
|
|
|
|
|
|
|
|
149
|
|
|
|
|
|
|
typedef struct aggrInfo aggrInfo; |
|
150
|
|
|
|
|
|
|
struct aggrInfo { |
|
151
|
|
|
|
|
|
|
SV *aggr_inst; |
|
152
|
|
|
|
|
|
|
SV *err; |
|
153
|
|
|
|
|
|
|
int inited; |
|
154
|
|
|
|
|
|
|
}; |
|
155
|
|
|
|
|
|
|
|
|
156
|
|
|
|
|
|
|
|
|
157
|
|
|
|
|
|
|
int sqlite_db_create_function(pTHX_ SV *dbh, const char *name, int argc, SV *func, int flags); |
|
158
|
|
|
|
|
|
|
|
|
159
|
|
|
|
|
|
|
#ifndef SQLITE_OMIT_LOAD_EXTENSION |
|
160
|
|
|
|
|
|
|
int sqlite_db_enable_load_extension(pTHX_ SV *dbh, int onoff); |
|
161
|
|
|
|
|
|
|
int sqlite_db_load_extension(pTHX_ SV *dbh, const char *file, const char *proc); |
|
162
|
|
|
|
|
|
|
#endif |
|
163
|
|
|
|
|
|
|
|
|
164
|
|
|
|
|
|
|
int sqlite_db_create_aggregate(pTHX_ SV *dbh, const char *name, int argc, SV *aggr, int flags ); |
|
165
|
|
|
|
|
|
|
int sqlite_db_create_collation(pTHX_ SV *dbh, const char *name, SV *func); |
|
166
|
|
|
|
|
|
|
int sqlite_db_progress_handler(pTHX_ SV *dbh, int n_opcodes, SV *handler); |
|
167
|
|
|
|
|
|
|
int sqlite_bind_col( SV *sth, imp_sth_t *imp_sth, SV *col, SV *ref, IV sql_type, SV *attribs ); |
|
168
|
|
|
|
|
|
|
int sqlite_db_busy_timeout (pTHX_ SV *dbh, SV *timeout ); |
|
169
|
|
|
|
|
|
|
int sqlite_db_backup_from_file(pTHX_ SV *dbh, char *filename); |
|
170
|
|
|
|
|
|
|
int sqlite_db_backup_to_file(pTHX_ SV *dbh, char *filename); |
|
171
|
|
|
|
|
|
|
int sqlite_db_backup_from_dbh(pTHX_ SV *dbh, SV *from); |
|
172
|
|
|
|
|
|
|
int sqlite_db_backup_to_dbh(pTHX_ SV *dbh, SV *to); |
|
173
|
|
|
|
|
|
|
void sqlite_db_collation_needed(pTHX_ SV *dbh, SV *callback ); |
|
174
|
|
|
|
|
|
|
SV* sqlite_db_commit_hook( pTHX_ SV *dbh, SV *hook ); |
|
175
|
|
|
|
|
|
|
SV* sqlite_db_rollback_hook( pTHX_ SV *dbh, SV *hook ); |
|
176
|
|
|
|
|
|
|
SV* sqlite_db_update_hook( pTHX_ SV *dbh, SV *hook ); |
|
177
|
|
|
|
|
|
|
int sqlite_db_set_authorizer( pTHX_ SV *dbh, SV *authorizer ); |
|
178
|
|
|
|
|
|
|
AV* sqlite_compile_options(); |
|
179
|
|
|
|
|
|
|
int sqlite_db_trace(pTHX_ SV *dbh, SV *func); |
|
180
|
|
|
|
|
|
|
int sqlite_db_profile(pTHX_ SV *dbh, SV *func); |
|
181
|
|
|
|
|
|
|
HV* sqlite_db_table_column_metadata(pTHX_ SV *dbh, SV *dbname, SV *tablename, SV *columnname); |
|
182
|
|
|
|
|
|
|
HV* _sqlite_db_status(pTHX_ SV *dbh, int reset); |
|
183
|
|
|
|
|
|
|
SV* sqlite_db_filename(pTHX_ SV *dbh); |
|
184
|
|
|
|
|
|
|
int sqlite_db_register_fts3_perl_tokenizer(pTHX_ SV *dbh); |
|
185
|
|
|
|
|
|
|
HV* _sqlite_status(int reset); |
|
186
|
|
|
|
|
|
|
HV* _sqlite_st_status(pTHX_ SV *sth, int reset); |
|
187
|
|
|
|
|
|
|
int sqlite_db_create_module(pTHX_ SV *dbh, const char *name, const char *perl_class); |
|
188
|
|
|
|
|
|
|
int sqlite_db_limit(pTHX_ SV *dbh, int id, int new_value); |
|
189
|
|
|
|
|
|
|
int sqlite_db_config(pTHX_ SV *dbh, int id, int new_value); |
|
190
|
|
|
|
|
|
|
int sqlite_db_get_autocommit(pTHX_ SV *dbh); |
|
191
|
|
|
|
|
|
|
int sqlite_db_txn_state(pTHX_ SV *dbh, SV *schema); |
|
192
|
|
|
|
|
|
|
int sqlite_db_do_sv(SV *dbh, imp_dbh_t *imp_dbh, SV *sv_statement); |
|
193
|
|
|
|
|
|
|
void init_cxt(); |
|
194
|
|
|
|
|
|
|
|
|
195
|
|
|
|
|
|
|
|
|
196
|
|
|
|
|
|
|
#ifdef SvUTF8_on |
|
197
|
|
|
|
|
|
|
|
|
198
|
|
|
|
|
|
|
static SV * |
|
199
|
0
|
|
|
|
|
|
newUTF8SVpv(char *s, STRLEN len) { |
|
200
|
|
|
|
|
|
|
dTHX; |
|
201
|
|
|
|
|
|
|
register SV *sv; |
|
202
|
|
|
|
|
|
|
|
|
203
|
0
|
|
|
|
|
|
sv = newSVpv(s, len); |
|
204
|
0
|
|
|
|
|
|
SvUTF8_on(sv); |
|
205
|
0
|
|
|
|
|
|
return sv; |
|
206
|
|
|
|
|
|
|
} |
|
207
|
|
|
|
|
|
|
|
|
208
|
|
|
|
|
|
|
static SV * |
|
209
|
0
|
|
|
|
|
|
newUTF8SVpvn(char *s, STRLEN len) { |
|
210
|
|
|
|
|
|
|
dTHX; |
|
211
|
|
|
|
|
|
|
register SV *sv; |
|
212
|
|
|
|
|
|
|
|
|
213
|
0
|
|
|
|
|
|
sv = newSV(0); |
|
214
|
0
|
|
|
|
|
|
sv_setpvn(sv, s, len); |
|
215
|
0
|
|
|
|
|
|
SvUTF8_on(sv); |
|
216
|
0
|
|
|
|
|
|
return sv; |
|
217
|
|
|
|
|
|
|
} |
|
218
|
|
|
|
|
|
|
|
|
219
|
|
|
|
|
|
|
#else /* #ifdef SvUTF8_on */ |
|
220
|
|
|
|
|
|
|
|
|
221
|
|
|
|
|
|
|
#define newUTF8SVpv newSVpv |
|
222
|
|
|
|
|
|
|
#define newUTF8SVpvn newSVpvn |
|
223
|
|
|
|
|
|
|
#define SvUTF8_on(a) (a) |
|
224
|
|
|
|
|
|
|
#define SvUTF8_off(a) (a) |
|
225
|
|
|
|
|
|
|
#define sv_utf8_upgrade(a) (a) |
|
226
|
|
|
|
|
|
|
|
|
227
|
|
|
|
|
|
|
#endif /* #ifdef SvUTF8_on */ |
|
228
|
|
|
|
|
|
|
|
|
229
|
|
|
|
|
|
|
#ifdef _MSC_VER |
|
230
|
|
|
|
|
|
|
# define atoll _atoi64 |
|
231
|
|
|
|
|
|
|
#endif |
|
232
|
|
|
|
|
|
|
|
|
233
|
|
|
|
|
|
|
#endif /* #ifndef _DBDIMP_H */ |