C# Tests.TestDb类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中SQLite.Tests.TestDb类的典型用法代码示例。如果您正苦于以下问题：C# TestDb类的具体用法？C# TestDb怎么用？C# TestDb使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

TestDb类属于SQLite.Tests命名空间，在下文中一共展示了TestDb类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Setup

        public void Setup()
        {
            testObjects = Enumerable.Range(1, 20).Select(i => new TestObj()).ToList();

            db = new TestDb(TestPath.GetTempFileName());
            db.InsertAll(testObjects);
        }

开发者ID:Banane9，项目名称:sqlite-net，代码行数:7，代码来源:TransactionTest.cs

示例2: ContainsQueriedData

        public void ContainsQueriedData()
        {
            int n = 20;
            var cq =from i in Enumerable.Range(1, n)
                    select new TestObj() {
                Name = i.ToString()
            };

            var db = new TestDb(Path.GetTempFileName());

            db.InsertAll(cq);

            db.Trace = true;

            var tensq = new string[] { "0", "10", "20" };
            var tens = (from o in db.Table<TestObj>() where tensq.Contains(o.Name) select o).ToList();
            Assert.AreEqual(2, tens.Count);

            var moreq = new string[] { "0", "x", "99", "10", "20", "234324" };
            var more = (from o in db.Table<TestObj>() where moreq.Contains(o.Name) select o).ToList();
            Assert.AreEqual(2, more.Count);

            // https://github.com/praeclarum/sqlite-net/issues/28
            var moreq2 = moreq.ToList ();
            var more2 = (from o in db.Table<TestObj>() where moreq2.Contains(o.Name) select o).ToList();
            Assert.AreEqual(2, more2.Count);
        }

开发者ID:Toshik，项目名称:sqlite-net，代码行数:27，代码来源:ContainsTest.cs

示例3: SetUp

        public void SetUp()
        {
            _db = new TestDb();
            _db.CreateTable<Product>();
            _db.CreateTable<Order>();
            _db.CreateTable<OrderLine>();

            var p1 = new Product { Name = "One", };
            var p2 = new Product { Name = "Two", };
            var p3 = new Product { Name = "Three", };
            _db.InsertAll(new[] { p1, p2, p3 });

            var o1 = new Order { PlacedTime = DateTime.Now, };
            var o2 = new Order { PlacedTime = DateTime.Now, };
            _db.InsertAll(new[] { o1, o2 });

            _db.InsertAll(new[] {
                new OrderLine {
                    OrderId = o1.Id,
                    ProductId = p1.Id,
                    Quantity = 1,
                },
                new OrderLine {
                    OrderId = o1.Id,
                    ProductId = p2.Id,
                    Quantity = 2,
                },
                new OrderLine {
                    OrderId = o2.Id,
                    ProductId = p3.Id,
                    Quantity = 3,
                },
            });
        }

开发者ID:Banane9，项目名称:sqlite-net，代码行数:34，代码来源:JoinTest.cs

示例4: Skip

        public void Skip()
        {
            var n = 100;

            var cq =	from i in Enumerable.Range(1, n)
                    select new TestObj() {
                Order = i
            };
            var objs = cq.ToArray();
            var db = new TestDb(TestPath.GetTempFileName());

            var numIn = db.InsertAll(objs);
            Assert.AreEqual(numIn, n, "Num inserted must = num objects");

            var q = from o in db.Table<TestObj>()
                    orderby o.Order
                    select o;

            var qs1 = q.Skip(1);
            var s1 = qs1.ToList();
            Assert.AreEqual(n - 1, s1.Count);
            Assert.AreEqual(2, s1[0].Order);

            var qs5 = q.Skip(5);
            var s5 = qs5.ToList();
            Assert.AreEqual(n - 5, s5.Count);
            Assert.AreEqual(6, s5[0].Order);
        }

开发者ID:aussieman9，项目名称:sqlite-net，代码行数:28，代码来源:SkipTest.cs

示例5: Collate

        public void Collate()
        {
            var obj = new TestObj()
            {
                CollateDefault = "Alpha ",
                CollateBinary = "Alpha ",
                CollateRTrim = "Alpha ",
                CollateNoCase = "Alpha ",
            };

            var db = new TestDb(TestPath.GetTempFileName());

            db.Insert(obj);

            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateDefault == "Alpha " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateDefault == "ALPHA " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateDefault == "Alpha" select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateDefault == "ALPHA" select o).Count());

            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateBinary == "Alpha " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateBinary == "ALPHA " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateBinary == "Alpha" select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateBinary == "ALPHA" select o).Count());

            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateRTrim == "Alpha " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateRTrim == "ALPHA " select o).Count());
            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateRTrim == "Alpha" select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateRTrim == "ALPHA" select o).Count());

            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateNoCase == "Alpha " select o).Count());
            Assert.AreEqual(1, (from o in db.Table<TestObj>() where o.CollateNoCase == "ALPHA " select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateNoCase == "Alpha" select o).Count());
            Assert.AreEqual(0, (from o in db.Table<TestObj>() where o.CollateNoCase == "ALPHA" select o).Count());
        }

开发者ID:Banane9，项目名称:sqlite-net，代码行数:34，代码来源:CollateTest.cs

示例6: InsertALot

        public void InsertALot()
        {
            int n = 100000;
            var q =	from i in Enumerable.Range(1, n)
                    select new TestObj() {
                Text = "I am"
            };
            var objs = q.ToArray();
            var db = new TestDb(Path.GetTempFileName());
            db.Trace = false;

            var sw = new Stopwatch();
            sw.Start();

            var numIn = db.InsertAll(objs);

            sw.Stop();

            Assert.AreEqual(numIn, n, "Num inserted must = num objects");

            var inObjs = db.CreateCommand("select * from TestObj").ExecuteQuery<TestObj>().ToArray();

            for (var i = 0; i < inObjs.Length; i++) {
                Assert.AreEqual(i+1, objs[i].Id);
                Assert.AreEqual(i+1, inObjs[i].Id);
                Assert.AreEqual("I am", inObjs[i].Text);
            }

            var numCount = db.CreateCommand("select count(*) from TestObj").ExecuteScalar<int>();

            Assert.AreEqual(numCount, n, "Num counted must = num objects");
        }

开发者ID:Ngugi1，项目名称:sqlite-net，代码行数:32，代码来源:InsertTest.cs

示例7: MappingIgnoreColumn

        public void MappingIgnoreColumn()
        {
            var db = new TestDb();
            var m = db.GetMapping<TestObj>();

            Assert.AreEqual(2, m.Columns.Length);
        }

开发者ID:Banane9，项目名称:sqlite-net，代码行数:7，代码来源:IgnoreTest.cs

示例8: InheritanceWorks

        public void InheritanceWorks()
        {
            var db = new TestDb ();

            var mapping = db.GetMapping<Derived> ();

            Assert.AreEqual (3, mapping.Columns.Length);
            Assert.AreEqual ("Id", mapping.PK.Name);
        }

开发者ID:rgmills，项目名称:sqlite-net，代码行数:9，代码来源:InheritanceTest.cs

示例9: CreateDb

 TestDb CreateDb()
 {
     var db = new TestDb ();
     db.CreateTable<Product> ();
     db.CreateTable<Order> ();
     db.CreateTable<OrderLine> ();
     db.CreateTable<OrderHistory> ();
     return db;
 }

开发者ID:roufamatic，项目名称:sqlite-net，代码行数:9，代码来源:LinqTest.cs

示例10: CreateDb

		SQLiteConnection CreateDb ()
		{
			var db = new TestDb ();
			db.CreateTable<TestTable> ();
			var items = from i in Enumerable.Range (0, Count)
				select new TestTable { Datum = 1000+i };
			db.InsertAll (items);
			Assert.AreEqual (Count, db.Table<TestTable> ().Count ());
			return db;
		}

开发者ID:89sos98，项目名称:sqlite-net，代码行数:10，代码来源:DeleteTest.cs

示例11: CreateThem

		public void CreateThem ()
		{
			var db = new TestDb ();
			
			db.CreateTable<Product> ();
			db.CreateTable<Order> ();
			db.CreateTable<OrderLine> ();
			db.CreateTable<OrderHistory> ();
			
			VerifyCreations(db);
		}

开发者ID:golddragon007，项目名称:sqlite-net，代码行数:11，代码来源:CreateTableTest.cs

示例12: UpperAndLowerColumnNames

        public void UpperAndLowerColumnNames()
        {
            using (var db = new TestDb (true) { Trace = true } ) {
                db.CreateTable<LowerId> ();
                db.CreateTable<UpperId> ();

                var cols = db.GetTableInfo ("Test").ToList ();
                Assert.AreEqual (1, cols.Count);
                Assert.AreEqual ("Id", cols[0].Name);
            }
        }

开发者ID:x4maT，项目名称:sqlite-net，代码行数:11，代码来源:MigrationTest.cs

示例13: UpperAndLowerColumnNames

        public void UpperAndLowerColumnNames()
        {
            using (var db = new TestDb (true) { Trace = true } ) {
                db.CreateTable<LowerId> ();
                db.CreateTable<UpperId> ();

                var cols = db.GetTableInfo ("Test").ToList ();
                Assert.That (cols.Count, Is.EqualTo (1));
                Assert.That (cols[0].Name, Is.EqualTo ("Id"));
            }
        }

开发者ID:dbuksbaum，项目名称:sqlite-net，代码行数:11，代码来源:MigrationTest.cs

示例14: CheckPK

 private void CheckPK(TestDb db)
 {
     for (int i = 1; i <= 10; i++)
     {
         var na = new NoAttributes { Id = i, AColumn = i.ToString(), IndexedId = 0 };
         db.Insert(na);
     }
     var item = db.Get<NoAttributes>(2);
     Assert.IsNotNull(item);
     Assert.AreEqual(2, item.Id);
 }

开发者ID:TycTak，项目名称:sqlite-net，代码行数:11，代码来源:CreateTableImplicitTest.cs

示例15: CreateAsPassedInTypes

        public void CreateAsPassedInTypes ()
        {
            var db = new TestDb();

            db.CreateTable(typeof(Product));
            db.CreateTable(typeof(Order));
            db.CreateTable(typeof(OrderLine));
            db.CreateTable(typeof(OrderHistory));

            VerifyCreations(db);
        }

开发者ID:golddragon007，项目名称:sqlite-net，代码行数:11，代码来源:CreateTableTest.cs

示例16: CreateUniqueIndexes

 public void CreateUniqueIndexes()
 {
     using (var db = new TestDb ()) {
         db.CreateTable<TheOne> ();
         var indexes = db.Query<IndexInfo> ("PRAGMA INDEX_LIST (\"TheOne\")");
         Assert.AreEqual (4, indexes.Count, "# of indexes");
         CheckIndex (db, indexes, "UX_Uno", true, "Uno");
         CheckIndex (db, indexes, "UX_Dos", true, "Dos", "Tres");
         CheckIndex (db, indexes, "UX_Uno_bool", true, "Cuatro");
         CheckIndex (db, indexes, "UX_Dos_bool", true, "Cinco", "Seis");
     }
 }

开发者ID:Toshik，项目名称:sqlite-net，代码行数:12，代码来源:UniqueTest.cs

示例17: SetUp

		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);
		}

开发者ID:golddragon007，项目名称:sqlite-net，代码行数:13，代码来源:StringQueryTest.cs

示例18: HasGoodNames

        public void HasGoodNames()
        {
            var db = new TestDb ();

            db.CreateTable<AFunnyTableName> ();

            var mapping = db.GetMapping<AFunnyTableName> ();

            Assert.AreEqual ("AGoodTableName", mapping.TableName);

            Assert.AreEqual ("Id", mapping.Columns [0].Name);
            Assert.AreEqual ("AGoodColumnName", mapping.Columns [1].Name);
        }

开发者ID:ariesy，项目名称:sqlite-net，代码行数:13，代码来源:MappingTest.cs

示例19: VerifyCreations

        private static void VerifyCreations(TestDb db)
        {
            var orderLine = db.GetMapping(typeof(OrderLine));
            Assert.AreEqual(6, orderLine.Columns.Length);

            var l = new OrderLine()
            {
                Status = OrderLineStatus.Shipped
            };
            db.Insert(l);
            var lo = db.Table<OrderLine>().First(x => x.Status == OrderLineStatus.Shipped);
            Assert.AreEqual(lo.Id, l.Id);
        }

开发者ID:golddragon007，项目名称:sqlite-net，代码行数:13，代码来源:CreateTableTest.cs

示例20: CheckIndex

 static void CheckIndex(TestDb db, List<IndexInfo> indexes, string iname, bool unique, params string [] columns)
 {
     if (columns == null)
         throw new Exception ("Don't!");
     var idx = indexes.SingleOrDefault (i => i.name == iname);
     Assert.IsNotNull (idx, String.Format ("Index {0} not found", iname));
     Assert.AreEqual (idx.unique, unique, String.Format ("Index {0} unique expected {1} but got {2}", iname, unique, idx.unique));
     var idx_columns = db.Query<IndexColumns> (String.Format ("PRAGMA INDEX_INFO (\"{0}\")", iname));
     Assert.AreEqual (columns.Length, idx_columns.Count, String.Format ("# of columns: expected {0}, got {1}", columns.Length, idx_columns.Count));
     foreach (var col in columns) {
         Assert.IsNotNull (idx_columns.SingleOrDefault (c => c.name == col), String.Format ("Column {0} not in index {1}", col, idx.name));
     }
 }

开发者ID:Toshik，项目名称:sqlite-net，代码行数:13，代码来源:UniqueTest.cs

注：本文中的SQLite.Tests.TestDb类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# SQLitePCL.SQLiteConnection类代码示例发布时间：2022-05-26

C# Tests.TestDb类代码示例发布时间：2022-05-26

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18176|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9644|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8166|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8542|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8444|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9368|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8415|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7852|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8400|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7391|2022-11-06

客服电话

电子邮件

C# Tests.TestDb类代码示例

示例1: Setup

示例2: ContainsQueriedData

示例3: SetUp

示例4: Skip

示例5: Collate

示例6: InsertALot

示例7: MappingIgnoreColumn

示例8: InheritanceWorks

示例9: CreateDb

示例10: CreateDb

示例11: CreateThem

示例12: UpperAndLowerColumnNames

示例13: UpperAndLowerColumnNames

示例14: CheckPK

示例15: CreateAsPassedInTypes

示例16: CreateUniqueIndexes

示例17: SetUp

示例18: HasGoodNames

示例19: VerifyCreations

示例20: CheckIndex

请发表评论

全部评论

上一篇：

下一篇：

PacktPublishing/Python-Machine-Learning-

[转载]Delphi常见属性

CVE-2022-20082

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053