public void OracleSourceConstructorTest_SourceAlias()
{
OracleSource target = new OracleSource("Table", "a");
Assert.AreEqual <string>(string.Format("\"{0}\"", target.Alias.ToUpper()), target.Fullname);
Assert.AreEqual <string>(string.Format("{0} \"{1}\"", target.Object.SqlString, target.Alias.ToUpper()), target.SqlString);
}
public void OracleSourceConstructorTest_SourceName()
{
OracleSource target = new OracleSource("Table");
Assert.AreEqual <string>(string.Format("\"{0}\"", target.Name.ToUpper()), target.Fullname);
Assert.AreEqual <string>(string.Format("\"{0}\"", target.Name.ToUpper()), target.SqlString);
}
public void OracleSourceConstructorTest_SourceOwnerNameAlias()
{
OracleSource owner = new OracleSource("INFORMATION_SCHEMA");
OracleSource target = new OracleSource(owner, "Table", "a");
Assert.AreEqual <string>(string.Format("\"{0}\"", target.Alias.ToUpper()), target.Fullname);
Assert.AreEqual <string>(string.Format("{0} \"{1}\"", target.Object.SqlString, target.Alias.ToUpper()), target.SqlString);
}
public void OracleFieldConstructorTest_FieldAlias()
{
ISqlObject source = new OracleSource("Table");
SqlAliasObject field = new OracleField(source, "Field", "ID");
Assert.AreEqual <string>(field.Object.Fullname, field.Fullname);
Assert.AreEqual <string>(string.Format("{0} AS \"{1}\"", field.Object.SqlString, field.Alias.ToUpper()), field.SqlString);
}
public void OracleFieldConstructorTest_FieldName()
{
ISqlObject source = new OracleSource("Table");
ISqlObject field = new OracleField(source, "Field");
Assert.AreEqual <string>(string.Format("{0}.\"{1}\"", source.Fullname, field.Name.ToUpper()), field.Fullname);
Assert.AreEqual <string>(string.Format("{0}.\"{1}\"", source.Fullname, field.Name.ToUpper()), field.SqlString);
}
public void OracleSourceConstructorTest_Subquery()
{
OracleSource source = new OracleSource("Table");
ISqlSelectStatement statement = new OracleSelectStatement();
statement.SelectClause.AddExpressions(new SqlAllField(source));
statement.FromClause.Source = source;
OracleSource target = new OracleSource(statement, "Source");
Assert.AreEqual <string>(string.Format("\"{0}\"", target.Name.ToUpper()), target.Fullname);
Assert.AreEqual <string>(string.Format("({0}) \"{1}\"", statement.SqlString, target.Name.ToUpper()), target.SqlString);
}
public void CountTest()
{
ISqlObject source = new OracleSource("Table");
ISqlObject field = new OracleField(source, "ID");
OracleSelectStatement target = new OracleSelectStatement();
target.SelectClause.AddExpressions(field);
target.FromClause.Source = source;
target.WhereClause.Condition = field.GreaterThan(new SqlStringExpression("13"));
target.OrderClause.AddExpression(field, SqlOrder.Desc);
string sqlString = target.SqlString;
target.Count = 13;
ISqlObject rowNumber = SqlObject.FromVariable("ROWNUM");
Assert.AreEqual <string>(string.Format("SELECT * FROM ({1}) {0} WHERE {2} ORDER BY {3} ASC", new OracleSource(OracleSelectStatement.MIDDLE_RESULT_NAME), sqlString, rowNumber.GreaterEqual(new SqlStringExpression(target.Count.ToString())), rowNumber.Fullname),
target.SqlString);
}
