public void TestDatabaseProvider()
{
string[] providers = TestUtil.Providers;
for (int i = 0; i < providers.Length; ++i)
{
GlazeFactory glazeFactory = new GlazeFactory(providers[i]);
GlazeCommand glazeCommand = (GlazeCommand)(glazeFactory.CreateCommand());
Assert.AreEqual(providers[i], glazeCommand.DatabaseProvider);
}
}
public void TestCreateCommand()
{
string[] providers = TestUtil.Providers;
for (int i = 0; i < providers.Length; ++i)
{
GlazeFactory glazeFactory = new GlazeFactory(providers[i]);
DbCommand command = glazeFactory.CreateCommand();
GlazeCommand glazeCommand = command as GlazeCommand;
Assert.IsNotNull(glazeCommand);
}
}
void CheckDelete(DbConnection connection)
{
GlazeCommand command = (GlazeCommand)(connection.CreateCommand());
command.CommandText = "delete from table1 where 0=1";
int c = command.ExecuteNonQuery();
Assert.AreEqual(0, c);
c = command.ExecuteNonQuery();
Assert.AreEqual(0, c);
}
public GlazeCommand MakeSchemaQuery(GlazeConnection cnn,
QueryExpression queryExpression)
{
QueryExpression schemaQuery = (QueryExpression)(queryExpression.Clone());
schemaQuery.Top = 1;
schemaQuery.Distinct = false;
GlazeCommand schemaCmd = (GlazeCommand)(cnn.CreateCommand());
schemaCmd.Statement = new SelectStatement(schemaQuery);
return(schemaCmd);
}
void CheckStatement(GlazeFactory glazeFactory, DbConnection connection)
{
QueryExpression queryExpression = new QueryExpression();
queryExpression.SelectItems = new AliasedItem(
new Expression(new IntegerValue(1),
ExpressionOperator.Minus,
new IntegerValue(2)));
GlazeCommand command = (GlazeCommand)(connection.CreateCommand());
command.Statement = new SelectStatement(queryExpression);
object c = command.ExecuteScalar();
Assert.IsNotNull(c);
int d = Convert.ToInt32(c);
Assert.AreEqual(-1, d);
InsertStatement insertStatement = new InsertStatement();
insertStatement.Table = new DbObject(new Identifier("no_table"));
insertStatement.ColumnNames = new AliasedItem(
new Identifier("test_column"));
Expression expr = new Expression();
expr.Left = new IntegerValue(42);
insertStatement.ColumnValues = new ExpressionItem(expr);
command.Statement = insertStatement;
bool changed = false;
try
{
command.ExecuteNonQuery();
}
catch
{
changed = true;
}
Assert.IsTrue(changed);
string text = command.CommandText;
Assert.IsTrue(text.StartsWith("INSERT"));
}
void CheckBindByName(GlazeFactory glazeFactory, DbConnection connection)
{
if (glazeFactory == null)
{
throw new ArgumentNullException("glazeFactory");
}
if (connection == null)
{
throw new ArgumentNullException("connection");
}
DbCommand command = glazeFactory.CreateCommand();
Assert.IsNotNull(command);
GlazeCommand glazeCommand = (GlazeCommand)command;
Assert.IsFalse(glazeCommand.BindByName);
glazeCommand.BindByName = true;
Assert.IsTrue(glazeCommand.BindByName);
}
