int
seaf_quota_manager_set_org_user_quota (SeafQuotaManager *mgr,
int org_id,
const char *user,
gint64 quota)
{
SeafDB *db = mgr->session->db;
char sql[512];
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean err;
snprintf(sql, sizeof(sql),
"SELECT 1 FROM OrgUserQuota WHERE org_id=%d AND user='******'",
org_id, user);
if (seaf_db_check_for_existence(db, sql, &err))
snprintf(sql, sizeof(sql),
"UPDATE OrgUserQuota SET quota=%"G_GINT64_FORMAT
" WHERE org_id=%d AND user='******'", quota, org_id, user);
else
snprintf(sql, sizeof(sql),
"INSERT INTO OrgQuota VALUES "
"(%d, '%s', %"G_GINT64_FORMAT")", org_id, user, quota);
if (err)
return -1;
return seaf_db_query (db, sql);
} else {
snprintf (sql, sizeof(sql),
"REPLACE INTO OrgUserQuota VALUES ('%d', '%s', %"G_GINT64_FORMAT")",
org_id, user, quota);
return seaf_db_query (mgr->session->db, sql);
}
}
int
seaf_repo_manager_set_repo_valid_since (SeafRepoManager *mgr,
const char *repo_id,
gint64 timestamp)
{
SeafDB *db = mgr->seaf->db;
char sql[256];
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean err;
snprintf(sql, sizeof(sql),
"SELECT repo_id FROM RepoValidSince WHERE "
"repo_id='%s'", repo_id);
if (seaf_db_check_for_existence(db, sql, &err))
snprintf(sql, sizeof(sql),
"UPDATE RepoValidSince SET timestamp=%"G_GINT64_FORMAT
" WHERE repo_id='%s'", timestamp, repo_id);
else
snprintf(sql, sizeof(sql),
"INSERT INTO RepoValidSince VALUES "
"('%s', %"G_GINT64_FORMAT")", repo_id, timestamp);
if (err)
return -1;
if (seaf_db_query (db, sql) < 0)
return -1;
} else {
snprintf (sql, sizeof(sql),
"REPLACE INTO RepoValidSince VALUES ('%s', %"G_GINT64_FORMAT")",
repo_id, timestamp);
if (seaf_db_query (db, sql) < 0)
return -1;
}
return 0;
}
gboolean
seaf_branch_manager_branch_exists (SeafBranchManager *mgr,
const char *repo_id,
const char *name)
{
#ifndef SEAFILE_SERVER
char *sql;
gboolean ret;
pthread_mutex_lock (&mgr->priv->db_lock);
sql = sqlite3_mprintf ("SELECT name FROM Branch WHERE name = %Q "
"AND repo_id='%s'", name, repo_id);
ret = sqlite_check_for_existence (mgr->priv->db, sql);
pthread_mutex_unlock (&mgr->priv->db_lock);
return ret;
#else
char sql[256];
gboolean db_err = FALSE;
snprintf (sql, sizeof(sql), "SELECT name FROM Branch WHERE name='%s' "
"AND repo_id='%s'", name, repo_id);
return seaf_db_check_for_existence (mgr->seaf->db, sql, &db_err);
#endif
}
int
seaf_share_manager_add_share (SeafShareManager *mgr, const char *repo_id,
const char *from_email, const char *to_email,
const char *permission)
{
char sql[512];
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);
snprintf (sql, sizeof(sql),
"SELECT repo_id from SharedRepo WHERE repo_id='%s' AND "
"from_email='%s' AND to_email='%s'", repo_id, from_email_l,
to_email_l);
if (seaf_db_check_for_existence (mgr->seaf->db, sql, &db_err))
goto out;
snprintf (sql, sizeof(sql),
"INSERT INTO SharedRepo VALUES ('%s', '%s', '%s', '%s')", repo_id,
from_email_l, to_email_l, permission);
if (seaf_db_query (mgr->seaf->db, sql) < 0) {
ret = -1;
goto out;
}
out:
g_free (from_email_l);
g_free (to_email_l);
return ret;
}
static gboolean
repo_exists_in_db_ex (SeafDB *db, const char *id, gboolean *db_err)
{
char sql[256];
snprintf (sql, sizeof(sql), "SELECT repo_id FROM Repo WHERE repo_id = '%s'",
id);
return seaf_db_check_for_existence (db, sql, db_err);
}
gboolean
seaf_repo_manager_is_virtual_repo (SeafRepoManager *mgr, const char *repo_id)
{
char sql[256];
gboolean db_err;
snprintf (sql, 256,
"SELECT 1 FROM VirtualRepo WHERE repo_id = '%s'", repo_id);
return seaf_db_check_for_existence (seaf->db, sql, &db_err);
}
gboolean
pgsql_index_exists (SeafDB *db, const char *index_name)
{
char sql[256];
gboolean db_err = FALSE;
snprintf (sql, sizeof(sql),
"SELECT 1 FROM pg_class WHERE relname='%s'",
index_name);
return seaf_db_check_for_existence (db, sql, &db_err);
}
int
seaf_repo_manager_set_repo_history_limit (SeafRepoManager *mgr,
const char *repo_id,
int days)
{
SeafVirtRepo *vinfo;
SeafDB *db = mgr->seaf->db;
char sql[256];
vinfo = seaf_repo_manager_get_virtual_repo_info (mgr, repo_id);
if (vinfo) {
seaf_virtual_repo_info_free (vinfo);
return 0;
}
if (seaf_db_type(db) == SEAF_DB_TYPE_PGSQL) {
gboolean err;
snprintf(sql, sizeof(sql),
"SELECT repo_id FROM RepoHistoryLimit "
"WHERE repo_id='%s'", repo_id);
if (seaf_db_check_for_existence(db, sql, &err))
snprintf(sql, sizeof(sql),
"UPDATE RepoHistoryLimit SET days=%d"
"WHERE repo_id='%s'", days, repo_id);
else
snprintf(sql, sizeof(sql),
"INSERT INTO RepoHistoryLimit VALUES "
"('%s', %d)", repo_id, days);
if (err)
return -1;
return seaf_db_query(db, sql);
} else {
snprintf (sql, sizeof(sql),
"REPLACE INTO RepoHistoryLimit VALUES ('%s', %d)",
repo_id, days);
if (seaf_db_query (db, sql) < 0)
return -1;
}
return 0;
}
int
seaf_share_manager_add_share (SeafShareManager *mgr, const char *repo_id,
const char *from_email, const char *to_email,
const char *permission)
{
char sql[512];
snprintf (sql, sizeof(sql),
"SELECT repo_id from SharedRepo WHERE repo_id='%s' AND "
"from_email='%s' AND to_email='%s'", repo_id, from_email,
to_email);
if (seaf_db_check_for_existence (mgr->seaf->db, sql))
return 0;
snprintf (sql, sizeof(sql),
"INSERT INTO SharedRepo VALUES ('%s', '%s', '%s', '%s')", repo_id,
from_email, to_email, permission);
if (seaf_db_query (mgr->seaf->db, sql) < 0)
return -1;
return 0;
}
