protected int[] Insert(TableName tableName, int numRows)
{
IList <DbField> fields = DbDefault.GetTableStructure(tableName).Columns;
int[] result = new int[numRows];
PrepareInsert(tableName);
for (int i = 0; i < numRows; i++)
{
foreach (DbField field in fields)
{
Command.Parameters.Add(
DbRandom.GetRandomFieldData(field));
}
Command.AddBatch();
}
return(Command.ExecuteBatch());
}
public override void Run(object context)
{
String tableName = null;
try
{
tableName = DbRandom.BuildRandomTable(10);
if (DbHelper.TableExists(tableName))
{
Log(String.Format("Table {0} has been created", tableName));
}
else
{
Log(String.Format("Failed to create table {0}", tableName));
}
//GFXDClientConnection conn = Helper.OpenNewConnection();
GFXDCommand cmd = Connection.CreateCommand();
cmd.CommandText = String.Format("SELECT * FROM {0}", tableName);
GFXDDataReader rdr = cmd.ExecuteReader();
int colCount = DbHelper.GetTableColumnCount(tableName);
while (rdr.Read())
{
StringBuilder row = new StringBuilder();
for (int i = 0; i < colCount; i++)
{
try
{
String data = rdr.GetString(i);
if (data == null && data == String.Empty)
{
Log("GetString() failed to retrieve column data");
}
row.Append(data);
row.Append(", ");
}
catch (Exception e)
{
Log(e.Message);
}
}
Log(row.ToString());
}
}
catch (Exception e)
{
Fail(e);
}
finally
{
try
{
DbHelper.DropTable(tableName);
}
catch (Exception e)
{
Fail(e);
}
base.Run(context);
}
}
