/// <summary>
/// Insert soldiername and eaguid (Update soldiername if eaguid is exist).
/// </summary>
/// <param name="parameters"></param>
private void InsertEAInfo(DbParameter[] parameters)
{
try
{
DbConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder();
connectionStringBuilder.Add("server", hostName);
connectionStringBuilder.Add("port", hostPort);
connectionStringBuilder.Add("user", hostUser);
connectionStringBuilder.Add("password", hostPassword);
connectionStringBuilder.Add("database", hostDatabase);
using (DbConnection connection = new MySqlConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (DbCommand command = connection.CreateCommand())
{
// select playerid by eaguid
command.Transaction = transaction;
command.Parameters.AddRange(parameters);
command.CommandText = string.Format(
"INSERT IGNORE INTO `{0}`.`{1}` (`serverid`,`gametype`,`soldiername`,`eaguid`,`firsttime`) VALUE (@serverid,@gametype,@soldiername,@eaguid,@firsttime);" +
"UPDATE `{0}`.`{1}` SET `soldiername` = @soldiername, `lasttime` = @lasttime WHERE eaguid = @eaguid;", hostDatabase, ClassName);
command.ExecuteNonQuery();
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
Output.Error(ex.ToString());
}
}
public static void Procedure(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();
Console.WriteLine("Anslutningen lyckades till datorbasen..");
Console.ReadLine();
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(String.Format("{0} {1} - {2}: {3} {4} {5}",
reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5))
);
}
Console.ReadLine();
reader.Close();
}
private void button1_Click(object sender, EventArgs e)
{
MySqlConnectionStringBuilder connBuilder =
new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "logicbase");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "078515");
connBuilder.Add("Charset", "utf8");
MySqlConnection connection =
new MySqlConnection(connBuilder.ConnectionString);
MySqlCommand cmd = connection.CreateCommand();
connection.Open();
// Here goes the code needed to perform operations on the
this.InsertCommand(cmd, "1", "数据1");
this.InsertCommand(cmd, "2", "数据2");
// database such as querying or inserting rows into a table
connection.Close();
}
public static void Main(string[] args)
{
// Connecting to MySQL DB
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "shop");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "admin#123");
connBuilder.Add("SslMode", "none");
MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString);
cmd = connection.CreateCommand();
connection.Open();
// Build a server
var server = new Server
{
Services = { GreetingService.BindService(new GreeterServiceImpl()) },
Ports = { new ServerPort(Host, Port, ServerCredentials.Insecure) }
};
// Start server
server.Start();
Console.WriteLine("GreeterServer listening on port " + Port);
Console.WriteLine("Press any key to stop the server...");
Console.ReadKey();
// Stopping MySql and Server Connection
connection.Close();
server.ShutdownAsync().Wait();
}
/// <summary>
/// Update an out of date database.
/// </summary>
/// <param name="user">MySQL "User id" with either root access or access to the `ChatTwo` database.</param>
/// <param name="password">Password of the user.</param>
/// <param name="ip">IP address of the machine hosting the MySQL server.</param>
/// <param name="port">Port number the MySQL server is running on.</param>
public static bool UpdateDatabase(string user, string password, string ip, int port)
{
int cmdResult = 0;
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("User id", user);
connBuilder.Add("Password", password);
connBuilder.Add("Network Address", ip);
connBuilder.Add("Port", port);
//connBuilder.Add("Database", "ChatTwo");
//connBuilder.Add("Connection timeout", 5);
using (MySqlConnection tempConn = new MySqlConnection(connBuilder.ConnectionString))
{
// Get the database version number from the `ServerStatus` table.
int version = -1;
using (MySqlCommand cmd = new MySqlCommand("SELECT `ChatTwo`.`Version` FROM `ServerStatus`;", tempConn))
{
try
{
tempConn.Open();
// Execute SQL command.
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
version = (int)reader["Version"];
}
}
finally
{
tempConn.Close();
}
}
switch (version)
{
case 0:
throw new NotImplementedException("There is no update from version 0 (yet).");
//using (MySqlCommand cmd = new MySqlCommand("UPDATE `ServerStatus` SET `Version` = 1, `LastUpdated` = NOW();", _conn))
//{
// try
// {
// Open();
// // Execute SQL command.
// cmdResult = cmd.ExecuteNonQuery();
// }
// finally
// {
// Close();
// }
//}
//break;
default:
break;
}
}
return(cmdResult != 0); // cmdResult content the number of affected rows.
}
/// <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);
}
/// <summary>
/// static constructor to determine the state of the environment and set defaults
/// </summary>
static MySQLConnections()
{
// 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);
}
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 void TestDatabase()
{
DbConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder();
connectionStringBuilder.Add("server", hostName);
connectionStringBuilder.Add("port", hostPort);
connectionStringBuilder.Add("user", hostUser);
connectionStringBuilder.Add("password", hostPassword);
connectionStringBuilder.Add("database", hostDatabase);
try
{
using (DbConnection connection = new MySqlConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
}
retryTestCount = 0;
}
catch (Exception ex)
{
Output.Error(ex.ToString());
if (retryTestCount++ > 5)
{
retryTestCount = 0;
Output.Error("{0} is disable", ClassName);
EnablePlugin(false);
}
}
}
/// <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;
}
}
private void button1_Click(object sender, EventArgs e)
{
MySqlConnection con = null;
string user = txtUser.Text;
string password = txtPassword.Text;
string server = txtServer.Text;
MySqlConnectionStringBuilder mssb = new MySqlConnectionStringBuilder();
mssb.Add("user id", user);
if (!String.IsNullOrEmpty(password))
{
mssb.Add("password", password);
}
mssb.Add("server", server);
mssb.Add("database", txtDatabase.Text);
try
{
Connection.ConnectionString = mssb.ConnectionString;
con = Connection.getConnection();
con.Open();
this.DialogResult = DialogResult.OK;
}
catch (MySqlException ex)
{
FrameworkControls.Classes.PanException.Show(this, ex);
}
finally
{
con.Close();
}
}
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();
}
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.");
}
}
/// <summary>
/// Create database by <see cref="hostDatabase"/> if not exist.
/// </summary>
private void InitDatabase()
{
DbConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder();
connectionStringBuilder.Add("server", hostName);
connectionStringBuilder.Add("port", hostPort);
connectionStringBuilder.Add("user", hostUser);
connectionStringBuilder.Add("password", hostPassword);
try
{
using (DbConnection connection = new MySqlConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
try
{
using (DbCommand command = connection.CreateCommand())
{
command.Transaction = transaction;
command.CommandText = string.Format("CREATE DATABASE if NOT EXISTS `{0}`", hostDatabase);
command.ExecuteNonQuery();
command.CommandText = string.Format("USE `{0}`", hostDatabase);
command.ExecuteNonQuery();
command.CommandText = string.Format("CREATE TABLE IF NOT EXISTS `{0}` (" +
"`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT," +
"`gameid` INT(10) UNSIGNED NOT NULL DEFAULT '0'," +
"`ipaddress` VARCHAR(22) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`clantag` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`soldiername` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`eaguid` VARCHAR(35) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`pbguid` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`country` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"`countrycode` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'," +
"PRIMARY KEY(`id`), UNIQUE INDEX `Index 2` (`eaguid`), UNIQUE INDEX `Index 3` (`pbguid`)" +
") COLLATE = 'utf8mb4_general_ci'", ClassName);
command.ExecuteNonQuery();
transaction.Commit();
}
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
catch (Exception ex)
{
Output.WriteLine("-------------------");
Output.Error(ex.ToString());
}
}
public MySqlConnection DatabaseSettings()
{
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);
return(connection);
}
static void Main(string[] args)
{
int rowsAffected = 0;
StringBuilder insertCommand = new StringBuilder();
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "Results_MakeCluster_Algorithm");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "***"); //change this line before running
MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString);
MySqlCommand cmd = connection.CreateCommand();
connection.Open();
for (int number = 0; number < 1000; number++)
{
Graph graph = new Graph();
List <string>[] clusters = new List <string> [21];
for (int i = 0; i < 21; i++)
{
clusters[i] = MakeCycles(graph);
}
clusters = PostProcess(clusters, graph);
insertCommand.Append("INSERT INTO Finished_Clusters VALUES (");
insertCommand.Append(number.ToString() + ", ");
for (int j = 0; j < clusters.Length; j++)
{
insertCommand.Append(ListToString(clusters[j]) + ",");
}
insertCommand.Append(ComputeObjFunction(clusters, graph).ToString() + ");");
cmd.CommandText = insertCommand.ToString();
rowsAffected += cmd.ExecuteNonQuery();
insertCommand.Clear();
}
connection.Close();
Console.WriteLine(rowsAffected);
Console.ReadKey();
}
static DB()
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "Project_JJK");
connBuilder.Add("Data Source", "hellojkw.com");
connBuilder.Add("User Id", "uj7380");
connBuilder.Add("Password", "uj7380");
_connectionString = connBuilder.ToString();
Conn = new MySqlConnection(_connectionString);
}
static PCFEnvironment()
{
if (BoundServices.GetValue("p-mysql") != null)
{
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();
}
}
public MySqlConnection GetConnection()
{
MySqlConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder();
connectionStringBuilder.Add("Database", "test");
connectionStringBuilder.Add("Data Source", "localhost");
connectionStringBuilder.Add("User Id", "root");
connectionStringBuilder.Add("Password", "");
dbConnection = new MySqlConnection(connectionStringBuilder.ConnectionString);
return(dbConnection);
}
public MySqlConnectionStringBuilder Conn_buildder()
{
MySqlConnectionStringBuilder connBuilder =
new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "pdbsoral");
// connBuilder.Add("Data Source", "10.95.14.153");
connBuilder.Add("Data Source", "10.82.14.237");
connBuilder.Add("User Id", "khoamap");
connBuilder.Add("Password", "123456");
connBuilder.Add("Charset", "utf8");
return(connBuilder);
}
/// <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("azure-sqldb") != null) // Azure SQL Database (Azure Broker)
{
DbEngine = DatabaseEngine.SqlServer;
SqlConnectionStringBuilder csbuilder = new SqlConnectionStringBuilder();
csbuilder.Add("server", BoundServices["azure-sqldb"][0]["credentials"]["hostname"].ToString());
csbuilder.Add("uid", BoundServices["azure-sqldb"][0]["credentials"]["username"].ToString());
csbuilder.Add("pwd", BoundServices["azure-sqldb"][0]["credentials"]["password"].ToString());
csbuilder.Add("database", BoundServices["azure-sqldb"][0]["credentials"]["name"].ToString());
_connectionString = csbuilder.ToString();
}
else if (BoundServices.GetValue("azure-mysqldb") != null || BoundServices.GetValue("p-mysql") != null || BoundServices.GetValue("cleardb") != null) // MySQL for PCF or Mysql for AZURE
{
string label = "p-mysql"; // MySQL Database.
if (BoundServices.GetValue("azure-mysqldb") != null)
{
label = "azure-mysqldb"; //Mysql Database on Azure (Mysql For Azure)
}
if (BoundServices.GetValue("cleardb") != null)
{
label = "cleardb"; //Mysql cleardb
}
DbEngine = DatabaseEngine.MySql;
MySqlConnectionStringBuilder csbuilder = new MySqlConnectionStringBuilder();
csbuilder.Add("server", BoundServices[label][0]["credentials"]["hostname"].ToString());
csbuilder.Add("port", BoundServices[label][0]["credentials"]["port"].ToString());
csbuilder.Add("uid", BoundServices[label][0]["credentials"]["username"].ToString());
csbuilder.Add("pwd", BoundServices[label][0]["credentials"]["password"].ToString());
csbuilder.Add("database", BoundServices[label][0]["credentials"]["name"].ToString());
_connectionString = csbuilder.ToString();
}
else
{
DbEngine = DatabaseEngine.None;
}
}
/// <summary>
/// Create database by <see cref="hostDatabase"/> if not exist.
/// </summary>
private void InitDatabase()
{
DbConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder();
connectionStringBuilder.Add("server", hostName);
connectionStringBuilder.Add("port", hostPort);
connectionStringBuilder.Add("user", hostUser);
connectionStringBuilder.Add("password", hostPassword);
connectionStringBuilder.Add("database", hostDatabase);
try
{
using (DbConnection connection = new MySqlConnection(connectionStringBuilder.ConnectionString))
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
using (DbCommand command = connection.CreateCommand())
{
command.Transaction = transaction;
command.CommandText = string.Format("CREATE TABLE IF NOT EXISTS `{0}`.`{1}` (" +
"`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT," +
"`serverid` INT(10) DEFAULT NULL," +
"`gametype` VARCHAR(10) NULL DEFAULT NULL," +
"`ipaddress` VARCHAR(22) NULL DEFAULT NULL," +
"`clantag` VARCHAR(5) NULL DEFAULT NULL," +
"`soldiername` VARCHAR(20) NULL DEFAULT NULL," +
"`eaguid` VARCHAR(35) NULL DEFAULT NULL ," +
"`pbguid` VARCHAR(32) NULL DEFAULT NULL ," +
"`country` VARCHAR(30) NULL DEFAULT NULL ," +
"`countrycode` VARCHAR(10) NULL DEFAULT NULL ," +
"`firsttime` datetime DEFAULT NULL," +
"`lasttime` datetime DEFAULT NULL," +
"PRIMARY KEY(`id`), " +
"UNIQUE INDEX `Index 2` (`eaguid`), " +
"UNIQUE INDEX `Index 3` (`pbguid`)" +
")", hostDatabase, ClassName);
command.ExecuteNonQuery();
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
Output.WriteLine("-------------------");
Output.Error(ex.ToString());
}
}
public DBManager()
{
server = "localhost";
database = "snus_shema";
uid = "root";
pass = "******";
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", database);
connBuilder.Add("Data Source", server);
connBuilder.Add("User Id", uid);
connBuilder.Add("Password", pass);
connection = new MySqlConnection(connBuilder.ConnectionString);
}
public static void connect()
{
connBuilder.Add("Database", "rover");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "");
connection = new MySqlConnection(connBuilder.ConnectionString);
cmd = connection.CreateCommand();
try
{
connection.Open();
IrcBot.log += "MYSQL connection ready\n";
}
catch
{
IrcBot.log += "MYSQL isn't running!!!\n";
}
}
public override void initialize_connections(ConfigurationPropertyHolder configuration_property_holder)
{
if (!string.IsNullOrEmpty(connection_string))
{
// Must allow User variables for SPROCs
var connectionBuilder = new MySqlConnectionStringBuilder(connection_string);
if (!connectionBuilder.AllowUserVariables)
{
connectionBuilder.Add("Allow User Variables", "True");
connection_string = connectionBuilder.ConnectionString;
}
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);
}
}
}
if (server_name == infrastructure.ApplicationParameters.default_server_name)
{
server_name = "localhost";
}
if (string.IsNullOrEmpty(connection_string))
{
InteractivePrompt.write_header(configuration_property_holder);
var user_name = InteractivePrompt.get_user("root", configuration_property_holder);
var password = InteractivePrompt.get_password("root", configuration_property_holder);
InteractivePrompt.write_footer();
connection_string = build_connection_string(server_name, database_name, user_name, password);
}
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;
}
configuration_property_holder.ServerName = server_name;
configuration_property_holder.DatabaseName = database_name;
configuration_property_holder.ConnectionStringAdmin = admin_connection_string;
}
/// <summary>
/// Creates a new connection to the database
/// </summary>
/// <returns></returns>
private MySqlConnection GetConnection()
{
//Credentials
string user = "******";
string pass = "******";
string server = "server";
string database = "database";
//Create the Connection String
MySqlConnectionStringBuilder mscsb = new MySqlConnectionStringBuilder();
mscsb.Add("Server", server);
mscsb.Add("Database", database);
mscsb.Add("User", user);
mscsb.Add("Password", pass);
mscsb.Add("Connection Timeout", 120);
//Return a new connection using the connection string
return(new MySqlConnection(mscsb.ToString()));
}
public MySqlConnection openconnection()
{
try
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "pharmacy");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "your data base password");
conn = new MySqlConnection(connBuilder.ConnectionString);
conn.Open();
return(conn);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(conn);
}
public new List <string> Init()
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", database);
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "Rhino1515");
MySqlConnection connection = new MySqlConnection(connBuilder.ConnectionString);
MySqlCommand cmd = connection.CreateCommand();
connection.Open();
cmd.CommandText = "SELECT * FROM fish";
cmd.CommandType = CommandType.Text;
MySqlDataReader reader = cmd.ExecuteReader();
var elegetter = new BuildTable();
var Elements = elegetter.GetElements();
var list = new List <string>();
while (reader.Read())
{
var temp = new StringBuilder();
for (int i = 0; i < 25; i++)
{
temp.Append(reader[Elements[i]]).Append(",");
}
list.Add(temp.ToString());
}
connection.Close();
return(list);
}
public void conn()
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Add("Database", "pharmacy");
connBuilder.Add("Data Source", "localhost");
connBuilder.Add("User Id", "root");
connBuilder.Add("Password", "24hoursnaya");
connection = new MySqlConnection(connBuilder.ConnectionString);
if (ok == 1) { Console.WriteLine("giye na"); }
else
{
Console.WriteLine("yanne na");
connection.Open();
ok = 1;
Console.WriteLine(ok);
}
// connection.Open();
}
public static string GetMySqlConnectionString(this IConfiguration configuration, bool ignoreDbName = false)
{
var ssb = new MySqlConnectionStringBuilder();
var section = configuration.GetSection("ConnectionProps");
foreach (var s in section.GetChildren())
{
if (ignoreDbName && s.Key == "Database" || s.Value == null)
{
continue;
}
ssb.Add(s.Key, s.Value);
}
return(ssb.ToString());
}
/// <summary>
/// Generate connection string with the given properties
/// </summary>
/// <param name="connectionDto">Connection details</param>
/// <returns>Connection string of the database</returns>
private static string GenerateConnectionString(ConnectionDto connectionDto)
{
DbConnectionStringBuilder connectionBuilder = null;
string connectionString = string.Empty;
connectionBuilder = new MySqlConnectionStringBuilder();
if (connectionBuilder != null)
{
// Populate connection builder with connection properties
foreach (KeyValuePair <string, string> property in connectionDto.Properties)
{
if (connectionBuilder.ContainsKey(property.Key) && !string.IsNullOrEmpty(property.Value))
{
connectionBuilder.Add(property.Key, property.Value);
}
}
connectionString = connectionBuilder.ConnectionString;
connectionDto.ConnectionString = connectionString;
}
return(connectionString);
}
