Lines Matching refs:sql_exec
129 ret = sql_exec(db, "INSERT into OBJECTS"
185 sql_exec(db, "INSERT into OBJECTS"
212 sql_exec(db, "INSERT into OBJECTS"
222 sql_exec(db, "INSERT into OBJECTS"
265 sql_exec(db, "INSERT into OBJECTS"
302 sql_exec(db, "INSERT into OBJECTS"
307 sql_exec(db, "INSERT into OBJECTS"
342 sql_exec(db, "INSERT into OBJECTS"
347 sql_exec(db, "INSERT into OBJECTS"
358 sql_exec(db, "INSERT into OBJECTS"
373 sql_exec(db, "INSERT into OBJECTS"
423 sql_exec(db, "INSERT into OBJECTS"
441 sql_exec(db, "INSERT into OBJECTS"
498 sql_exec(db, "INSERT into OBJECTS"
517 sql_exec(db, "INSERT into OBJECTS"
553 ret = sql_exec(db, create_objectTable_sqlite);
556 ret = sql_exec(db, create_detailTable_sqlite);
559 ret = sql_exec(db, create_albumArtTable_sqlite);
562 ret = sql_exec(db, create_captionTable_sqlite);
565 ret = sql_exec(db, create_bookmarkTable_sqlite);
568 ret = sql_exec(db, create_playlistTable_sqlite);
571 ret = sql_exec(db, create_settingsTable_sqlite);
574 ret = sql_exec(db, "INSERT into SETTINGS values ('UPDATE_ID', '0')");
579 ret = sql_exec(db, "INSERT into OBJECTS (OBJECT_ID, PARENT_ID, DETAIL_ID, CLASS, NAME)"
596 ret = sql_exec(db, "INSERT into OBJECTS (OBJECT_ID, PARENT_ID, DETAIL_ID, CLASS, NAME)"
605 sql_exec(db, "create INDEX IDX_OBJECTS_OBJECT_ID ON OBJECTS(OBJECT_ID);");
606 sql_exec(db, "create INDEX IDX_OBJECTS_PARENT_ID ON OBJECTS(PARENT_ID);");
607 sql_exec(db, "create INDEX IDX_OBJECTS_DETAIL_ID ON OBJECTS(DETAIL_ID);");
608 sql_exec(db, "create INDEX IDX_OBJECTS_CLASS ON OBJECTS(CLASS);");
609 sql_exec(db, "create INDEX IDX_DETAILS_PATH ON DETAILS(PATH);");
610 sql_exec(db, "create INDEX IDX_DETAILS_ID ON DETAILS(ID);");
611 sql_exec(db, "create INDEX IDX_ALBUM_ART ON ALBUM_ART(ID);");
612 sql_exec(db, "create INDEX IDX_SCANNER_OPT ON OBJECTS(PARENT_ID, NAME, OBJECT_ID);");
915 sql_exec(db, "UPDATE DETAILS set TIMESTAMP = %d where ID = %lld", media_path->types, (long long)id);
917 sql_exec(db, "INSERT into SETTINGS values (%Q, %Q)", "media_dir", media_path->path);
923 sql_exec(db, "create INDEX IDX_SEARCH_OPT ON OBJECTS(OBJECT_ID, CLASS, DETAIL_ID);");
936 sql_exec(db, "pragma user_version = %d;", DB_VERSION);