Re: [sqlite] A memvfs for loading/saving database from buffer

[stephen liu]

http://sphivedb.googlecode.com/files/spmemvfs-0.2.src.tar.gz

The demo code:

typedef struct spmembuffer_t {
    char * data;
    int used;
    int total;
} spmembuffer_t;

typedef struct spmemvfs_db_t {
    sqlite3 * handle;
    spmembuffer_t * mem;
} spmemvfs_db_t;

void test( spmemvfs_db_t * db )
{
......
        // do whatever you want
        errcode = sqlite3_exec( db->handle, ...... );
......
}

int readFile( const char * path, spmembuffer_t * mem )
{
      // read file content from path
}

int writeFile( const char * path, spmembuffer_t * mem )
{
      // write buffer into file
}

int main( int argc, char * argv[] )
{
        const char * path = "abc.db";

        spmemvfs_db_t db;

        spmembuffer_t * mem = (spmembuffer_t*)calloc( sizeof(
spmembuffer_t ), 1 );

        spmemvfs_env_init();

        readFile( path, mem );
        spmemvfs_open_db( &db, path, mem );

        assert( db.mem == mem );

        test( &db );

        writeFile( path, db.mem );

        spmemvfs_close_db( &db );

        spmemvfs_env_fini();

        return 0;
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users