/// <summary>
/// Подключение к СУБД
/// </summary>
/// <param name="pCredentials"></param>
public static void ConnectDb(DbCredentials pCredentials)
{
switch (Db.CurrDbType)
{
case DbType.Vertica:
Connection = DbVertica.ConnectDb(pCredentials);
break;
default: throw new NotImplementedException("Нет реализации для данного типа СУБД");
}
}
public static VerticaConnection ConnectDb(DbCredentials pCredentials)
{
var vcsb = new VerticaConnectionStringBuilder
{
Database = pCredentials.DataBase,
User = pCredentials.User,
Password = pCredentials.Password,
Host = pCredentials.ServerIp
};
var vConnection = new VerticaConnection(vcsb.ConnectionString);
vConnection.Open();
return vConnection;
}
public static async Task <DbCredentials> GetDbCredentials()
{
if (!File.Exists(CredentialFileName))
{
var creds = new DbCredentials("localhost", 3306, "root", "");
var json = JsonConvert.SerializeObject(creds, Formatting.Indented);
await File.WriteAllTextAsync(CredentialFileName, json);
return(creds);
}
else
{
var json = await File.ReadAllTextAsync(CredentialFileName);
return(JsonConvert.DeserializeObject <DbCredentials>(json));
}
}