public void InsertString_값_삽입하기_pk_자동생성()
{
OracleORMHelper helper = new OracleORMHelper();
OracleRepositoryString RepositoryString = new OracleRepositoryString(helper);
Test2Class t2 = new Test2Class();
Assert.Throws <RequiredValueNotFoundException>(() => RepositoryString.InsertStr(t2));
t2.Data = "test";
string expect2 = "INSERT INTO Test2 ( Data, CDate ) VALUES ( :Data, SYSDATE )";
var actual2 = RepositoryString.InsertStr(t2);
Assert.Equal(expect2, actual2);
t2.FakeNameColumn = "test";
string expect3 = "INSERT INTO Test2 ( Data, RealColumnName, CDate ) VALUES ( :Data, :FakeNameColumn, SYSDATE )";
var actual3 = RepositoryString.InsertStr(t2);
Assert.Equal(expect3, actual3);
}
public void SelectString_쿼리_가져오기()
{
OracleORMHelper helper = new OracleORMHelper();
OracleRepositoryString RepositoryString = new OracleRepositoryString(helper);
TestClass t = new TestClass();
Test2Class t2 = new Test2Class();
string expect = "SELECT * FROM Test WHERE 1=1";
var actual = RepositoryString.SelectString(t);
Assert.Equal(expect, actual);
t.Id = 1;
string expect2 = "SELECT * FROM Test WHERE 1=1 AND Test.Id = :Id";
var actual2 = RepositoryString.SelectString(t);
Assert.Equal(expect2, actual2);
}
public void UpdateString_값_수정하기()
{
OracleORMHelper helper = new OracleORMHelper();
OracleRepositoryString RepositoryString = new OracleRepositoryString(helper);
TestClass t = new TestClass();
Assert.Throws <PkNotFoundException>(() => RepositoryString.UpdateStr(t));
t.Id = 1;
t.Data = "test";
string expect2 = "UPDATE Test SET Data = :Data, LDate = SYSDATE WHERE Id = :Id";
var actual2 = RepositoryString.UpdateStr(t);
Assert.Equal(expect2, actual2);
string expect3 = "UPDATE Test SET Data = :Data, RealColumnName = NULL, LDate = SYSDATE WHERE Id = :Id";
var actual3 = RepositoryString.UpdateStr(t, true);
Assert.Equal(expect3, actual3);
t.FakeNameColumn = "test";
string expect4 = "UPDATE Test SET Data = :Data, RealColumnName = :FakeNameColumn, LDate = SYSDATE WHERE Id = :Id";
var actual4 = RepositoryString.UpdateStr(t);
Assert.Equal(expect4, actual4);
// -- Test2
expect2 = string.Empty;
expect3 = string.Empty;
expect4 = string.Empty;
actual2 = string.Empty;
actual3 = string.Empty;
actual4 = string.Empty;
Test2Class t2 = new Test2Class();
t2.Data = "test";
Assert.Throws <PkNotFoundException>(() => RepositoryString.UpdateStr(t2));
t2.Data = null;
t2.Id = 1;
Assert.Throws <RequiredValueNotFoundException>(() => RepositoryString.UpdateStr(t2));
t2.Data = "test";
expect2 = "UPDATE Test2 SET Data = :Data, LDate = SYSDATE WHERE Id = :Id";
actual2 = RepositoryString.UpdateStr(t2);
Assert.Equal(expect2, actual2);
expect3 = "UPDATE Test2 SET Data = :Data, RealColumnName = NULL, LDate = SYSDATE WHERE Id = :Id";
actual3 = RepositoryString.UpdateStr(t2, true);
Assert.Equal(expect3, actual3);
t2.FakeNameColumn = "test";
expect4 = "UPDATE Test2 SET Data = :Data, RealColumnName = :FakeNameColumn, LDate = SYSDATE WHERE Id = :Id";
actual4 = RepositoryString.UpdateStr(t2);
Assert.Equal(expect4, actual4);
}
