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); } }