4
** The author disclaims copyright to this source code. In place of
5
** a legal notice, here is a blessing:
7
** May you do good and not evil.
8
** May you find forgiveness for yourself and forgive others.
9
** May you share freely, never taking more than you give.
11
*************************************************************************
12
** Main file for the SQLite library. The routines in this file
13
** implement the programmer interface to the library. Routines in
14
** other files are for internal use by SQLite and should not be
15
** accessed by users of the library.
17
** $Id: legacy.c,v 1.7 2004/09/06 17:34:13 drh Exp $
20
#include "sqliteInt.h"
25
** Execute SQL code. Return one of the SQLITE_ success/failure
26
** codes. Also write an error message into memory obtained from
27
** malloc() and make *pzErrMsg point to that message.
29
** If the SQL is a query, then for each row in the query result
30
** the xCallback() function is called. pArg becomes the first
31
** argument to xCallback(). If xCallback=NULL then no callback
32
** is invoked, even for queries.
35
sqlite3 *db, /* The database on which the SQL executes */
36
const char *zSql, /* The SQL to be executed */
37
sqlite3_callback xCallback, /* Invoke this callback routine */
38
void *pArg, /* First argument to xCallback() */
39
char **pzErrMsg /* Write error messages here */
42
const char *zLeftover;
43
sqlite3_stmt *pStmt = 0;
50
if( zSql==0 ) return SQLITE_OK;
51
while( (rc==SQLITE_OK || (rc==SQLITE_SCHEMA && (++nRetry)<2)) && zSql[0] ){
56
rc = sqlite3_prepare(db, zSql, -1, &pStmt, &zLeftover);
58
if( pStmt ) sqlite3_finalize(pStmt);
62
/* this happens for a comment or white-space */
67
db->nChange += nChange;
70
nCol = sqlite3_column_count(pStmt);
71
azCols = sqliteMalloc(2*nCol*sizeof(const char *));
72
if( nCol && !azCols ){
79
rc = sqlite3_step(pStmt);
81
/* Invoke the callback function if required */
82
if( xCallback && (SQLITE_ROW==rc ||
83
(SQLITE_DONE==rc && !nCallback && db->flags&SQLITE_NullCallback)) ){
85
for(i=0; i<nCol; i++){
86
azCols[i] = (char *)sqlite3_column_name(pStmt, i);
91
azVals = &azCols[nCol];
92
for(i=0; i<nCol; i++){
93
azVals[i] = (char *)sqlite3_column_text(pStmt, i);
96
if( xCallback(pArg, nCol, azVals, azCols) ){
102
if( rc!=SQLITE_ROW ){
103
rc = sqlite3_finalize(pStmt);
106
nChange = db->nChange;
108
if( rc!=SQLITE_SCHEMA ){
111
while( isspace((unsigned char)zSql[0]) ) zSql++;
122
if( pStmt ) sqlite3_finalize(pStmt);
123
if( azCols ) sqliteFree(azCols);
125
if( sqlite3_malloc_failed ){
128
if( rc!=SQLITE_OK && rc==sqlite3_errcode(db) && pzErrMsg ){
129
*pzErrMsg = malloc(1+strlen(sqlite3_errmsg(db)));
131
strcpy(*pzErrMsg, sqlite3_errmsg(db));
133
}else if( pzErrMsg ){