| public ChangeDatabase ( string databaseName ) : void | ||
| databaseName | string | |
| return | void | |
public void CanCreateDBScriptWithDateTimePrecision()
{
if (Version < new Version(5, 6, 5)) return;
MySqlConnection c = new MySqlConnection(conn.ConnectionString);
c.Open();
var script = new MySqlScript(c);
using (var ctx = new datesTypesEntities())
{
MySqlCommand query = new MySqlCommand("Create database test_types", c);
query.Connection = c;
query.ExecuteNonQuery();
c.ChangeDatabase("test_types");
script.Query = ctx.CreateDatabaseScript();
script.Execute();
query = new MySqlCommand("Select Column_name, Is_Nullable, Data_Type, DateTime_Precision from information_schema.Columns where table_schema ='" + c.Database + "' and table_name = 'Products' and column_name ='DateTimeWithPrecision'", c);
query.Connection = c;
MySqlDataReader reader = query.ExecuteReader();
while (reader.Read())
{
Assert.AreEqual("DateTimeWithPrecision", reader[0].ToString());
Assert.AreEqual("NO", reader[1].ToString());
Assert.AreEqual("datetime", reader[2].ToString());
Assert.AreEqual("3", reader[3].ToString());
}
reader.Close();
ctx.DeleteDatabase();
c.Close();
}
}
public static MySqlConnection GetConnection()
{
MySqlConnection connection;
try
{
Dictionary<string, string> defaults = new Dictionary<string, string>();
defaults.Add("connectionString", "datasource=localhost;port=3306;username=talky;password=talky;");
defaults.Add("database", "talky");
ConfigurationFile config = new ConfigurationFile("database");
if (!config.Exists())
{
config.Write(defaults);
}
string connectionString;
string db;
config.Values(defaults).TryGetValue("connectionString", out connectionString);
config.Values(defaults).TryGetValue("database", out db);
connection = new MySqlConnection(connectionString);
connection.Open();
connection.ChangeDatabase(db);
return connection;
} catch (MySqlException e)
{
Program.Instance.OHGODNO("Terminate!! Could not connect to MySQL!! Danger!! Danger!!", e);
return null;
}
}
private void init(string connString) {
connection = new MySqlConnection(connString);
connection.Open();
connection.ChangeDatabase(Server.MySQLDatabaseName);
transaction = connection.BeginTransaction();
}
public override IDbConnection GetConnWithoutDatabaseSpecified()
{
var systemConnection = new MySqlConnection(connectionString);
systemConnection.Open();
systemConnection.ChangeDatabase("mysql");
return systemConnection;
}
public static void fill(string queryString, DataTable toReturn) {
using (var conn = new MySqlConnection(connString)) {
conn.Open();
conn.ChangeDatabase(Server.MySQLDatabaseName);
using (MySqlDataAdapter da = new MySqlDataAdapter(queryString, conn)) {
da.Fill(toReturn);
}
conn.Close();
}
}
public static void execute(string queryString, bool createDB) {
using (var conn = new MySqlConnection(connString)) {
conn.Open();
if (!createDB) {
conn.ChangeDatabase(Server.MySQLDatabaseName);
}
using (MySqlCommand cmd = new MySqlCommand(queryString, conn)) {
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="host"></param>
/// <param name="username"></param>
/// <param name="passwd"></param>
/// <param name="dbname"></param>
/// <param name="port"></param>
/// <param name="socket"></param>
public MySQLi(
string host = TAKE_FROM_INI,
string username = TAKE_FROM_INI,
string passwd = TAKE_FROM_INI,
string dbname = "",
int port = default_port,
string socket = TAKE_FROM_INI)
{
if (host == TAKE_FROM_INI)
PhpIni.TryGetValue("mysqli.default_host", out host);
if (username == TAKE_FROM_INI)
PhpIni.TryGetValue("mysqli.default_user", out username);
if (passwd == TAKE_FROM_INI)
PhpIni.TryGetValue("mysqli.default_pw", out passwd);
if (port == default_port)
{
string portStr;
if (PhpIni.TryGetValue("mysqli.default_port", out portStr))
port = int.Parse(portStr);
else
port = PhpIni.MYSQL_DEFAULT_PORT;
}
if (socket == TAKE_FROM_INI)
PhpIni.TryGetValue("mysqli.default_socket", out socket);
// MySQL a = new MySQL();
MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder();
b.Server = host;
b.UserID = username;
b.Port = (uint)port;
if (!string.IsNullOrEmpty(passwd))
b.Password = passwd;
_connection = new MySqlConnection(b.ToString());
try
{
_connection.Open();
if (!string.IsNullOrEmpty(dbname))
_connection.ChangeDatabase(dbname);
}
catch (MySqlException e)
{
connectError = e.Message;
connectErrno = e.Number;
}
catch (Exception e)
{
connectError = e.Message;
}
}
public static void executeQuery(string queryString, bool createDB = false)
{
int totalCount = 0;
if (!Server.useMySQL)
return;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
if (!createDB)
{
conn.ChangeDatabase(Server.MySQLDatabaseName);
}
using (MySqlCommand cmd = new MySqlCommand(queryString, conn))
{
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception e)
{
if (!createDB)
{
totalCount++;
if (totalCount > 10)
{
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
}
else
{
goto retry;
}
}
else
{
throw e;
}
}
}
public static void executeQuery(string queryString, bool createDB = false)
{
int totalCount = 0;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
if (!createDB)
{
conn.ChangeDatabase(Program.Config.DatabaseName);
}
MySqlCommand cmd = new MySqlCommand(queryString, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
}
catch (Exception e)
{
if (!createDB)
{
totalCount++;
if (totalCount > 10)
{
File.WriteAllLines("LastMySQLError.txt", new string[] {
"Query string: " + queryString,
"Error Log: " + e.ToString()
});
Console.WriteLine(e.ToString());
}
else
{
goto retry;
}
}
else
{
throw e;
}
}
}
public static DataTable fillData(string queryString, bool skipError = false)
{
DataTable toReturn = new DataTable("toReturn");
if (!Server.useMySQL) return toReturn;
int totalCount = 0;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
conn.ChangeDatabase(Server.MySQLDatabaseName);
using (MySqlDataAdapter da = new MySqlDataAdapter(queryString, conn))
{
da.Fill(toReturn);
}
conn.Close();
}
}
catch (Exception e)
{
totalCount++;
if (totalCount > 10)
{
if (!skipError)
{
File.WriteAllText("MySQL_error.log", queryString);
Server.ErrorLog(e);
}
}
else
goto retry;
}
return toReturn;
}
private void create(String project)
{
String mysqlDB = "mysql";
String connectionString = String.Format("server={0}; port={1}; user id={2}; password={3}; database={4}; pooling=false", server, port, username, password, mysqlDB);
DataSet dataset = new DataSet(database);
DataTable table;
MySqlCommand command;
MySqlDataReader datareader;
try
{
//Console.WriteLine("Opening connection to the '{0}' database.", mysqlDB);
connection = new MySqlConnection(connectionString);
connection.Open();
//Console.WriteLine("Deleting the '{0}' database!", database);
String dropDBQuery = String.Format("DROP DATABASE IF EXISTS {0}", database);
command = new MySqlCommand(dropDBQuery, connection);
command.ExecuteNonQuery();
//Console.WriteLine("Creating the '{0}' database.", database);
String createDBQuery = String.Format("CREATE DATABASE IF NOT EXISTS {0}", database);
command = new MySqlCommand(createDBQuery, connection);
command.ExecuteNonQuery();
//Console.WriteLine("Switching the connection to the '{0}' database.", database);
connection.ChangeDatabase(database);
// Create Tables and schema file.
String createTableQuery = String.Empty;
String tableName = String.Empty;
String sql = String.Empty;
// ComponentTable
tableName = "ComponentTable";
//Console.WriteLine("Creating the '{0}' table.", tableName);
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, type VARCHAR(80), name VARCHAR(80), description VARCHAR(255), etype VARCHAR(80), PRIMARY KEY (id)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
// ParameterTable
tableName = "ParameterTable";
//Console.WriteLine("Creating the '{0}' table.", tableName);
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, parentId INT NOT NULL, parentType VARCHAR(80), name VARCHAR(80), value VARCHAR(512), description VARCHAR(256), PRIMARY KEY (id), UNIQUE (parentId, parentType, name)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
// LinkTable
tableName = "LinkTable";
//Console.WriteLine("Creating the '{0}' table.", tableName);
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, fromComponentId INT, toComponentId INT, type VARCHAR(80), description VARCHAR(255), PRIMARY KEY (id)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
//RegistryKey rk = Registry.CurrentUser.CreateSubKey(@"Software\Aptima\MOST");
//String path = System.Convert.ToString(rk.GetValue("ConfigPath", ""));
//if (!path.Equals(String.Empty))
// {
// dataset.WriteXmlSchema(path + @"\" + "db.xsd");
//}
}
catch (MySqlException ex)
{
MessageBox.Show("Error connecting to the server: " + ex.Message + '\n');
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
finally
{
//Console.WriteLine(String.Format("Closing connection to the '{0}' database.", DATABASE_NAME));
connection.Close();
//Console.WriteLine();
}
}
public void ReclaimBrokenConnection()
{
// now create a new connection string only allowing 1 connection in the pool
string connStr = GetPoolingConnectionString() + ";connect timeout=2;max pool size=1";
// now use up that connection
MySqlConnection c = new MySqlConnection(connStr);
c.Open();
// now attempting to open a connection should fail
try
{
MySqlConnection c2 = new MySqlConnection(connStr);
c2.Open();
Assert.Fail("Open after using up pool should fail");
}
catch (Exception) { }
// we now kill the first connection to simulate a server stoppage
base.KillConnection(c);
// now we do something on the first connection
try
{
c.ChangeDatabase("mysql");
Assert.Fail("This change database should not work");
}
catch (Exception) { }
// Opening a connection now should work
MySqlConnection connection = new MySqlConnection(connStr);
connection.Open();
KillConnection(connection);
connection.Close();
}
MySqlConnection GetMySqlConnection(string server, string dbname, string pwd, string uid, bool sspi, string port)
{
MySqlConnection dbcon = null;
try
{
dbcon = new MySqlConnection(getConnectionString(server, dbname, pwd, uid, sspi, port));
dbcon.Open();
if (!string.IsNullOrEmpty(dbname))
{
using (MySqlCommand cmd = dbcon.CreateCommand())
{
object o;
//cmd.CommandText = string.Format("use {0}", dbname);
//object o = cmd.ExecuteScalar();
dbcon.ChangeDatabase(dbname);
cmd.CommandText = "select database()";
o = cmd.ExecuteScalar();
if (string.IsNullOrEmpty(o.ToString()) || o.ToString()!=dbname)
{
dbcon.Close();
dbcon = null;
}
else
{
long minpksize = 10 * 1024 * 1024;
long pksize = 10 * 1024 * 1024;
cmd.CommandText = "SHOW VARIABLES like 'max_allowed_packet%'";
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
pksize = dr.GetInt64(1);
}
}
if (pksize < minpksize)
{
cmd.CommandText = string.Format("set global max_allowed_packet = {0}", minpksize);
cmd.ExecuteNonQuery();
dbcon.Close();
dbcon = null;
System.Threading.Thread.Sleep(2000);
dbcon = new MySqlConnection(getConnectionString(server, dbname, pwd, uid, sspi, port));
dbcon.Open();
dbcon.ChangeDatabase(dbname);
using (MySqlCommand cmd2 = dbcon.CreateCommand())
{
cmd2.CommandText = "SHOW VARIABLES like 'max_allowed_packet%'";
using (MySqlDataReader dr = cmd2.ExecuteReader())
{
if (dr.Read())
{
pksize = dr.GetInt64(1);
}
}
}
}
}
}
}
}
catch
{
dbcon = null;
}
return dbcon;
}
internal void Initialize(string ConnString)
{
connection = new MySqlConnection(ConnString);
connection.Open();
connection.ChangeDatabase(Databasing.DatabaseName);
transaction = connection.BeginTransaction();
}
/// <summary>
/// Connect to the server
/// </summary>
/// <param name="server">IP or domain</param>
/// <param name="userName">Username</param>
/// <param name="password">Password</param>
/// <param name="database">Optional initial database</param>
/// <returns></returns>
public bool Connect(string server, string userName, string password, string database = "")
{
try
{
var connection = new MySqlConnection($"server={server};uid={userName}");
if (password != "")
{
connection.ConnectionString += $";password={password}";
}
Debug.WriteLine($"Connecting to {server} as {userName}");
connection.Open();
CurrentConnection = connection;
}
catch (Exception exception)
{
Debug.WriteLine("Unable to connect...");
var myException = exception as MySqlException;
if (myException != null)
HandleException(myException);
else
MessageBox.Show("Unknown exception:" + exception.Message);
return false;
}
// ensure that the database exists
if (database != "")
{
var databaseExists = new MySqlCommand($"SHOW DATABASES LIKE '{database}'") {Connection = CurrentConnection};
if (databaseExists.ExecuteScalar() != null)
{
Debug.WriteLine($"Database {database} already exists");
}
else
{
Debug.WriteLine($"Trying to create database {database}");
try
{
ExecuteCommand(Properties.Resources.create_my_sound_lib);
}
catch (DatabaseAccessDeniedExcpetion)
{
MessageBox.Show($"{userName} is not allowed to create databases");
return false;
}
catch (Exception e) {
MessageBox.Show("Unable to create database: " + e.Message);
}
Debug.WriteLine($"Successfully created {database}");
MessageBox.Show("Created initial database");
}
CurrentConnection.ChangeDatabase(database);
}
CurrentConnection.StateChange += CurrentConnectionOnStateChange;
return CurrentConnection.State == ConnectionState.Open;
}
public static bool Connect(string tdbhost,string tdbuser,string tdbpass, /*string tdbsd2,*/string tdbworld)
{
try
{
dbhost = tdbhost;
dbuser = tdbuser;
dbpass = tdbpass;
dbworld = tdbworld;
string connStr = String.Format("server={0};user id={1};password={2}; database={3}; pooling=false", dbhost, dbuser, dbpass, tdbworld);
conn = new MySqlConnection(connStr);
conn.Open();
conn.ChangeDatabase(tdbworld);
return true;
}
catch (Exception ex)
{
error = ex;
return false;
}
}
public static DataTable fillData(string queryString, bool skipError = false)
{
DataTable toReturn = new DataTable("toReturn");
int totalCount = 0;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
conn.ChangeDatabase(Program.Config.DatabaseName);
using (MySqlDataAdapter da = new MySqlDataAdapter(queryString, conn))
{
da.Fill(toReturn);
}
conn.Close();
}
}
catch (Exception e)
{
totalCount++;
if (totalCount > 10)
{
if (!skipError)
{
File.WriteAllText("MySQLError.txt", queryString);
Console.WriteLine(e.ToString());
}
}
else
goto retry;
}
return toReturn;
}
public void ChangeDatabase()
{
string connStr = GetConnectionString(true);
MySqlConnection c = new MySqlConnection(connStr + ";pooling=false");
c.Open();
Assert.IsTrue(c.State == ConnectionState.Open);
Assert.AreEqual(database0.ToLower(), c.Database.ToLower());
c.ChangeDatabase(database1);
Assert.AreEqual(database1.ToLower(), c.Database.ToLower());
c.Close();
}
public int CheckConnect(string strDatabase, string strServer, string strUserId, string strPassword, string strPort)
{
MySqlConnection cn = null;
int res = 0;
try
{
cn = new MySqlConnection(string.Format("server={0};user id={1};password={2};port={3};",
strServer, strUserId, strPassword, strPort));
cn.Open();
cn.ChangeDatabase(strDatabase);
}
catch { }
finally
{
if (cn != null && cn.State == ConnectionState.Open)
{
cn.Close();
res = 0;
}
else
{
res = -1;
}
cn = null;
}
return res;
}
public static bool SelectDatabase(MySqlConnection connection, String database)
{
try
{
connection.ChangeDatabase(database);
return true;
}
catch (Exception E)
{
ConIO.Warning("MySQL", "Failed to change database: " + E.Message);
return false;
}
}
public MySqlConnection GetConn()
{
try
{
conn = new MySqlConnection(GetStrConn());
conn.Open();
conn.ChangeDatabase(strDatabase);
}
catch
{
conn = null;
}
return conn;
}
public MySqlProvider(IDatabase db, bool createDatabaseIfNotExist)
{
this.db = db;
try
{
connection = new MySqlConnection(db.ConnectionString);
//connection.Open();
//IDbCommand cmd = connection.CreateCommand();
//cmd.CommandText = "SET NAMES 'utf8';";
//cmd.ExecuteNonQuery();
//connection.Close();
if (createDatabaseIfNotExist)
{
connection.Open();
connection.Close();
}
}
catch
{
if (createDatabaseIfNotExist)
{
// ihtimal, veritabaný create edilmemiþ. create edelim o zaman:
string newConnStr = "";
string dbName = "";
foreach (string param in db.ConnectionString.Split(';'))
{
if (param.StartsWith("Database=", StringComparison.InvariantCultureIgnoreCase))
dbName = param.Split('=')[1];
else
newConnStr += param + ";";
}
connection = new MySqlConnection(newConnStr);
try
{
connection.Open();
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = "create database " + dbName + " default charset utf8 collate utf8_turkish_ci";
cmd.ExecuteNonQuery();
connection.ChangeDatabase(dbName);
CreatedNow = true;
connection.Close();
connection = new MySqlConnection(db.ConnectionString);
}
catch { }
}
}
}
override public void InitializeDB()
{
MySqlConnection connection = new MySqlConnection(connectionString);
MySqlCommand command;
MySqlDataReader datareader;
DataTable table;
DataSet dataset = new DataSet("dataset");
try
{
connection.Open();
String dropDBQuery = String.Format("DROP DATABASE IF EXISTS {0}", database);
command = new MySqlCommand(dropDBQuery, connection);
command.ExecuteNonQuery();
String createDBQuery = String.Format("CREATE DATABASE IF NOT EXISTS {0}", database);
command = new MySqlCommand(createDBQuery, connection);
command.ExecuteNonQuery();
connection.ChangeDatabase(database);
// Create Tables and schema file.
String createTableQuery = String.Empty;
String tableName = String.Empty;
String sql = String.Empty;
// ComponentTable
tableName = "ComponentTable";
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, type VARCHAR(80), name VARCHAR(80), description VARCHAR(255), etype VARCHAR(80), PRIMARY KEY (id)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
// ParameterTable
tableName = "ParameterTable";
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, parentId INT NOT NULL, parentType VARCHAR(80), name VARCHAR(80), value VARCHAR(512), description VARCHAR(256), PRIMARY KEY (id), UNIQUE (parentId, parentType, name)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
// LinkTable
tableName = "LinkTable";
createTableQuery = String.Format("CREATE TABLE {0} (id INT NOT NULL AUTO_INCREMENT, fromComponentId INT, toComponentId INT, type VARCHAR(80), description VARCHAR(255), PRIMARY KEY (id), UNIQUE (fromComponentId, toComponentId, type)) ENGINE = MYISAM", tableName);
command = new MySqlCommand(createTableQuery, connection);
command.ExecuteNonQuery();
// For schema file.
sql = String.Format("SELECT * FROM {0}", tableName);
command = new MySqlCommand(sql, connection);
datareader = command.ExecuteReader();
table = new DataTable(tableName);
table.Load(datareader);
dataset.Tables.Add(table);
datareader.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error initializing database: " + ex.Message);
}
finally
{
connection.Close();
}
}
/// <summary>
/// Constructs a new runner that will execute the given file
/// </summary>
/// <param name="conn">The database connection to execute the commands against</param>
/// <param name="filePath">The path of the SQL dump that contains the commands to run</param>
public SqlFileRunner(MySqlConnection conn, string schema, string filePath)
{
_conn = conn;
_conn.ChangeDatabase(schema);
//try to open the file
string[] lines = File.ReadAllLines(filePath);
List<string> filteredLines = new List<string>(lines.Length);
//filter commented lines
foreach (var line in lines)
{
if (! line.StartsWith("--") && !String.IsNullOrWhiteSpace(line))
{
filteredLines.Add(line);
}
}
//parse the file looking for semicolons or delimiter statements
string delim = ";";
char[] delimCharArray = delim.ToCharArray();
StringBuilder commandSoFar = new StringBuilder();
foreach (var line in filteredLines)
{
if (line.StartsWith("DELIMITER "))
{
delim = line.Split(' ')[1];
delimCharArray = delim.ToCharArray();
continue;
}
for (int i = 0; i < line.Length; i++)
{
if (line[i] == delim[0])
{
if (i + delim.Length - 1 < line.Length &&
line.ToCharArray(i, delim.Length).SequenceEqual(delimCharArray))
{
//we hit a delimiter
_commands.Add(commandSoFar.ToString());
commandSoFar.Clear();
}
else
{
commandSoFar.Append(line[i]);
}
}
else
{
commandSoFar.Append(line[i]);
}
}
commandSoFar.Append("\n");
}
if (commandSoFar.Length > 0 && !String.IsNullOrWhiteSpace(commandSoFar.ToString()))
{
_commands.Add(commandSoFar.ToString());
}
}
// the logging system regerence
//static LoggingSystem.Log loggingSystem = new LoggingSystem.Log();
#endregion Variables
#region Construction
static ServerAccessMySQL()
{
mySQLConnection = getMySQLConnection(null);
List<string> databaseNames = new List<string>();
try
{
try
{
string commandString = "show databases ;";
MySql.Data.MySqlClient.MySqlCommand mySqlCommand = new MySqlCommand(commandString, mySQLConnection);
MySqlDataReader myReader = mySqlCommand.ExecuteReader();
//if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText);
while (myReader.Read())
{
if (!string.IsNullOrEmpty(myReader.GetString(0)))
{
databaseNames.Add(myReader.GetString(0));
}
}
myReader.Close();
}
catch (InvalidOperationException ioe)
{
}
}
catch (MySqlException retrieveSymbolIndexException)
{
Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString());
}
foreach (string database in databaseNames)
{
List<string> tableNames = new List<string>();
try
{
try
{
mySQLConnection.ChangeDatabase(database);
getMySQLConnection(database);
string commandString = "USE " + database + "; SHOW TABLES ;";
MySql.Data.MySqlClient.MySqlCommand mySqlCommand = new MySqlCommand(commandString, mySQLConnection);
MySqlDataReader myReader = mySqlCommand.ExecuteReader();
//if (MySqlTrace) SQLView.Log(mySqlCommand.CommandText);
while (myReader.Read())
{
if (!string.IsNullOrEmpty(myReader.GetString(0)))
{
string tb = myReader.GetString(0);
string db = myReader.GetString(0);
if (tb.Equals("simbs") || tb.Equals("srel"))
{
tableNames.Add(tb);
}
}
}
myReader.Close();
}
catch (InvalidOperationException ioe)
{
}
}
catch (MySqlException retrieveSymbolIndexException)
{
Console.WriteLine("Error: {0}", retrieveSymbolIndexException.ToString());
}
if (tableNames.Contains("simbs") && tableNames.Contains("srel"))
{
GoodBDs.Add(database);
}
}
DB = GoodBDs[0];
//if (MyResultsTrace) SQLView.LogResult(new string[] { name });
}
public override void executeQuery(string queryString)
{
try {
using (var conn = new MySqlConnection(connString))
{
conn.Open();
if (queryString.IndexOf("CREATE DATABASE") != -1)
conn.ChangeDatabase(ServerSettings.GetSetting("MySQL-DBName"));
MySqlCommand cmd = new MySqlCommand(queryString, conn);
cmd.ExecuteNonQuery();
conn.Clone();
conn.Dispose();
}
}
catch (Exception e)
{
Server.Log(e);
}
}