private static void AddMockData()
{
var runner = new IntegrationTestsRunner();
runner.DeleteDatabase("schoolDb");
runner.CreateDatabase("schoolDb");
runner.ExecuteQuery("CREATE TABLE students (Id:int,FirstName:string,LastName:string,Grade:int)", "schoolDb");
runner.ExecuteQuery("CREATE TABLE objects (Id:int,Name:string,TeacherName:string,Language:string)", "schoolDb");
var firstNames = new List <string>()
{
"Vasile", "Ion", "Gheorghe", "Nicolai", "Elena", "Stefan", "Alexandra", "Mihai", "Maria", "Ana"
};
var lastNames = new List <string>()
{
"Pojoga", "Munteanu", "Herta", "Ailenei", "Creanga", "Stan", "Budescu", "Apostol", "Mironica", "Velea"
};
var grades = new List <int>()
{
9, 4, 8, 7, 10, 9, 3, 2, 8, 10
};
for (var i = 0; i < 10; i++)
{
runner.ExecuteQuery(string.Format("INSERT INTO students(Id,FirstName,LastName,Grade) VALUES({0},'{1}','{2}',{3})", i + 1, firstNames[i], lastNames[i], grades[i]), "schoolDb");
}
var objectNames = new List <string>()
{
"Math", "Computer Science", "History", "Business", "Biology", "Chemistry", "Phisics", "Literatre", "Algorithms", "Sport"
};
var teacherName = new List <string>()
{
"Ion Neculce", "Ion Creanga", "Herta Gheorghe", "Tudorel Toader", "Dorel Lucanu", "Vlad Radulescu", "Valeriu Baltag", "Apostol Sergiu", "Mironica Maria", "Velea Alex"
};
var language = new List <string>()
{
"English", "Romanian", "Russia", "French", "English", "Romanian", "German", "Spanish", "English", "Romanian"
};
for (var i = 0; i < 10; i++)
{
runner.ExecuteQuery(string.Format("INSERT INTO objects(Id,Name,TeacherName,Language) VALUES({0},'{1}','{2}','{3}')", i + 1, objectNames[i], teacherName[i], language[i]), "schoolDb");
}
}
private static void Test()
{
var runner = new IntegrationTestsRunner();
var result = runner.CreateDatabase("schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("CREATE TABLE students (Id:int,FirstName:string,LastName:string,Grade:int)", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("CREATE TABLE objects (Name:string,Points:int)", "schoolDb");
PrintResult(result);
var firstNames = new List <string>()
{
"Vasile", "Ion", "Gheorghe", "Nicolai", "Elena", "Stefan", "Alexandra", "Mihai", "Maria", "Ana"
};
var lastNames = new List <string>()
{
"Pojoga", "Munteanu", "Herta", "Ailenei", "Creanga", "Stan", "Budescu", "Apostol", "Mironica", "Velea"
};
var grades = new List <int>()
{
9, 4, 8, 7, 10, 9, 3, 2, 8, 10
};
for (var i = 0; i < 10; i++)
{
result = runner.ExecuteQuery(string.Format("INSERT INTO students(Id,FirstName,LastName,Grade) VALUES({0},'{1}','{2}',{3})", i + 1, firstNames[i], lastNames[i], grades[i]), "schoolDb");
PrintResult(result);
}
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("SELECT * FROM students WHERE Id>0 AND Id<2 OR Grade>9 AND Id>=2 AND FirstName!='Vasile'", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("DELETE FROM students WHERE Id=1 OR Id>=8", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("UPDATE students SET Grade=5 WHERE Grade<5", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("UPDATE students SET Grade=5,LastName='Failed' WHERE Grade<5 OR FirstName='Vasile'", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
PrintResult(result);
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
IQueryResultSerializer serializer = new CsvQueryResultSerializer();
var csv = serializer.Serialize(result);
System.Console.WriteLine(csv);
result = runner.ExecuteQuery("SELECT * FROM students", "schoolDb");
serializer = new XmlQueryResultSerializer();
var xml = serializer.Serialize(result);
System.Console.WriteLine(xml);
result = runner.ExecuteQuery("DELETE FROM students", "schoolDb");
PrintResult(result);
var databaseConnection = new DatabaseConnection(new DatabaseCofiguration(new DatabaseStorageService()), Constants.ServerLocation, "schoolDb");
ITableImporter importer = new CsvTableImporter();
var success = importer.Import(databaseConnection, "students", csv);
System.Console.WriteLine(string.Format("Import from csv: {0}", success));
importer = new XmlTableImporter();
success = importer.Import(databaseConnection, "students", xml);
System.Console.WriteLine(string.Format("Import from xml: {0}", success));
System.Console.ReadKey();
}
