public void MySqlStore()
{
MySqlConnection connection = new MySqlConnection(
"Server=localhost;" +
"User ID=root;" +
"Password=;");
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
string sql = "DROP DATABASE openid_test;";
cmd.CommandText = sql;
try {
cmd.ExecuteNonQuery();
}
catch (MySqlException e)
{ }
cmd.Dispose();
cmd = connection.CreateCommand();
cmd.CommandText = "CREATE DATABASE openid_test;";
cmd.ExecuteNonQuery();
cmd.Dispose();
cmd = connection.CreateCommand();
cmd.CommandText = "USE openid_test;";
cmd.ExecuteNonQuery();
cmd.Dispose();
MySqlStore store = new MySqlStore(connection);
store.CreateTables();
StoreTester tester = new StoreTester(store);
tester.Test();
}
/// <summary>l um valor</summary>
internal static int executeNonQuery( string query )
{
string connectionString = OrionGlobals.getConnectionString("connectiostring-mysql");
MySqlConnection conn = new MySqlConnection(connectionString);
try {
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = query;
cmd.CommandType = CommandType.Text;
object obj = cmd.ExecuteScalar();
if( obj == null ) {
return 0;
}
return int.Parse(obj.ToString());
} catch( Exception e ) {
Chronos.Utils.Log.log("Connection String: {0}", connectionString);
Chronos.Utils.Log.log("Error: " + e.Message);
throw;
} finally {
conn.Close();
}
}
public CatLists(MySqlConnection conn)
{
_conn = conn;
conn.Open();
ArrayList listNames = new ArrayList();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText ="SELECT DISTINCT ListName FROM " + _table;
MySqlDataReader dr = cmd.ExecuteReader();
while(dr.Read()) {
listNames.Add(Convert.ToString(dr["ListName"]));
}
dr.Close();
conn.Close();
foreach(string listName in listNames){
List.Add(new CatList(listName, false, conn));
}
}
