int dt_film_import(const char *dirname)
{
int rc;
sqlite3_stmt *stmt;
GError *error = NULL;
/* initialize a film object*/
dt_film_t *film = (dt_film_t *)malloc(sizeof(dt_film_t));
dt_film_init(film);
film->id = -1;
/* lookup if film exists and reuse id */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "SELECT id FROM main.film_rolls WHERE folder = ?1",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, dirname, -1, SQLITE_STATIC);
if(sqlite3_step(stmt) == SQLITE_ROW) film->id = sqlite3_column_int(stmt, 0);
sqlite3_finalize(stmt);
/* if we didn't find an id, lets instantiate a new filmroll */
if(film->id <= 0)
{
char datetime[20];
dt_gettime(datetime, sizeof(datetime));
/* insert a new film roll into database */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),
"INSERT INTO main.film_rolls (id, datetime_accessed, folder) VALUES "
"(NULL, ?1, ?2)",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, datetime, -1, SQLITE_STATIC);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 2, dirname, -1, SQLITE_STATIC);
rc = sqlite3_step(stmt);
if(rc != SQLITE_DONE)
fprintf(stderr, "[film_import] failed to insert film roll! %s\n",
sqlite3_errmsg(dt_database_get(darktable.db)));
sqlite3_finalize(stmt);
/* requery for filmroll and fetch new id */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "SELECT id FROM main.film_rolls WHERE folder=?1",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, dirname, -1, SQLITE_STATIC);
if(sqlite3_step(stmt) == SQLITE_ROW) film->id = sqlite3_column_int(stmt, 0);
sqlite3_finalize(stmt);
}
/* bail out if we got troubles */
if(film->id <= 0)
{
// if the film is empty => remove it again.
if(dt_film_is_empty(film->id))
{
dt_film_remove(film->id);
}
dt_film_cleanup(film);
free(film);
return 0;
}
// when called without job system running the import will be done synchronously and destroy the film object
int filmid = film->id;
/* at last put import film job on queue */
film->last_loaded = 0;
g_strlcpy(film->dirname, dirname, sizeof(film->dirname));
char *last = &film->dirname[strlen(film->dirname) - 1];
if(*last == '/' && last != film->dirname) *last = '\0'; // remove the closing /, unless it's also the start
film->dir = g_dir_open(film->dirname, 0, &error);
if(error)
{
fprintf(stderr, "[film_import] failed to open directory %s: %s\n", film->dirname, error->message);
g_error_free(error);
dt_film_cleanup(film);
free(film);
return 0;
}
dt_control_add_job(darktable.control, DT_JOB_QUEUE_USER_BG, dt_film_import1_create(film));
return filmid;
}
int dt_film_import(const char *dirname)
{
int rc;
sqlite3_stmt *stmt;
/* initialize a film object*/
dt_film_t *film = (dt_film_t *)malloc(sizeof(dt_film_t));
dt_film_init(film);
film->id = -1;
/* lookup if film exists and reuse id */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select id from film_rolls where folder = ?1",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, dirname, -1, SQLITE_STATIC);
if(sqlite3_step(stmt) == SQLITE_ROW) film->id = sqlite3_column_int(stmt, 0);
sqlite3_finalize(stmt);
/* if we didn't find a id, lets instansiate a new filmroll */
if(film->id <= 0)
{
char datetime[20];
dt_gettime(datetime, sizeof(datetime));
/* insert a new film roll into database */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),
"insert into film_rolls (id, datetime_accessed, folder) values "
"(null, ?1, ?2)",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, datetime, -1, SQLITE_STATIC);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 2, dirname, -1, SQLITE_STATIC);
rc = sqlite3_step(stmt);
if(rc != SQLITE_DONE)
fprintf(stderr, "[film_import] failed to insert film roll! %s\n",
sqlite3_errmsg(dt_database_get(darktable.db)));
sqlite3_finalize(stmt);
/* requery for filmroll and fetch new id */
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), "select id from film_rolls where folder=?1",
-1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_TEXT(stmt, 1, dirname, -1, SQLITE_STATIC);
if(sqlite3_step(stmt) == SQLITE_ROW) film->id = sqlite3_column_int(stmt, 0);
sqlite3_finalize(stmt);
}
/* bail out if we got troubles */
if(film->id <= 0)
{
// if the film is empty => remove it again.
if(dt_film_is_empty(film->id))
{
dt_film_remove(film->id);
}
dt_film_cleanup(film);
free(film);
return 0;
}
/* at last put import film job on queue */
film->last_loaded = 0;
g_strlcpy(film->dirname, dirname, sizeof(film->dirname));
film->dir = g_dir_open(film->dirname, 0, NULL);
dt_control_add_job(darktable.control, DT_JOB_QUEUE_USER_BG, dt_film_import1_create(film));
return film->id;
}
