diff -r 823d42546cea -r 8c88756f81b0 database.c --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/database.c Tue Sep 13 22:13:02 2011 -0700 @@ -0,0 +1,67 @@ +/* vim: set noet nosta sw=4 ts=4 ft=c : */ +/* +Copyright (c) 2011, Mahlon E. Smith +All rights reserved. +Redistribution and use in source and binary forms, with or without +modification, are permitted provided that the following conditions are met: + + * Redistributions of source code must retain the above copyright + notice, this list of conditions and the following disclaimer. + + * Redistributions in binary form must reproduce the above copyright + notice, this list of conditions and the following disclaimer in the + documentation and/or other materials provided with the distribution. + + * Neither the name of Mahlon E. Smith nor the names of his + contributors may be used to endorse or promote products derived + from this software without specific prior written permission. + +THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND ANY +EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED +WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE +DISCLAIMED. IN NO EVENT SHALL THE REGENTS AND CONTRIBUTORS BE LIABLE FOR ANY +DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES +(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; +LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND +ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT +(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS +SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. +*/ + +#include "volta.h" + + +/* + * Parse command line options, perform actions, and enter accept loop. + * + */ +int +db_initialize( void ) +{ + debug( 1, LOC, "init! init! init!\n" ); + + struct sqlite3 *db; + struct sqlite3_stmt *stmt; + + if ( sqlite3_open( "testing.db", &db ) != SQLITE_OK ) { + debug( 1, LOC, "Error when initializing database: %s\n", sqlite3_errmsg(db) ); + return( sqlite3_errcode(db) ); + } + + if ( sqlite3_prepare( db, "create table foo(bar int);", -1, &stmt, NULL ) != SQLITE_OK ) { + debug( 1, LOC, "Error preparing statement: %s\n", sqlite3_errmsg(db) ); + return( sqlite3_errcode(db) ); + } + + if ( sqlite3_step( stmt ) != SQLITE_DONE ) { + debug( 1, LOC, "Error executing statement: %s\n", sqlite3_errmsg(db) ); + return( sqlite3_errcode(db) ); + } + + sqlite3_finalize( stmt ); + sqlite3_close( db ); + + debug( 1, LOC, "okay! okay! okay!\n" ); + return( SQLITE_OK ); +} +