public bool MemberOfRole(string rolename)
{
string username = ConnectionStringUtility.GetToken(ConnectionString, "User id", "");
string sql = "select rolname from pg_user join pg_auth_members on (pg_user.usesysid=pg_auth_members.member) "
+ " join pg_roles on (pg_roles.oid=pg_auth_members.roleid) where pg_user.usename='"
+ username + "' and rolname ='" + rolename + "'";
var tbl = Table("roles1", sql);
return(tbl.Rows.Count > 0);
}
public static string GetFileName(string ConnectionString, string databasePath)
{
string fileName = ConnectionStringUtility.GetToken(ConnectionString, "FileName", "");
if (!Path.IsPathRooted(fileName))
{
string dir = Path.GetDirectoryName(databasePath);
fileName = Path.Combine(dir, fileName);
}
return(fileName);
}
/// <summary>
/// Modifies FileName in connection string to be relative to the specified path
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
public static string MakeFileNameRelative(string connectionString, string piscesDatabasePath)
{
string fn = ConnectionStringUtility.GetToken(connectionString, "FileName", "");
string rval = connectionString;
if (fn.Length > 0 && Directory.Exists(Path.GetDirectoryName(piscesDatabasePath)))
{// modify to be relative path to database
fn = FileUtility.RelativePathTo(Path.GetDirectoryName(piscesDatabasePath), fn);
rval = ConnectionStringUtility.Modify(connectionString, "FileName", fn);
}
return(rval);
}
public SQLiteServer(string connString)
{
if (File.Exists(connString) || connString.IndexOf("=") < 0)
{
ConnectionString = "Data Source=" + connString + ";";
FileName = connString;
}
else
{
ConnectionString = connString;
FileName = ConnectionStringUtility.GetToken(connString, "Data Source", "");
}
}
public PostgreSQL(string cs)
{
//SearchPath=wtr..
//searchpath=schemanamehere..
//NpgsqlConnection conn = new NpgsqlConnection(cs);
//"Server=127.0.0.1;Database=eeeeee;User id=npgsql_tests;password=npgsql_tests;");
ConnectionString = cs;
Name = ConnectionStringUtility.GetToken(cs, "Database", "");
var pw = ConnectionStringUtility.GetToken(cs, "password", "");
var logSafeConnectionString = cs;
if (pw.Trim() != "")
{
logSafeConnectionString = logSafeConnectionString.ToLower().Replace(pw, "*******");
}
SqlCommands.Add(logSafeConnectionString);
}
