OrmLiteCreateTableWithIndexesTests.cs

using NUnit.Framework;
using ServiceStack.Text;
using ServiceStack.Common.Tests.Models;
using ServiceStack.Logging;

namespace ServiceStack.OrmLite.Tests
{
    [TestFixture]
    public class OrmLiteCreateTableWithIndexesTests
        : OrmLiteTestBase
    {
        [Test]
        public void Can_create_ModelWithIndexFields_table()
        {
            using (var db = OpenDbConnection())
            {
                db.CreateTable<ModelWithIndexFields>(true);

                var sql = OrmLiteConfig.DialectProvider.ToCreateIndexStatements(typeof(ModelWithIndexFields)).Join();

                var indexName = "idx_modelwithindexfields_name";
                var uniqueName = "uidx_modelwithindexfields_uniquename";

                if (Dialect == Dialect.Oracle || Dialect == Dialect.Firebird)
                {
                    indexName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(indexName);
                    uniqueName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(uniqueName);
                }

                Assert.That(sql, Is.StringContaining(indexName));
                Assert.That(sql, Is.StringContaining(uniqueName));
            }
        }

        [Test]
        public void Can_create_ModelWithCompositeIndexFields_table()
        {
            using (var db = OpenDbConnection())
            {
                db.CreateTable<ModelWithCompositeIndexFields>(true);

                var sql = OrmLiteConfig.DialectProvider.ToCreateIndexStatements(typeof(ModelWithCompositeIndexFields)).Join();

                var indexName = "idx_modelwithcompositeindexfields_name";
                var compositeName = "idx_modelwithcompositeindexfields_composite1_composite2";

                if (Dialect == Dialect.Oracle || Dialect == Dialect.Firebird)
                {
                    indexName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(indexName);
                    compositeName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(compositeName);
                }

                Assert.That(sql, Is.StringContaining(indexName));
                Assert.That(sql, Is.StringContaining(compositeName));
            }
        }

        [Test]
        public void Can_create_ModelWithCompositeIndexFieldsDesc_table()
        {
            using (var db = OpenDbConnection())
            {
                db.CreateTable<ModelWithCompositeIndexFieldsDesc>(true);
                db.GetLastSql().Print();

                var sql = OrmLiteConfig.DialectProvider.ToCreateIndexStatements(typeof(ModelWithCompositeIndexFieldsDesc)).Join();

                var indexName = "idx_modelwithcompositeindexfieldsdesc_name";
                var compositeName = "idx_modelwithcompositeindexfieldsdesc_composite1_composite2";

                if (Dialect == Dialect.Oracle || Dialect == Dialect.Firebird)
                {
                    indexName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(indexName).ToLower();
                    compositeName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(compositeName).ToLower();
                }

                Assert.That(sql, Is.StringContaining(indexName));
                Assert.That(sql, Is.StringContaining(compositeName));
            }
        }

        [Test]
        public void Can_create_ModelWithCompositeIndexOnFieldSpacesDesc_table()
        {
            if (Dialect == Dialect.Firebird) return; //Too long, not supported

            using (var db = OpenDbConnection())
            {
                db.CreateTable<ModelWithCompositeIndexOnFieldSpacesDesc>(true);
                db.GetLastSql().Print();

                var sql = OrmLiteConfig.DialectProvider.ToCreateIndexStatements(typeof(ModelWithCompositeIndexOnFieldSpacesDesc)).Join();

                var compositeName = "idx_modelwithcompositeindexonfieldspacesdesc_field_field";

                if (Dialect == Dialect.Oracle || Dialect == Dialect.Firebird)
                    compositeName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(compositeName).ToLower();

                Assert.That(sql, Is.StringContaining(compositeName));
            }
        }

        [Test]
        public void Can_create_ModelWithNamedCompositeIndex_table()
        {
            using (var db = OpenDbConnection())
            {
                db.CreateTable<ModelWithNamedCompositeIndex>(true);

                var sql = OrmLiteConfig.DialectProvider.ToCreateIndexStatements(typeof(ModelWithNamedCompositeIndex)).Join();

                var indexName = "idx_modelwithnamedcompositeindex_name";
                var compositeName = "uidx_modelwithnamedcompositeindexfields_composite1_composite2";

                if (Dialect == Dialect.Oracle || Dialect == Dialect.Firebird)
                {
                    indexName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(indexName);
                    compositeName = OrmLiteConfig.DialectProvider.NamingStrategy.ApplyNameRestrictions(compositeName);
                }

                Assert.That(sql, Is.StringContaining(indexName));
                Assert.That(sql, Is.StringContaining("custom_index_name"));
                Assert.That(sql, Is.Not.StringContaining(compositeName));
            }
        }

        [Test]
        public void Can_create_CompositeIndex_with_Enum()
        {
            using (var db = OpenDbConnection())
            {
                db.DropAndCreateTable<ModelWithEnum>();
            }
        }
    }
}