自学教程：C++ DT_DEBUG_SQLITE3_BIND_INT函数代码示例

void dt_view_filmstrip_prefetch(){  const gchar *qin = dt_collection_get_query (darktable.collection);  if(!qin) return;  char query[1024];  int offset = 0;  if(qin)  {    int imgid = -1;    sqlite3_stmt *stmt;    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select imgid from selected_images", -1, &stmt, NULL);    if(sqlite3_step(stmt) == SQLITE_ROW)      imgid = sqlite3_column_int(stmt, 0);    sqlite3_finalize(stmt);    snprintf(query, 1024, "select rowid from (%s) where id=?3", qin);    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), query, -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 1,  0);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, -1);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 3, imgid);    if(sqlite3_step(stmt) == SQLITE_ROW)      offset = sqlite3_column_int(stmt, 0) - 1;    sqlite3_finalize(stmt);  }  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), qin, -1, &stmt, NULL);  // only get one more image:  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, offset+1);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, offset+2);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    const uint32_t prefetchid = sqlite3_column_int(stmt, 0);    // dt_control_log("prefetching image %u", prefetchid);    dt_mipmap_cache_read_get(darktable.mipmap_cache, NULL, prefetchid, DT_MIPMAP_FULL, DT_MIPMAP_PREFETCH);  }  sqlite3_finalize(stmt);}

static void menuitem_update_preset(GtkMenuItem *menuitem, dt_iop_module_t *module){  gchar *name = get_preset_name(menuitem);  // commit all the module fields  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "UPDATE presets SET op_version=?2, op_params=?3, enabled=?4, "                              "blendop_params=?5, blendop_version=?6 WHERE name=?7 AND operation=?1",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, module->op, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, module->version());  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 3, module->params, module->params_size, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 4, module->enabled);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 5, module->blend_params, sizeof(dt_develop_blend_params_t),                             SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 6, dt_develop_blend_version());  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 7, name, -1, SQLITE_TRANSIENT);  sqlite3_step(stmt);  sqlite3_finalize(stmt);}

void dt_gui_presets_add_generic(const char *name, dt_dev_operation_t op, const int32_t version,                                const void *params, const int32_t params_size, const int32_t enabled){  sqlite3_stmt *stmt;  dt_develop_blend_params_t default_blendop_params      = { DEVELOP_MASK_DISABLED,          DEVELOP_BLEND_NORMAL2,          100.0f,          DEVELOP_COMBINE_NORM_EXCL,          0,          0,          0.0f,          { 0, 0, 0, 0 },          { 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f,            0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f,            0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f,            0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f, 0.0f, 0.0f, 1.0f, 1.0f } };  DT_DEBUG_SQLITE3_PREPARE_V2(      dt_database_get(darktable.db),      "INSERT OR REPLACE INTO presets (name, description, operation, op_version, op_params, enabled, "      "blendop_params, blendop_version, multi_priority, multi_name, model, maker, lens, "      "iso_min, iso_max, exposure_min, exposure_max, aperture_min, aperture_max, focal_length_min, "      "focal_length_max, "      "writeprotect, autoapply, filter, def, format) "      "VALUES (?1, '', ?2, ?3, ?4, ?5, ?6, ?7, 0, '', '%', '%', '%', 0, 51200, 0, 10000000, 0, 100000000, 0, "      "1000, 1, 0, 0, 0, 0)",      -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, name, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 2, op, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 3, version);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 4, params, params_size, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 5, enabled);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 6, &default_blendop_params, sizeof(dt_develop_blend_params_t),                             SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 7, dt_develop_blend_version());  sqlite3_step(stmt);  sqlite3_finalize(stmt);}

void dt_image_full_path(const int imgid, char *pathname, int len){  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "select folder || '/' || filename from images, film_rolls where "                              "images.film_id = film_rolls.id and images.id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    g_strlcpy(pathname, (char *)sqlite3_column_text(stmt, 0), len);  }  sqlite3_finalize(stmt);}

/** * /brief Set the selection bit to a given value for the specified image * /param[in] imgid The image id * /param[in] value The boolean value for the bit */void dt_view_set_selection(int imgid, int value){  /* clear and reset statement */  DT_DEBUG_SQLITE3_CLEAR_BINDINGS(darktable.view_manager->statements.is_selected);  DT_DEBUG_SQLITE3_RESET(darktable.view_manager->statements.is_selected);  /* setup statement and iterate over rows */  DT_DEBUG_SQLITE3_BIND_INT(darktable.view_manager->statements.is_selected, 1, imgid);  if(sqlite3_step(darktable.view_manager->statements.is_selected) == SQLITE_ROW)  {    if(!value)    {      /* Value is set and should be unset; get rid of it */      /* clear and reset statement */      DT_DEBUG_SQLITE3_CLEAR_BINDINGS(darktable.view_manager->statements.delete_from_selected);      DT_DEBUG_SQLITE3_RESET(darktable.view_manager->statements.delete_from_selected);      /* setup statement and execute */      DT_DEBUG_SQLITE3_BIND_INT(darktable.view_manager->statements.delete_from_selected, 1, imgid);      sqlite3_step(darktable.view_manager->statements.delete_from_selected);    }  }  else if(value)  {    /* Select bit is unset and should be set; add it */        /* clear and reset statement */     DT_DEBUG_SQLITE3_CLEAR_BINDINGS(darktable.view_manager->statements.make_selected);    DT_DEBUG_SQLITE3_RESET(darktable.view_manager->statements.make_selected);        /* setup statement and execute */      DT_DEBUG_SQLITE3_BIND_INT(darktable.view_manager->statements.make_selected, 1, imgid);    sqlite3_step(darktable.view_manager->statements.make_selected);  } }

static void _lib_filmstrip_scroll_to_image(dt_lib_module_t *self, gint imgid, gboolean activate){  dt_lib_filmstrip_t *strip = (dt_lib_filmstrip_t *)self->data;   /* if no imgid just bail out */  if(imgid <= 0) return;  strip->activated_image = imgid;  char query[1024];  const gchar *qin = dt_collection_get_query (darktable.collection);  if(qin)  {    snprintf(query, 1024, "select rowid from (%s) where id=?3", qin);    sqlite3_stmt *stmt;    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), query, -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 1,  0);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, -1);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 3, imgid);    if(sqlite3_step(stmt) == SQLITE_ROW)    {      strip->offset = sqlite3_column_int(stmt, 0) - 1;    }    sqlite3_finalize(stmt);  }  /* activate the image if requested */  if (activate)  {    strip->activated_image = imgid;    dt_control_signal_raise(darktable.signals, DT_SIGNAL_VIEWMANAGER_FILMSTRIP_ACTIVATE);  }  /* redraw filmstrip */  gboolean owns_lock = dt_control_gdk_lock();  gtk_widget_queue_draw(self->widget);  if(owns_lock) dt_control_gdk_unlock();}

static void dt_add_hist(int imgid, char *operation, dt_iop_params_t *params, int params_size, char *imported,                        size_t imported_len, int version, int *import_count){  int32_t num = 0;  dt_develop_blend_params_t blend_params = { 0 };  //  get current num if any  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "SELECT count(num) FROM history WHERE imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    num = sqlite3_column_int(stmt, 0);  }  sqlite3_finalize(stmt);  // add new history info  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "INSERT INTO history (imgid, num, module, operation, op_params, enabled, "                              "blendop_params, blendop_version, multi_priority, multi_name) "                              "VALUES (?1, ?2, ?3, ?4, ?5, 1, ?6, ?7, 0, ' ')",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, num);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 3, version);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 4, operation, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 5, params, params_size, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 6, &blend_params, sizeof(dt_develop_blend_params_t), SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 7, LRDT_BLEND_VERSION);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  if(imported[0]) g_strlcat(imported, ", ", imported_len);  g_strlcat(imported, dt_iop_get_localized_name(operation), imported_len);  (*import_count)++;}

void dt_image_remove(const int32_t imgid){  sqlite3_stmt *stmt;  const dt_image_t *img = dt_image_cache_read_get(darktable.image_cache, imgid);  int old_group_id = img->group_id;  dt_image_cache_read_release(darktable.image_cache, img);  int new_group_id = dt_grouping_remove_from_group(imgid);  if(darktable.gui && darktable.gui->expanded_group_id == old_group_id)    darktable.gui->expanded_group_id = new_group_id;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from images where id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "update tagxtag set count = count - 1 where "                              "(id2 in (select tagid from tagged_images where imgid = ?1)) or "                              "(id1 in (select tagid from tagged_images where imgid = ?1))",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from tagged_images where imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from history where imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from color_labels where imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from meta_data where id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "delete from selected_images where imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  // also clear all thumbnails in mipmap_cache.  dt_image_cache_remove(darktable.image_cache, imgid);  dt_mipmap_cache_remove(darktable.mipmap_cache, imgid);}

/** open film with given id. */intdt_film_open2 (dt_film_t *film){  /* check if we got a decent film id */  if(film->id<0) return 1;  /* query database for id and folder */  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "select id, folder from film_rolls where id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, film->id);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    /* fill out the film dirname */    sprintf (film->dirname,"%s",(gchar *)sqlite3_column_text (stmt, 1));    sqlite3_finalize (stmt);    char datetime[20];    dt_gettime (datetime);    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                                "update film_rolls set datetime_accessed = ?1 where id = ?2",                                -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, datetime, strlen(datetime),                               SQLITE_STATIC);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, film->id);    sqlite3_step (stmt);    sqlite3_finalize (stmt);    dt_film_set_query (film->id);    dt_control_queue_redraw_center ();    dt_view_manager_reset (darktable.view_manager);    return 0;  }  else sqlite3_finalize (stmt);  /* failure */  return 1;}

// drops the write priviledges on an image struct.// this triggers a write-through to sql, and if the setting// is present, also to xmp sidecar files (safe setting).voiddt_image_cache_write_release(  dt_image_cache_t *cache,  dt_image_t *img,  dt_image_cache_write_mode_t mode){  if(img->id <= 0) return;  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "update images set width = ?1, height = ?2, maker = ?3, model = ?4, "                              "lens = ?5, exposure = ?6, aperture = ?7, iso = ?8, focal_length = ?9, "                              "focus_distance = ?10, film_id = ?11, datetime_taken = ?12, flags = ?13, "                              "crop = ?14, orientation = ?15, raw_parameters = ?16, group_id = ?17, longitude = ?18, "                              "latitude = ?19, color_matrix = ?20 where id = ?21", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, img->width);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, img->height);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 3, img->exif_maker, strlen(img->exif_maker), SQLITE_STATIC);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 4, img->exif_model, strlen(img->exif_model), SQLITE_STATIC);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 5, img->exif_lens,  strlen(img->exif_lens),  SQLITE_STATIC);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 6, img->exif_exposure);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 7, img->exif_aperture);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 8, img->exif_iso);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 9, img->exif_focal_length);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 10, img->exif_focus_distance);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 11, img->film_id);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 12, img->exif_datetime_taken, strlen(img->exif_datetime_taken), SQLITE_STATIC);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 13, img->flags);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 14, img->exif_crop);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 15, img->orientation);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 16, *(uint32_t*)(&img->legacy_flip));  DT_DEBUG_SQLITE3_BIND_INT(stmt, 17, img->group_id);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 18, img->longitude);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 19, img->latitude);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 20, &img->d65_color_matrix, sizeof(img->d65_color_matrix), SQLITE_STATIC);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 21, img->id);  int rc = sqlite3_step(stmt);  if (rc != SQLITE_DONE) fprintf(stderr, "[image_cache_write_release] sqlite3 error %d/n", rc);  sqlite3_finalize(stmt);  // TODO: make this work in relaxed mode, too.  if(mode == DT_IMAGE_CACHE_SAFE)  {    // rest about sidecars:    // also synch dttags file:    dt_image_write_sidecar_file(img->id);  }  dt_cache_write_release(&cache->cache, img->id);}

static void menuitem_pick_preset(GtkMenuItem *menuitem, dt_iop_module_t *module){  gchar *name = get_preset_name(menuitem);  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "select op_params, enabled, blendop_params, blendop_version, writeprotect from "                              "presets where operation = ?1 and op_version = ?2 and name = ?3",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, module->op, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, module->version());  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 3, name, -1, SQLITE_TRANSIENT);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    const void *op_params = sqlite3_column_blob(stmt, 0);    int op_length = sqlite3_column_bytes(stmt, 0);    int enabled = sqlite3_column_int(stmt, 1);    const void *blendop_params = sqlite3_column_blob(stmt, 2);    int bl_length = sqlite3_column_bytes(stmt, 2);    int blendop_version = sqlite3_column_int(stmt, 3);    int writeprotect = sqlite3_column_int(stmt, 4);    if(op_params && (op_length == module->params_size))    {      memcpy(module->params, op_params, op_length);      module->enabled = enabled;    }    if(blendop_params && (blendop_version == dt_develop_blend_version())       && (bl_length == sizeof(dt_develop_blend_params_t)))    {      memcpy(module->blend_params, blendop_params, sizeof(dt_develop_blend_params_t));    }    else if(blendop_params            && dt_develop_blend_legacy_params(module, blendop_params, blendop_version, module->blend_params,                                              dt_develop_blend_version(), bl_length) == 0)    {      // do nothing    }    else    {      memcpy(module->blend_params, module->default_blendop_params, sizeof(dt_develop_blend_params_t));    }    if(!writeprotect) dt_gui_store_last_preset(name);  }  sqlite3_finalize(stmt);  g_free(name);  dt_iop_gui_update(module);  dt_dev_add_history_item(darktable.develop, module, FALSE);  gtk_widget_queue_draw(module->widget);}

GList *dt_styles_get_item_list (const char *name, gboolean params){  GList *result=NULL;  sqlite3_stmt *stmt;  int id=0;  if ((id=dt_styles_get_id_by_name(name)) != 0)  {    if (params)      DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select num, operation, enabled, op_params, blendop_params from style_items where styleid=?1 order by num desc", -1, &stmt, NULL);    else      DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select num, operation, enabled from style_items where styleid=?1 order by num desc", -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, id);    while (sqlite3_step(stmt) == SQLITE_ROW)    {      char name[512]= {0};      dt_style_item_t *item=g_malloc (sizeof (dt_style_item_t));      item->num = sqlite3_column_int (stmt, 0);      if (params)      {        // when we get the parameters we do not want to get the operation localized as this        // is used to compare against the internal module name.        g_snprintf(name,512,"%s",sqlite3_column_text (stmt, 1));        const unsigned char *op_blob = sqlite3_column_blob(stmt, 3);        const int32_t op_len = sqlite3_column_bytes(stmt, 3);        const unsigned char *bop_blob = sqlite3_column_blob(stmt, 4);        const int32_t bop_len = sqlite3_column_bytes(stmt, 4);        item->params = malloc(op_len);        memcpy(item->params, op_blob, op_len);        item->blendop_params = malloc(bop_len);        memcpy(item->blendop_params, bop_blob, bop_len);      }      else      {        g_snprintf(name,512,"%s (%s)",dt_iop_get_localized_name((gchar *)sqlite3_column_text (stmt, 1)),(sqlite3_column_int (stmt, 2)!=0)?_("on"):_("off"));        item->params = NULL;        item->blendop_params = NULL;      }      item->name = g_strdup (name);      result = g_list_append (result,item);    }    sqlite3_finalize(stmt);  }  return result;}

GList *dt_film_get_image_ids(const int filmid){  GList *result = NULL;  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "SELECT id FROM main.images WHERE film_id = ?1",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, filmid);  while(sqlite3_step(stmt) == SQLITE_ROW)  {    int id = sqlite3_column_int(stmt, 0);    result = g_list_append(result, GINT_TO_POINTER(id));  }  return result;}

int dt_image_altered(const uint32_t imgid){  int altered = 0;  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "select num from history where imgid = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if(sqlite3_step(stmt) == SQLITE_ROW)    altered = 1;  sqlite3_finalize(stmt);  if(altered) return 1;  return altered;}

void dt_colorlabels_toggle_label_selection(const int color){  sqlite3_stmt *stmt, *stmt2;  // check if all images in selection have that color label, i.e. try to get those which do not have the label  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select * from selected_images where imgid not "                                                             "in (select a.imgid from selected_images as a "                                                             "join color_labels as b on a.imgid = b.imgid "                                                             "where b.color = ?1)",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, color);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    // none or only part of images have that color label, so label them all    DT_DEBUG_SQLITE3_PREPARE_V2(        dt_database_get(darktable.db),        "insert or ignore into color_labels (imgid, color) select imgid, ?1 from selected_images", -1, &stmt2,        NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt2, 1, color);    sqlite3_step(stmt2);    sqlite3_finalize(stmt2);  }  else  {    // none of the selected images without that color label, so delete them all    DT_DEBUG_SQLITE3_PREPARE_V2(        dt_database_get(darktable.db),        "delete from color_labels where imgid in (select imgid from selected_images) and color=?1", -1,        &stmt2, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt2, 1, color);    sqlite3_step(stmt2);    sqlite3_finalize(stmt2);  }  sqlite3_finalize(stmt);  dt_collection_hint_message(darktable.collection);}

void dt_colorlabels_toggle_label_selection(const int color){  sqlite3_stmt *stmt, *stmt2;  // check if all images in selection have that color label, i.e. try to get those which do not have the label  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "SELECT imgid FROM main.selected_images WHERE imgid "                                                             "NOT IN (SELECT a.imgid FROM main.selected_images AS "                                                             "a JOIN main.color_labels AS b ON a.imgid = b.imgid "                                                             "WHERE b.color = ?1)",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, color);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    // none or only part of images have that color label, so label them all    DT_DEBUG_SQLITE3_PREPARE_V2(        dt_database_get(darktable.db),        "INSERT OR IGNORE INTO main.color_labels (imgid, color) SELECT imgid, ?1 FROM main.selected_images",        -1, &stmt2, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt2, 1, color);    sqlite3_step(stmt2);    sqlite3_finalize(stmt2);  }  else  {    // none of the selected images without that color label, so delete them all    DT_DEBUG_SQLITE3_PREPARE_V2(        dt_database_get(darktable.db),        "DELETE FROM main.color_labels WHERE imgid IN (SELECT imgid FROM main.selected_images) AND color=?1", -1,        &stmt2, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt2, 1, color);    sqlite3_step(stmt2);    sqlite3_finalize(stmt2);  }  sqlite3_finalize(stmt);  dt_collection_hint_message(darktable.collection);}

void dt_lua_image_push(lua_State * L,int imgid){  // check that id is valid  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select id from images where id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if(sqlite3_step(stmt) != SQLITE_ROW)  {    sqlite3_finalize(stmt);    luaL_error(L,"invalid id for image : %d",imgid);    return;  }  sqlite3_finalize(stmt);  luaA_push(L,dt_lua_image_t,&imgid);}

void dt_view_filmstrip_set_active_image(dt_view_manager_t *vm,int iid){  /* First off clear all selected images... */  DT_DEBUG_SQLITE3_EXEC(dt_database_get(darktable.db), "delete from selected_images", NULL, NULL, NULL);  /* clear and reset statement */  DT_DEBUG_SQLITE3_CLEAR_BINDINGS(darktable.view_manager->statements.make_selected);  DT_DEBUG_SQLITE3_RESET(darktable.view_manager->statements.make_selected);  /* setup statement and execute */  DT_DEBUG_SQLITE3_BIND_INT(darktable.view_manager->statements.make_selected, 1, iid);  sqlite3_step(darktable.view_manager->statements.make_selected);  dt_view_filmstrip_scroll_to_image(vm, iid, TRUE);}

void dt_colorlabels_toggle_label_selection (const int color){  sqlite3_stmt *stmt;  // store away all previously unlabeled images in selection:  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "insert into memory.color_labels_temp select a.imgid from selected_images as a join color_labels as b on a.imgid = b.imgid where b.color = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, color);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  // delete all currently colored image labels in selection  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "delete from color_labels where imgid in (select imgid from selected_images) and color=?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, color);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  // label all previously unlabeled images:  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "insert into color_labels select imgid, ?1 from selected_images where imgid not in (select imgid from memory.color_labels_temp)", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, color);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  // clean up  DT_DEBUG_SQLITE3_EXEC(dt_database_get(darktable.db), "delete from memory.color_labels_temp", NULL, NULL, NULL);}

voiddt_styles_delete_by_name(const char *name){  int id=0;  if ((id=dt_styles_get_id_by_name(name)) != 0)  {    /* delete the style */    sqlite3_stmt *stmt;    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "DELETE FROM styles WHERE id = ?1", -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, id);    sqlite3_step (stmt);    sqlite3_finalize (stmt);    /* delete style_items belonging to style */    DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "delete from style_items where styleid = ?1", -1, &stmt, NULL);    DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, id);    sqlite3_step (stmt);    sqlite3_finalize (stmt);    char tmp_accel[1024];    snprintf(tmp_accel,1024,C_("accel", "styles/apply %s"),name);    dt_accel_deregister_global(tmp_accel);  }}

static void_dt_style_cleanup_multi_instance(int id){  sqlite3_stmt *stmt;  /* let's clean-up the style multi-instance. What we want to do is have a unique multi_priority value for each iop.     Furthermore this value must start to 0 and increment one by one for each multi-instance of the same module. On     SQLite there is no notion of ROW_NUMBER, so we use rather resource consuming SQL statement, but as a style has     never a huge number of items that's not a real issue. */  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "update style_items set multi_priority=(select COUNT(0)-1 from style_items sty2 where sty2.num<=style_items.num and sty2.operation=style_items.operation and sty2.styleid=?1), multi_name=multi_priority where styleid=?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, id);  sqlite3_step (stmt);  sqlite3_finalize (stmt);}

static int film_len(lua_State*L){  dt_lua_film_t film_id;  luaA_to(L,dt_lua_film_t,&film_id,-1);  sqlite3_stmt *stmt = NULL;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),"select count(*) from images where film_id = ?1  ", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, film_id);  if(sqlite3_step(stmt) == SQLITE_ROW) {    lua_pushnumber(L,sqlite3_column_int(stmt, 0));  }else{    lua_pushnumber(L,0);  }  sqlite3_finalize(stmt);  return 1;}

static int collection_numindex(lua_State *L){  int index = luaL_checkinteger(L, -1);  if(index < 1)  {    return luaL_error(L, "incorrect index in database");  }  gchar *query = NULL;  gchar *sq = NULL;  /* get collection order */  if((darktable.collection->params.query_flags & COLLECTION_QUERY_USE_SORT))    sq = dt_collection_get_sort_query(darktable.collection);  sqlite3_stmt *stmt = NULL;  /* build the query string */  query = dt_util_dstrcat(query, "select distinct id from images ");  if(darktable.collection->params.sort == DT_COLLECTION_SORT_COLOR     && (darktable.collection->params.query_flags & COLLECTION_QUERY_USE_SORT))    query = dt_util_dstrcat(query, "as a left outer join color_labels as b on a.id = b.imgid ");  query = dt_util_dstrcat(query, "%s limit -1 offset ?1", sq);  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), query, -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, index -1);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    int imgid = sqlite3_column_int(stmt, 0);    luaA_push(L, dt_lua_image_t, &imgid);    sqlite3_finalize(stmt);  }  else  {    g_free(sq);    g_free(query);    sqlite3_finalize(stmt);    return luaL_error(L, "incorrect index in database");  }  g_free(sq);  g_free(query);  return 1;}

void dt_history_snapshot_undo_create(int32_t imgid, int *snap_id, int *history_end){  // create history & mask snapshots for imgid, return the snapshot id  sqlite3_stmt *stmt;  gboolean all_ok = TRUE;  // get current history end  *history_end = 0;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "SELECT history_end FROM main.images WHERE id=?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if (sqlite3_step(stmt) == SQLITE_ROW)    *history_end = sqlite3_column_int(stmt, 0);  sqlite3_finalize(stmt);  // get max snapshot  *snap_id = 0;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "SELECT MAX(id) FROM memory.undo_history WHERE imgid=?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  if (sqlite3_step(stmt) == SQLITE_ROW)    *snap_id = sqlite3_column_int(stmt, 0) + 1;  sqlite3_finalize(stmt);  sqlite3_exec(dt_database_get(darktable.db), "BEGIN TRANSACTION", NULL, NULL, NULL);  // copy current state into undo_history  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "INSERT INTO memory.undo_history SELECT ?1, imgid, num, module, operation, op_params, enabled, "                              "blendop_params, blendop_version, multi_priority, multi_name, iop_order "                              " FROM main.history WHERE imgid=?2", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, *snap_id);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, imgid);  all_ok = all_ok && (sqlite3_step(stmt) == SQLITE_DONE);  sqlite3_finalize(stmt);  // copy current state into undo_masks_history  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "INSERT INTO memory.undo_masks_history SELECT ?1, imgid, num, formid, form, name, version, "                              "points, points_count, source FROM main.masks_history WHERE imgid=?2", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, *snap_id);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, imgid);  all_ok = all_ok && (sqlite3_step(stmt) == SQLITE_DONE);  sqlite3_finalize(stmt);  if(all_ok)    sqlite3_exec(dt_database_get(darktable.db), "COMMIT", NULL, NULL, NULL);  else    sqlite3_exec(dt_database_get(darktable.db), "ROLLBACK_TRANSACTION", NULL, NULL, NULL);}

void dt_gui_presets_update_tv(const char *name, dt_dev_operation_t op, const int32_t version, const float min,                              const float max){  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(      dt_database_get(darktable.db),      "update presets set exposure_min=?1, exposure_max=?2 where operation=?3 and op_version=?4 and name=?5",      -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 1, min);  DT_DEBUG_SQLITE3_BIND_DOUBLE(stmt, 2, max);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 3, op, -1, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 4, version);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 5, name, -1, SQLITE_TRANSIENT);  sqlite3_step(stmt);  sqlite3_finalize(stmt);}

/* enumerator of images from filmroll */void dt_control_image_enumerator_job_film_init(dt_control_image_enumerator_t *t, int32_t filmid){  sqlite3_stmt *stmt;  /* get a list of images in filmroll */  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "select * from images where film_id = ?1",                              -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, filmid);  while (sqlite3_step(stmt) == SQLITE_ROW)  {    long int imgid = sqlite3_column_int(stmt, 0);    t->index = g_list_append(t->index, (gpointer)imgid);  }  sqlite3_finalize(stmt);}

static void _lib_history_compress_clicked_callback (GtkWidget *widget, gpointer user_data){  const int imgid = darktable.develop->image_storage.id;  if(!imgid) return;  // make sure the right history is in there:  dt_dev_write_history(darktable.develop);  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "delete from history where imgid = ?1 and num not in (select MAX(num) from history where imgid = ?1 group by operation,multi_priority)", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, imgid);  sqlite3_step(stmt);  sqlite3_finalize(stmt);  dt_dev_reload_history_items(darktable.develop);  dt_dev_modulegroups_set(darktable.develop, dt_dev_modulegroups_get(darktable.develop));}

void dt_film_set_query(const int32_t id){  /* enable film id filter and set film id */  dt_conf_set_int("plugins/lighttable/collect/num_rules", 1);  dt_conf_set_int("plugins/lighttable/collect/item0", 0);  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),                              "SELECT id, folder FROM main.film_rolls WHERE id = ?1", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, id);  if(sqlite3_step(stmt) == SQLITE_ROW)  {    dt_conf_set_string("plugins/lighttable/collect/string0", (gchar *)sqlite3_column_text(stmt, 1));  }  sqlite3_finalize(stmt);  dt_collection_update_query(darktable.collection);}

static voidmenuitem_update_preset (GtkMenuItem *menuitem, dt_lib_module_info_t *minfo){  gchar *name = get_preset_name(menuitem);  // commit all the module fields  sqlite3_stmt *stmt;  DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "update presets set operation=?1, op_version=?2, op_params=?3 where name=?4", -1, &stmt, NULL);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, minfo->plugin_name, strlen(minfo->plugin_name), SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_INT(stmt, 2, minfo->version);  DT_DEBUG_SQLITE3_BIND_BLOB(stmt, 3, minfo->params, minfo->params_size, SQLITE_TRANSIENT);  DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 4, name, strlen(name), SQLITE_TRANSIENT);  sqlite3_step(stmt);  sqlite3_finalize(stmt);}