当前位置: 首页>>代码示例>>C#>>正文


C# TestDb.GetMapping方法代码示例

本文整理汇总了C#中SQLite.Net.Tests.TestDb.GetMapping方法的典型用法代码示例。如果您正苦于以下问题:C# TestDb.GetMapping方法的具体用法?C# TestDb.GetMapping怎么用?C# TestDb.GetMapping使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SQLite.Net.Tests.TestDb的用法示例。


在下文中一共展示了TestDb.GetMapping方法的12个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: TestColumnValues

        public void TestColumnValues()
        {
            using (TestDb db = new TestDb())
            {
                db.CreateTable<WithDefaultValue>();
               

                string failed = string.Empty;
                foreach (var col in db.GetMapping<WithDefaultValue>().Columns)
                {
                    if (col.PropertyName == "TestInt" && !col.DefaultValue.Equals(WithDefaultValue.IntVal))
                        failed += " , TestInt does not equal " + WithDefaultValue.IntVal;

                    if (col.PropertyName == "TestDecimal" && !col.DefaultValue.Equals(WithDefaultValue.DecimalVal))
                        failed += "TestDecimal does not equal " + WithDefaultValue.DecimalVal;

                    if (col.PropertyName == "TestDateTime" && !col.DefaultValue.Equals(WithDefaultValue.DateTimegVal))
                        failed += "TestDateTime does not equal " + WithDefaultValue.DateTimegVal;

                    if (col.PropertyName == "TestString" && !col.DefaultValue.Equals(WithDefaultValue.StringVal))
                        failed += "TestString does not equal " + WithDefaultValue.StringVal;
                }
                
                Assert.True(string.IsNullOrWhiteSpace(failed), failed);

            }
        }
开发者ID:quentez,项目名称:SQLite.Net-PCL,代码行数:27,代码来源:DefaulAttributeTest.cs

示例2: InheritanceWorks

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

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

            Assert.AreEqual(3, mapping.Columns.Length);
            Assert.AreEqual("Id", mapping.PK.Name);
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:9,代码来源:InheritanceTest.cs

示例3: ImplicitIndex

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

            db.CreateTable<NoAttributes>(CreateFlags.ImplicitIndex);

            TableMapping mapping = db.GetMapping<NoAttributes>();
            TableMapping.Column column = mapping.Columns[2];
            Assert.AreEqual("IndexedId", column.Name);
            Assert.IsTrue(column.Indices.Any());
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:11,代码来源:CreateTableImplicitTest.cs

示例4: ImplicitAutoIncAsPassedInTypes

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

            db.CreateTable(typeof (PkAttribute), CreateFlags.AutoIncPK);

            TableMapping mapping = db.GetMapping<PkAttribute>();

            Assert.IsNotNull(mapping.PK);
            Assert.AreEqual("Id", mapping.PK.Name);
            Assert.IsTrue(mapping.PK.IsPK);
            Assert.IsTrue(mapping.PK.IsAutoInc);
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:13,代码来源:CreateTableImplicitTest.cs

示例5: VerifyCreations

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

            var l = new OrderLine
            {
                Status = OrderLineStatus.Shipped
            };
            db.Insert(l);
            OrderLine lo = db.Table<OrderLine>().First(x => x.Status == OrderLineStatus.Shipped);
            Assert.AreEqual(lo.Id, l.Id);
        }
开发者ID:flowpilots,项目名称:SQLite.Net-PCL,代码行数:13,代码来源:CreateTableTest.cs

示例6: HasGoodNames

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

            db.CreateTable<AFunnyTableName>();

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

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

            Assert.AreEqual("Id", mapping.Columns[0].Name);
            Assert.AreEqual("AGoodColumnName", mapping.Columns[1].Name);
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:13,代码来源:MappingTest.cs

示例7: ImplicitAutoInc

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

            db.CreateTable<PkAttribute>(CreateFlags.AutoIncPK);

            TableMapping mapping = db.GetMapping<PkAttribute>();

            Assert.IsFalse(mapping.HasCompositePK);
            Assert.IsNotNull(mapping.PK);
            Assert.AreEqual("Id", mapping.PK.Name);
            Assert.IsTrue(mapping.PK.IsPK);
            Assert.IsTrue(mapping.PK.IsAutoInc);
        }
开发者ID:Rhapsody,项目名称:SQLite.Net-PCL,代码行数:14,代码来源:CreateTableImplicitTest.cs

示例8: ImplicitPK

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

            db.CreateTable<NoAttributes>(CreateFlags.ImplicitPK);

            TableMapping mapping = db.GetMapping<NoAttributes>();

            Assert.IsNotNull(mapping.PK);
            Assert.AreEqual("Id", mapping.PK.Name);
            Assert.IsTrue(mapping.PK.IsPK);
            Assert.IsFalse(mapping.PK.IsAutoInc);

            CheckPK(db);
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:15,代码来源:CreateTableImplicitTest.cs

示例9: WithoutImplicitMapping

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

            db.CreateTable<NoAttributes>();

            TableMapping mapping = db.GetMapping<NoAttributes>();

            Assert.IsNull(mapping.PK);

            TableMapping.Column column = mapping.Columns[2];
            Assert.AreEqual("IndexedId", column.Name);
            Assert.IsFalse(column.Indices.Any());

            Assert.Throws(typeof (AssertionException), () => CheckPK(db));
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:16,代码来源:CreateTableImplicitTest.cs

示例10: ImplicitPKAutoInc

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

            db.CreateTable(typeof (NoAttributes), CreateFlags.ImplicitPK | CreateFlags.AutoIncPK);

            TableMapping mapping = db.GetMapping<NoAttributes>();

            Assert.IsNotNull(mapping.PK);
            Assert.AreEqual("Id", mapping.PK.Name);
            Assert.IsTrue(mapping.PK.IsPK);
            Assert.IsTrue(mapping.PK.IsAutoInc);
        }
开发者ID:Reza1024,项目名称:SQLite.Net-PCL,代码行数:13,代码来源:CreateTableImplicitTest.cs

示例11: ExecuteNonQueryWithNullThrowsException

        public void ExecuteNonQueryWithNullThrowsException()
        {
            using (TestDb db = new TestDb())
            {
                TableMapping map;

                db.CreateTable<NotNullNoPK>();

                try
                {
                    NotNullNoPK obj = new NotNullNoPK()
                    {
                        AnotherRequiredStringProp = "Another required prop",
                        RequiredIntProp = 123,
                        RequiredStringProp = "Required string prop"
                    };
                    db.Insert(obj);

                    map = db.GetMapping<NotNullNoPK>();
                    map.GetInsertCommand(db, "OR REPLACE").ExecuteNonQuery(new object[] { 1, null, 123, null, null, null });
                }
                catch (NotNullConstraintViolationException)
                {
                    return;
                }
                catch (SQLiteException ex)
                {
                    if (db.Platform.SQLiteApi.LibVersionNumber() < 3007017 && ex.Result == Result.Constraint)
                    {
                        Assert.Inconclusive("Detailed constraint information is only available in SQLite3 version 3.7.17 and above.");
                    }
                }
                catch (Exception ex)
                {
                    Assert.Fail("Expected an exception of type NotNullConstraintViolationException to be thrown. An exception of type {0} was thrown instead.", ex.GetType().Name);
                }
            }
            Assert.Fail("Expected an exception of type NotNullConstraintViolationException to be thrown. No exception was thrown.");
        }
开发者ID:quentez,项目名称:SQLite.Net-PCL,代码行数:39,代码来源:NotNullAttributeTest.cs

示例12: ImplicitPkAsPassedInTypes

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

            db.CreateTable(typeof (NoAttributes), CreateFlags.ImplicitPK);

            TableMapping mapping = db.GetMapping<NoAttributes>();

            Assert.IsFalse(mapping.HasCompositePK);
            Assert.IsNotNull(mapping.PK);
            Assert.AreEqual("Id", mapping.PK.Name);
            Assert.IsTrue(mapping.PK.IsPK);
            Assert.IsFalse(mapping.PK.IsAutoInc);
        }
开发者ID:Rhapsody,项目名称:SQLite.Net-PCL,代码行数:14,代码来源:CreateTableImplicitTest.cs


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