public void BulkInsertAndSelect()
{
var db = new TestDb(false, new ContractResolver(t => _container.CanResolve(t), (t, op) => _container.Resolve(t)));
db.CreateTable <IProduct>();
db.CreateTable <IOrder>();
db.CreateTable <IOrderLine>();
db.CreateTable <IOrderHistory>();
var rnd = new Random();
var data = new List <IOrderLine>();
for (var i = 0; i < 100; i++)
{
var l = _container.Resolve <IOrderLine>();
l.OrderId = rnd.Next(1, 100);
l.ProductId = rnd.Next(1, 100);
l.Quantity = rnd.Next(1, 25);
l.Status = OrderLineStatus.Shipped;
l.UnitPrice = rnd.Next(0, 100);
data.Add(l);
}
db.InsertAll(data.ToArray());
var results = db.Table <IOrderLine>();
Assert.AreEqual(data.Count, results.Count());
Assert.AreEqual(data.First().UnitPrice, results.First().UnitPrice);
Assert.AreEqual(data.Last().UnitPrice, results.Last().UnitPrice);
}
public void Setup()
{
testObjects = Enumerable.Range(1, 20).Select(i => new TestObj()).ToList();
db = new TestDb(TestPath.CreateTemporaryDatabase());
db.InsertAll(testObjects);
}
private SQLiteConnection CreateDb()
{
var db = new TestDb();
db.CreateTable <TestTable>();
IEnumerable <TestTable> items = from i in Enumerable.Range(0, Count)
select new TestTable
{
Two = 2
};
db.InsertAll(items);
Assert.AreEqual(Count, db.Table <TestTable>().Count());
return(db);
}
private static TestDb GetTestDBWith100Elements()
{
int n = 100;
IEnumerable <TestObj> cq = from i in Enumerable.Range(1, n)
select new TestObj
{
Order = i
};
TestObj[] objs = cq.ToArray();
var db = new TestDb(TestPath.CreateTemporaryDatabase());
int numIn = db.InsertAll(objs);
Assert.AreEqual(numIn, n, "Num inserted must = num objects");
return(db);
}
public void AddForStringsMeansConcatenate()
{
int n = 20;
IEnumerable <TestObjString> cq = from i in Enumerable.Range(1, n)
select new TestObjString()
{
Data = i.ToString(),
};
var db = new TestDb(TestPath.CreateTemporaryDatabase());
db.InsertAll(cq);
TableQuery <TestObjString> results = db.Table <TestObjString>().Where(o => o.Data + "1" == "11");
Assert.AreEqual(1, results.Count());
Assert.AreEqual("1", results.OrderBy(o => o.Data).FirstOrDefault().Data);
}
public void CanHaveSubtractInWhereClause()
{
int n = 20;
IEnumerable <TestObjInt> cq = from i in Enumerable.Range(1, n)
select new TestObjInt()
{
Data = i,
};
var db = new TestDb(TestPath.CreateTemporaryDatabase());
db.InsertAll(cq);
TableQuery <TestObjInt> results = db.Table <TestObjInt>().Where(o => o.Data - 10 >= 0);
Assert.AreEqual(results.Count(), 11);
Assert.AreEqual(results.OrderBy(o => o.Data).FirstOrDefault().Data, 10);
}
public void Issue115_MissingPrimaryKey()
{
using (var conn = new TestDb())
{
conn.CreateTable <Issue115_MyObject>();
conn.InsertAll(from i in Enumerable.Range(0, 10)
select new Issue115_MyObject
{
UniqueId = i.ToString(),
OtherValue = (byte)(i * 10),
});
TableQuery <Issue115_MyObject> query = conn.Table <Issue115_MyObject>();
foreach (Issue115_MyObject itm in query)
{
itm.OtherValue++;
Assert.AreEqual(1, conn.Update(itm, typeof(Issue115_MyObject)));
}
}
}
public void SetUp()
{
db = new TestDb();
db.CreateTable <Product>();
var prods = new[]
{
new Product
{
Name = "Foo"
},
new Product
{
Name = "Bar"
},
new Product
{
Name = "Foobar"
}
};
db.InsertAll(prods);
}
public void ReplaceInWhere()
{
string testElement = "Element";
string alternateElement = "Alternate";
string replacedElement = "ReplacedElement";
int n = 20;
IEnumerable <TestObj> cq = from i in Enumerable.Range(1, n)
select new TestObj
{
Name = (i % 2 == 0) ? testElement : alternateElement
};
var db = new TestDb(TestPath.CreateTemporaryDatabase());
db.InsertAll(cq);
db.TraceListener = DebugTraceListener.Instance;
List <TestObj> result = (from o in db.Table <TestObj>() where o.Name.Replace(testElement, replacedElement) == replacedElement select o).ToList();
Assert.AreEqual(10, result.Count);
}
