public void ExecuteNonQueryTest()
{
DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value
string sql = "update users set lastloginip='127.0.0.1'"; // TODO: Initialize to an appropriate value
System.Data.OleDb.OleDbParameter[] parameters = null; // TODO: Initialize to an appropriate value
int expected = 2; // TODO: Initialize to an appropriate value
int actual;
actual = target.ExecuteNonQuery(sql, parameters);
Assert.AreEqual(expected, actual);
}
public void ExecuteSql2DataSetTestNoData()
{
DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper();
string sql = "select * from users where userid=''";
System.Data.OleDb.OleDbParameter[] parameters = null;
int startIndex = 0;
int length = 5;
string srcTable = string.Empty;
System.Data.DataSet actual;
actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable);
Assert.AreEqual(0, actual.Tables[0].Rows.Count);
}
public void ExecuteScalarTest()
{
DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value
string sql = "select userid from users where userid=@userid";
System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] {
new OleDbParameter()
{
ParameterName = "userid",
Value = "Payne"
}
};
object expected = "Payne"; // TODO: Initialize to an appropriate value
object actual;
actual = target.ExecuteScalar(sql, parameters);
Assert.AreEqual(expected, actual);
}
public void ExecuteNonQueryTestWithParameters()
{
DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value
string sql = "update users set lastloginip='127.0.0.1' where userid=@userid"; // TODO: Initialize to an appropriate value
System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] {
new OleDbParameter()
{
ParameterName = "userid",
Value = "Payne"
}
};
int expected = 1; // TODO: Initialize to an appropriate value
int actual;
actual = target.ExecuteNonQuery(sql, parameters);
Assert.AreEqual(expected, actual);
}
public void ExecuteSql2DataSetTestOneRecord()
{
DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper();
string sql = "select * from users where userid=@userid";
System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] {
new OleDbParameter()
{
ParameterName = "userid",
Value = "Payne"
}
};
int startIndex = 0;
int length = 0;
string srcTable = string.Empty;
System.Data.DataSet actual;
actual = target.ExecuteSql2DataSet(sql, parameters, startIndex, length, srcTable);
Assert.AreEqual(1, actual.Tables[0].Rows.Count);
Assert.AreEqual("Payne", actual.Tables[0].Rows[0]["UserID"].ToString());
Assert.AreEqual("Payne Kang", actual.Tables[0].Rows[0]["Name"].ToString());
}
