| line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
|
1
|
|
|
|
|
|
|
|
|
2
|
|
|
|
|
|
|
#ifndef _DBDIMP_H |
|
3
|
|
|
|
|
|
|
#define _DBDIMP_H 1 |
|
4
|
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
#include "SQLeetXS.h" |
|
6
|
|
|
|
|
|
|
#include "sqlite3.h" |
|
7
|
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
#define MY_CXT_KEY "DBD::SQLeet::_guts" XS_VERSION |
|
9
|
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
typedef struct { |
|
11
|
|
|
|
|
|
|
int last_dbh_is_unicode; |
|
12
|
|
|
|
|
|
|
} my_cxt_t; |
|
13
|
|
|
|
|
|
|
|
|
14
|
|
|
|
|
|
|
#define PERL_UNICODE_DOES_NOT_WORK_WELL \ |
|
15
|
|
|
|
|
|
|
(PERL_REVISION <= 5) && ((PERL_VERSION < 8) \ |
|
16
|
|
|
|
|
|
|
|| (PERL_VERSION == 8 && PERL_SUBVERSION < 5)) |
|
17
|
|
|
|
|
|
|
|
|
18
|
|
|
|
|
|
|
/* 30 second timeout by default */ |
|
19
|
|
|
|
|
|
|
#define SQL_TIMEOUT 30000 |
|
20
|
|
|
|
|
|
|
|
|
21
|
|
|
|
|
|
|
#ifndef sqlite3_int64 |
|
22
|
|
|
|
|
|
|
#define sqlite3_int64 sqlite_int64 |
|
23
|
|
|
|
|
|
|
#endif |
|
24
|
|
|
|
|
|
|
|
|
25
|
|
|
|
|
|
|
/* A linked list of statements prepared by this module */ |
|
26
|
|
|
|
|
|
|
typedef struct stmt_list_s stmt_list_s; |
|
27
|
|
|
|
|
|
|
|
|
28
|
|
|
|
|
|
|
struct stmt_list_s { |
|
29
|
|
|
|
|
|
|
sqlite3_stmt * stmt; |
|
30
|
|
|
|
|
|
|
stmt_list_s * prev; |
|
31
|
|
|
|
|
|
|
}; |
|
32
|
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
/* Driver Handle */ |
|
34
|
|
|
|
|
|
|
struct imp_drh_st { |
|
35
|
|
|
|
|
|
|
dbih_drc_t com; |
|
36
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
37
|
|
|
|
|
|
|
}; |
|
38
|
|
|
|
|
|
|
|
|
39
|
|
|
|
|
|
|
/* Database Handle */ |
|
40
|
|
|
|
|
|
|
struct imp_dbh_st { |
|
41
|
|
|
|
|
|
|
dbih_dbc_t com; |
|
42
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
43
|
|
|
|
|
|
|
sqlite3 *db; |
|
44
|
|
|
|
|
|
|
bool unicode; |
|
45
|
|
|
|
|
|
|
bool handle_binary_nulls; |
|
46
|
|
|
|
|
|
|
int timeout; |
|
47
|
|
|
|
|
|
|
AV *functions; |
|
48
|
|
|
|
|
|
|
AV *aggregates; |
|
49
|
|
|
|
|
|
|
SV *collation_needed_callback; |
|
50
|
|
|
|
|
|
|
bool allow_multiple_statements; |
|
51
|
|
|
|
|
|
|
bool use_immediate_transaction; |
|
52
|
|
|
|
|
|
|
bool see_if_its_a_number; |
|
53
|
|
|
|
|
|
|
int extended_result_codes; |
|
54
|
|
|
|
|
|
|
stmt_list_s * stmt_list; |
|
55
|
|
|
|
|
|
|
bool began_transaction; |
|
56
|
|
|
|
|
|
|
}; |
|
57
|
|
|
|
|
|
|
|
|
58
|
|
|
|
|
|
|
/* Statement Handle */ |
|
59
|
|
|
|
|
|
|
struct imp_sth_st { |
|
60
|
|
|
|
|
|
|
dbih_stc_t com; |
|
61
|
|
|
|
|
|
|
/* sqlite specific bits */ |
|
62
|
|
|
|
|
|
|
sqlite3_stmt *stmt; |
|
63
|
|
|
|
|
|
|
/* |
|
64
|
|
|
|
|
|
|
char **results; |
|
65
|
|
|
|
|
|
|
char **coldata; |
|
66
|
|
|
|
|
|
|
*/ |
|
67
|
|
|
|
|
|
|
int retval; |
|
68
|
|
|
|
|
|
|
int nrow; |
|
69
|
|
|
|
|
|
|
AV *params; |
|
70
|
|
|
|
|
|
|
AV *col_types; |
|
71
|
|
|
|
|
|
|
const char *unprepared_statements; |
|
72
|
|
|
|
|
|
|
}; |
|
73
|
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
#define dbd_init sqlite_init |
|
75
|
|
|
|
|
|
|
#define dbd_discon_all sqlite_discon_all |
|
76
|
|
|
|
|
|
|
#define dbd_db_login6 sqlite_db_login6 |
|
77
|
|
|
|
|
|
|
#define dbd_db_commit sqlite_db_commit |
|
78
|
|
|
|
|
|
|
#define dbd_db_rollback sqlite_db_rollback |
|
79
|
|
|
|
|
|
|
#define dbd_db_disconnect sqlite_db_disconnect |
|
80
|
|
|
|
|
|
|
#define dbd_db_destroy sqlite_db_destroy |
|
81
|
|
|
|
|
|
|
#define dbd_db_STORE_attrib sqlite_db_STORE_attrib |
|
82
|
|
|
|
|
|
|
#define dbd_db_FETCH_attrib sqlite_db_FETCH_attrib |
|
83
|
|
|
|
|
|
|
#define dbd_db_last_insert_id sqlite_db_last_insert_id |
|
84
|
|
|
|
|
|
|
#define dbd_st_prepare_sv sqlite_st_prepare_sv |
|
85
|
|
|
|
|
|
|
#define dbd_st_rows sqlite_st_rows |
|
86
|
|
|
|
|
|
|
#define dbd_st_execute sqlite_st_execute |
|
87
|
|
|
|
|
|
|
#define dbd_st_fetch sqlite_st_fetch |
|
88
|
|
|
|
|
|
|
#define dbd_st_finish3 sqlite_st_finish3 |
|
89
|
|
|
|
|
|
|
#define dbd_st_finish sqlite_st_finish |
|
90
|
|
|
|
|
|
|
#define dbd_st_destroy sqlite_st_destroy |
|
91
|
|
|
|
|
|
|
#define dbd_st_blob_read sqlite_st_blob_read |
|
92
|
|
|
|
|
|
|
#define dbd_st_STORE_attrib sqlite_st_STORE_attrib |
|
93
|
|
|
|
|
|
|
#define dbd_st_FETCH_attrib sqlite_st_FETCH_attrib |
|
94
|
|
|
|
|
|
|
#define dbd_bind_ph sqlite_bind_ph |
|
95
|
|
|
|
|
|
|
#define dbd_st_bind_col sqlite_bind_col |
|
96
|
|
|
|
|
|
|
|
|
97
|
|
|
|
|
|
|
typedef struct aggrInfo aggrInfo; |
|
98
|
|
|
|
|
|
|
struct aggrInfo { |
|
99
|
|
|
|
|
|
|
SV *aggr_inst; |
|
100
|
|
|
|
|
|
|
SV *err; |
|
101
|
|
|
|
|
|
|
int inited; |
|
102
|
|
|
|
|
|
|
}; |
|
103
|
|
|
|
|
|
|
|
|
104
|
|
|
|
|
|
|
|
|
105
|
|
|
|
|
|
|
int sqlite_db_create_function(pTHX_ SV *dbh, const char *name, int argc, SV *func, int flags); |
|
106
|
|
|
|
|
|
|
|
|
107
|
|
|
|
|
|
|
#ifndef SQLITE_OMIT_LOAD_EXTENSION |
|
108
|
|
|
|
|
|
|
int sqlite_db_enable_load_extension(pTHX_ SV *dbh, int onoff); |
|
109
|
|
|
|
|
|
|
int sqlite_db_load_extension(pTHX_ SV *dbh, const char *file, const char *proc); |
|
110
|
|
|
|
|
|
|
#endif |
|
111
|
|
|
|
|
|
|
|
|
112
|
|
|
|
|
|
|
int sqlite_db_create_aggregate(pTHX_ SV *dbh, const char *name, int argc, SV *aggr, int flags ); |
|
113
|
|
|
|
|
|
|
int sqlite_db_create_collation(pTHX_ SV *dbh, const char *name, SV *func); |
|
114
|
|
|
|
|
|
|
int sqlite_db_progress_handler(pTHX_ SV *dbh, int n_opcodes, SV *handler); |
|
115
|
|
|
|
|
|
|
int sqlite_bind_col( SV *sth, imp_sth_t *imp_sth, SV *col, SV *ref, IV sql_type, SV *attribs ); |
|
116
|
|
|
|
|
|
|
int sqlite_db_busy_timeout (pTHX_ SV *dbh, SV *timeout ); |
|
117
|
|
|
|
|
|
|
int sqlite_db_backup_from_file(pTHX_ SV *dbh, char *filename); |
|
118
|
|
|
|
|
|
|
int sqlite_db_backup_to_file(pTHX_ SV *dbh, char *filename); |
|
119
|
|
|
|
|
|
|
void sqlite_db_collation_needed(pTHX_ SV *dbh, SV *callback ); |
|
120
|
|
|
|
|
|
|
SV* sqlite_db_commit_hook( pTHX_ SV *dbh, SV *hook ); |
|
121
|
|
|
|
|
|
|
SV* sqlite_db_rollback_hook( pTHX_ SV *dbh, SV *hook ); |
|
122
|
|
|
|
|
|
|
SV* sqlite_db_update_hook( pTHX_ SV *dbh, SV *hook ); |
|
123
|
|
|
|
|
|
|
int sqlite_db_set_authorizer( pTHX_ SV *dbh, SV *authorizer ); |
|
124
|
|
|
|
|
|
|
AV* sqlite_compile_options(); |
|
125
|
|
|
|
|
|
|
int sqlite_db_trace(pTHX_ SV *dbh, SV *func); |
|
126
|
|
|
|
|
|
|
int sqlite_db_profile(pTHX_ SV *dbh, SV *func); |
|
127
|
|
|
|
|
|
|
HV* sqlite_db_table_column_metadata(pTHX_ SV *dbh, SV *dbname, SV *tablename, SV *columnname); |
|
128
|
|
|
|
|
|
|
HV* _sqlite_db_status(pTHX_ SV *dbh, int reset); |
|
129
|
|
|
|
|
|
|
SV* sqlite_db_filename(pTHX_ SV *dbh); |
|
130
|
|
|
|
|
|
|
int sqlite_db_register_fts3_perl_tokenizer(pTHX_ SV *dbh); |
|
131
|
|
|
|
|
|
|
HV* _sqlite_status(int reset); |
|
132
|
|
|
|
|
|
|
HV* _sqlite_st_status(pTHX_ SV *sth, int reset); |
|
133
|
|
|
|
|
|
|
int sqlite_db_create_module(pTHX_ SV *dbh, const char *name, const char *perl_class); |
|
134
|
|
|
|
|
|
|
int sqlite_db_do_sv(SV *dbh, imp_dbh_t *imp_dbh, SV *sv_statement); |
|
135
|
|
|
|
|
|
|
void init_cxt(); |
|
136
|
|
|
|
|
|
|
|
|
137
|
|
|
|
|
|
|
|
|
138
|
|
|
|
|
|
|
#ifdef SvUTF8_on |
|
139
|
|
|
|
|
|
|
|
|
140
|
|
|
|
|
|
|
static SV * |
|
141
|
0
|
|
|
|
|
|
newUTF8SVpv(char *s, STRLEN len) { |
|
142
|
|
|
|
|
|
|
dTHX; |
|
143
|
|
|
|
|
|
|
register SV *sv; |
|
144
|
|
|
|
|
|
|
|
|
145
|
0
|
|
|
|
|
|
sv = newSVpv(s, len); |
|
146
|
0
|
|
|
|
|
|
SvUTF8_on(sv); |
|
147
|
0
|
|
|
|
|
|
return sv; |
|
148
|
|
|
|
|
|
|
} |
|
149
|
|
|
|
|
|
|
|
|
150
|
|
|
|
|
|
|
static SV * |
|
151
|
0
|
|
|
|
|
|
newUTF8SVpvn(char *s, STRLEN len) { |
|
152
|
|
|
|
|
|
|
dTHX; |
|
153
|
|
|
|
|
|
|
register SV *sv; |
|
154
|
|
|
|
|
|
|
|
|
155
|
0
|
|
|
|
|
|
sv = newSV(0); |
|
156
|
0
|
|
|
|
|
|
sv_setpvn(sv, s, len); |
|
157
|
0
|
|
|
|
|
|
SvUTF8_on(sv); |
|
158
|
0
|
|
|
|
|
|
return sv; |
|
159
|
|
|
|
|
|
|
} |
|
160
|
|
|
|
|
|
|
|
|
161
|
|
|
|
|
|
|
#else /* #ifdef SvUTF8_on */ |
|
162
|
|
|
|
|
|
|
|
|
163
|
|
|
|
|
|
|
#define newUTF8SVpv newSVpv |
|
164
|
|
|
|
|
|
|
#define newUTF8SVpvn newSVpvn |
|
165
|
|
|
|
|
|
|
#define SvUTF8_on(a) (a) |
|
166
|
|
|
|
|
|
|
#define SvUTF8_off(a) (a) |
|
167
|
|
|
|
|
|
|
#define sv_utf8_upgrade(a) (a) |
|
168
|
|
|
|
|
|
|
|
|
169
|
|
|
|
|
|
|
#endif /* #ifdef SvUTF8_on */ |
|
170
|
|
|
|
|
|
|
|
|
171
|
|
|
|
|
|
|
#ifdef _MSC_VER |
|
172
|
|
|
|
|
|
|
# define atoll _atoi64 |
|
173
|
|
|
|
|
|
|
#endif |
|
174
|
|
|
|
|
|
|
|
|
175
|
|
|
|
|
|
|
#endif /* #ifndef _DBDIMP_H */ |