/**
\details Search for existing FMID in indexing database
\param ictx valid pointer to indexing context
\param username samAccountName for current user
\param fmid FMID to search for
\param is_soft_deleted pointer to output location to return soft deleted state
\return MAPISTORE_SUCCESS on success, otherwise MAPISTORE error
*/
static enum mapistore_error mysql_search_existing_fmid(struct indexing_context *ictx,
const char *username,
uint64_t fmid, bool *is_soft_deleted)
{
int ret;
uint64_t soft_deleted;
char *sql;
TALLOC_CTX *mem_ctx;
/* Sanity */
MAPISTORE_RETVAL_IF(!ictx, MAPISTORE_ERR_NOT_INITIALIZED, NULL);
MAPISTORE_RETVAL_IF(!username, MAPISTORE_ERR_INVALID_PARAMETER, NULL);
MAPISTORE_RETVAL_IF(!fmid, MAPISTORE_ERR_INVALID_PARAMETER, NULL);
MAPISTORE_RETVAL_IF(!is_soft_deleted, MAPISTORE_ERR_INVALID_PARAMETER, NULL);
mem_ctx = talloc_new(NULL);
sql = talloc_asprintf(mem_ctx,
"SELECT soft_deleted FROM %s "
"WHERE username = '******' AND fmid = %"PRIu64,
INDEXING_TABLE, _sql(mem_ctx, username), fmid);
ret = select_first_uint(MYSQL(ictx), sql, &soft_deleted);
MAPI_RETVAL_IF(ret != MYSQL_SUCCESS, MAPISTORE_ERR_EXIST, mem_ctx);
*is_soft_deleted = (soft_deleted == 1);
talloc_free(mem_ctx);
return MAPISTORE_SUCCESS;
}
/**
\details Check if the database is empty
\param conn pointer to the MySQL connection
\return true if the database is empty, otherwise false
*/
static bool is_database_empty(MYSQL *conn)
{
enum MYSQLRESULT ret;
uint64_t n = 0;
ret = select_first_uint(conn, "SELECT count(*) FROM "NAMEDPROPS_MYSQL_TABLE, &n);
if (ret != MYSQL_SUCCESS) {
/* query failed, table does not exist? */
return true;
}
return n == 0;
}
static enum mapistore_error mysql_record_allocate_fmids(struct indexing_context *ictx,
const char *username,
int count,
uint64_t *fmidp)
{
int ret;
uint64_t next_fmid;
char *sql;
TALLOC_CTX *mem_ctx;
/* SANITY checks */
MAPISTORE_RETVAL_IF(!ictx, MAPISTORE_ERR_NOT_INITIALIZED, NULL);
MAPISTORE_RETVAL_IF(!username, MAPISTORE_ERR_NOT_INITIALIZED, NULL);
MAPISTORE_RETVAL_IF(!fmidp, MAPISTORE_ERR_NOT_INITIALIZED, NULL);
MAPISTORE_RETVAL_IF(count < 0, MAPISTORE_ERR_NOT_INITIALIZED, NULL);
MAPISTORE_RETVAL_IF(count == 0, MAPISTORE_SUCCESS, NULL);
/* Retrieve and increment the counter */
ret = execute_query(MYSQL(ictx), "START TRANSACTION");
MAPISTORE_RETVAL_IF(ret != MYSQL_SUCCESS, MAPISTORE_ERR_DATABASE_OPS, NULL);
mem_ctx = talloc_new(NULL);
sql = talloc_asprintf(mem_ctx,
"SELECT next_fmid FROM %s "
"WHERE username = '******'",
INDEXING_ALLOC_TABLE, _sql(mem_ctx, username));
ret = select_first_uint(MYSQL(ictx), sql, &next_fmid);
switch (ret) {
case MYSQL_SUCCESS:
if (next_fmid <= MAX_PUBLIC_FOLDER_ID) {
next_fmid = MAX_PUBLIC_FOLDER_ID + 1;
}
// Update next fmid
sql = talloc_asprintf(mem_ctx,
"UPDATE %s SET next_fmid = %"PRIu64
" WHERE username='******'",
INDEXING_ALLOC_TABLE,
next_fmid + count,
_sql(mem_ctx, username));
break;
case MYSQL_NOT_FOUND:
// First allocation, insert in the database
next_fmid = MAX_PUBLIC_FOLDER_ID + 1;
sql = talloc_asprintf(mem_ctx,
"INSERT INTO %s (username, next_fmid) "
"VALUES('%s', %"PRIu64")",
INDEXING_ALLOC_TABLE,
_sql(mem_ctx, username),
next_fmid + count);
break;
default:
// Unknown error
talloc_free(mem_ctx);
return MAPISTORE_ERR_DATABASE_OPS;
}
ret = execute_query(MYSQL(ictx), sql);
MAPISTORE_RETVAL_IF(ret != MYSQL_SUCCESS, MAPISTORE_ERR_DATABASE_OPS, mem_ctx);
ret = execute_query(MYSQL(ictx), "COMMIT");
MAPISTORE_RETVAL_IF(ret != MYSQL_SUCCESS, MAPISTORE_ERR_DATABASE_OPS, mem_ctx);
*fmidp = next_fmid;
return MAPISTORE_SUCCESS;
}