def test_invalid_script_options(self):
"""
Verify invalid script options.
"""
invalid_options = {u'ScriptAnsiPadding': u'NonValid'}
invalid_server_version = {
u'ScriptCompatibilityOption': u'SQL Server 1689'}
with self.assertRaises(ValueError):
scripting.ScriptingOptions(invalid_options)
with self.assertRaises(ValueError):
scripting.ScriptingOptions(invalid_server_version)
def test_nondefault_script_options(self):
"""
Verify scripting options updated.
"""
new_options = {
u'ScriptAnsiPadding': True,
u'AppendToFile': True,
u'TypeOfDataToScript': u'SchemaOnly',
u'ScriptDropAndCreate': u'ScriptCreate',
u'ScriptForTheDatabaseEngineType': u'SingleInstance',
u'ScriptStatistics': u'ScriptStatsNone',
u'ScriptCompatibilityOption': u'Script140Compat',
u'TargetDatabaseEngineEdition': u'SqlServerStandardEdition'
}
scripting_options = scripting.ScriptingOptions(new_options)
expected = {
u'ScriptAnsiPadding': True,
u'AppendToFile': True,
u'IncludeIfNotExists': False,
u'ContinueScriptingOnError': False,
u'ConvertUDDTToBaseType': False,
u'GenerateScriptForDependentObjects': False,
u'IncludeDescriptiveHeaders': False,
u'IncludeSystemConstraintNames': False,
u'IncludeUnsupportedStatements': False,
u'SchemaQualify': False,
u'Bindings': False,
u'Collation': False,
u'Default': False,
u'ScriptExtendedProperties': False,
u'ScriptLogins': False,
u'ScriptObjectLevelPermissions': False,
u'ScriptOwner': False,
u'ScriptUseDatabase': False,
u'ScriptChangeTracking': False,
u'ScriptCheckConstraints': False,
u'ScriptDataCompressionOptions': False,
u'ScriptForeignKeys': False,
u'ScriptFullTextIndexes': False,
u'ScriptIndexes': False,
u'ScriptPrimaryKeys': False,
u'ScriptTriggers': False,
u'UniqueKeys': False,
u'TypeOfDataToScript': u'SchemaOnly',
u'ScriptCreateDrop': u'ScriptCreate',
u'TargetDatabaseEngineType': u'SingleInstance',
u'ScriptStatistics': u'ScriptStatsNone',
u'ScriptCompatibilityOption': u'Script140Compat',
u'TargetDatabaseEngineEdition': u'SqlServerStandardEdition'
}
self.assertEqual(scripting_options.get_options(), expected)