public void CreateNewSessionTableCmd_Should_Create_SqlCommand_Without_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateNewSessionTableCmd(SqlStatement);
VerifyBasicsOfSqlCommand(cmd);
Assert.Empty(cmd.Parameters);
}
public void CreateDeleteExpiredSessionsCmd_Should_Create_SqlCommand_Withone_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateDeleteExpiredSessionsCmd(SqlStatement);
VerifyBasicsOfSqlCommand(cmd);
Assert.Single(cmd.Parameters);
}
public void CreateResetItemTimeoutCmd_Should_Create_SqlCommand_With_Right_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateResetItemTimeoutCmd(SqlStatement, SessionId);
VerifyBasicsOfSqlCommand(cmd);
VerifySessionIdParameter(cmd);
//lockdate
Assert.Equal(2, cmd.Parameters.Count);
}
public void CreateRemoveStateItemCmd_Should_Create_SqlCommand_With_Right_Parameters(object lockId)
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateRemoveStateItemCmd(SqlStatement, SessionId, lockId);
VerifyBasicsOfSqlCommand(cmd);
VerifySessionIdParameter(cmd);
// VerifyLockCookieParameter(cmd, lockId);
Assert.Equal(1, cmd.Parameters.Count);
}
public void CreateGetStateItemCmd_Should_Create_SqlCommand_With_Right_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateGetStateItemCmd(SqlStatement, SessionId);
VerifyBasicsOfSqlCommand(cmd);
VerifySessionIdParameter(cmd);
//VerifyLockedParameter(cmd);
//VerifyLockAgeParameter(cmd);
//VerifyLockCookieParameter(cmd);
//VerifyActionFlagsParameter(cmd);
Assert.Equal(2, cmd.Parameters.Count);
}
public void CreateTempInsertUninitializedItemCmd_Should_Create_SqlCommand_With_Right_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateTempInsertUninitializedItemCmd(SqlStatement, SessionId, BufferLength, Buffer, SessionTimeout);
VerifyBasicsOfSqlCommand(cmd);
VerifySessionIdParameter(cmd);
VerifySessionItemLongParameter(cmd);
VerifyTimeoutParameter(cmd);
//lockdate
//lockdatelocal
//expirestime
Assert.Equal(6, cmd.Parameters.Count);
}
public void CreateUpdateStateItemLongCmd_Should_Create_SqlCommand_With_Right_Parameters()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
var cmd = helper.CreateUpdateStateItemLongCmd(SqlStatement, SessionId, Buffer, BufferLength, SessionTimeout, LockId);
VerifyBasicsOfSqlCommand(cmd);
VerifySessionIdParameter(cmd);
VerifySessionItemLongParameter(cmd);
VerifyTimeoutParameter(cmd);
//lockdate
//expiresin
//VerifyLockCookieParameter(cmd, LockId);
Assert.Equal(5, cmd.Parameters.Count);
}
public void Constructor_Should_Initialize_CommandTimeout()
{
var helper = new NpgsqlCommandHelper(SqlCommandTimeout);
Assert.Equal(SqlCommandTimeout, helper.CommandTimeout);
}