commit 6f92d0af5a421e6331d7f1a94c3a051cd0523a7e
Author: Hector Martin <hec...@marcansoft.com>
Date:   Tue Oct 20 04:04:34 2009 +0200

    Better handle Locations.itdb
    
    Honestly it's 4am and I don't know if this is needed, but it's syncing
    properly now so I'm committing it.

 src/itdb_sqlite.c |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)
---
diff --git a/src/itdb_sqlite.c b/src/itdb_sqlite.c
index 24240b1..5f05b57 100644
--- a/src/itdb_sqlite.c
+++ b/src/itdb_sqlite.c
@@ -1075,7 +1075,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char 
*outpath, const char *u
                continue;
            }
 
-           if (SQLITE_OK != sqlite3_prepare_v2(db, "INSERT INTO \"location\" 
VALUES(?,?,?,?,:path,?,?,?,?,?,?,?,?);", -1, &stmt, &sqltail)) {
+           if (SQLITE_OK != sqlite3_prepare_v2(db, "INSERT INTO \"location\" 
(item_pid, sub_id, base_location_id, location_type, location, extension, 
kind_id, date_created, file_size) VALUES(?,?,?,?,?,?,?,?,?);", -1, &stmt, 
&sqltail)) {
                fprintf(stderr, "[%s] sqlite3_prepare error: %s\n", __func__, 
sqlite3_errmsg(db));
            } else {
                char *ipod_path = strdup(track->ipod_path);
@@ -1116,6 +1116,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char 
*outpath, const char *u
                sqlite3_bind_int(stmt, ++idx, timeconv(track->time_modified));
                /* file_size */
                sqlite3_bind_int(stmt, ++idx, track->size);
+#if 0
                /* file_creator */
                /* TODO unknown, set to NULL */
                sqlite3_bind_null(stmt, ++idx);
@@ -1128,7 +1129,7 @@ static void mk_Locations(Itdb_iTunesDB *itdb, const char 
*outpath, const char *u
                /* num_dir_levels_lib */
                /* TODO unknown, set to NULL */
                sqlite3_bind_null(stmt, ++idx);
-
+#endif
                res = sqlite3_step(stmt);
                if (res == SQLITE_DONE) {
                    /* expected result */

------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
gtkpod-cvs2 mailing list
gtkpod-cvs2@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gtkpod-cvs2

Reply via email to