public static void InSharedModeNoWait()
{
var statement = new LockTableStatement(ObjectName.Parse("APP.tab1"), LockingMode.Shared, 0);
var sql = statement.ToString();
const string expected = "LOCK TABLE APP.tab1 IN SHARED MODE NOWAIT";
Assert.AreEqual(expected, sql);
}
public static void InExclusiveModeInifiteWait()
{
var statement = new LockTableStatement(ObjectName.Parse("APP.tab1"), LockingMode.Exclusive);
var sql = statement.ToString();
const string expected = "LOCK TABLE APP.tab1 IN EXCLUSIVE MODE";
Assert.AreEqual(expected, sql);
}
public static void InExclusiveModeWait()
{
var statement = new LockTableStatement(ObjectName.Parse("APP.tab1"), LockingMode.Exclusive, 1200);
var sql = statement.ToString();
const string expected = "LOCK TABLE APP.tab1 IN EXCLUSIVE MODE WAIT 1200";
Assert.AreEqual(expected, sql);
}
public static void InSharedModeNoWait()
{
var statement = new LockTableStatement(ObjectName.Parse("APP.tab1"), LockingMode.Shared, 0);
var sql = statement.ToString();
const string expected = "LOCK TABLE APP.tab1 IN SHARED MODE NOWAIT";
Assert.AreEqual(expected, sql);
}