public static Task CreateDatabaseAsync(this MySqlDatabase db)
{
return Task.Run(() =>
{
MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder();
connStr.Server = db.Host;
connStr.Port = (uint)db.Port;
connStr.UserID = db.Username;
connStr.Password = db.Password;
string connString = connStr.ToString();
string nonQuery = String.Format("DROP DATABASE IF EXISTS {0}; CREATE DATABASE {0};", db.DatabaseName);
using (MySqlConnection conn = new MySqlConnection(connString))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand(nonQuery, conn))
{
cmd.ExecuteNonQuery();
}
conn.Close();
}
});
}
protected MySQLDatabase(MySQLStorageEngine engine)
{
StorageEngine = engine;
Name = String.Format("MySQL ({0})", StorageEngine);
Category = "SQL";
Description = "MySQL + .NET Connector";
Website = "http://www.mysql.com/";
Color = System.Drawing.Color.FromArgb(215, 233, 247);
Requirements = new string[]
{
"MySql.Data.dll"
};
MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder();
cb.ConnectionLifeTime = 0;
cb.DefaultCommandTimeout = 0;
cb.Server = "localhost";
cb.UserID = "root";
cb.Password = "";
cb.Database = "test";
CollectionName = "table1";
ConnectionString = cb.ConnectionString;
InsertsPerQuery = 10000;
}
public override void initialize_connections(ConfigurationPropertyHolder configuration_property_holder)
{
if (!string.IsNullOrEmpty(connection_string))
{
string[] parts = connection_string.Split(';');
foreach (string part in parts)
{
if (string.IsNullOrEmpty(server_name) && (part.to_lower().Contains("server") || part.to_lower().Contains("data source")))
{
server_name = part.Substring(part.IndexOf("=") + 1);
}
if (string.IsNullOrEmpty(database_name) && (part.to_lower().Contains("database") || part.to_lower().Contains("database")))
{
database_name = part.Substring(part.IndexOf("=") + 1);
}
}
}
configuration_property_holder.ConnectionString = connection_string;
set_provider();
if (string.IsNullOrEmpty(admin_connection_string))
{
var builder = new MySqlConnectionStringBuilder(connection_string);
builder.Database = "information_schema";
admin_connection_string = builder.ConnectionString;
}
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="Engine">The string name, from the GetDatabaseEngine() method</param>
/// <param name="Host">The Database server IP Address</param>
/// <param name="Port">The Database server Port Number</param>
/// <param name="DatabaseName">The name of the database</param>
/// <param name="User">A username, with database privliages</param>
/// <param name="Pass">The password to the User</param>
public DatabaseDriver(string Engine, string Host, int Port, string DatabaseName, string User, string Pass)
{
// Set class variables, and create a new connection builder
this.DatabaseEngine = GetDatabaseEngine(Engine);
DbConnectionStringBuilder Builder;
if (this.DatabaseEngine == DatabaseEngine.Sqlite)
{
string FullPath = Path.Combine(MainForm.Root, DatabaseName + ".sqlite3");
IsNewDatabase = !File.Exists(FullPath) || new FileInfo(FullPath).Length == 0;
Builder = new SQLiteConnectionStringBuilder();
Builder.Add("Data Source", FullPath);
Connection = new SQLiteConnection(Builder.ConnectionString);
}
else if (this.DatabaseEngine == DatabaseEngine.Mysql)
{
IsNewDatabase = false;
Builder = new MySqlConnectionStringBuilder();
Builder.Add("Server", Host);
Builder.Add("Port", Port);
Builder.Add("User ID", User);
Builder.Add("Password", Pass);
Builder.Add("Database", DatabaseName);
Connection = new MySqlConnection(Builder.ConnectionString);
}
else
{
throw new Exception("Invalid Database type.");
}
}
protected void OnTestClicked(object sender, EventArgs e)
{
MySql.Data.MySqlClient.MySqlConnectionStringBuilder bld
= new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
bld.Server = _server.Text;
bld.UserID = _user.Text;
bld.Password = _pass.Text;
_connectionstring = bld.ConnectionString;
MySql.Data.MySqlClient.MySqlConnection con
= new MySql.Data.MySqlClient.MySqlConnection();
con.ConnectionString = _connectionstring;
MessageDialog dlg;
try{
con.Open();
if (con.State != System.Data.ConnectionState.Open)
{
dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok, "オープンできません。" + con.State.ToString());
dlg.Show();
}
else
{
dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Info, ButtonsType.Ok, "Success. " + con.State.ToString());
dlg.Show();
con.Close();
}
}
catch (MySql.Data.MySqlClient.MySqlException ex) {
dlg = new MessageDialog(this, DialogFlags.Modal, MessageType.Error, ButtonsType.Ok, "Can not open MySQL." + ex.ErrorCode.ToString());
dlg.Show();
}
}
private void GetOptionsPricingParam()
{
//从数据库中读取合约参数
MySqlConnection connMysql = new MySqlConnection();
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Server = "10.2.7.210";
connBuilder.Port = 3306;
connBuilder.Database = "otc";
connBuilder.UserID = "tanzehuan";
connBuilder.Password = "******";
connMysql.ConnectionString = connBuilder.ConnectionString;
connMysql.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter("select * from options_contracts", connMysql);//创建连接sql数据库和datatable的dataadapter
adapter.Fill(this, "options_contracts");//将sql数据库中的数据读入datatable
connMysql.Close();
//在datatable中添加新的列，用来储存最新价
DataColumn col = new DataColumn("last_price");
col.DataType = typeof(decimal);
col.AllowDBNull = true;
col.DefaultValue = 0;
this.Tables["options_contracts"].Columns.Add(col);
DataColumn colBls = new DataColumn("bls_price");
colBls.DataType = typeof(decimal);
colBls.AllowDBNull = true;
colBls.DefaultValue = 0;
this.Tables["options_contracts"].Columns.Add(colBls);
}
private void btnOK_Click(object sender, EventArgs e)
{
//验证控件内容
if (!CheckInput())
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "بوش قالمىسۇن";
return;
}
lblMsg.ForeColor = Color.Blue;
lblMsg.Text = "ساندانغا ئۇلىنىۋاتىدۇ...";
//string conStr = string.Format("user id={0};password={1};host={2};Database={3};persist security info=True", txtUserName.Text.Trim(), txtPassWord.Text, txtHost.Text.Trim(), txtDataBase.Text.Trim());
MySqlConnectionStringBuilder buil = new MySqlConnectionStringBuilder();
buil.CharacterSet = "utf8";
buil.Server = txtHost.Text.Trim();
buil.UserID = txtUserName.Text.Trim();
buil.Password = txtPassWord.Text;
buil.Database = txtDataBase.Text.Trim();
using (MySqlConnection con = new MySqlConnection(buil.ConnectionString))
{
try
{
con.Open();
}
catch (Exception)
{
lblMsg.ForeColor = Color.Red;
lblMsg.Text = "ساندانغا ئۇلىنالمىدى";
return;
}
}
MessageBox.Show("ساندانغا مۇۋاپىقىيەتلىك ئۇلاندى!~");
Helper.conStr = buil.ConnectionString;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
/// <summary>
///
/// </summary>
/// <param name="connStr">���ܹ��������ַ���</param>
/// <returns></returns>
/// <exception cref="System.NullReferenceException"></exception>
/// <exception cref="System.Execption"></exception>
public static MySqlConnection GetMySqlConn(string connStr)
{
if(string.IsNullOrEmpty(connStr))
{
throw new System.NullReferenceException("�����ֲ���Ϊ��");
}
string tmp = PswdHelper.DecryptString(connStr);
string[] ss = tmp.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
if(ss.Length!=5)
{
throw new Exception("�����ָ�ʽ����");
}
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("User Id", ss[0]);
connBuilder.Add("Password", ss[1]);
connBuilder.Add("Data Source", ss[2]);
connBuilder.Add("Database", ss[3]);
connBuilder.Add("Charset", ss[4]);
MySqlConnection connection =
new MySqlConnection(connBuilder.ConnectionString);
return connection;
}
// Zu Quell- und Zieldatenbank verbinden
private void connectFischFaunaButton_Click(object sender, EventArgs e)
{
DatabaseConnection sourceCon = (DatabaseConnection)sourceDatabaseConnetions.SelectedValue;
DatabaseConnection targetCon = (DatabaseConnection)targetDatabaseConnetions.SelectedValue;
NpgsqlConnectionStringBuilder pgConStrBuilder = new NpgsqlConnectionStringBuilder();
pgConStrBuilder.Host = sourceCon.ServerAddress;
pgConStrBuilder.UserName = sourceCon.UserName;
pgConStrBuilder.Password = sourceCon.Password;
pgConStrBuilder.Database = sourceCon.Database;
MySqlConnectionStringBuilder mySqlConStrBuilder = new MySqlConnectionStringBuilder();
mySqlConStrBuilder.Server = targetCon.ServerAddress;
mySqlConStrBuilder.UserID = targetCon.UserName;
mySqlConStrBuilder.Password = targetCon.Password;
mySqlConStrBuilder.Database = targetCon.Database;
mySqlConStrBuilder.AllowZeroDateTime = true;
_sourceCon = new NpgsqlConnection(pgConStrBuilder.ToString());
_targetCon = new MySqlConnection(mySqlConStrBuilder.ToString());
_mainLogic = new MainLogic(_sourceCon, _targetCon);
_mainLogic.CheckForImportedFieldInMySql();
FillImportsCombobox();
FillImportUsersCombobox();
FillRecordQualityCombobox();
FillSourceTypeCombobox();
FillCountryCombobox();
PreSelectTestData();
groupBox2.Enabled = true;
}
public static void DeleteBoatSQL(string sqlQuery)
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "boatclub");
connBuilder.Add("Data Source", "127.0.0.1");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "");
MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString);
MySqlCommand cmd = connection.CreateCommand();
connection.Open();
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(String.Format("{0} {1} {2}",
reader.GetInt32(0), reader.GetString(1), reader.GetString(2))
);
}
reader.Close();
}
private void TestBtn_Click(object sender, EventArgs e)
{
// Disable console
this.Enabled = false;
// Build Connection String
DbConnectionStringBuilder Builder = new MySqlConnectionStringBuilder();
Builder.Add("Server", Hostname.Text);
Builder.Add("Port", (int)Port.Value);
Builder.Add("User ID", Username.Text);
Builder.Add("Password", Password.Text);
Builder.Add("Database", DBName.Text);
// Attempt to connect, reporting any and all errors
try
{
MySqlConnection Connection = new MySqlConnection(Builder.ConnectionString);
Connection.Open();
Connection.Close();
}
catch(Exception E)
{
this.Enabled = true;
MessageBox.Show(E.Message, "Connection Error");
return;
}
MessageBox.Show("Connection Successful!", "Success");
this.Enabled = true;
}
private bool testConnection()
{
bool returning;
//Teste Mysql-Verbindung
MySqlConnectionStringBuilder connectionString = new MySqlConnectionStringBuilder();
connectionString.Server = mysqlRow.Host;
connectionString.Port = mysqlRow.Port;
connectionString.Database = mysqlRow.Database;
connectionString.UserID = mysqlRow.UserID;
connectionString.Password = mysqlRow.Password;
connectionString.ConnectionTimeout = 3;
MySqlConnection connection = new MySqlConnection(connectionString.ConnectionString);
try
{
connection.Open();
this.mysqlConnection = connection;
returning = true;
}
catch (MySqlException ex)
{
this.mysqlException = ex.Message;
returning = false;
}
finally
{
connection.Close();
}
return returning;
}
public override bool Connect() {
bool opened = true;
if (this.Connection == null || this.Connection.State == ConnectionState.Closed) {
if (this.Connection != null) {
this.Connection.Close();
this.Connection = null;
}
MySqlConnectionStringBuilder connectionBuilder = new MySqlConnectionStringBuilder {
Server = this.Settings.Hostname,
Port = this.Settings.Port != null ? this.Settings.Port.Value : 0,
Database = this.Settings.Database,
UserID = this.Settings.Username,
Password = this.Settings.Password,
UseCompression = true
};
try {
this.Connection = new MySqlConnection(connectionBuilder.ToString());
this.Connection.Open();
if (this.Connection.State != ConnectionState.Open) {
this.Connection.Close();
this.Connection = null;
}
}
catch {
opened = false;
}
}
return opened;
}
/// <summary>
/// static constructor to determine the state of the environment and set defaults
/// </summary>
static CurrentEnvironment()
{
// Not on cloud foundry filling in the blanks.
if (string.IsNullOrEmpty(Environment.GetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME)))
{
Environment.SetEnvironmentVariable(BOUND_SERVICES_ENV_VARIABLE_NAME, "{}");
Environment.SetEnvironmentVariable(PORT_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
Environment.SetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
Environment.SetEnvironmentVariable(INSTANCE_INDEX_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
}
// check to see if DB is bound, if so...what type
// sql server first
if (BoundServices.GetValue("mssql-dev") != null) // sql server
{
DbEngine = DatabaseEngine.SqlServer;
_connectionString = BoundServices["mssql-dev"][0]["credentials"]["connectionString"].ToString();
}
else if (BoundServices.GetValue("p-mysql") != null)
{
DbEngine = DatabaseEngine.MySql;;
MySqlConnectionStringBuilder csbuilder = new MySqlConnectionStringBuilder();
csbuilder.Add("server", BoundServices["p-mysql"][0]["credentials"]["hostname"].ToString());
csbuilder.Add("port", BoundServices["p-mysql"][0]["credentials"]["port"].ToString());
csbuilder.Add("uid", BoundServices["p-mysql"][0]["credentials"]["username"].ToString());
csbuilder.Add("pwd", BoundServices["p-mysql"][0]["credentials"]["password"].ToString());
csbuilder.Add("database", BoundServices["p-mysql"][0]["credentials"]["name"].ToString());
_connectionString = csbuilder.ToString();
}
else
DbEngine = DatabaseEngine.None;
}
public static void ClearPool(MySqlConnectionStringBuilder settings)
{
Debug.Assert(settings != null);
string text = settings.ConnectionString;
ClearPoolByText(text);
}
public DataTable GetComments(string queryString)
{
DataTable = new DataTable();
mysqlCS = connectToBase();
using (con = new MySqlConnection())
{
con.ConnectionString = mysqlCS.ConnectionString;
command = new MySqlCommand(queryString, con);
try
{
con.Open();
using (dr = command.ExecuteReader())
{
if (dr.HasRows)
{
DataTable.Load(dr);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
return DataTable;
}
private static string GetKey(MySqlConnectionStringBuilder settings)
{
string key = settings.ConnectionString;
#if !CF
if(settings.IntegratedSecurity && !settings.ConnectionReset)
{
try
{
// Append SID to the connection string to generate a key
// With Integrated security different Windows users with the same
// connection string may be mapped to different MySQL accounts.
System.Security.Principal.WindowsIdentity id =
System.Security.Principal.WindowsIdentity.GetCurrent();
key += ";" + id.User;
}
catch (System.Security.SecurityException ex)
{
// Documentation for WindowsIdentity.GetCurrent() states
// SecurityException can be thrown. In this case the
// connection can only be pooled if reset is done.
throw new MySqlException(Resources.NoWindowsIdentity, ex );
}
}
#endif
return key;
}
DataTable dt_dr = new DataTable(); // tek tablo
#endregion Fields
#region Constructors
public Form3(MySqlConnectionStringBuilder _bag)
{
InitializeComponent();
MySqlConnection conn = new MySqlConnection(_bag.ToString());
MySqlCommand cmd_hasta_sel = new MySqlCommand("select h.tc,h.adsoyad,d.doktorad from hasta h inner join doktor d on d.iddoktor=h.iddr;", conn);
da_hasta = new MySqlDataAdapter();
da_hasta.SelectCommand = cmd_hasta_sel;
MySqlCommand cmd_dr_sel = new MySqlCommand("select iddoktor, doktorad from doktor;", conn);
MySqlDataAdapter da_dr = new MySqlDataAdapter();
da_dr.SelectCommand = cmd_dr_sel;
da_dr.Fill(dt_dr); // doktorlarin listesi
da_hasta_ekle = new MySqlDataAdapter(); // hasta eklemek icin
MySqlCommand cmdhasta_sel = new MySqlCommand("select tc, adsoyad, iddr from hasta;", conn);
MySqlCommand cmdhasta_ins = new MySqlCommand("insert into hasta(tc, adsoyad, iddr) values(@tc, @adsoyad, @iddr);", conn);
cmdhasta_ins.Parameters.Add("@tc", MySqlDbType.VarChar, 11, "tc");
cmdhasta_ins.Parameters.Add("@adsoyad", MySqlDbType.VarChar, 45, "adsoyad");
cmdhasta_ins.Parameters.Add("@iddr", MySqlDbType.Int32, 11, "iddr");
da_hasta_ekle.SelectCommand = cmdhasta_sel;
da_hasta_ekle.InsertCommand = cmdhasta_ins;
verigetir();
// doktorlarin listesini comboya
for (int i = 0; i < dt_dr.Rows.Count; i++)
cdoktor.Items.Add(dt_dr.Rows[i].ItemArray[1].ToString());
}
public DbConnection CreateConnection(string nameOrConnectionString)
{
var connectionBuilder = new MySqlConnectionStringBuilder(_baseConnectionString);
connectionBuilder.Database = nameOrConnectionString;
return new MySqlConnection(connectionBuilder.ToString());
}
public static MySqlConnectionStringBuilder ConnectionBuilder()
{
string connectionString = "Server=127.0.0.1;Database=vk_app;Uid=root;CharSet=utf8";
MySqlConnectionStringBuilder mysqlCSB;
mysqlCSB = new MySqlConnectionStringBuilder(connectionString);
return mysqlCSB;
}
public static void Command(string command)
{
try
{
var connstring = new MySqlConnectionStringBuilder
{
Server = meh.Default.MysqlHost,
UserID = meh.Default.MysqlUsername,
Password = meh.Default.MysqlPassword,
Database = meh.Default.MysqlDatabase
};
var connection = new MySqlConnection(connstring.ToString());
LogWriter.WriteLine(@"opening connection to mysql");
connection.Open();
LogWriter.WriteLine(@"connection successful!");
var sqlcommand = new MySqlCommand(command, connection);
LogWriter.WriteLine(@"Running sql command");
sqlcommand.ExecuteNonQuery();
LogWriter.WriteLine(@"Sql Command finished.");
}
catch (Exception ex)
{
MessageBox.Show(@"An Error occured while importing the file!, log output should have more info.");
LogWriter.WriteLine(ex.Data + ex.StackTrace + ex.Message);
}
}
public WizardSelectDatabaseViewModel(WizardSelectDatabaseModel model, string host, int port, string username, string password)
{
WizardSelectDatabase = model;
OkCommand = new Command(Ok);
CancelCommand = new Command(CancelCmd);
var connStr = new MySqlConnectionStringBuilder();
connStr.Server = host;
connStr.Port = (uint)port;
connStr.UserID = username;
connStr.Password = password;
using (var connection = new MySqlConnection(connStr.ToString()))
{
connection.Open();
using (var returnVal = new MySqlDataAdapter("SHOW DATABASES", connection))
{
var dataTable = new DataTable();
returnVal.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
for (int i = 0; i < row.ItemArray.Length; i++)
Databases.Add(row.ItemArray[i].ToString());
}
}
}
public static SerializeResult Serialize()
{
try
{
var Builder = new MySqlConnectionStringBuilder();
Builder.Server = Settings.GetValue("Database.Host");
Builder.Port = uint.Parse(Settings.GetValue("Database.Port"));
Builder.UserID = Settings.GetValue("Database.Username");
Builder.Password = Settings.GetValue("Database.Password");
Builder.Database = Settings.GetValue("Database.Database");
Builder.Pooling = Settings.GetValue("Database.Pooling.Enabled").ToLower() == "true";
Builder.MinimumPoolSize = uint.Parse(Settings.GetValue("Database.Pooling.Min"));
Builder.MaximumPoolSize = uint.Parse(Settings.GetValue("Database.Pooling.Max"));
ConnectionString = Builder.ConnectionString;
var Connection = new MySqlConnection(ConnectionString);
Connection.Open();
Solution.AppendLine("DatabaseHandler: Connected with database: {0}({1})", Connection.Database, Connection.ServerVersion);
}
catch { return SerializeResult.Broken; }
return SerializeResult.Finished;
}
// API GO
// Запросы на получение
public DataTable get_clients()
{
DataTable dt = new DataTable();
MySqlConnectionStringBuilder mysqlCSB;
mysqlCSB = new MySqlConnectionStringBuilder();
mysqlCSB.Server = server;
mysqlCSB.Database = db;
mysqlCSB.UserID = user;
mysqlCSB.Password = pass;
string queryString = @"SELECT *
FROM clients";
using (MySqlConnection con = new MySqlConnection())
{
con.ConnectionString = mysqlCSB.ConnectionString;
MySqlCommand com = new MySqlCommand(queryString, con);
try
{
con.Open();
using (MySqlDataReader dr = com.ExecuteReader())
{
if (dr.HasRows)
{
dt.Load(dr);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
return dt;
}
// Передача параметров подключения фенкции, с последующим назначением свойств.
/// <summary>
/// Метод MySqlConnection. Устанавливает подлючение к БД.
/// </summary>
public static bool MySqlConnection(string user, string passwd, string host, string db, bool test)
{
User = user;
Pass = passwd;
Host = host;
DB = db;
MySqlConnectionStringBuilder mysqlSting = new MySqlConnectionStringBuilder();
mysqlSting.Server = Host;
mysqlSting.Database = DB;
mysqlSting.UserID = User;
mysqlSting.Password = Pass;
mysqlSting.CharacterSet = "utf8";
connection = new MySqlConnection(mysqlSting.ToString());
{
try
{
connection.Open();
connection.Close();
return true;
}
catch { return false; }
}
}
public DatabaseDriver()
{
this.DatabaseEngine = Config.GetDatabaseEngine();
DbConnectionStringBuilder Builder;
if (this.DatabaseEngine == DatabaseEngine.Sqlite)
{
Builder = new SQLiteConnectionStringBuilder();
string FullPath = Path.Combine(Utils.AssemblyPath, Config.GetType<string>("Database", "Database") + ".sqlite3");
IsNewDatabase = !File.Exists(FullPath) || new FileInfo(FullPath).Length == 0;
Builder.Add("Data Source", FullPath);
Connection = new SQLiteConnection(Builder.ConnectionString);
}
else if (this.DatabaseEngine == DatabaseEngine.Mysql)
{
Builder = new MySqlConnectionStringBuilder();
Builder.Add("Server", Config.GetType<string>("Database", "Hostname"));
Builder.Add("Port", Config.GetType<int>("Database", "Port"));
Builder.Add("User ID", Config.GetType<string>("Database", "Username"));
Builder.Add("Password", Config.GetType<string>("Database", "Password"));
Builder.Add("Database", Config.GetType<string>("Database", "Database"));
Connection = new MySqlConnection(Builder.ConnectionString);
}
else
{
throw new Exception("Invalid Database type.");
}
}
private static void StringBuilderCopy(DbConStringBuilder strBuilder, MySqlConnectionStringBuilder stringBuilder)
{
stringBuilder.Server = strBuilder.Server;
stringBuilder.UserID = strBuilder.UserID;
stringBuilder.Password = strBuilder.Password;
stringBuilder.Database = strBuilder.Database;
}
private string BuildConnectionString()
{
uint port = 0;
try
{
port = Convert.ToUInt32(this.portTB.Text);
}
catch (FormatException)
{
MessageBox.Show("Invalid port number.");
return null;
}
MySqlConnectionStringBuilder bldr = new MySqlConnectionStringBuilder();
bldr.Server = this.hostTB.Text.Trim();
bldr.Port = port;
bldr.UserID = this.userTB.Text.Trim();
bldr.Database = this.dbTB.Text.Trim();
bldr.Password = this.passwordTB.Text;
if (this.useSslCB.Checked)
{
bldr.SslMode = MySqlSslMode.Required;
}
return bldr.GetConnectionString(true);
}
/// <summary>
/// Default Constructor
/// </summary>
public ConnectionStringDialog()
{
InitializeComponent();
this.cmbServerName.Items.Add("<Browse for more>");
this.cmbServerName.Text = "";
dbConnectionStringBuilder = new MySqlConnectionStringBuilder();
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="Engine">The string name, for the GetDatabaseEngine() method</param>
/// <param name="Host">The Database server IP Address</param>
/// <param name="Port">The Database server Port Number</param>
/// <param name="DatabaseName">The name of the database</param>
/// <param name="User">A username, with database privliages</param>
/// <param name="Pass">The password to the User</param>
public DatabaseDriver(string Engine, string Host, int Port, string DatabaseName, string User, string Pass)
{
// Set class variables, and create a new connection builder
this.DatabaseEngine = GetDatabaseEngine(Engine);
DbConnectionStringBuilder Builder;
// Establish the connection
if (this.DatabaseEngine == DatabaseEngine.Sqlite)
{
// Create the connection
Builder = new SQLiteConnectionStringBuilder();
Builder.Add("Data Source", Path.Combine(Program.RootPath, DatabaseName + ".sqlite3"));
Connection = new SQLiteConnection(Builder.ConnectionString);
}
else if (this.DatabaseEngine == DatabaseEngine.Mysql)
{
// Create the connection
Builder = new MySqlConnectionStringBuilder();
Builder.Add("Server", Host);
Builder.Add("Port", Port);
Builder.Add("User ID", User);
Builder.Add("Password", Pass);
Builder.Add("Database", DatabaseName);
Builder.Add("Convert Zero Datetime", "true");
Connection = new MySqlConnection(Builder.ConnectionString);
}
else
{
throw new Exception("Invalid Database type.");
}
}
/// <include file='docs/MySqlConnection.xml' path='docs/DefaultCtor/*'/>
public MySqlConnection()
{
//TODO: add event data to StateChange docs
settings = new MySqlConnectionStringBuilder();
advisor = new UsageAdvisor(this);
database = String.Empty;
}
public static String getConnectionStr(String host, String port, String userName, String passWord, String dataBase)
{
MySql.Data.MySqlClient.MySqlConnectionStringBuilder builder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
builder.Server = host;
builder.Port = UInt32.Parse(port);
//builder.Database = dataBaseName;
builder.UserID = userName;
builder.Password = passWord;
builder.Database = dataBase;
return(builder.GetConnectionString(true));
//return String.Format("host={0};database={1};uid={2};pwd={3};charset=UTF-8", host, dataBaseName, userName, passWord);
}
public static DbConnection GetConnection(IOrchardServices orchardServices, ILogger logger)
{
var setting = orchardServices.WorkContext.CurrentSite.As <SuiteCRMSettingPart>();
if (setting == null)
{
logger.Error("SuiteCRMSettingPart is null for current site");
return(null);
}
DbConnectionStringBuilder builder = null;
string providerName = string.Empty;
if (setting.Provider == Constants.SqlServer)
{
var sqlConnectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
sqlConnectionStringBuilder.DataSource = setting.Host;
sqlConnectionStringBuilder.InitialCatalog = setting.Database;
sqlConnectionStringBuilder.UserID = setting.Username;
sqlConnectionStringBuilder.Password = setting.Password;
providerName = "System.Data.SqlClient";
EntityConnectionStringBuilder mainBuilder = new EntityConnectionStringBuilder();
mainBuilder.Provider = providerName;
mainBuilder.ProviderConnectionString = builder.ConnectionString;
mainBuilder.Metadata =
"res://*/Database.SuiteCRMDataContext.csdl|" +
"res://*/Database.SuiteCRMDataContext.ssdl|" +
"res://*/Database.SuiteCRMDataContext.msl";
return(new EntityConnection(mainBuilder.ConnectionString));
}
else if (setting.Provider == Constants.MySql)
{
var mySqlConnectionStringBuilder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
mySqlConnectionStringBuilder.Database = setting.Database;
mySqlConnectionStringBuilder.UserID = setting.Username;
mySqlConnectionStringBuilder.Password = setting.Password;
mySqlConnectionStringBuilder.Port = (uint)setting.Port;
mySqlConnectionStringBuilder.Server = setting.Host;
mySqlConnectionStringBuilder.OldGuids = true;
builder = mySqlConnectionStringBuilder;
return(new MySqlConnection(builder.ConnectionString));
}
else
{
logger.Error("The provider is not supported");
return(null);
}
}
private MySqlConnection GetMySqlConnection(bool open = true, bool convertZeroDatetime = false, bool allowZeroDatetime = false)
{
string cs = @"Server=35.228.116.222;Database=bachelordb;user=Read;pwd=Read1234;";
var csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(cs)
{
AllowZeroDateTime = allowZeroDatetime,
ConvertZeroDateTime = convertZeroDatetime
};
var conn = new MySql.Data.MySqlClient.MySqlConnection(csb.ConnectionString);
if (open)
{
conn.Open();
}
return(conn);
}
public static bool SetDatabaseParameters_MySQL()
{
try
{
MySql.Data.MySqlClient.MySqlConnectionStringBuilder sqlCnnStrBld = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
sqlCnnStrBld.Server = ConfigurationManager.AppSettings["dbServer_MySQL"].ToString();
sqlCnnStrBld.Database = ConfigurationManager.AppSettings["dbDatabase_MySQL"].ToString();
sqlCnnStrBld.UserID = ConfigurationManager.AppSettings["dbUserID_MySQL"].ToString();
sqlCnnStrBld.Password = ConfigurationManager.AppSettings["dbPassword_MySQL"].ToString();
strSQLconn_MySQL = sqlCnnStrBld.ConnectionString;
sqlCnnStrBld.Pooling = false;
sqlCnnStrBld.Clear();
strTableName = ConfigurationManager.AppSettings["dbImageTable_MySQL"].ToString();
return(true);
}
catch
{
return(false);
}
}
protected void CheckConnectionStringAsUri(string connectionstring, string user, string password, string server, uint port, params string[] parameters)
{
string result = this.session.ParseConnectionString(connectionstring);
MySql.Data.MySqlClient.MySqlConnectionStringBuilder csbuilder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(result);
Assert.True(user == csbuilder.UserID, string.Format("Expected:{0} Current:{1} in {2}", user, csbuilder.UserID, connectionstring));
Assert.True(password == csbuilder.Password, string.Format("Expected:{0} Current:{1} in {2}", password, csbuilder.Password, connectionstring));
Assert.True(server == csbuilder.Server, string.Format("Expected:{0} Current:{1} in {2}", server, csbuilder.Server, connectionstring));
Assert.True(port == csbuilder.Port, string.Format("Expected:{0} Current:{1} in {2}", port, csbuilder.Port, connectionstring));
if (parameters != null)
{
if (parameters.Length % 2 != 0)
{
throw new ArgumentOutOfRangeException();
}
for (int i = 0; i < parameters.Length; i += 2)
{
Assert.True(csbuilder.ContainsKey(parameters[i]));
Assert.Equal(parameters[i + 1], csbuilder[parameters[i]].ToString());
}
}
}
public DbConnectionStringBuilder BuildConnectionString(EnumDbProviderType providerType, string server, string database, string userId, string password, bool integratedSecurity = false, int port = 0, bool embedded = false, string provider = null)
{
var csb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
csb.Server = server;
csb.Database = database;
if (!string.IsNullOrWhiteSpace(userId))
{
csb.UserID = userId;
}
if (!string.IsNullOrWhiteSpace(password))
{
csb.Password = password;
}
if (integratedSecurity)
{
csb.IntegratedSecurity = integratedSecurity;
}
if (port > 0)
{
csb.Port = (uint)port;
}
return(csb);
}
public static void ClearPool(MySqlConnectionStringBuilder settings)
{
string text = settings.GetConnectionString(true);
ClearPoolByText(text);
}
internal object GetValue(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
{
return((bool)msb.values["useoldsyntax"]);
}
internal object getConnectiontimeout(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
{
return((uint)msb.values["connectiontimeout"]);
}
internal void SetSslMode(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender, object value)
{
sender.ValidateValue(ref value);
MySqlTrace.LogWarning(-1, "Encrypt is now obsolete. Use Ssl Mode instead");
msb.SetValue("Ssl Mode", ((bool)value) ? MySqlSslMode.Preferred : MySqlSslMode.None);
}
private async void Connect()
{
mainForm.ResetStatusStripColors();
TreeNode selectedNode = treeServers.SelectedNode;
if (selectedNode.Tag.GetType() == typeof(Realm))
{
Server selectedServer = (Server)selectedNode.Parent.Tag;
Realm selectedRealm = (Realm)selectedNode.Tag;
RealmManager.currRealm = selectedRealm;
if (selectedServer.useSSHTunnel)
{
if (selectedServer.sshHost != String.Empty && selectedServer.sshUser != String.Empty)
{
ServerManager.initSSH(new SshConnection(selectedServer.sshHost, selectedServer.sshPort, selectedServer.sshUser, selectedServer.sshPassword));
ServerManager.sshConn.AddForwardedPort(selectedServer.sshForwardedPort, selectedServer.sqlHost, selectedServer.sqlPort);
}
}
if (selectedServer.sqlHost != String.Empty && selectedServer.sqlUser != String.Empty)
{
if (selectedServer.authdb != String.Empty)
{
MySqlConnectionStringBuilder authString = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
authString.Server = selectedServer.sqlHost;
if (ServerManager.sshConn != null && ServerManager.sshConn.isConnected)
{
authString.Port = selectedServer.sshForwardedPort;
}
else
{
authString.Port = selectedServer.sqlPort;
}
authString.UserID = selectedServer.sqlUser;
authString.Password = selectedServer.sqlPassword;
authString.Database = selectedServer.authdb;
authString.IgnorePrepare = false;
connSuccess = ServerManager.InitDB(new AuthDatabase(authString));
}
if (selectedRealm.chardb != String.Empty)
{
MySqlConnectionStringBuilder charString = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
charString.Server = selectedServer.sqlHost;
if (ServerManager.sshConn != null && ServerManager.sshConn.isConnected)
{
charString.Port = selectedServer.sshForwardedPort;
}
else
{
charString.Port = selectedServer.sqlPort;
}
charString.UserID = selectedServer.sqlUser;
charString.Password = selectedServer.sqlPassword;
charString.Database = selectedRealm.chardb;
charString.IgnorePrepare = false;
connSuccess = ServerManager.InitDB(new CharDatabase(charString));
}
}
}
if (connSuccess)
{
await Account.LoadFromDB();
ServerManager.Save();
this.Close();
}
}
internal object GetSslMode(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
{
return(msb.SslMode > MySqlSslMode.None);
}
internal object GetIntegratedSecurity(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
{
return((bool)msb.values["Integrated Security"]);
}
public NativeDriver(MySqlConnectionStringBuilder settings)
: base(settings)
{
isOpen = false;
}
internal void SetValue(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender, object value)
{
MySqlTrace.LogWarning(-1, "Use Old Syntax is now obsolete. Please see documentation");
msb.SetValue("useoldsyntax", value);
}
/// <include file='docs/MySqlConnection.xml' path='docs/Open/*'/>
public override void Open()
{
if (State == ConnectionState.Open)
{
Throw(new InvalidOperationException(Resources.ConnectionAlreadyOpen));
}
#if !CF && !WINDOWS_UWP
// start up our interceptors
exceptionInterceptor = new ExceptionInterceptor(this);
commandInterceptor = new CommandInterceptor(this);
#endif
SetState(ConnectionState.Connecting, true);
AssertPermissions();
#if !CF && !WINDOWS_UWP
// if we are auto enlisting in a current transaction, then we will be
// treating the connection as pooled
if (Settings.AutoEnlist && Transaction.Current != null)
{
driver = DriverTransactionManager.GetDriverInTransaction(Transaction.Current);
if (driver != null &&
(driver.IsInActiveUse ||
!driver.Settings.EquivalentTo(this.Settings)))
{
Throw(new NotSupportedException(Resources.MultipleConnectionsInTransactionNotSupported));
}
}
#endif
try
{
MySqlConnectionStringBuilder currentSettings = Settings;
#if !CF
// Load balancing
if (ReplicationManager.IsReplicationGroup(Settings.Server))
{
if (driver == null)
{
ReplicationManager.GetNewConnection(Settings.Server, false, this);
}
else
{
currentSettings = driver.Settings;
}
}
#endif
if (Settings.Pooling)
{
MySqlPool pool = MySqlPoolManager.GetPool(currentSettings);
if (driver == null || !driver.IsOpen)
{
driver = pool.GetConnection();
}
procedureCache = pool.ProcedureCache;
}
else
{
if (driver == null || !driver.IsOpen)
{
driver = Driver.Create(currentSettings);
}
procedureCache = new ProcedureCache((int)Settings.ProcedureCacheSize);
}
}
catch (Exception ex)
{
SetState(ConnectionState.Closed, true);
throw;
}
// if the user is using old syntax, let them know
if (driver.Settings.UseOldSyntax)
{
MySqlTrace.LogWarning(ServerThread,
"You are using old syntax that will be removed in future versions");
}
SetState(ConnectionState.Open, false);
driver.Configure(this);
if (!(driver.SupportsPasswordExpiration && driver.IsPasswordExpired))
{
if (Settings.Database != null && Settings.Database != String.Empty)
{
ChangeDatabase(Settings.Database);
}
}
// setup our schema provider
schemaProvider = new ISSchemaProvider(this);
#if !CF
perfMonitor = new PerformanceMonitor(this);
#endif
// if we are opening up inside a current transaction, then autoenlist
// TODO: control this with a connection string option
#if !MONO && !CF && !WINDOWS_UWP
if (Transaction.Current != null && Settings.AutoEnlist)
{
EnlistTransaction(Transaction.Current);
}
#endif
hasBeenOpen = true;
SetState(ConnectionState.Open, true);
}
/// <include file='docs/MySqlConnection.xml' path='docs/DefaultCtor/*'/>
public MySqlConnection()
{
//TODO: add event data to StateChange docs
Settings = new MySqlConnectionStringBuilder();
database = String.Empty;
}
public abstract object GetObject(MySqlConnectionStringBuilder builder);
public TracingDriver(MySqlConnectionStringBuilder settings)
: base(settings)
{
driverId = Interlocked.Increment(ref driverCounter);
}
//
// Entity Code Gen
//
public string GetSourceCode()
{
tit = Filename;
tit = tit.Substring(tit.LastIndexOf(Resources.DirSp) + 1, tit.LastIndexOf(".") - tit.LastIndexOf("/") - 1);
string ret = Resources.Header1;
ret = ret + Resources.ComSp + tab + tit + ".cs" + nl + nl;
ret = ret + "NameSpace " + Name + Resources.SB + nl
+ tab + "[DbConfigurationType(typeof(MySqlEFConfiguration))]" + nl
+ tab + "public partial class " + tit + "DB : DbContext {" + nl
+ tab + tab + "public " + tit + "DB() : base(" + bd + "name=" + tit + "ConnectionS" + bd + ") {" + nl
+ tab + tab + tab + _init + ";" + nl
+ tab + tab + "}" + nl
+ tab + tab + "public " + tit + "DB(string ConnectionString) : base( ConnectionString ){ " + nl
+ tab + tab + tab + _init + ";" + nl
+ tab + tab + "}" + nl
+ tab + tab + "public " + tit + "DB(MySqlConnection Connection) : base(Connection.ConnectionString) {" + nl
+ tab + tab + tab + _init + ";" + nl
+ tab + tab + "}" + nl
+ tab + tab + "private void " + _init + " {" + nl;
if (Routines.Count > 0)
{
ret = ret + tab + tab + tab + tit + "Connection = new MySqlConnection();" + nl;
}
foreach (MyRoutine rtn in Routines)
{
ret = ret + tab + tab + tab + rtn.name + " = new MySqlCommand();" + nl;
ret = ret + tab + tab + tab + rtn.name + ".Connection = (MySqlConnection)"
+ "Database.Connection;" + nl;
ret = ret + tab + tab + tab + rtn.name + ".CommandText = \"CALL " + rtn.name;
if (rtn.Params.Count > 0)
{
ret = ret + " (\"" + nl;
}
else
{
ret = ret + ";\";" + nl;
}
int wk1 = 0;
foreach (MyRoutineParam prm in rtn.Params)
{
wk1++;
ret = ret + tab + tab + tab + tab + "+ \"`" + prm.name + "`";
if (wk1 != rtn.Params.Count)
{
ret = ret + ",\"" + nl;
}
else
{
ret = ret + "\"" + nl + tab + tab + tab + tab + "+ \");\";" + nl;
}
}
foreach (MyRoutineParam prm in rtn.Params)
{
ret = ret + tab + tab + tab + rtn.name + ".Parameters.Add(new MySqlParameter(\""
+ prm.name + "\",";
int len = prm.datatype.LastIndexOf("(");
if (len < 1)
{
len = prm.datatype.Length;
}
//len--;
string type = prm.datatype.Substring(0, len);
type = type.ToLower();
type = paramtype(type);
ret = ret + type + "));" + nl;
}
}
ret = ret + tab + tab + Resources.EB + nl;
foreach (MyTable tbl in Tables)
{
ret = ret + tab + tab + "public DbSet<" + tbl.name + "> " + tbl.name + "s " + prop + nl;
}
ret = ret + nl;
if (Routines.Count > 0)
{
ret = ret + tab + tab + "private MySqlConnection " + tit + "Connection;" + nl;
}
foreach (MyRoutine rtn_name in Routines)
{
ret = ret + tab + tab + "public MySqlCommand " + rtn_name.name + ";" + nl;
}
ret = ret + nl + tab + "}" + nl + nl;
foreach (MyTable tbl in Tables)
{
ret = ret + tab + "public partial class " + tbl.name + " {" + nl;
MyIndexColumn icx = null;
MyIndex ixx = null;
foreach (MyColumn col in tbl.Columns)
{
icx = null;
ixx = null;
foreach (MyIndex idx in Indexes)
{
foreach (MyIndexColumn icl in idx.IndexColumn)
{
if (col.linkid == icl.referencedColumn)
{
icx = icl;
break;
}
}
if (icx != null)
{
ixx = idx;
break;
}
}
if ((icx != null) && (ixx != null))
{
if (ixx.isPrimary > 0)
{
if (col.autoIncrement > 0)
{
ret = ret + tab + tab + "[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]" + nl;
}
else
{
ret = ret + tab + tab + "[Key, DatabaseGenerated(DatabaseGeneratedOption.None)]" + nl;
}
}
}
MyUserDatatype typ = Usertype.Find(x => x.actualType == col.SimpleDatatype);
string styp = "";
if (typ != null)
{
styp = cstype(typ);
}
if (styp.Length < 1)
{
styp = col.SimpleDatatype.Substring(col.SimpleDatatype.LastIndexOf(".") + 1, col.SimpleDatatype.Length - col.SimpleDatatype.LastIndexOf(".") - 1);
styp = cstype(styp);
}
if (styp != "string")
{
if (col.isNotNull == 0)
{
ret = ret + tab + tab + "public Nullable<" + styp + "> " + col.name + prop + nl;
}
else
{
ret = ret + tab + tab + "public " + styp + " " + col.name + prop + nl;
}
}
else
{
ret = ret + tab + tab + "public " + styp + " " + col.name + prop + nl;
}
}
ret = ret + tab + Resources.EB + nl;
}
ret = ret + tab + "public partial class " + tit + "CreateDatabaseIfNotExists : CreateDatabaseIfNotExists<" + tit + "> {" + nl
+ tab + tab + "public " + tit + "CreateDatabaseIfNotExists() :base() {" + nl
+ tab + tab + Resources.EB + nl
+ tab + tab + "protected override void Seed(" + tit + " context) {" + nl
+ tab + tab + tab + "base.Seed(context);" + nl
+ tab + tab + Resources.EB + nl
+ tab + Resources.EB + nl
+ Resources.EB + nl;
string savename = Filename;
savename = savename.Substring(0, savename.LastIndexOf(Resources.DirSp));
savename = savename + Resources.DirSp + tit + ".cs";
StreamWriter wrt = File.CreateText(savename);
wrt.Write(ret);
wrt.Close();
savename = savename.Substring(0, savename.LastIndexOf(Resources.DirSp));
savename = savename + Resources.DirSp + "RreadmeAppconfig.txt";
wrt = File.CreateText(savename);
wrt.Write(Resources.Config1);
wrt.Write("\"" + tit + "ConnectionS\" ");
wrt.Write(Resources.Config2);
MySql.Data.MySqlClient.MySqlConnectionStringBuilder bld = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
bld.Server = Server;
bld.UserID = UserID;
bld.Password = Password;
bld.Database = Database;
wrt.Write("\"" + bld.ConnectionString + "\" ");
wrt.Write(Resources.Config3);
wrt.Close();
return(ret);
}
internal object GetUseprocedurebodies(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
{
return((bool)msb.values["useprocedurebodies"]);
}
