Setup for running Ormlite tests

Mac · March 10, 2019, 1:28pm

@mythz As part of looking at oracle provider changes to use the managed provider and update for newer dialects/capabiltiies I am creating docker instances of the db servers so I can run all or most of the tests.

Just getting started with running firebird, mysql and postgres so far but wondering if this approach is of any interest for the main repo?

Planning to add docker sql server 2017 linux and oracle XE versions 10, 12 and 18 so I can properly test oracle versioned dialects (could also do multiple versions for other dbs).

I think I’ll need something for handling connectionstrings and re-running or filtering tests based on diff db versions, conditional nunit attribrites maybe … and also detecting if containers are up etc but haven’t thought about that much yet.

Can view the branch changes here - https://github.com/ServiceStack/ServiceStack.OrmLite/compare/master...wwwlicious:docker-db

mythz · March 10, 2019, 3:57pm

Sure we can add these to the main repo, the main behavior to keep is that we can still run tests locally and we can switch which DB to run them on by changing:

github.com

ServiceStack/ServiceStack.OrmLite/blob/68da1178548b66e8e5588449ecb02e3c28b4fa91/tests/ServiceStack.OrmLite.Tests/OrmLiteTestBase.cs#L16


using NUnit.Framework;
using ServiceStack.Logging;
#if !NETCORE
using ServiceStack.OrmLite.Oracle;
#endif


namespace ServiceStack.OrmLite.Tests
{
    public class Config
    {
        public static Dialect DefaultDialect = Dialect.Sqlite;
        public const bool EnableDebugLogging = false;


        public static string SqliteMemoryDb = ":memory:";
        public static string SqliteFileDir = "~/App_Data/".MapAbsolutePath();
        public static string SqliteFileDb = "~/App_Data/db.sqlite".MapAbsolutePath();
        public static string SqlServerDb = "~/App_Data/Database1.mdf".MapAbsolutePath();
        public static string SqlServerBuildDb = "Server=localhost;Database=test;User Id=test;Password=test;MultipleActiveResultSets=True;";
        //public static string SqlServerBuildDb = "Data Source=localhost;Initial Catalog=TestDb;Integrated Security=SSPI;Connect Timeout=120;MultipleActiveResultSets=True";


        public static string OracleDb = "Data Source=localhost:1521/ormlite;User ID=test;Password=test";

Mac · March 10, 2019, 4:29pm

ok, will bear that in mind.

Once I’ve got sql server and oracle setup, I’ll look at creating a PR for you