public void ApplyParametersComplexTest() { try { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); sqlStatement = nhibernateFormatter.TryParsSql(SecureResources.SQL14); Assert.IsTrue(sqlStatement.Parameters.Count == 1); string appliedParameterSql = sqlStatement.ApplyParameters(); Assert.IsFalse(appliedParameterSql.Contains("@")); string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 3454); sqlStatement = nhibernateFormatter.TryParsSql(Properties.SecureResources.SQL7); appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsFalse(appliedParameterSql.Contains("@")); sqlStatement = nhibernateFormatter.TryParsSql(Properties.SecureResources.SQL8); appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsFalse(appliedParameterSql.Contains("@")); } catch (Exception exception) { Assert.IsNotInstanceOfType(exception, typeof(Exception)); } finally { SecureResources.ResourceManager.ReleaseAllResources(); } }
public void ParseTest() { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); sqlStatement = nhibernateFormatter.TryParsSql(SecureResources.SQLInsert1); Assert.IsTrue(sqlStatement.Parameters.Count == 4); string appliedParameterSql = sqlStatement.ApplyParameters(); Assert.IsFalse(appliedParameterSql.Contains("@")); string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 161); }
public void ApplyParametersSqlColesceSelectTest() { try { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); nhibernateFormatter.SqlIdentifiers = new string[] { "NHibernate.SQL:" }; sqlStatement = nhibernateFormatter.TryParsSql(SecureResources.ColesceSelectSql); Assert.IsTrue(sqlStatement.Parameters.Count == 3); string appliedParameterSql = sqlStatement.ApplyParameters(); Assert.IsFalse(appliedParameterSql.Contains("@")); string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 371); } catch (Exception exception) { Assert.IsNotInstanceOfType(exception, typeof(Exception)); } finally { SecureResources.ResourceManager.ReleaseAllResources(); } }
public void ApplySuggestedFormatTest() { try { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); nhibernateFormatter.SqlIdentifiers = new string[] { "NHibernate.SQL:" }; IList<ISqlStatement> sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL1); var sqlStatement = sqlStatements[0]; var sqlSelectStatement = sqlStatement as SqlSelectStatement; string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 3454); Assert.IsTrue(sqlStatement.ColumnNames.Count == 48); Assert.IsTrue(sqlStatement.Parameters.Count == 1); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 3061); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 6); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 30); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 29); sqlStatement = sqlStatements[1]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 454); Assert.IsTrue(sqlStatement.ColumnNames.Count == 11); Assert.IsTrue(sqlStatement.Parameters.Count == 1); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 361); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 23); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 21); sqlStatement = sqlStatements[2]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 2136); Assert.IsTrue(sqlStatement.ColumnNames.Count == 29); Assert.IsTrue(sqlStatement.Parameters.Count == 4); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 1121); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 595); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 121); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL3); sqlStatement = sqlStatements[3]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 366); Assert.IsTrue(sqlStatement.ColumnNames.Count == 4); Assert.IsTrue(sqlStatement.Parameters.Count == 2); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 93); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 32); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 48); sqlStatement = sqlStatements[5]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 378); Assert.IsTrue(sqlStatement.ColumnNames.Count == 4); Assert.IsTrue(sqlStatement.Parameters.Count == 2); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 93); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 32); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 48); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL5); sqlStatement = sqlStatements[7]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 1634); Assert.IsTrue(sqlStatement.ColumnNames.Count == 8); Assert.IsTrue(sqlStatement.Parameters.Count == 0); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 1016); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 5); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 325); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 65); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL6); sqlStatement = sqlStatements[8]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 1811); Assert.IsTrue(sqlStatement.ColumnNames.Count == 27); Assert.IsTrue(sqlStatement.Parameters.Count == 6); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 931); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 270); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 187); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL7); sqlStatement = sqlStatements[9]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 885); Assert.IsTrue(sqlStatement.ColumnNames.Count == 2); Assert.IsTrue(sqlStatement.Parameters.Count == 56); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 45); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 33); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 426); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL8); sqlStatement = sqlStatements[10]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 282); Assert.IsTrue(sqlStatement.ColumnNames.Count == 1); Assert.IsTrue(sqlStatement.Parameters.Count == 1); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 26); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 33); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 46); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL9); sqlStatement = sqlStatements[11]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 735); Assert.IsTrue(sqlStatement.ColumnNames.Count == 17); Assert.IsTrue(sqlStatement.Parameters.Count == 1); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 588); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 27); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 37); sqlStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL10); sqlStatement = sqlStatements[12]; sqlSelectStatement = sqlStatement as SqlSelectStatement; appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 156); Assert.IsTrue(sqlStatement.ColumnNames.Count == 1); Assert.IsTrue(sqlStatement.Parameters.Count == 1); Assert.IsTrue(sqlSelectStatement.SelectPart.Value.Length == 27); Assert.IsTrue(sqlSelectStatement.SelectPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.FromPart.Value.Length == 27); Assert.IsTrue(sqlSelectStatement.FromPart.SqlStatements.Count == 0); Assert.IsTrue(sqlSelectStatement.WherePart.Value.Length == 43); IList<ISqlStatement> sqlSelectStatements = nhibernateFormatter.GetSqlFromDebugOutput(Properties.SecureResources.SQL3); foreach (var statement in sqlSelectStatements) { string sql = statement.ApplySuggestedFormat(); #if DEBUG Debug.WriteLine(sql); #endif } } catch { throw; } finally { SecureResources.ResourceManager.ReleaseAllResources(); } }
public void ApplySuggestedFormatNoColumnTableNameAliasTest() { try { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); nhibernateFormatter.SqlIdentifiers = new string[] { Environment.NewLine }; sqlStatement = nhibernateFormatter.TryParsSql(SecureResources.NoColumnOrTableNameAliases); Assert.IsTrue(sqlStatement.Parameters.Count == 1); string appliedParameterSql = sqlStatement.ApplyParameters(); Assert.IsFalse(appliedParameterSql.Contains("@")); string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 195); } catch { throw; } finally { SecureResources.ResourceManager.ReleaseAllResources(); } }
public void ApplySuggestedFormatAliasQuotedValuesTest() { try { NHibernateSqlOutputFormatter nhibernateFormatter = new NHibernateSqlOutputFormatter(); nhibernateFormatter.SqlIdentifiers = new string[] { Environment.NewLine }; sqlStatement = nhibernateFormatter.TryParsSql(SecureResources.ColumnNameAliasQuotedValues); Assert.IsTrue(sqlStatement.Parameters.Count == 2); string appliedParameterSql = sqlStatement.ApplyParameters(); Assert.IsFalse(appliedParameterSql.Contains("@")); string appliedFormatSql = sqlStatement.ApplySuggestedFormat(); Assert.IsTrue(appliedFormatSql.Length == 1375); } catch (Exception exception) { Assert.IsNotInstanceOfType(exception, typeof(Exception)); } finally { SecureResources.ResourceManager.ReleaseAllResources(); } }