public void DeleteOneRowTest()
{
TestHelper.Init();
TestSqlHelper.Init(new UnitTestInit {
databases = Databases.LearnTransactSql, cryptData = true
});
Dictionary <string, MSColumnsDB> s = new Dictionary <string, MSColumnsDB>();
const string tableName = "Test_PageVT";
s.Add(tableName, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "IDPage"),
MSSloupecDB.CI(SqlDbType2.TinyInt, "IDTable"),
MSSloupecDB.CI(SqlDbType2.Int, "IDItem"),
MSSloupecDB.CI(SqlDbType2.SmallInt, "Day"),
MSSloupecDB.CI(SqlDbType2.Int, XlfKeys.Views)
));
int IDPage = 0;
byte IDTable = 0;
int IDItem = 0;
short Day = NormalizeDate.To(DateTime.Today);
int Views = int.MaxValue;
foreach (var item in s)
{
MSStoredProceduresI.ci.DropAndCreateTable(item.Key, item.Value);
}
for (int i = 0; i < 3; i++)
{
MSStoredProceduresI.ci.Insert4(tableName, IDPage, IDTable, IDItem, Day, Views);
}
var c = MSStoredProceduresI.ci.SelectCount(tableName);
Assert.AreEqual(3, c);
MSStoredProceduresI.ci.DeleteOneRow(tableName, AB.Get("IDTable", IDTable), AB.Get("IDItem", IDItem), AB.Get("Day", Day));
c = MSStoredProceduresI.ci.SelectCount(tableName);
Assert.AreEqual(2, c);
}
public static void CreateStaticTables()
{
if (s.Count > 0)
{
return;
}
#region Table structure
#region Lyr
// Musí být bez _ protože aplikace mi přes něj parsují
s.Add(TablesLTS.Test_PageLyrSong, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "ID", true),
MSSloupecDB.CI(SqlDbType2.Int, "OverallViews")
));
//Test_PageNewLyrSong
s.Add(tableName4, new MSColumnsDB(true,
// can't be primary key coz there will be many days for every days
MSSloupecDB.CI(SqlDbType2.Int, ColumnNamesWeb.IDPageLyrSong),
MSSloupecDB.CI(SqlDbType2.SmallInt, "Day"),
MSSloupecDB.CI(SqlDbType2.Int, XlfKeys.Views)
));
//Test_Lyr_Song
s.Add(tableEntity4, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "ID", true),
MSSloupecDB.CI(SqlDbType2.Int, "ViewLastWeek"))
);
#endregion
#region !Lyr
s.Add(TablesLTS.Test_Page, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "ID", true),
MSSloupecDB.CI(SqlDbType2.Bit, "IsOld"),
MSSloupecDB.CI(SqlDbType2.Int, "OverallViews"),
MSSloupecDB.CI(SqlDbType2.Bit, "AllowNewComments")
));
s.Add(tableName3, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "IDItem"),
MSSloupecDB.CI(SqlDbType2.Int, "IDPage"),
MSSloupecDB.CI(SqlDbType2.SmallInt, "Day"),
MSSloupecDB.CI(SqlDbType2.Int, XlfKeys.Views)
));
#endregion
s.Add(TablesLTS.Test_PageNew3_SI, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.SmallInt, "IDItem"),
MSSloupecDB.CI(SqlDbType2.Int, "IDPage"),
MSSloupecDB.CI(SqlDbType2.SmallInt, "Day"),
MSSloupecDB.CI(SqlDbType2.Int, XlfKeys.Views)
));
s.Add(tableEntity3, new MSColumnsDB(true,
MSSloupecDB.CI(SqlDbType2.Int, "ID", true),
MSSloupecDB.CI(SqlDbType2.Int, "ViewLastWeek"))
);
#endregion
}
