Mercurial > pub > bltoolkit

comparison UnitTests/CS/DataAccess/SqlQueryTest.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 using System;
2 using System.Collections;
3
4 using NUnit.Framework;
5
6 using BLToolkit.DataAccess;
7
8 namespace DataAccess
9 {
10 [TestFixture]
11 public class SqlQueryTest
12 {
13 public class Person
14 {
15 public int ID;
16 public string LastName;
17 public string FirstName;
18 public string MiddleName;
19 }
20
21 [ObjectType(typeof(Person))]
22 public abstract class PersonAccessor : DataAccessor
23 {
24 [TestQuery(
25 SqlText = "SELECT * FROM Person WHERE LastName = @lastName",
26 OracleText = "SELECT * FROM Person WHERE LastName = :lastName")]
27 public abstract ArrayList SelectByLastName(string lastName);
28
29 [TestQuery(
30 SqlText = "SELECT * FROM Person WHERE {0} = @value",
31 OracleText = "SELECT * FROM Person WHERE {0} = :value")]
32 public abstract ArrayList SelectBy([Format] string fieldName, string value);
33
34 [TestQuery(
35 SqlText = "SELECT TOP ({0}) * FROM Person WHERE LastName = @lastName",
36 AccessText = "SELECT TOP {0} * FROM Person WHERE LastName = @lastName",
37 OracleText = "SELECT * FROM Person WHERE LastName = :lastName AND rownum <= {0}",
38 FbText = "SELECT FIRST {0} * FROM Person WHERE LastName = @lastName",
39 SQLiteText = "SELECT * FROM Person WHERE LastName = @lastName LIMIT {0}")]
40 public abstract ArrayList SelectByLastName(string lastName, [Format(0)] int top);
41 }
42
43 [Test]
44 public void Test1()
45 {
46 var da = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
47 var list = da.SelectByLastName("Pupkin");
48
49 Assert.AreNotEqual(0, list.Count);
50 }
51
52 [Test]
53 public void Test2()
54 {
55 var da = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
56 var list = da.SelectBy("FirstName", "John");
57
58 Assert.AreNotEqual(0, list.Count);
59 }
60
61 [Test]
62 public void Test3()
63 {
64 var da = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
65 var list = da.SelectByLastName("Pupkin", 1);
66
67 Assert.AreNotEqual(0, list.Count);
68 }
69 }
70 }