public void CheckConnectionTest()
{
ProviderSetting.CurrentDBProvider = DbProviderType.OracleOdpNetManaged;
UniDbConnection connect = new UniDbConnection("knvtest", "3");
connect.Open();
Assert.AreEqual(connect.State, ConnectionState.Open);
UniDbCommand cmd = new UniDbCommand("select * from apstaff.emp where emp_birth_date=:p_date and per_num=:p_per_num and perco_sync_id=:p_perco_sync_id order by per_num", connect);
cmd.Parameters.Add("p_per_num", UniDbType.String, "14534");
cmd.Parameters.Add("p_date", UniDbType.DateTime, new DateTime(1989, 7, 8));
cmd.Parameters.Add("p_perco_sync_id", UniDbType.Decimal, 9479);
UniDbDataReader dr = cmd.ExecuteReader();
List <string> ls = new List <string>();
while (dr.Read())
{
ls.Add(dr["PER_NUM"].ToString());
}
Assert.AreEqual(ls.Count, 1);
Assert.AreEqual(ls[ls.Count - 1], "14534");
connect.Close();
connect.Dispose();
}
public void CheckUniAdapterTest()
{
ProviderSetting.CurrentDBProvider = DbProviderType.OracleOdpNetManaged;
UniDbConnection connect = new UniDbConnection("knvtest", "3");
connect.Open();
Assert.AreEqual(connect.State, ConnectionState.Open);
UniDbAdapter a = new UniDbAdapter("select * from test_apstaff.temp_rep where per_num=:p_per_num", connect);
a.TableMappings.Add("Table", "temp_rep");
a.SelectCommand.Parameters.Add("p_per_num", UniDbType.String, "14534");
DataSet ds = new DataSet();
a.Fill(ds);
a.Dispose();
UniDbAdapter a1 = new UniDbAdapter("declare begin open :c for select * from test_apstaff.temp_rep where per_num=:p_per_num; end;", connect);
a1.TableMappings.Add("Table", "temp_rep1");
a1.SelectCommand.Parameters.Add("p_per_num", UniDbType.String, "14534");
a1.SelectCommand.Parameters.Add("c", UniDbType.RefCursor);
a1.Fill(ds);
Assert.AreEqual(ds.Tables["temp_rep1"].Rows.Count, 2);
UniDbAdapter a2 = new UniDbAdapter();
UniDbCommand cm = new UniDbCommand("declare begin open :c for select * from test_apstaff.temp_rep where per_num=:p_per_num; end;", connect);
a2.SelectCommand = cm;
a2.TableMappings.Add("Table", "temp_rep2");
a2.SelectCommand.Parameters.Add("p_per_num", UniDbType.String);
a2.SelectCommand.Parameters.Add("c", UniDbType.RefCursor);
a2.SelectCommand.SetParameters(new TestFilter());
DataTable t = new DataTable();
a2.Fill(ds);
Assert.AreEqual(ds.Tables["temp_rep2"].Rows.Count, 2);
Assert.IsTrue(ds.Tables["temp_rep2"].Rows.Cast <DataRow>().All(r => r["PER_NUM"].ToString() == "12714"));
a2.SelectCommand.Parameters["p_per_num"].Value = "13772";
a2.Fill(t);
Assert.AreEqual(t.Rows.Count, 2);
Assert.IsTrue(t.Rows.Cast <DataRow>().All(r => r["PER_NUM"].ToString() == "13772"));
connect.Close();
connect.Dispose();
}
