public void UpdateReservedWordsInDialect() { var reservedDb = new HashedSet<string>(); var configuration = TestConfigurationHelper.GetDefaultConfiguration(); var dialect = Dialect.Dialect.GetDialect(configuration.Properties); var connectionHelper = new ManagedProviderConnectionHelper(configuration.Properties); connectionHelper.Prepare(); try { var metaData = dialect.GetDataBaseSchema(connectionHelper.Connection); foreach (var rw in metaData.GetReservedWords()) { reservedDb.Add(rw.ToLowerInvariant()); } } finally { connectionHelper.Release(); } var sf = (ISessionFactoryImplementor) configuration.BuildSessionFactory(); SchemaMetadataUpdater.Update(sf); var match = reservedDb.Intersect(sf.Dialect.Keywords); Assert.That(match, Is.EquivalentTo(reservedDb)); }
private static ISet <string> GetReservedWords(IDictionary <string, string> cfgProperties) { var dialect = Dialect.Dialect.GetDialect(cfgProperties); var connectionHelper = new ManagedProviderConnectionHelper(cfgProperties); return(GetReservedWords(dialect, connectionHelper)); }
public void CanRetrieveReservedWords() { var configuration = TestConfigurationHelper.GetDefaultConfiguration(); var dialect = Dialect.Dialect.GetDialect(configuration.Properties); var connectionHelper = new ManagedProviderConnectionHelper(configuration.Properties); connectionHelper.Prepare(); try { var metaData = dialect.GetDataBaseSchema(connectionHelper.Connection); var reserved = metaData.GetReservedWords(); Assert.That(reserved, Is.Not.Empty); Assert.That(reserved, Has.Member("SELECT")); Assert.That(reserved, Has.Member("FROM")); } finally { connectionHelper.Release(); } }
public void AutoQuoteTableAndColumnsAtStratupIncludeKeyWordsImport() { var reservedDb = new HashedSet<string>(); var configuration = TestConfigurationHelper.GetDefaultConfiguration(); var dialect = Dialect.Dialect.GetDialect(configuration.Properties); var connectionHelper = new ManagedProviderConnectionHelper(configuration.Properties); connectionHelper.Prepare(); try { var metaData = dialect.GetDataBaseSchema(connectionHelper.Connection); foreach (var rw in metaData.GetReservedWords()) { reservedDb.Add(rw.ToLowerInvariant()); } } finally { connectionHelper.Release(); } configuration.SetProperty(Environment.Hbm2ddlKeyWords, "auto-quote"); configuration.AddResource("NHibernate.Test.Tools.hbm2ddl.SchemaMetadataUpdaterTest.HeavyEntity.hbm.xml", GetType().Assembly); var sf = (ISessionFactoryImplementor)configuration.BuildSessionFactory(); var match = reservedDb.Intersect(sf.Dialect.Keywords); Assert.That(match, Is.EquivalentTo(reservedDb)); }
private static Iesi.Collections.Generic.ISet<string> GetReservedWords(IDictionary<string, string> cfgProperties) { var dialect = Dialect.Dialect.GetDialect(cfgProperties); var connectionHelper = new ManagedProviderConnectionHelper(cfgProperties); return GetReservedWords(dialect, connectionHelper); }