Rather than doing malloc you can mmap the file and then copy it into the
blob.
Peter A. Friend wrote:
> On Feb 27, 2008, at 4:48 PM, Mike McGonagle wrote:
>
>> Hello all,
>> I was hoping that someone might share some tips on working with
>> Blobs? I
>> would like to be able to store some images and sound files in a
>> database,
>> but never having dealt with them, I am kind of at a loss for some
>> examples.
>> I have looked on the web, and there are few examples that were of use.
>
> Well, I wrote a quick and dirty program for stuffing image files into
> a database. You just provide a directory and it stats() each file,
> allocates enough space for the image data, then loads it from disk.
> Sql statement is something like:
>
> char* sql = "insert into i (name, data) values (?, ?);";
>
> Of course if your images are huge this method coud be problematic. I
> believe SQLite supports an incremental way to do this but I haven't
> looked at those calls yet.
>
> while ( (dentry = readdir(dir)) != '\0') {
> if (dentry->d_name[0] == '.')
> continue;
>
> if (fd != -1) {
> close(fd);
> fd = -1;
> }
>
> if (data != '\0') {
> free(data);
> data = '\0';
> }
>
> snprintf(fname, sizeof(fname), "%s/%s", newdir, dentry->d_name);
> stat(fname, &sb);
>
> if ( (data = malloc(sb.st_size)) == '\0') {
> fprintf(stderr, "malloc() failed\n");
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> if ( (fd = open(fname, O_RDONLY, 0000)) == -1) {
> fprintf(stderr, "open() failed\n");
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> if ( (retval = read(fd, data, sb.st_size)) == -1) {
> fprintf(stderr, "read() failed\n");
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> if (retval != sb.st_size) {
> fprintf(stderr, "read() failed\n");
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> rc = sqlite3_bind_text(stmt, 1, dentry->d_name, dentry->d_namlen,
> SQLITE_STATIC);
>
> if (rc != SQLITE_OK) {
> fprintf(stderr, "sqlite3_bind_text() %s\n", sqlite3_errmsg
> (db));
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> rc = sqlite3_bind_blob(stmt, 2, data, sb.st_size, SQLITE_STATIC);
>
> if (rc != SQLITE_OK) {
> fprintf(stderr, "sqlite3_bind_blob() %s\n", sqlite3_errmsg
> (db));
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> rc = sqlite3_step(stmt);
>
> if (rc != SQLITE_DONE) {
> fprintf(stderr, "sqlite3_step() %s\n", sqlite3_errmsg(db));
> sqlite3_finalize(stmt);
> sqlite3_close(db);
> exit(1);
> }
>
> sqlite3_reset(stmt);
> }
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
