#include <stdio.h>
#include <sqlite3.h>

int main(int argc, char **argv){
	sqlite3 *db; //the database
	sqlite3_stmt *stmt; //the SQL statement

	int rc;

	if( argc!=3 ){
		fprintf(stderr, "Usage: %s <database file> <select query>\n", argv[0]);
		return(1);
	}

	rc = sqlite3_open(argv[1], &db);
	if( rc ){
		fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
		sqlite3_close(db);
		return 1;
	}

	char *sql_stmt = argv[2];

	rc = sqlite3_prepare_v2(db, sql_stmt, -1, &stmt, 0);

	if (rc != SQLITE_OK) {  
		fprintf(stderr, "Failed preparing statment: %s\n", sqlite3_errmsg(db));
		sqlite3_close(db);
		return 1;
	}    

	while((rc = sqlite3_step(stmt)) == SQLITE_ROW) {
		int col;
		for(col=0; col<sqlite3_column_count(stmt)-1; col++) {
			printf("%s|", sqlite3_column_text(stmt, col));
		}
		printf("%s", sqlite3_column_text(stmt, col));
		printf("\n");
	}

	sqlite3_finalize(stmt); //always finalize a statement
}