int
seaf_quota_manager_set_org_quota (SeafQuotaManager *mgr,
int org_id,
gint64 quota)
{
SeafDB *db = mgr->session->db;
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean exists, err;
int rc;
exists = seaf_db_statement_exists (db,
"SELECT 1 FROM OrgQuota WHERE org_id=?",
&err, 1, "int", org_id);
if (err)
return -1;
if (exists)
rc = seaf_db_statement_query (db,
"UPDATE OrgQuota SET quota=? WHERE org_id=?",
2, "int64", quota, "int", org_id);
else
rc = seaf_db_statement_query (db,
"INSERT INTO OrgQuota VALUES (?, ?)",
2, "int", org_id, "int64", quota);
return rc;
} else {
int rc = seaf_db_statement_query (db,
"REPLACE INTO OrgQuota VALUES (?, ?)",
2, "int", org_id, "int64", quota);
return rc;
}
}
int
seaf_quota_manager_set_user_quota (SeafQuotaManager *mgr,
const char *user,
gint64 quota)
{
SeafDB *db = mgr->session->db;
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean exists, err;
int rc;
exists = seaf_db_statement_exists (db,
"SELECT 1 FROM UserQuota WHERE \"user\"=?",
&err, 1, "string", user);
if (err)
return -1;
if (exists)
rc = seaf_db_statement_query (db,
"UPDATE UserQuota SET quota=? "
"WHERE \"user\"=?",
2, "int64", quota, "string", user);
else
rc = seaf_db_statement_query (db,
"INSERT INTO UserQuota VALUES "
"(?, ?)",
2, "string", user, "int64", quota);
return rc;
} else {
int rc;
rc = seaf_db_statement_query (db,
"REPLACE INTO UserQuota VALUES (?, ?)",
2, "string", user, "int64", quota);
return rc;
}
}
int
seaf_branch_manager_update_branch (SeafBranchManager *mgr, SeafBranch *branch)
{
#ifndef SEAFILE_SERVER
sqlite3 *db;
char *sql;
pthread_mutex_lock (&mgr->priv->db_lock);
db = mgr->priv->db;
sql = sqlite3_mprintf ("UPDATE Branch SET commit_id = %Q "
"WHERE name = %Q AND repo_id = %Q",
branch->commit_id, branch->name, branch->repo_id);
sqlite_query_exec (db, sql);
sqlite3_free (sql);
pthread_mutex_unlock (&mgr->priv->db_lock);
return 0;
#else
int rc = seaf_db_statement_query (mgr->seaf->db,
"UPDATE Branch SET commit_id = ? "
"WHERE name = ? AND repo_id = ?",
3, "string", branch->commit_id,
"string", branch->name,
"string", branch->repo_id);
if (rc < 0)
return -1;
return 0;
#endif
}
int
seaf_branch_manager_del_branch (SeafBranchManager *mgr,
const char *repo_id,
const char *name)
{
#ifndef SEAFILE_SERVER
char *sql;
pthread_mutex_lock (&mgr->priv->db_lock);
sql = sqlite3_mprintf ("DELETE FROM Branch WHERE name = %Q AND "
"repo_id = '%s'", name, repo_id);
if (sqlite_query_exec (mgr->priv->db, sql) < 0)
seaf_warning ("Delete branch %s failed\n", name);
sqlite3_free (sql);
pthread_mutex_unlock (&mgr->priv->db_lock);
return 0;
#else
int rc = seaf_db_statement_query (mgr->seaf->db,
"DELETE FROM Branch WHERE name=? AND repo_id=?",
2, "string", name, "string", repo_id);
if (rc < 0)
return -1;
return 0;
#endif
}
int
seaf_share_manager_add_share (SeafShareManager *mgr, const char *repo_id,
const char *from_email, const char *to_email,
const char *permission)
{
gboolean db_err = FALSE;
int ret = 0;
char *from_email_l = g_ascii_strdown (from_email, -1);
char *to_email_l = g_ascii_strdown (to_email, -1);
if (seaf_db_statement_exists (mgr->seaf->db,
"SELECT repo_id from SharedRepo "
"WHERE repo_id=? AND "
"from_email=? AND to_email=?",
&db_err, 3, "string", repo_id,
"string", from_email_l, "string", to_email_l))
goto out;
if (seaf_db_statement_query (mgr->seaf->db,
"INSERT INTO SharedRepo (repo_id, from_email, "
"to_email, permission) VALUES (?, ?, ?, ?)",
4, "string", repo_id, "string", from_email_l,
"string", to_email_l, "string", permission) < 0) {
ret = -1;
goto out;
}
out:
g_free (from_email_l);
g_free (to_email_l);
return ret;
}
static void
set_virtual_repo_base_commit_path (const char *vrepo_id, const char *base_commit_id,
const char *new_path)
{
seaf_db_statement_query (seaf->db,
"UPDATE VirtualRepo SET base_commit=?, path=? WHERE repo_id=?",
3, "string", base_commit_id, "string", new_path,
"string", vrepo_id);
}
int
seaf_share_manager_remove_repo (SeafShareManager *mgr, const char *repo_id)
{
if (seaf_db_statement_query (mgr->seaf->db,
"DELETE FROM SharedRepo WHERE repo_id = ?",
1, "string", repo_id) < 0)
return -1;
return 0;
}
int
seaf_share_manager_remove_share (SeafShareManager *mgr, const char *repo_id,
const char *from_email, const char *to_email)
{
if (seaf_db_statement_query (mgr->seaf->db,
"DELETE FROM SharedRepo WHERE repo_id = ? AND from_email ="
" ? AND to_email = ?",
3, "string", repo_id, "string", from_email,
"string", to_email) < 0)
return -1;
return 0;
}
static int
save_virtual_repo_info (SeafRepoManager *mgr,
const char *repo_id,
const char *origin_repo_id,
const char *path,
const char *base_commit)
{
int ret = 0;
if (seaf_db_statement_query (mgr->seaf->db,
"INSERT INTO VirtualRepo VALUES (?, ?, ?, ?)",
4, "string", repo_id, "string", origin_repo_id,
"string", path, "string", base_commit) < 0)
ret = -1;
return ret;
}
int
seaf_share_manager_set_permission (SeafShareManager *mgr, const char *repo_id,
const char *from_email, const char *to_email,
const char *permission)
{
char *sql;
int ret;
char *from_email_l = g_ascii_strdown (from_email, -1);
char *to_email_l = g_ascii_strdown (to_email, -1);
sql = "UPDATE SharedRepo SET permission=? WHERE "
"repo_id=? AND from_email=? AND to_email=?";
ret = seaf_db_statement_query (mgr->seaf->db, sql,
4, "string", permission, "string", repo_id,
"string", from_email_l, "string", to_email_l);
g_free (from_email_l);
g_free (to_email_l);
return ret;
}
int
seaf_branch_manager_add_branch (SeafBranchManager *mgr, SeafBranch *branch)
{
#ifndef SEAFILE_SERVER
char sql[256];
pthread_mutex_lock (&mgr->priv->db_lock);
sqlite3_snprintf (sizeof(sql), sql,
"SELECT 1 FROM Branch WHERE name=%Q and repo_id=%Q",
branch->name, branch->repo_id);
if (sqlite_check_for_existence (mgr->priv->db, sql))
sqlite3_snprintf (sizeof(sql), sql,
"UPDATE Branch SET commit_id=%Q WHERE "
"name=%Q and repo_id=%Q",
branch->commit_id, branch->name, branch->repo_id);
else
sqlite3_snprintf (sizeof(sql), sql,
"INSERT INTO Branch VALUES (%Q, %Q, %Q)",
branch->name, branch->repo_id, branch->commit_id);
sqlite_query_exec (mgr->priv->db, sql);
pthread_mutex_unlock (&mgr->priv->db_lock);
return 0;
#else
char *sql;
SeafDB *db = mgr->seaf->db;
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean exists, err;
int rc;
sql = "SELECT repo_id FROM Branch WHERE name=? AND repo_id=?";
exists = seaf_db_statement_exists(db, sql, &err,
2, "string", branch->name,
"string", branch->repo_id);
if (err)
return -1;
if (exists)
rc = seaf_db_statement_query (db,
"UPDATE Branch SET commit_id=? "
"WHERE name=? AND repo_id=?",
3, "string", branch->commit_id,
"string", branch->name,
"string", branch->repo_id);
else
rc = seaf_db_statement_query (db,
"INSERT INTO Branch VALUES (?, ?, ?)",
3, "string", branch->name,
"string", branch->repo_id,
"string", branch->commit_id);
if (rc < 0)
return -1;
} else {
int rc = seaf_db_statement_query (db,
"REPLACE INTO Branch VALUES (?, ?, ?)",
3, "string", branch->name,
"string", branch->repo_id,
"string", branch->commit_id);
if (rc < 0)
return -1;
}
return 0;
#endif
}