public void Can_create_TableWithNamingStrategy_table_aliases() { var aliasNamingStrategy = new AliasNamingStrategy { TableAliases = { { "ModelWithOnlyStringFields", "TableAlias" } }, ColumnAliases = { { "Name", "ColumnAlias" } }, }; using (new TemporaryNamingStrategy(DialectProvider, aliasNamingStrategy)) using (var db = OpenDbConnection()) { db.CreateTable <ModelWithOnlyStringFields>(true); var sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Does.Contain("CREATE TABLE TableAlias".NormalizeSql())); Assert.That(sql, Does.Contain("ColumnAlias".NormalizeSql())); var result = db.SqlList <ModelWithIdAndName>( $"SELECT * FROM {"ModelWithOnlyStringFields".SqlTable(DialectProvider)} WHERE {"Name".SqlColumn(DialectProvider)} = 'foo'"); Assert.That(db.GetLastSql().NormalizeSql(), Is.EqualTo("SELECT * FROM TableAlias WHERE ColumnAlias = 'foo'".NormalizeSql())); db.DropTable <ModelWithOnlyStringFields>(); aliasNamingStrategy.UseNamingStrategy = new LowerCaseUnderscoreNamingStrategy(); db.CreateTable <ModelWithOnlyStringFields>(true); sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Does.Contain("CREATE TABLE table_alias".NormalizeSql())); Assert.That(sql, Does.Contain("column_alias".NormalizeSql())); } }
public void Can_create_TableWithNamingStrategy_table_aliases() { var aliasNamingStrategy = new AliasNamingStrategy { TableAliases = { { "ModelWithOnlyStringFields", "TableAlias" } }, ColumnAliases = { { "Name", "ColumnAlias" } }, }; OrmLiteConfig.DialectProvider.NamingStrategy = aliasNamingStrategy; using (var db = OpenDbConnection()) { db.CreateTable<ModelWithOnlyStringFields>(true); var sql = db.GetLastSql(); Assert.That(sql, Is.StringContaining("CREATE TABLE \"TableAlias\"") .Or.StringContaining("CREATE TABLE TableAlias")); Assert.That(sql, Is.StringContaining("ColumnAlias")); var result = db.SqlList<ModelWithIdAndName>( "SELECT * FROM {0} WHERE {1} = {2}" .Fmt("ModelWithOnlyStringFields".SqlTable(), "Name".SqlColumn(), "foo".SqlValue())); Assert.That(db.GetLastSql(), Is.EqualTo("SELECT * FROM \"TableAlias\" WHERE \"ColumnAlias\" = 'foo'") .Or.EqualTo("SELECT * FROM TableAlias WHERE ColumnAlias = 'foo'")); db.DropTable<ModelWithOnlyStringFields>(); aliasNamingStrategy.UseNamingStrategy = new LowerCaseUnderscoreNamingStrategy(); db.CreateTable<ModelWithOnlyStringFields>(true); sql = db.GetLastSql(); Assert.That(sql, Is.StringContaining("CREATE TABLE \"table_alias\"") .Or.StringContaining("CREATE TABLE table_alias")); Assert.That(sql, Is.StringContaining("column_alias")); } OrmLiteConfig.DialectProvider.NamingStrategy = new OrmLiteNamingStrategyBase(); }
public void Can_create_TableWithNamingStrategy_table_aliases() { var aliasNamingStrategy = new AliasNamingStrategy { TableAliases = { { "ModelWithOnlyStringFields", "TableAlias" } }, ColumnAliases = { { "Name", "ColumnAlias" } }, }; OrmLiteConfig.DialectProvider.NamingStrategy = aliasNamingStrategy; using (var db = OpenDbConnection()) { db.CreateTable <ModelWithOnlyStringFields>(true); var sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Is.StringContaining("CREATE TABLE TableAlias".NormalizeSql())); Assert.That(sql, Is.StringContaining("ColumnAlias".NormalizeSql())); var result = db.SqlList <ModelWithIdAndName>( "SELECT * FROM {0} WHERE {1} = {2}" .Fmt("ModelWithOnlyStringFields".SqlTable(), "Name".SqlColumn(), "foo".SqlValue())); Assert.That(db.GetLastSql().NormalizeSql(), Is.EqualTo("SELECT * FROM TableAlias WHERE ColumnAlias = 'foo'".NormalizeSql())); db.DropTable <ModelWithOnlyStringFields>(); aliasNamingStrategy.UseNamingStrategy = new LowerCaseUnderscoreNamingStrategy(); db.CreateTable <ModelWithOnlyStringFields>(true); sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Is.StringContaining("CREATE TABLE table_alias".NormalizeSql())); Assert.That(sql, Is.StringContaining("column_alias".NormalizeSql())); } OrmLiteConfig.DialectProvider.NamingStrategy = new OrmLiteNamingStrategyBase(); }
public void Can_create_TableWithNamingStrategy_table_aliases() { var aliasNamingStrategy = new AliasNamingStrategy { TableAliases = { { "ModelWithOnlyStringFields", "TableAlias" } }, ColumnAliases = { { "Name", "ColumnAlias" } }, }; using (new TemporaryNamingStrategy(aliasNamingStrategy)) using (var db = OpenDbConnection()) { db.CreateTable<ModelWithOnlyStringFields>(true); var sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Does.Contain("CREATE TABLE TableAlias".NormalizeSql())); Assert.That(sql, Does.Contain("ColumnAlias".NormalizeSql())); var result = db.SqlList<ModelWithIdAndName>( "SELECT * FROM {0} WHERE {1} = {2}" .Fmt("ModelWithOnlyStringFields".SqlTable(), "Name".SqlColumn(), "foo".SqlValue())); Assert.That(db.GetLastSql().NormalizeSql(), Is.EqualTo("SELECT * FROM TableAlias WHERE ColumnAlias = 'foo'".NormalizeSql())); db.DropTable<ModelWithOnlyStringFields>(); aliasNamingStrategy.UseNamingStrategy = new LowerCaseUnderscoreNamingStrategy(); db.CreateTable<ModelWithOnlyStringFields>(true); sql = db.GetLastSql().NormalizeSql(); Assert.That(sql, Does.Contain("CREATE TABLE table_alias".NormalizeSql())); Assert.That(sql, Does.Contain("column_alias".NormalizeSql())); } }