public void AnimatedTweetDateUpdater_UpdateTweetDateForBlob_Arg_Date_Test()
{
TestDB testDB = new TestDB();
var animatedCollection = testDB.CreateAnimatedTestDB("animatedtweetdateupdater_test1");
//ищем точно заданную запись, обновляем. Работает поиск по Id, нужно помнить про это
var sampleAnim1 = SamplePostsDatabase.Images[0];
var findResult = animatedCollection.FindAsync(x => x.BlobName == sampleAnim1.BlobName).Result;
var record = findResult.FirstOrDefault();
var upd = new AnimatedTweetDateUpdater(animatedCollection);
try
{
upd.UpdateTweetDateForBlob(record, DateTime.MinValue);
Assert.Fail("Очікувалося ArgumentException");
}
catch (ArgumentException ex)
{
Assert.IsTrue(ex.ParamName == "date");
}
}
private string getTypeID(bool ability, int typeID)
{
TestDB dbScript = GameObject.Find("InitOb").GetComponent <TestDB>();
//Debug.Log ("Getting info, ability is " + ability);
return(dbScript.getCardType(ability, typeID));
}
private void btnConfirm_Click_1(object sender, EventArgs e)
{
// Создаём тест
TestDB test = new TestDB();
test.name = tbName.Text;
test.group_id = Convert.ToInt32(((KeyValuePair <string, string>)cbGroup.SelectedItem).Key);
MainForm main_fm = (MainForm)Application.OpenForms["MainForm"];
AdminDB user = new AdminDB(main_fm.login);
test.owner_id = user.id;
test.date_created = DateTime.Now;
test.date_last_saved = DateTime.Now;
test.AddToDB();
this.Close();
EditTest et = new EditTest(test.name);
test = null;
et.Show();
main_fm.UpdateDGV_Tests();
}
private void btnConfirm_Click_1(object sender, EventArgs e)
{
this.Close();
DialogResult dr = MessageBox.Show("Вы уверены, что хотите переместить тест?", "Вопрос", MessageBoxButtons.YesNo);
switch (dr)
{
case DialogResult.Yes:
// Тесты текущей группы
TestDB test = new TestDB(this.test_id);
// Id выбранной группы
int group_to_move_id = Convert.ToInt32(((KeyValuePair <string, string>)cbTestGroupMove.SelectedItem).Key);
this.Close();
// Перемещаем
test.MoveToGroupId(group_to_move_id);
// Обновим dgv
MainForm main_fm = (MainForm)Application.OpenForms["MainForm"];
main_fm.UpdateDGV_Tests();
break;
case DialogResult.No:
break;
}
this.Close();
}
public void SitePageTweetDateUpdater_UpdateTweetDateForPage_Argument_Date_Invalid_Test()
{
TestDB testDB = new TestDB();
var sitePages = testDB.CreateSitePagesTestDB("sitepages-sitepagetweetdateupdater_1");
string url = "https://kawaii-mobile.com/2020/08/speed-grapher/";
DateTime dtNow = new DateTime(2020, 10, 14, 0, 0, 0);
var findResult = sitePages.FindAsync(x => x.URL == url).Result;
var recordSpeedGrapher = findResult.FirstOrDefault();
Assert.IsNotNull(recordSpeedGrapher);
var upd = new SitePageTweetDateUpdater(sitePages);
try
{
upd.UpdateTweetDateForPage(recordSpeedGrapher, DateTime.MinValue);
}
catch (ArgumentException ex)
{
Assert.IsTrue(ex.ParamName == "date");
}
}
public void AnimatedTweetDateUpdater_UpdateTweetDateForBlob_Test()
{
TestDB testDB = new TestDB();
var animatedCollection = testDB.CreateAnimatedTestDB("animatedtweetdateupdater_test1");
//ищем точно заданную запись, обновляем. Работает поиск по Id, нужно помнить про это
var sampleAnim1 = SamplePostsDatabase.Images[0];
var findResult = animatedCollection.FindAsync(x => x.BlobName == sampleAnim1.BlobName).Result;
var record = findResult.FirstOrDefault();
var upd = new AnimatedTweetDateUpdater(animatedCollection);
DateTime dtNow = new DateTime(2020, 04, 26, 0, 0, 0);
upd.UpdateTweetDateForBlob(record, dtNow);
//теперь снова поиск и тест:
var findResult2 = animatedCollection.FindAsync(x => x.BlobName == sampleAnim1.BlobName).Result;
var record2 = findResult2.FirstOrDefault();
Assert.IsTrue(record2.TweetDate == dtNow);
}
public void SitePageTweetDateUpdater_UpdateTweetDateForPage_Test()
{
TestDB testDB = new TestDB();
var sitePages = testDB.CreateSitePagesTestDB("sitepages-sitepagetweetdateupdater_1");
string url = "https://kawaii-mobile.com/2020/08/speed-grapher/";
DateTime dtNow = new DateTime(2020, 10, 14, 0, 0, 0);
var findResult = sitePages.FindAsync(x => x.URL == url).Result;
var recordSpeedGrapher = findResult.FirstOrDefault();
Assert.IsNotNull(recordSpeedGrapher);
var upd = new SitePageTweetDateUpdater(sitePages);
//найти страницу, обновить дату
upd.UpdateTweetDateForPage(recordSpeedGrapher, dtNow);
//теперь снова поиск - и сверяем дату
var findResult2 = sitePages.FindAsync(x => x.URL == url).Result;
var recordSpeedGrapher2 = findResult2.FirstOrDefault();
Assert.IsTrue(recordSpeedGrapher2.TweetDate == dtNow);
}
public IHttpActionResult PutTestDB(int id, TestDB testDB)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != testDB.ID)
{
return(BadRequest());
}
db.Entry(testDB).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TestDBExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// ----------------------------------------------------------------------------------------
// ЗАГРУЗКА -------------------------------------------------------------------------------
// ----------------------------------------------------------------------------------------
#region MAIN
public EditTest(string test_name)
{
InitializeComponent();
// Получим только что созданный тест
TestDB test = new TestDB(test_name);
tbTestName.Text = test_name;
this.test = test;
// Создаём первый вопрос по дефолту
dgvQuestionsList.Rows.Add(
test.questions_list[0].id,
0,
test.questions_list[0].name
);
// Заголовок вопроса
tbQuestionName.Text = test.questions_list[0].name;
// Тело вопроса
question_body[0] = this.test.questions_list[0].description;
wbQuestion.Document.InvokeScript("setContent", question_body);
wbQuestion.Document.InvokeScript("setContent", question_body);
this.question_counts = dgvQuestionsList.Rows.Count;
// Заполним вопрос в редактор из БД
question_body[0] = this.test.questions_list[0].description;
wbQuestion.Navigate(System.IO.Path.Combine(Application.StartupPath, "Resources\\Editor\\CKEDITOR.htm"));
wbQuestion.Document.InvokeScript("InitEditor", question_body);
Application.DoEvents();
}
public void Local_search_searches_track_album_and_artist_names()
{
// Arrange
HomeController controller = new HomeController();
var repo = new TestDB();
var a1 = new Album { Id = 1, Artist = "Metallica", Name = "xpto", Year = 1986 };
var a2 = new Album { Id = 2, Artist = "V/A", Name = "..And Justice for All", Year = 1988 };
var a3 = new Album { Id = 3, Artist = "xpto", Name = "Master Of Puppets", Year = 1985 };
repo.Tracks.Add(new Track { Id = 1, Artist = "Metallica", Name = "Battery", Duration = 5.12, Album = a3 });
repo.Tracks.Add(new Track { Id = 2, Artist = "xpto", Name = "Polly", Duration = 12.3, Album = a2 });
repo.Tracks.Add(new Track { Id = 3, Artist = "Nirvana", Name = "xpto", Duration = 12.3, Album = a1 });
repo.Albums.Add(a1);
repo.Albums.Add(a2);
repo.Albums.Add(a3);
string query = "xpto";
controller._repo = repo;
// TODO: Mock data mappers
controller.a2mMapper = new SpotiChelas.DataMappers.AlbumToAlbumModelMapper();
controller._t2mMapper = new SpotiChelas.DataMappers.TrackToTrackModelMapper();
// Act
ViewResult result = controller.Search(query) as ViewResult;
var model = result.Model as SearchResult;
// Assert
Assert.IsNotNull(result);
Assert.IsInstanceOfType(model, typeof(SearchResult));
Assert.AreEqual(1, model.Albums.Count());
Assert.AreEqual(query, model.Albums.First().Name);
Assert.AreEqual(1, model.Tracks.Count());
Assert.AreEqual(query, model.Tracks.First().Name);
Assert.AreEqual(1, model.Artists.Count());
Assert.AreEqual(query, model.Artists.First());
}
public void AutoValue_Strategies_Update()
{
// Arrange
var user = new User("my user");
var db = TestDB.Create();
var entity = db.AutoValueTestEntities.Attach(new AutoValueTestEntity()
{
AutoOne = 5
});
var entry = db.Entry(entity);
entry.State = EntityState.Modified;
var ctx = new EntityContext()
{
Entry = entry, User = user, Operation = EntityOperation.Update
};
// Act
var visitor = new AutoValueVisitor();
visitor.Visit(ctx);
// Assert
Assert.AreEqual("two", entity.AutoTwo);
Assert.AreEqual(5, entity.AutoOne);
}
public void Access_Granted()
{
// Arrange
var user = new User("admin1");
user.Roles.Add("admin");
var db = TestDB.Create();
var entity = db.AccessTestEntities.Attach(new AccessTestEntity());
var entry = db.Entry(entity);
var ctx = new EntityContext()
{
Entry = entry, User = user, Operation = EntityOperation.Insert
};
// Access violation
entry.Property(e => e.RestrictedUsers_Throw).IsModified = true;
entry.Property(e => e.RestrictedRoles_Throw).IsModified = true;
// Act
var visitor = new AccessVisitor();
visitor.Visit(ctx);
// Assert
Assert.IsTrue(entry.Property(e => e.RestrictedUsers_Throw).IsModified);
Assert.IsTrue(entry.Property(e => e.RestrictedRoles_Throw).IsModified);
}
public MovingTest(int test_id)
{
InitializeComponent();
TestDB test = new TestDB(test_id);
tbText.Text = "Перемещение теста '" + test.name + "' в группу: ";
this.test_id = test_id;
TestsGroupDB obj = new TestsGroupDB();
obj.Fill();
// list групп для перемещения в неё
Dictionary <string, string> test_group_list_move = new Dictionary <string, string>();
for (int i = 0; i < obj.list_objects.Count; i++)
{
// Исключим из списка удаляемую группу, как?
test_group_list_move.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
}
cbTestGroupMove.DataSource = new BindingSource(test_group_list_move, null);
cbTestGroupMove.DisplayMember = "Value";
cbTestGroupMove.ValueMember = "Key";
cbTestGroupMove.SelectedIndex = 0;
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
TestDB.InitDB();
Application.Run(new FrmMain());
}
public void Access_Internal_Ignore()
{
// Arrange
var user = new User("my user");
var db = TestDB.Create();
var entity = db.AccessTestEntities.Attach(new AccessTestEntity());
var entry = db.Entry(entity);
var ctx = new EntityContext()
{
Entry = entry, User = user, Operation = EntityOperation.Insert
};
// Access violation
entry.Property(e => e.Internal_Ignore).IsModified = true;
// Act
var visitor = new AccessVisitor();
visitor.Visit(ctx);
// Assert
Assert.IsFalse(entry.Property(e => e.Internal_Ignore).IsModified);
}
static void Main(string[] args)
{
using (var db = new TestDB())
{
//Initialize DataTable
DataTable table = new DataTable();
var columnNames = db.Templates.Select(t => t.TemplateName).ToArray();
table.Columns.Add("Employeename", typeof(string));
foreach (var name in columnNames)
{
DataColumn column = new DataColumn(name, typeof(DateTime));
column.AllowDBNull = true;
table.Columns.Add(column);
}
//Get Matrix objects
var result = db.Matrices.Select(m => new MatrixCell
{
ColumnName = m.Template.TemplateName,
Date = (DateTime)m.Date,
EmployeeName = m.Employee.EmployeeName
}).ToArray();
//Populate datatable
foreach (var matrix in result)
{
table = matrix.ProcessRow(table);
}
Console.Read();
}
}
public override bool StoreActivity()
{
// Save completed Test to the database. Auto-increment Activity ID in database.
TestDB.AddCompletedTest(this, Student);
return(true);
}
public UpdateTests()
{
_db = new TestDB(ProviderFactory.GetProvider("WestWind"));
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public LinqGeneratorBugs()
{
_db = new TestDB(TestConfiguration.MsSql2005TestConnectionString, DbClientTypeName.MsSql);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public MySQLSelectTests()
{
_db = new TestDB(TestConfiguration.MySqlTestConnectionString, "MySql.Data.MySqlClient");
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public ActionResult DeleteConfirmed(int id)
{
TestDB testdb = db.TestDBs.Find(id);
db.TestDBs.Remove(testdb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private string getNameById(int id_test)
{
TestDB obj = new TestDB(id_test);
return(obj.name);
obj = null;
}
public static Test GetTest(string filename)
{
TestDB test = ReadTestFromFile(filename);
return(new Test(test.Name, test.Info, test.Duration,
test.Questions.Select(t => QuestionFromDB(t)).ToList(),
test.Criteries.Select(t => CriteriaFromDB(t)).ToList()));
}
public SQLiteSelectTests()
{
_db = new TestDB(new SQLitey().Connection, DataProviders.DbClientTypeName.SqlLite);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public OracleSelectTests()
{
_db = new TestDB(TestConfiguration.OracleTestConnectionString, DbClientTypeName.Oracle);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public void TweetCreator_OneTweet_Test()
{
var testDB = new TestDB();
var sitePagesCollection = testDB.CreateSitePagesTestDB("tweetcreator_sitepages_1");
var animatedCollection = testDB.CreateAnimatedTestDB("tweetcreator_animated_1");
HttpClient httpClient = new HttpClient();
ITwitterTextCreator textCreator = new kawaii.twitter.core.Text.TwitterTextCreator();
IImageOnWeb imageOnWeb = new kawaii.twitter.core.HtmlParsers.ImageOnWeb(httpClient);
ITwitterImageURL twitterImageURL = new kawaii.twitter.core.HtmlParsers.TwitterImageURL(httpClient);
//--- блок для lastTweetUpdater
DateTime nowDate = new DateTime(2020, 04, 26, 10, 00, 00);
var dateSupply = new SelectLogic.Stubs.DateSupplyStub
{
Now = nowDate
};
IAnimatedTweetDateUpdater animatedTweetDateUpdater = new AnimatedTweetDateUpdater(animatedCollection);
ISitePageTweetDateUpdater sitePageTweetDateUpdater = new SitePageTweetDateUpdater(sitePagesCollection);
ILastTweetUpdater lastTweetUpdater = new kawaii.twitter.core.SelectLogic.LastTweetUpdater(dateSupply, animatedTweetDateUpdater, sitePageTweetDateUpdater);
//---
var service = new Stubs.TwitterServiceStub(); //стаб для анализа (проверим что в него попадет в итоге)
IBlobDownload blobDownload = new Stubs.BlobDownloadStub(); //в данном тесте он не применяется (выбросит исключение)
//селектор - главная вещь, но здесь он будет "простой"
//Мы берем в обработку одну страницу:
string url = "https://kawaii-mobile.com/2020/10/uchuu-no-stellvia/";
var findResultStellvia = sitePagesCollection.FindAsync(x => x.URL == url).Result;
var pageStellvia = findResultStellvia.FirstOrDefault();
var selector = new Stubs.PageForTwittingSelectorStub
{
ResultPage = pageStellvia
};
var creator = new kawaii.twitter.core.TweetCreator(selector, textCreator, twitterImageURL, imageOnWeb, blobDownload, service, lastTweetUpdater, new Stubs.Logger());
creator.Execute().Wait();
//проверка состояния базы после данной операции:
var findResultStellvia2 = sitePagesCollection.FindAsync(x => x.URL == url).Result;
var pageStellvia2 = findResultStellvia2.FirstOrDefault();
//1) должна быть дата твита - та что мы задали
Assert.IsTrue(pageStellvia2.TweetDate == nowDate);
//2) проверяем, что там прислали в "твит-текст"
Assert.IsNotNull(service.ResultText);
Assert.IsTrue(service.ResultText.Contains(url));
//3) TODO@: проверить остальное - текст, хештеги, тело изображения
}
private void FrmMain_Load(object sender, EventArgs e)
{
_lstSql = TestDB.GetDBinfo().CheckDataBase();
txtSQL.AppendText("======" + TestDB.GetDBinfo().Name + "=========\r\n\r\n");
foreach (string sql in _lstSql)
{
txtSQL.AppendText(sql + ";\r\n");
}
}
public OracleSelectTests()
{
_db = new TestDB(TestConfiguration.OracleTestConnectionString, DbClientTypeName.OracleDataAccess);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public IActionResult EndTest(string Sub, int QATempId = 0, long UID = 0)
{
DataTable dt = null;
DataTable UserAnswer = null;
dt = JsonConvert.DeserializeAnonymousType <DataTable>(Sub, dt);
UserAnswer = TestDB.EndTest(dt, QATempId, UID, GetConfiguration().GetConnectionString(DEFAULT_CONNECTION));
return(Json(UserAnswer));
}
public UpdateTests()
{
_db = new TestDB(ProviderFactory.GetProvider("WestWind"));
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public LinqGeneratorBugs()
{
_db = new TestDB(TestConfiguration.MsSql2005TestConnectionString, DbClientTypeName.MsSql);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public DeleteTests()
{
provider = ProviderFactory.GetProvider("WestWind");
_db = new TestDB(provider);
var setup = new Setup(provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public MySQLSelectTests()
{
_db = new TestDB(TestConfiguration.MySqlTestConnectionString, "MySql.Data.MySqlClient");
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public SQLiteDateTests()
{
_db = new TestDB(new SQLitey().Connection, DataProviders.DbClientTypeName.SqlLite);
var setup = new Setup(_db.Provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public PlayerUnitTest()
{
var context = new FootballContext(dbContextOptions);
TestDB db = new TestDB();
db.Seed(context);
players = new PlayersController(context);
}
public DeleteTests()
{
provider = ProviderFactory.GetProvider("WestWind");
_db = new TestDB(provider);
var setup = new Setup(provider);
setup.DropTestTables();
setup.CreateTestTable();
setup.LoadTestData();
}
public void SetUserBalance_ShouldReturnFalse()
{
int userCount = TestDB.GetUserTable().Count;
// Act
bool validCall = admin.SetUserBalance(userCount + 100, 2500);
// Assert
Assert.False(validCall);
}
public ArrayList SearchEmployees()
{
//查询条件
string key = Request["key"];
//字段排序
String sortField = Request["sortField"];
String sortOrder = Request["sortOrder"];
Hashtable result = new TestDB().SearchEmployees(key, 0, 10000, sortField, sortOrder);
return result["data"] as ArrayList;
}
public void Test_Get_Track_With_Playlists_Info()
{
// Arrange
var controller = new Mock<PlaylistController>();
var repo = new TestDB();
var t1 = new Track { Id=1, Artist = "Metallica", Name = "Battery", Duration = 5.12 };
var t2 = new Track { Id=2, Artist = "Nirvana", Name = "Polly", Duration = 2.3 };
var tl1 = new TrackList{ ID=1, Order=1, Track=t1 };
var tl2 = new TrackList{ ID=2, Order=2, Track=t2 };
var tl3 = new TrackList{ ID=3, Order=1, Track=t2 };
ICollection<TrackList> ts1 = new TrackList[] {tl1,tl2};
ICollection<TrackList> ts2 = new TrackList[] {tl3};
var pl1 = new Playlist{ Id=1, Name="pl1", Tracks=ts1};
var pl2 = new Playlist{ Id=2, Name="pl2", Tracks=ts2};
repo.Tracks.Add(t1);
repo.Tracks.Add(t2);
repo.UsersInfo.Add(new UserInfo { Name="xpto", Username="******", Playlists=new []{pl1,pl2}});
controller.Object._repo = repo;
var principal = new Mock<System.Security.Principal.IPrincipal>();
principal.Setup(x => x.Identity.Name).Returns("xpto");
var ctx = new Mock<HttpContextBase>();
ctx.Setup(x => x.User).Returns(principal.Object);
var controllerContextMock = new Mock<ControllerContext>();
controllerContextMock.SetupGet(x => x.HttpContext).Returns(ctx.Object);
controller.Object.ControllerContext = controllerContextMock.Object;
// TODO: Mock data mappers
controller.Object._t2tipmMapper = new SpotiChelas.DataMappers.TrackToTrackInPlaylistModelMapper{};
controller.Object._p2mMapper = new SpotiChelas.DataMappers.PlaylistToPlaylistModelMapper{ trackMapper=new SpotiChelas.DataMappers.TrackToTrackModelMapper()};
// Act
var result = controller.Object.GetTrack(1);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.Id);
Assert.AreEqual(1, result.OnPlaylists.Count());
Assert.AreEqual(1, result.NotOnPlaylists.Count());
Assert.AreEqual(pl1.Name, result.OnPlaylists.First().Name);
Assert.AreEqual(pl2.Name, result.NotOnPlaylists.First().Name);
}
public void Index_always_returns_IEnumerable_of_TrackModel()
{
// Arrange
var controller = new TrackController();
var repo = new TestDB();
repo.Tracks.Add(new Track { Artist = "Metallica", Name = "Battery", Duration = 5.12 });
repo.Tracks.Add(new Track { Artist = "Nirvana", Name = "Polly", Duration = 2.3 });
controller._repo = repo;
// TODO: Mock data mappers
controller._t2mMapper = new SpotiChelas.DataMappers.TrackToTrackModelMapper();
// Act
var result = controller.Index() as ViewResult;
// Assert
Assert.IsNotNull(result);
Assert.IsNotNull(result.Model);
Assert.IsInstanceOfType(result.Model, typeof(IEnumerable<TrackModel>));
}
public void Test_Index()
{
// Arrange
var controller = new TrackController();
var repo = new TestDB();
repo.Tracks.Add(new Track { Artist = "Metallica", Name = "Battery", Duration = 5.12 });
repo.Tracks.Add(new Track { Artist = "Nirvana", Name = "Polly", Duration = 2.3 });
controller._repo = repo;
// TODO: Mock data mappers
controller._t2mMapper = new SpotiChelas.DataMappers.TrackToTrackModelMapper();
// Act
var result = controller.Index() as ViewResult;
var list = result.Model as IEnumerable<TrackModel>;
// Assert
Assert.AreEqual(2, list.Count());
}
public Sql2005DateTests()
{
_db = new TestDB(TestConfiguration.MsSql2005TestConnectionString, DbClientTypeName.MsSql);
_dateTestsSql = new Sql2005DateTestsSql();
}
public Linq() {
_db = new TestDB(TestConfiguration.MsSql2005TestConnectionString, DbClientTypeName.MsSql);
}
private static void SelectIQueryable(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with IQueryable: " + DateTime.Now + " using " + provider.Name);
var db = new TestDB(provider);
DateTime start = DateTime.Now;
for (int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = db.Products.SingleOrDefault(x => x.ProductID == 1);
//Console.Write(i + ",");
}
WriteResult(start);
}
private static void SelectIQueryable(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with IQueryable: " + DateTime.Now + " using " + provider.Client);
var db = new TestDB(provider);
DateTime start = DateTime.Now;
for(int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = db.Products.SingleOrDefault(x => x.ProductID == 1);
Console.WriteLine(i);
}
DateTime end = DateTime.Now;
TimeSpan ts = end.Subtract(start);
Console.WriteLine("End: " + DateTime.Now + " (" + ts.Seconds + ":" + ts.Milliseconds + ")");
}
public Sql2008NumberTests()
{
_db = new TestDB(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql);
_numberTestsSql = new Sql2008NumberTestsSql();
}
public SQLiteStringTests()
{
_stringTestsSql = new SQLiteStringTestsSql();
_db = new TestDB(TestConfiguration.SQLiteTestsConnectionString, DbClientTypeName.SqlLite);
}
public SQLiteDateTests()
{
_dateTestsSql = new SQLiteDateTestsSql();
_db = new TestDB(TestConfiguration.SQLiteTestsConnectionString, DataProviders.DbClientTypeName.SqlLite);
}
public MySQLNumberTests()
{
_numberTestsSql = new MySqlNumberTestsSql();
_db = new TestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
}
public OracleDateTests()
{
_dateTestsSql = new OracleDateTestsSql();
_db = new TestDB(TestConfiguration.OracleTestConnectionString, DbClientTypeName.OracleDataAccess);
}
public Sql2008DateTests()
{
_db = new TestDB(TestConfiguration.MsSql2008TestConnectionString, DbClientTypeName.MsSql);
}
public OracleSpecificTests()
{
_selectTestsSql = new OracleSelectTestsSql();
_db = new TestDB(TestConfiguration.OracleTestConnectionString, DbClientTypeName.OracleDataAccess);
_db.Provider.ExecuteDetachedForDebug = true;
}
public MySQLStringTests()
{
_db = new TestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
}
public BugReports() {
_db=new TestDB(ProviderFactory.GetProvider("WestWind"));
}
public void CheckParameterization()
{
var _db = new TestDB(TestConfiguration.OracleTestConnectionString, DbClientTypeName.DB2);
var queryable = _db.Categories.Where(x => x.CategoryID == 123 || x.CategoryName == "abc").Select(x => x.CategoryID);
var expr = queryable.Expression;
var plan = _db.QueryProvider.GetQueryPlan(expr);
var query = queryable.PrintDebugInfo();
// the literals should be in the plan as named values
Assert.Contains("CategoryName = :", plan);
Assert.Contains("CategoryID = :", plan);
Assert.Contains("(Object)\"abc\"", plan);
Assert.Contains("(Object)123", plan);
}
public MySQLDateTests()
{
_dateTestsSql = new MySqlDateTestsSql();
_db = new TestDB(TestConfiguration.MySqlTestConnectionString, DbClientTypeName.MySql);
}
