public static void Init()
{
Utils.CreateHockeyTable();
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
DbCommand command = new NuoDbCommand("select count(*) from hockey", connection);
connection.Open();
tableRows = (int)command.ExecuteScalar();
}
}
public void TestBulkLoadOnStoredProcedureCommand()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop table temp if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create table temp (col string)", connection).ExecuteNonQuery();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(input_data string) " +
" as " +
" insert into temp values (input_data); " +
" end_procedure", connection).ExecuteNonQuery();
DataTable metadata = new DataTable("dummy");
metadata.Columns.Add("xyz", typeof(string));
DataRow[] rows = new DataRow[10];
for (int i = 0; i < rows.Length; i++)
{
rows[i] = metadata.NewRow();
rows[i][0] = Convert.ToString(i);
}
NuoDbCommand loader = new NuoDbCommand(connection);
loader.CommandType = CommandType.StoredProcedure;
loader.CommandText = "nunit_test";
loader.ExecuteBatch(rows);
DbCommand command = new NuoDbCommand("select count(*) from temp", connection);
object val = command.ExecuteScalar();
Assert.AreEqual(10, val);
command = new NuoDbCommand("select col from temp", connection);
val = command.ExecuteScalar();
Assert.AreEqual("0", val);
}
}
public void TestDataType(string sqlType, object value, object expected)
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
connection.Open();
//DbTransaction transaction = connection.BeginTransaction();
Utils.DropTable(connection, "temp");
DbCommand createCommand = new NuoDbCommand("create table temp (col " + sqlType + ")", connection);
int result = createCommand.ExecuteNonQuery();
DbCommand insertCommand = new NuoDbCommand("insert into temp (col) values (?)", connection);
insertCommand.Parameters.Add(value);
int inserted = insertCommand.ExecuteNonQuery();
DbCommand command = new NuoDbCommand("select col from temp", connection);
object val = command.ExecuteScalar();
// compare dates using the string representation
if (val.GetType() == expected.GetType())
Assert.AreEqual(expected, val);
else if (val is DateTime)
Assert.AreEqual(DateTime.Parse(expected.ToString()), val);
else if (val is TimeSpan)
Assert.AreEqual(TimeSpan.Parse(expected.ToString()), val);
else if (expected is ICollection)
CollectionAssert.AreEqual((ICollection)expected, (ICollection)val);
else
Assert.AreEqual(expected, val);
//transaction.Rollback();
}
}
public void TestBulkLoad_DataReaderWithMappingOrdinal2Ordinal()
{
CreateTargetForBulkLoad();
NuoDbBulkLoader loader = new NuoDbBulkLoader(connectionString);
loader.BatchSize = 2;
loader.DestinationTableName = "TEMP";
loader.ColumnMappings.Add(1, 0);
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
DbCommand command = new NuoDbCommand("select number, position as xyz2 from hockey order by number", connection);
connection.Open();
DbDataReader reader = command.ExecuteReader();
loader.WriteToServer(reader);
reader.Close();
command = new NuoDbCommand("select count(*) from hockey", connection);
object val = command.ExecuteScalar();
VerifyBulkLoad((int)val, "Fan");
}
}
private static void VerifyBulkLoad(int expectedCount, string expectedFirstRow)
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
connection.Open();
DbCommand command = new NuoDbCommand("select count(*) from temp", connection);
object val = command.ExecuteScalar();
Assert.AreEqual(expectedCount, val);
command = new NuoDbCommand("select col from temp", connection);
val = command.ExecuteScalar();
Assert.AreEqual(expectedFirstRow, val);
}
}
internal static int GetTableRows()
{
using (NuoDbConnection connection = new NuoDbConnection(connectionString))
{
DbCommand command = new NuoDbCommand("select count(*) from hockey", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
