OrmLiteComplexTypesTests.cs

using System;
using System.Linq;
using NUnit.Framework;
using ServiceStack.Common.Tests.Models;
using ServiceStack.Text;

namespace ServiceStack.OrmLite.Tests
{
    using System.Collections;
    using System.Collections.Generic;

    [TestFixture]
	public class OrmLiteComplexTypesTests
		: OrmLiteTestBase
	{
		[Test]
		public void Can_insert_into_ModelWithComplexTypes_table()
		{
			using (var db = OpenDbConnection())
			{
				db.CreateTable<ModelWithComplexTypes>(true);

				var row = ModelWithComplexTypes.Create(1);

				db.Insert(row);
			}
		}

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

				var row = ModelWithComplexTypes.Create(1);

				db.Insert(row);

				var rows = db.Select<ModelWithComplexTypes>();

				Assert.That(rows, Has.Count.EqualTo(1));

				ModelWithComplexTypes.AssertIsEqual(rows[0], row);
			}
		}

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

				var orderIds = new[] { 1, 2, 3, 4, 5 }.ToList();

				orderIds.ForEach(x => db.Insert(
					SampleOrderLine.Create(Guid.NewGuid(), x, 1)));

				var rows = db.Select<SampleOrderLine>();
				Assert.That(rows, Has.Count.EqualTo(orderIds.Count));
			}
		}

	    [Test]
	    public void Lists_Of_Guids_Are_Formatted_Correctly()
	    {
            SuppressIfOracle("Can't read a list of Guids with Oracle provider because core OrmLite doesn't give provider a chance to override conversion");

            using (var db = OpenDbConnection())
            {
                db.DropAndCreateTable<WithAListOfGuids>();

                JsConfig<Guid>.RawSerializeFn = x => x.ToString();

                var item = new WithAListOfGuids {
                    GuidOne = new Guid("32cb0acb-db43-4061-a6aa-7f4902a7002a"),
                    GuidTwo = new Guid("13083231-b005-4ff4-ab62-41bdc7f50a4d"),
                    TheGuids = new[] { new Guid("18176030-7a1c-4288-82df-a52f71832381"), new Guid("017f986b-f7be-4b6f-b978-ff05fba3b0aa") },
                };

                db.Insert(item);

                var savedGuidOne = db.Select<string>("SELECT GuidOne FROM WithAListOfGuids").First();
                Assert.That(savedGuidOne, Is.EqualTo("32cb0acb-db43-4061-a6aa-7f4902a7002a"));

                var savedGuidTwo = db.Select<string>("SELECT GuidTwo FROM WithAListOfGuids").First();
                Assert.That(savedGuidTwo, Is.EqualTo("13083231-b005-4ff4-ab62-41bdc7f50a4d"));

                var savedGuidList = db.Select<string>("SELECT TheGuids FROM WithAListOfGuids").First();
                Assert.That(savedGuidList, Is.EqualTo("[18176030-7a1c-4288-82df-a52f71832381,017f986b-f7be-4b6f-b978-ff05fba3b0aa]"));

                JsConfig.Reset();
            }
	    }

	}

    public class WithAListOfGuids
    {
        public Guid GuidOne { get; set; }

        public Guid GuidTwo { get; set; }

        public IEnumerable<Guid> TheGuids { get; set; }
    }
}