| private buildUpdateFolderQuery ( domain folder ) : OracleQuery | ||
| folder | domain | |
| return | OracleQuery | |
public void testUpdateFolderSql()
{
FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource()
{
ConnectionString = "MyCxnString"
}));
OracleQuery result = dao.buildUpdateFolderQuery(new domain.sm.Folder()
{
Id = 1, Name = "New Folder Name"
});
Assert.IsNotNull(result);
Assert.IsNull(result.Command.Connection);
Assert.AreEqual("UPDATE SMS.FOLDER SET FOLDER_NAME=:folderName, OPLOCK=:oplockPlusOne, MODIFIED_DATE=:modifiedDate WHERE FOLDER_ID=:folderId and OPLOCK=:oplock AND ACTIVE=1", result.Command.CommandText);
Assert.AreEqual(5, result.Command.Parameters.Count);
Assert.AreEqual(System.Data.DbType.String, result.Command.Parameters[0].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Varchar2, result.Command.Parameters[0].OracleDbType);
Assert.AreEqual("folderName", result.Command.Parameters[0].ParameterName);
Assert.AreEqual("New Folder Name", result.Command.Parameters[0].Value);
Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[1].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[1].OracleDbType);
Assert.AreEqual("oplockPlusOne", result.Command.Parameters[1].ParameterName);
Assert.AreEqual(1, result.Command.Parameters[1].Value);
Assert.AreEqual(System.Data.DbType.Date, result.Command.Parameters[2].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Date, result.Command.Parameters[2].OracleDbType);
Assert.AreEqual("modifiedDate", result.Command.Parameters[2].ParameterName);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[3].OracleDbType);
Assert.AreEqual("folderId", result.Command.Parameters[3].ParameterName);
Assert.AreEqual(1, result.Command.Parameters[3].Value);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[4].OracleDbType);
Assert.AreEqual("oplock", result.Command.Parameters[4].ParameterName);
}
public void testUpdateFolderSql()
{
FolderDao dao = new FolderDao(new MdoOracleConnection(new DataSource() { ConnectionString = "MyCxnString" }));
OracleQuery result = dao.buildUpdateFolderQuery(new domain.sm.Folder() { Id = 1, Name = "New Folder Name" });
Assert.IsNotNull(result);
Assert.IsNull(result.Command.Connection);
Assert.AreEqual("UPDATE SMS.FOLDER SET FOLDER_NAME=:folderName, OPLOCK=:oplockPlusOne, MODIFIED_DATE=:modifiedDate WHERE FOLDER_ID=:folderId and OPLOCK=:oplock AND ACTIVE=1", result.Command.CommandText);
Assert.AreEqual(5, result.Command.Parameters.Count);
Assert.AreEqual(System.Data.DbType.String, result.Command.Parameters[0].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Varchar2, result.Command.Parameters[0].OracleDbType);
Assert.AreEqual("folderName", result.Command.Parameters[0].ParameterName);
Assert.AreEqual("New Folder Name", result.Command.Parameters[0].Value);
Assert.AreEqual(System.Data.DbType.Decimal, result.Command.Parameters[1].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[1].OracleDbType);
Assert.AreEqual("oplockPlusOne", result.Command.Parameters[1].ParameterName);
Assert.AreEqual(1, result.Command.Parameters[1].Value);
Assert.AreEqual(System.Data.DbType.Date, result.Command.Parameters[2].DbType);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Date, result.Command.Parameters[2].OracleDbType);
Assert.AreEqual("modifiedDate", result.Command.Parameters[2].ParameterName);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[3].OracleDbType);
Assert.AreEqual("folderId", result.Command.Parameters[3].ParameterName);
Assert.AreEqual(1, result.Command.Parameters[3].Value);
Assert.AreEqual(Oracle.DataAccess.Client.OracleDbType.Decimal, result.Command.Parameters[4].OracleDbType);
Assert.AreEqual("oplock", result.Command.Parameters[4].ParameterName);
}