public void T04_Insert()
{
ISqlClient sqlClient = getClient();
sqlClient.ClearTable(testTable);
// Get column definitions (from data base)
List <SqlColumn> columns = sqlClient.GetColumns(testTable);
// Add some information from test meta data definition
foreach (ColumnMetadata cmd in columnMetadata)
{
SqlColumn col = columns.Where(n => n.Name == cmd.Fieldname).First();
col.ValueString = cmd.TestValue;
col.IsDocument = cmd.IsDocument;
}
// Remove unsupported columns
List <SqlColumn> toBeRemoved = columns.Where(n => n.SqlType == null).ToList();
foreach (SqlColumn col in toBeRemoved)
{
columns.Remove(col);
}
// Convert strings to objects and insert row
sqlClient.SetObjectValues(columns);
sqlClient.Insert(columns);
// Read back row from data base
List <SqlColumn> result = new List <SqlColumn>();
foreach (SqlColumn col in columns)
{
result.Add(new SqlColumn()
{
Name = col.Name, SqlType = col.SqlType
});
}
sqlClient.GetOneRow(result);
// Verify that input values and output values match
foreach (SqlColumn col in columns)
{
compareSqlColumn(col, result.Where(n => n.Name == col.Name).First());
}
// Verify that docuoment has been stored properly as blob
string resultDocument = Path.Combine(Path.GetTempPath(), "Document1.pdf");
File.WriteAllBytes(resultDocument,
columns.Where(n => n.Name == "MyDocument").First().ValueObject as Byte[]);
Assert.IsTrue(SIEEUtils.CompareFiles(testDocument, resultDocument));
File.Delete(resultDocument);
// Clear table
sqlClient.ClearTable(testTable);
}
// Construction
public SqlEEClient_Test()
{
connectionDefinitions = SIEEUtils.GetLocalTestDefinintions(connectionDefinitions);
testConnection = connectionDefinitions.Where(n => n.TestSystemName == testSystem).First();
testDocument = Path.Combine(Path.GetTempPath(), "Document.pdf");
File.WriteAllBytes(testDocument, Properties.Resources.Document);
createColumnMetadata(testDocument);
createDefaultTable(testTable, columnMetadata);
}
public void SetFieldNames(SIEEFieldlist fieldList)
{
List <string> newFieldNames = fieldList.GetScalarFieldNames();
if (!SIEEUtils.StringListEqual(FieldNames, newFieldNames))
{
FieldNames = newFieldNames;
if (FieldNames.Count > 0)
{
SelectedFieldName = FieldNames[0];
}
}
}
public TestSPOClient()
{
testsystems = SIEEUtils.GetLocalTestDefinintions(testsystems);
testDocument = Path.GetTempFileName().Replace(".tmp", ".pdf");
File.WriteAllBytes(testDocument, Properties.Resources.Document);
foreach (SPOTestSystem ts in testsystems)
{
if (ts.Active && reallyRemoveStuff)
{
reallyRemoveTestLists(ts, unitTestLibrary);
reallyRemoveTestLists(ts, unitTestList);
}
}
}
public void PasswordChangedHandler()
{
Password = SIEEUtils.GetUsecuredString(passwordBox.SecurePassword);
}
