sqlite_functions.h

Go to the documentation of this file.

/*
 * Copyright © 2008  Red Hat, Inc. All rights reserved.
 * Copyright © 2008  Ding-Yi Chen <dchen at redhat dot com>
 *
 * This file is part of the libUnihan Project.
 *
 * 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 program; if not, write to the
 * Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA  02111-1307  USA
 */ 



#ifndef SQLITE_FUNCTIONS_H_
#define SQLITE_FUNCTIONS_H_
#include <sqlite3.h>
#include "str_functions.h"


#ifndef SQLITE_OPEN_READONLY

#define SQLITE_OPEN_READONLY         0x00000001
#endif

#ifndef SQLITE_OPEN_READWRITE

#define SQLITE_OPEN_READWRITE        0x00000002
#endif

#ifndef SQLITE_OPEN_CREATE

#define SQLITE_OPEN_CREATE           0x00000004
#endif

#ifndef SQL_RESULT_FIELD_CHUNK_SIZE

#   define SQL_RESULT_FIELD_CHUNK_SIZE 2048
#endif 

#ifndef SQL_RESULT_FIELD_ELEMENT_COUNT

#   define SQL_RESULT_FIELD_ELEMENT_COUNT 128
#endif 

#ifndef SQL_RESULT_FIELD_CONST_COUNT

#   define SQL_RESULT_FIELD_CONST_COUNT 0
#endif 

#ifndef SQL_RESULT_RESULT_CHUNK_SIZE

#   define SQL_RESULT_RESULT_CHUNK_SIZE 65536
#endif 

#ifndef SQL_RESULT_RESULT_ELEMENT_COUNT

#   define SQL_RESULT_RESULT_ELEMENT_COUNT 512
#endif 

typedef int (*sqlite_exec_callback)(gpointer user_option,gint col_num,gchar **results,gchar **col_names); 

typedef void (*sqlite_error_callback)(sqlite3 *db, const gchar *sqlClause, gint error_code, const gchar *error_msg, gpointer error_option); 


int sqlite_open(const char *filename,  sqlite3 **ppDb,  int flags);

typedef struct {
    StringList *fieldList;      
    StringList *resultList;     
    int colCount;               
    int execResult;             
    char *errMsg;               
} SQL_Result;

SQL_Result *sql_result_new();

StringList *sql_result_free(SQL_Result *sResult, gboolean freeResult);

int sqlite_count_matches(sqlite3 *db,const char * sqlClause,char **errMsg_ptr);


void sqlite_error_callback_hide_constraint_error(sqlite3 *db, const gchar *sqlClause, gint error_code, 
        const gchar *error_msg, gpointer prompt);

void sqlite_error_callback_print_message(sqlite3 *db, const gchar *sqlClause, gint error_code, 
        const gchar *error_msg, gpointer prompt);


int sqlite_exec_handle_error(sqlite3 *db, const gchar *sqlClause, sqlite_exec_callback exec_func, 
        gpointer exec_option, sqlite_error_callback error_func, gpointer error_option);

SQL_Result *sqlite_get_sql_result(sqlite3 *db, const char *sqlClause);

SQL_Result *sqlite_get_tableNames(sqlite3 *db);

StringList *sqlite_get_fieldNames(sqlite3 *db,const char * sqlClause, int *execResult_ptr, char **errMsg_ptr);

char *sqlite_value_signed_text(sqlite3_value *value);

char *sqlite_value_signed_text_buffer(char *buf,sqlite3_value *value);

#endif /* SQLITE_FUNCTIONS_H_ */

---