public override void update()
{
CswTableUpdate NTUpdate = _CswNbtSchemaModTrnsctn.makeCswTableUpdate( "update_ntnames", "nodetypes" );
DataTable NTTable = NTUpdate.getTable();
foreach( DataRow NTRow in NTTable.Rows )
{
NTRow["nodetypename"] = CswFormat.MakeIntoValidName( NTRow["nodetypename"].ToString() );
}
NTUpdate.update( NTTable );
} // update()
public override void update()
{
CswTableUpdate NTPUpdate = _CswNbtSchemaModTrnsctn.makeCswTableUpdate( "update_nt_oraview_names", "nodetype_props" );
DataTable NTPTable = NTPUpdate.getTable("where oraviewcolname is null");
foreach( DataRow Prop in NTPTable.Rows )
{
Prop["oraviewcolname"] = CswFormat.MakeOracleCompliantIdentifier( Prop["propname"].ToString() );
}
NTPUpdate.update( NTPTable );
} // update()
public void MakeIntoValidNameTest()
{
string[] UnformattedNames = { "abc!", "1'23", "(abc123)", "abc123", "", "name (demo)", "this_is_valid", "_this_is_not" };
string[] ExpectedFormattedNames = { "abc", "n123", "abc123", "abc123", "n", "name demo", "this_is_valid", "n_this_is_not" };
Assert.AreEqual(UnformattedNames.Length, ExpectedFormattedNames.Length);
for (int i = 0; i < UnformattedNames.Length; i++)
{
Assert.AreEqual(ExpectedFormattedNames[i], CswFormat.MakeIntoValidName(UnformattedNames[i]));
}
}
