Running Individual OrmLite Tests (PostgreSQL)

cthames · January 25, 2020, 3:37am

I figured out a hack to get it to work, but maybe there is a different way that I didn’t see.

My question is… what is the proper way to run the PostgreSql OrmLite individual tests ONLY, instead of using the below hacks? (using Resharper GUI, not command line)

I only need to test something quickly for a possible issue…

My quick and stupid hack to get it to work (b/c I didn’t have time to figure out what all setup was needed) is:

Start with a fresh git pull
Then load solution in Visual Studio.
Then execute a single test case or test fixture.

If you get the following error when running an already existing test like CustomSqlIssue.cs:

Dialect not included in TestConfig.Dialect value Sqlite

Change in ServiceStack.OrmLite.Tests.Setup/TestConfig.cs#L18:

// OLD
public static Dialect Dialects = EnvironmentVariable("ORMLITE_DIALECT", Dialect.Sqlite);
// NEW
public static Dialect Dialects = EnvironmentVariable("ORMLITE_DIALECT", Dialect.AnyPostgreSql);

If you cannot connect and getting a connection refused or server timed out error (No connection could be made because the target machine actively refused it), please note that the connection string in the App.config gets overwritten.
Most notably the Port is overridden (if you use the same user/password).

github.com

ServiceStack/ServiceStack.OrmLite/blob/master/tests/ServiceStack.OrmLite.Tests.Setup/TestConfig.cs#L263


public static Dictionary<Tuple<Dialect,int>, string> DialectConnections => dialectConnections ?? (dialectConnections = new Dictionary<Tuple<Dialect,int>, string> 
{
    [Tuple.Create(Dialect.Sqlite, SqliteDb.Memory)] = EnvironmentVariable(new[]{ "SQLITE_MEMORY_CONNECTION", "SQLITE_CONNECTION" }, ":memory:"),
    [Tuple.Create(Dialect.Sqlite, SqliteDb.File)] = EnvironmentVariable(new[]{ "SQLITE_FILE_CONNECTION", "SQLITE_CONNECTION" }, "~/App_Data/db.sqlite".MapAbsolutePath()),


    [Tuple.Create(Dialect.SqlServer, SqlServerDb.V2008)] = EnvironmentVariable(new[]{ "MSSQL2008_CONNECTION", "MSSQL_CONNECTION" }, "Data Source=tcp:localhost,48501\\SQLExpress;Initial Catalog=master;User Id=sa;Password=Test!tesT;Connect Timeout=120;MultipleActiveResultSets=True;"),
    [Tuple.Create(Dialect.SqlServer2016, SqlServerDb.V2016)] = EnvironmentVariable(new[]{ "MSSQL2016_CONNECTION", "MSSQL_CONNECTION" }, "Data Source=tcp:localhost,48501\\SQLExpress;Initial Catalog=master;User Id=sa;Password=Test!tesT;Connect Timeout=120;MultipleActiveResultSets=True;"),
    [Tuple.Create(Dialect.SqlServer2017, SqlServerDb.V2017)] = EnvironmentVariable(new[]{ "MSSQL2017_CONNECTION", "MSSQL_CONNECTION" }, "Data Source=tcp:localhost,48501\\SQLExpress;Initial Catalog=master;User Id=sa;Password=Test!tesT;Connect Timeout=120;MultipleActiveResultSets=True;"),


    [Tuple.Create(Dialect.PostgreSql, PostgreSqlDb.V9)]  = EnvironmentVariable(new[]{ "PGSQL9_CONNECTION",  "PGSQL_CONNECTION" }, "Server=localhost;Port=48301;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200"),
    [Tuple.Create(Dialect.PostgreSql, PostgreSqlDb.V10)] = EnvironmentVariable(new[]{ "PGSQL10_CONNECTION", "PGSQL_CONNECTION" }, "Server=localhost;Port=48302;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200"),
    [Tuple.Create(Dialect.PostgreSql, PostgreSqlDb.V11)] = EnvironmentVariable(new[]{ "PGSQL11_CONNECTION", "PGSQL_CONNECTION" }, "Server=localhost;Port=48303;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200"),
    
    [Tuple.Create(Dialect.MySql, MySqlDb.V5_5)]  = EnvironmentVariable(new[]{ "MYSQL55_CONNECTION",  "MYSQL_CONNECTION" }, "Server=localhost;Port=48201;Database=test;UID=root;Password=test;SslMode=none;Convert Zero Datetime=True;"),
    [Tuple.Create(Dialect.MySql, MySqlDb.V10_1)] = EnvironmentVariable(new[]{ "MYSQL101_CONNECTION", "MYSQL_CONNECTION" }, "Server=localhost;Port=48202;Database=test;UID=root;Password=test;SslMode=none"),
    [Tuple.Create(Dialect.MySql, MySqlDb.V10_2)] = EnvironmentVariable(new[]{ "MYSQL102_CONNECTION", "MYSQL_CONNECTION" }, "Server=localhost;Port=48203;Database=test;UID=root;Password=test;SslMode=none"),
    [Tuple.Create(Dialect.MySql, MySqlDb.V10_3)] = EnvironmentVariable(new[]{ "MYSQL103_CONNECTION", "MYSQL_CONNECTION" }, "Server=localhost;Port=48204;Database=test;UID=root;Password=test;SslMode=none"),
    [Tuple.Create(Dialect.MySql, MySqlDb.V10_4)] = EnvironmentVariable(new[]{ "MYSQL104_CONNECTION", "MYSQL_CONNECTION" }, "Server=localhost;Port=48205;Database=test;UID=root;Password=test;SslMode=none"),


    [Tuple.Create(Dialect.MySqlConnector, MySqlDb.V10_4)] = EnvironmentVariable(new[]{ "MYSQL104_CONNECTION", "MYSQL_CONNECTION" }, "Server=localhost;Port=48205;Database=test;UID=root;Password=test;SslMode=none"),

To combat this (b/c I"m using ReSharper GUI) and as a quick fix (e.g. stupid, don’t commit this)…
In ServiceStack.OrmLite\OrmLiteConnectionFactory.cs in method CreateDbConnection() add the following line.

// https://github.com/ServiceStack/ServiceStack.OrmLite/blob/master/src/ServiceStack.OrmLite/OrmLiteConnectionFactory.cs#L67
this.ConnectionString = this.ConnectionString.Replace("Port=48301", "Port=5432");
this.ConnectionString = this.ConnectionString.Replace("Port=48302", "Port=5432");
this.ConnectionString = this.ConnectionString.Replace("Port=48303", "Port=5432");
// Note: Port 5432 is the default PostgreSql port.

If you now get a permission denied for user test then

-- using a superuser account
-- assumes db test is already created
GRANT ALL PRIVILEGES ON DATABASE test TO test;

mythz · January 25, 2020, 4:06pm

Basically you need to specify which RDBMS dialect you want to run by setting:

github.com

ServiceStack/ServiceStack.OrmLite/blob/786eccbaf279d8c0758984cf9827c7809c11ad1b/tests/ServiceStack.OrmLite.Tests.Setup/TestConfig.cs#L18


using System.Linq;
using ServiceStack.Text;


namespace ServiceStack.OrmLite.Tests
{
    public partial class TestConfig
    {
        /// <summary>
        /// This value controls which providers are tested for all <see cref="TestFixtureOrmLiteAttribute"/> tests where dialects are not explicitly set
        /// </summary>
        public static Dialect Dialects = EnvironmentVariable("ORMLITE_DIALECT", Dialect.Sqlite);
    }


    [Flags]
    public enum Dialect
    {
        Sqlite = 1,
        
        SqlServer = 1 << 1,
        SqlServer2008 = 1 << 2,
        SqlServer2012 = 1 << 3,

Generally the only external setup I can recall is needing to create a Schema called “Schema” for RDBMS’s that support schemas, otherwise you just need to modify TestConfig above to specify which RDBMS + version you want to use.

If you pull the latest from OrmLite you will be able to run just your single version of PostgreSQL, e.g:

Dialects = EnvironmentVariable("ORMLITE_DIALECT", Dialect.PostgreSql11);

Note you can put your connection string you want to use in PGSQL_VERSION to use that instead without needing to modify any source code.

The main test project is ServiceStack.OrmLite.Tests the other test projects are basically RDBS-specific scratchpads for adhoc tests.