static char *
get_cached_head_id (SeafDB *db, const char *repo_id)
{
char *sql;
sql = "SELECT head_id FROM RepoSize WHERE repo_id=?";
return seaf_db_statement_get_string (db, sql, 1, "string", repo_id);
}
static char *
get_existing_virtual_repo (SeafRepoManager *mgr,
const char *origin_repo_id,
const char *path)
{
char *sql = "SELECT repo_id FROM VirtualRepo WHERE origin_repo = ? AND path = ?";
return seaf_db_statement_get_string (mgr->seaf->db, sql, 2,
"string", origin_repo_id, "string", path);
}
char *
seaf_share_manager_check_permission (SeafShareManager *mgr,
const char *repo_id,
const char *email)
{
char *sql;
sql = "SELECT permission FROM SharedRepo WHERE repo_id=? AND to_email=?";
return seaf_db_statement_get_string (mgr->seaf->db, sql,
2, "string", repo_id, "string", email);
}
char *
seaf_repo_manager_get_virtual_repo_id (SeafRepoManager *mgr,
const char *origin_repo,
const char *path,
const char *owner)
{
char *sql;
char *ret;
sql = "SELECT RepoOwner.repo_id FROM RepoOwner, VirtualRepo "
"WHERE owner_id=? AND origin_repo=? AND path=? "
"AND RepoOwner.repo_id = VirtualRepo.repo_id";
ret = seaf_db_statement_get_string (mgr->seaf->db, sql,
3, "string", owner, "string", origin_repo,
"string", path);
return ret;
}
