public void Test()
{
ProcedureDatabase db;
db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider));
int count;
db.GetCategoriesCount(out count);
Assert.AreEqual(db.Categories.Count(), count);
var id = db.Categories.Max(o => o.CategoryID);
string name;
db.GetCategoryName(id, out name);
Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Single().CategoryName, name);
OracleRefCursor myrc;
db.Connection.Open();
db.GetAllCategories(out myrc);
var reader = myrc.GetDataReader();
IEnumerable <Category> categories = db.Translate <Category>(reader).ToArray();
Assert.AreEqual(db.Categories.Count(), categories.Count());
db.Connection.Close();
categories = db.GetAllCategories();
Assert.AreEqual(db.Categories.Count(), categories.Count());
}
public void GetAllCategores()
{
var db = new ProcedureDatabase();
var items = db.GetCategories().ToArray();
Assert.AreEqual(db.Categories.Count(), items.Count());
}
public void AddCategory()
{
var db = new ProcedureDatabase();
var id = db.Categories.Max(o => o.CategoryID) + 1;
db.AddCategory(id, "Name" + id, "Description" + id);
}
public void CreateDatabase()
{
var db = new ProcedureDatabase();
FbConnection.DropDatabase(db.Connection.ConnectionString);
db.CreateDatabase();
}
public void GetAllCategories()
{
var db = new ProcedureDatabase();
object myrc;
var items = db.GetAllCategories(out myrc);
Assert.AreEqual(db.Categories.Count(), items.Count());
}
public void GetCategoriesCount()
{
var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider));
int count;
db.GetCategoriesCount(out count);
Assert.AreEqual(db.Categories.Count(), count);
}
public void GetCategoriesCount()
{
var db = new ProcedureDatabase();
int count;
db.GetCategoriesCount(out count);
Assert.AreEqual(db.Categories.Count(), count);
}
public void GetCategoryName2()
{
var db = new ProcedureDatabase();
var id = db.Categories.Max(o => o.CategoryID);
var name = db.Categories.Where(o => o.CategoryID == id).Select(o => GetCategoryName2(o.CategoryID)).Single();
Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Select(o => o.CategoryName).Single(), name);
}
public void GetCategoryPicture3()
{
var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider));
//var id = 2;
db.Connection.Open();
//var pic = db.DUAL.Select(o => GetCategoryPicture(id)).Single();
db.Connection.Close();
}
public void GetCategoryPicture2()
{
var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider));
db.Connection.Open();
var pics = db.Categories.Select(o => GetCategoryPicture(o.CategoryID)).ToArray();
db.Connection.Close();
}
public void AddCategory()
{
var db = new ProcedureDatabase();
var count = db.Categories.Count();
var id = db.Categories.Max(o => o.CategoryID) + 1;
db.AddCategory(id, "Name", "Description");
Assert.AreEqual(count + 1, db.Categories.Count());
}
public void GetAllCategories()
{
var db = new ProcedureDatabase();
string categoryName, categoryDescription;
int categoryID;
var items = db.GetAllCategories(out categoryID, out categoryName, out categoryDescription);
Assert.AreEqual(db.Categories.Count(), items.Count());
}
public void GetCategoryName()
{
var db = new ProcedureDatabase();
var id = db.Categories.Max(o => o.CategoryID);
string name;
db.GetCategoryName(id, out name);
Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Single().CategoryName, name);
}
public void GetCategories()
{
var db = new ProcedureDatabase {
Log = Console.Out
};
var categories = db.GetCategories();
Assert.Equals(db.Categories.Count(), categories.Count());
}
public void AddCategory()
{
var db = new ProcedureDatabase {
Log = Console.Out
};
var count = db.Categories.Count();
db.AddCategory("name", "description");
Assert.AreEqual(count + 1, db.Categories.Count());
}
public void CreateProcedure3()
{
var command = @"Create PROCEDURE GetCategoryName
AS
Select CategoryName From Categories
Where CategoryID = [@categoryID]";
var db = new ProcedureDatabase();
db.ExecuteCommand(command);
}
public void CreateDatabase()
{
var db = new ProcedureDatabase();
if (db.DatabaseExists())
{
db.DeleteDatabase();
}
db.CreateDatabase();
}
public void GetCategoryName()
{
var db = new ProcedureDatabase {
Log = Console.Out
};
var maxID = db.Categories.Max(c => c.CategoryID);
var category = db.Categories.Where(o => o.CategoryID == maxID).Single();
var categoryName = db.GetCategoryName(category.CategoryID);
Assert.AreEqual(category.CategoryName, categoryName);
}
public void AddProduct()
{
var db = new ProcedureDatabase();
var id = db.Products.Max(o => o.ProductID) + 1;
db.Products.Insert(new Product
{
ProductID = id,
ProductName = "Name"
});
}
public void GetCategoryPicture1()
{
var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider));
var id = 2;
db.Connection.Open();
var pic = db.GetCategoryPicture(id);
db.Connection.Close();
Assert.IsNotNull(pic);
}
public void GetPictures()
{
var db = new ProcedureDatabase();
var ids = db.Categories.Select(o => o.CategoryID).ToArray();
//ids.Select(o => db.GetCategoryPicture(o, out pic)).ToArray();
foreach (var id in ids)
{
byte[] pic;
db.GetCategoryPicture(id, out pic);
}
}
public void CreateDatabase()
{
var db = new ProcedureDatabase()
{
Log = Console.Out
};
if (db.DatabaseExists())
{
db.DeleteDatabase();
}
db.CreateDatabase();
}
public void GetCategoriesAndProducts()
{
var db = new ProcedureDatabase();
object myrc1;
object myrc2;
var result = db.GetCategoriesAndProducts(out myrc1, out myrc2);
var categories = result.GetResult <Category>();
Assert.AreEqual(db.Categories.Count(), categories.Count());
var products = result.GetResult <Product>();
Assert.AreEqual(db.Products.Count(), products.Count());
}
public void GetCategoresAndProducts()
{
var db = new ProcedureDatabase();
var result = db.GetCategoriesAndProducts();
var categories = result.GetResult <Category>().ToArray();
var products = result.GetResult <Product>().ToArray();
foreach (var category in categories)
{
Console.WriteLine("{0} {1} {2}", category.CategoryID, category.CategoryName, category.Description);
}
Assert.AreEqual(db.Categories.Count(), categories.Count());
Assert.AreEqual(db.Products.Count(), products.Count());
}
public void CreateProcedure1()
{
var sb = new StringBuilder();
sb.AppendLine("DROP PROCEDURE IF EXISTS ADD_CATEGORY;");
sb.AppendLine("CREATE PROCEDURE ADD_CATEGORY(IN CATEGORY_NAME VARCHAR(30), IN CATEGORY_DESCRIPTION TEXT)");
sb.AppendLine("BEGIN");
sb.AppendLine("INSERT INTO CATEGORIES (CategoryName, Description)");
sb.AppendLine("Values (category_name, category_description);");
sb.AppendLine("END;");
sb.AppendLine();
var db = new ProcedureDatabase();
db.ExecuteCommand(sb.ToString());
}
