Adding upstream version 7.7.0+dfsg.upstream/7.7.0+dfsg

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

3 files changed, 437 insertions, 0 deletions

diff --git a/ansible_collections/lowlydba/sqlserver/changelogs/changelog.yaml b/ansible_collections/lowlydba/sqlserver/changelogs/changelog.yaml
new file mode 100644
index 000000000..33237c7b7
--- /dev/null
+++ b/ansible_collections/lowlydba/sqlserver/changelogs/changelog.yaml
@@ -0,0 +1,407 @@
+ancestor: null
+releases:
+  0.1.0:
+    changes:
+      release_summary: It's a release! First version to publish to Ansible Galaxy.
+    fragments:
+    - v0.1.0_summary.yml
+    modules:
+    - description: Configures a SQL Agent job.
+      name: agent_job
+      namespace: ''
+    - description: Configures a SQL Agent job category.
+      name: agent_job_category
+      namespace: ''
+    - description: Configures a SQL Agent job schedule.
+      name: agent_job_schedule
+      namespace: ''
+    - description: Configures a SQL Agent job step.
+      name: agent_job_step
+      namespace: ''
+    - description: Creates and configures a database.
+      name: database
+      namespace: ''
+    - description: Configures a login for the target SQL Server instance.
+      name: login
+      namespace: ''
+    - description: Install/update Maintenance Solution
+      name: maintenance_solution
+      namespace: ''
+    - description: Sets the maximum memory for a SQL Server instance.
+      name: memory
+      namespace: ''
+    - description: Executes a generic nonquery.
+      name: nonquery
+      namespace: ''
+    - description: Configures the resource governor on a SQL Server instance.
+      name: resource_governor
+      namespace: ''
+    - description: Configures a resource pool for use by the Resource Governor.
+      name: rg_resource_pool
+      namespace: ''
+    - description: Configures a workload group for use by the Resource Governor.
+      name: rg_workload_group
+      namespace: ''
+    - description: Make instance level system configuration changes via sp_configure.
+      name: sp_configure
+      namespace: ''
+    - description: Install/update sp_whoisactive by Adam Mechanic.
+      name: sp_whoisactive
+      namespace: ''
+    - description: Enable or disable global trace flags on a SQL  Server instance.
+      name: traceflag
+      namespace: ''
+    release_date: '2022-03-30'
+  0.1.1:
+    changes:
+      release_summary: Add database tag for Galaxy
+    fragments:
+    - v0.1.1_summary.yml
+    release_date: '2022-03-31'
+  0.10.0:
+    changes:
+      minor_changes:
+      - Update minimum required DBATools version universally to 1.1.108 to accommodate
+        new tcp module.
+      release_summary: The first_responder_kit and tcp_port modules, along with a
+        bump in the required dbatools version.
+    fragments:
+    - 105-update-dbatools-version.yml
+    - v0-10-0-release-summary.yml
+    modules:
+    - description: Install/update the First Responder Kit scripts.
+      name: first_responder_kit
+      namespace: ''
+    - description: Sets the TCP port for the instance.
+      name: tcp_port
+      namespace: ''
+    release_date: '2022-06-27'
+  0.10.1:
+    changes:
+      bugfixes:
+      - Fix change detection in resource_governor module.
+      release_summary: Bug fix for resource_governor.
+    fragments:
+    - 108-rg-bug-fix.yml
+    - v0-10-1-release-summary.yml
+    release_date: '2022-06-28'
+  0.11.0:
+    changes:
+      release_summary: Adding new dbops module.
+    fragments:
+    - 0-11-0-release-summary.yml
+    modules:
+    - description: Runs migration scripts against a database.
+      name: install_script
+      namespace: ''
+    release_date: '2022-07-03'
+  0.11.1:
+    changes:
+      bugfixes:
+      - Fix `availability_group` module so that NUL backups can be properly taken
+        if needed.
+      - Fix incorrect examples in `availability_group` module documentation.
+      - Fix incorrect examples in `install_script` module documentation.
+      - Fix incorrect examples in `spn` module documentationb.
+      - Fixed bugs where adding replica did not work properly for several reasons.
+      release_summary: Bug fixes for AlwaysOn related modules and fixing errors in
+        some documentation examples.
+    fragments:
+    - 0-11-1-release-summary.yml
+    - 113-fix-ag-module.yml
+    - x-fix-spn-docs.yml
+    release_date: '2022-07-06'
+  0.11.2:
+    changes:
+      release_summary: Bumping required dbatools version to ensure the `restore` module
+        works on MacOS PowerShell Core (https://github.com/dataplat/dbatools/pull/8435).
+    fragments:
+    - 0-11-2-release-summary.yml
+    release_date: '2022-07-09'
+  0.2.0:
+    changes:
+      minor_changes:
+      - Add DbaTools module requirement to documentation and fix missing examples.
+        (https://github.com/lowlydba/lowlydba.sqlserver/pull/47)
+      - Utilize PowerShell Requires for dbatools min version needs instead of custom
+        function. Consolidate/standardize credential setup and serialization. (https://github.com/lowlydba/lowlydba.sqlserver/pull/48)
+      release_summary: Code cleanup, testing improvements, new _info module!
+    fragments:
+    - 47-improve-module-documentation.yml
+    - 48-cleanup-utils.yml
+    modules:
+    - description: Returns basic information for a SQL Server instance.
+      name: instance_info
+      namespace: ''
+    release_date: '2022-04-04'
+  0.3.0:
+    changes:
+      minor_changes:
+      - Fix logic to properly pass password policy options to function in the login
+        module.
+      release_summary: New sa module and fixes for login related modules.
+    fragments:
+    - 55-fix-login-param.yml
+    - v0.3.0-release-summary.yml
+    modules:
+    - description: Configure the 'sa' login for security best practices.
+      name: sa
+      namespace: ''
+    release_date: '2022-04-05'
+  0.4.0:
+    changes:
+      breaking_changes:
+      - All modules should use a bool 'enabled' instead of a string 'status' to control
+        object state.
+      minor_changes:
+      - Test for 'Name' property for sa module after dbatools release 1.1.95 standardizes
+        command outputs. (https://github.com/dataplat/dbatools/releases/tag/v1.1.95)
+      release_summary: Two new AlwaysOn modules and a few consistency fixes!
+    fragments:
+    - 0.4.0-release-summary.yml
+    - 56-test-for-login-name.yml
+    - 60-standardize-enabled-option.yml
+    modules:
+    - description: Configures availability group(s).
+      name: availability_group
+      namespace: ''
+    - description: Enable or disable HADR.
+      name: hadr
+      namespace: ''
+    release_date: '2022-04-27'
+  0.5.0:
+    changes:
+      minor_changes:
+      - Remove CI support for Ansible 2.10
+      release_summary: CI and testing improvements, along with the final availability
+        group module ag_replica.
+    fragments:
+    - 70-deprecate-ansible-2.10.yml
+    - release-summary.yml
+    modules:
+    - description: Configures an availability group listener.
+      name: ag_listener
+      namespace: ''
+    - description: Configures an availability group replica.
+      name: ag_replica
+      namespace: ''
+    release_date: '2022-05-11'
+  0.6.0:
+    changes:
+      release_summary: Adding new SPN module
+    fragments:
+    - release-summary-0-6-0.yml
+    modules:
+    - description: Configures SPNs for SQL Server.
+      name: spn
+      namespace: ''
+    release_date: '2022-05-20'
+  0.7.0:
+    changes:
+      release_summary: Add module for DBA Multitool.
+    fragments:
+    - release-summary-0-7-0.yml
+    modules:
+    - description: Install/update the DBA Multitool suite by John McCAll
+      name: dba_multitool
+      namespace: ''
+    release_date: '2022-05-21'
+  0.8.0:
+    changes:
+      bugfixes:
+      - Fix inability to enable an agent job schedule after it has been disabled.
+      minor_changes:
+      - Standardize use of 'database' vs 'database_name' in all documentation and
+        options specs. Not a breaking change.
+      release_summary: A few small fixes and the new 'backup' module.
+    fragments:
+    - 83-fix-agent-schedule.yml
+    - 84-standardize-database-option.yml
+    modules:
+    - description: Performs a backup operation.
+      name: backup
+      namespace: ''
+    release_date: '2022-05-31'
+  0.9.0:
+    changes:
+      bugfixes:
+      - backup - Only use blocksize when specified.
+    fragments:
+    - 90-fix-backup-blocksize.yml
+    modules:
+    - description: Performs a restore operation.
+      name: restore
+      namespace: ''
+    release_date: '2022-06-18'
+  0.9.1:
+    changes:
+      bugfixes:
+      - Allow agent job steps to be removed by specifying the step ID only. This is
+        likely needed in cleanup of steps from previous job configurations.
+      release_summary: Bugfix!
+    fragments:
+    - 0-9-1-release_sumary.yml
+    - 95-fix-agent-job-step-removal.yml
+    release_date: '2022-06-21'
+  0.9.2:
+    changes:
+      bugfixes:
+      - agent_job - Fix incorrectly reported change status when no change occurred.
+      - agent_job_schedule - Fix incorrectly reported change status when no change
+        occurred.
+      - agent_job_step - Fix incorrectly reported change status when no change occurred.
+      release_summary: Bugfixes for agent related modules that incorrectly reported
+        change statuses.
+    fragments:
+    - 97-fix-agent-related-status.yml
+    - 97-release-summary.yml
+    release_date: '2022-06-22'
+  0.9.3:
+    changes:
+      bugfixes:
+      - memory - Fix improper changed detection.
+      release_summary: More change detection fixing.
+    fragments:
+    - 100-fix-memory.yml
+    - v0-9-3-release-summary.yml
+    release_date: '2022-06-22'
+  1.0.0:
+    changes:
+      release_summary: "Bumping to version 1.0.0 now that this collection is being
+        used in production in at least one place \U0001F389"
+    fragments:
+    - v1-release-summary.yml
+    release_date: '2022-08-03'
+  1.0.1:
+    changes:
+      bugfixes:
+      - Fixed bug in how the classifier function name is being assigned to the variable
+        in the resource_governor module.
+      release_summary: Minor bug fix.
+    fragments:
+    - 1-0-1-release_summary.yml
+    - resource_governor.yml
+    release_date: '2022-08-20'
+  1.0.2:
+    changes:
+      bugfixes:
+      - _SqlServerUtils module_util - added explicit license to private module util
+        (https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
+      - meta/runtime.yml - updated out of date runtime version info (https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
+      - most modules - fixed alignment, formatting, and typos in module documentation
+        (https://github.com/lowlydba/lowlydba.sqlserver/pull/119).
+      release_summary: Minor documentation bugfixes and enhancements as requested
+        in the Ansible inclusion process.
+    fragments:
+    - 119-doc-updates.yml
+    - v1-0-2-release-summary.yml
+    release_date: '2022-08-29'
+  1.0.3:
+    changes:
+      bugfixes:
+      - Minor documentation fixes (https://github.com/lowlydba/lowlydba.sqlserver/pull/122).
+      release_summary: Minor documentation fixes from the second Ansible inclusion
+        review.
+    fragments:
+    - 122-doc-fixes.yml
+    - v1-0-3-release-summary.yml
+    release_date: '2022-09-03'
+  1.0.4:
+    changes:
+      bugfixes:
+      - Fix cleanup_time default to match documentation default & lint fixes (https://github.com/lowlydba/lowlydba.sqlserver/pull/127).
+      release_summary: Minor fixes to resolve new dlevel sanity checks.
+    fragments:
+    - 127-fix-doc-check.yml
+    - release-summary.yml
+    release_date: '2022-11-05'
+  1.1.0:
+    changes:
+      release_summary: Adding a new user module.
+    modules:
+    - description: Configures a user within a database
+      name: user
+      namespace: ''
+    release_date: '2022-11-12'
+  1.1.1:
+    changes:
+      minor_changes:
+      - modules - all modules now document their platform and support for check mode
+        in their attributes documentation (https://github.com/lowlydba/lowlydba.sqlserver/pull/134).
+    fragments:
+    - 137-add-attributes.yml
+    release_date: '2022-11-28'
+  1.1.2:
+    changes:
+      bugfixes:
+      - Removed the default value for xp_dirtree to allow compatibility with Azure
+        SQL Mangaed instances (https://github.com/lowlydba/lowlydba.sqlserver/pull/141)
+      release_summary: Bug fix for Azure Database Managed Instance compatibility.
+    fragments:
+    - 1-1-2-release-summary.yml
+    - xpdirtree_sql_mi_bugfix.yml
+    release_date: '2022-12-02'
+  1.1.3:
+    changes:
+      bugfixes:
+      - Removed default value for reuse_source_folder_structure to fix compatability
+        with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/145)
+      release_summary: Another minor fix to increase SQL Managed Instance support.
+    fragments:
+    - reuse_source_folder_structure_sql_mi_bugfix.yml
+    - v1-1-3-release-summary.yml
+    release_date: '2022-12-05'
+  1.2.0:
+    changes:
+      bugfixes:
+      - Removed default value for ReplaceDbNameInFile to fix compatability with SQL
+        MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/148)
+      minor_changes:
+      - Fixed typo in the traceflag module's documentation. (https://github.com/lowlydba/lowlydba.sqlserver/pull/150)
+      - Return "RestartRequired" when a module performs changes that require an addition
+        service restart to take effect. (https://github.com/lowlydba/lowlydba.sqlserver/pull/150/)
+      release_summary: Azure SQL MI compatibility fixes & indicating required restarts
+        for settings changes.
+    fragments:
+    - 1-2-0-release-summary.yml
+    - 150-restart-indicator.yml
+    - ReplaceDbNameInFile_sql_mi_bugfix.yml
+    release_date: '2022-12-05'
+  1.2.1:
+    changes:
+      bugfixes:
+      - Added missing mapping for UseDestinationDefaultDirectories (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
+      - Removed default value for KeepCDC to fix compatability with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
+      - Removed default value for UseDestinationDefaultDirectories to fix compatability
+        with SQL MI (https://github.com/lowlydba/lowlydba.sqlserver/pull/153)
+      release_summary: More Azure SQL Managed Instance compatibility fixes.
+    fragments:
+    - 1-2-1-release_summary.yml
+    - 153-additional_sql_mi_fixes.yml
+    release_date: '2022-12-06'
+  1.3.0:
+    changes:
+      minor_changes:
+      - Adding a new credential module
+      release_summary: New module to manage credentials added!
+    fragments:
+    - 1-3-0-release_summary.yml
+    - add_credential_module.yml
+    modules:
+    - description: Configures a credential on a SQL server
+      name: credential
+      namespace: ''
+    release_date: '2022-12-09'
+  1.3.1:
+    changes:
+      bugfixes:
+      - Fixes to incorrect variable reference in Login module (https://github.com/lowlydba/lowlydba.sqlserver/pull/161)
+      minor_changes:
+      - Update login module documentation to indicate result will always be changed
+        when a password is supplied. (https://github.com/lowlydba/lowlydba.sqlserver/pull/167)
+      release_summary: Small bugfixes and documentation enhancements.
+    fragments:
+    - 1-3-1-release_summary.yml
+    - 167-update-login-docs.yml
+    - fix_sa.yml
+    release_date: '2022-12-18'
diff --git a/ansible_collections/lowlydba/sqlserver/changelogs/config.yaml b/ansible_collections/lowlydba/sqlserver/changelogs/config.yaml
new file mode 100644
index 000000000..6fa3e9ae8
--- /dev/null
+++ b/ansible_collections/lowlydba/sqlserver/changelogs/config.yaml
@@ -0,0 +1,30 @@
+# https://github.com/ansible-community/antsibull-changelog/blob/main/docs/changelogs.rst
+changelog_filename_template: ../CHANGELOG.rst
+changelog_filename_version_depth: 0
+changes_file: changelog.yaml
+changes_format: combined
+keep_fragments: false
+mention_ancestor: true
+new_plugins_after_name: removed_features
+notesdir: fragments
+prelude_section_name: release_summary
+prelude_section_title: Release Summary
+sections:
+- - major_changes
+  - Major Changes
+- - minor_changes
+  - Minor Changes
+- - breaking_changes
+  - Breaking Changes / Porting Guide
+- - deprecated_features
+  - Deprecated Features
+- - removed_features
+  - Removed Features (previously deprecated)
+- - security_fixes
+  - Security Fixes
+- - bugfixes
+  - Bugfixes
+- - known_issues
+  - Known Issues
+title: lowlydba.sqlserver
+trivial_section_name: trivial
diff --git a/ansible_collections/lowlydba/sqlserver/changelogs/fragments/.keep b/ansible_collections/lowlydba/sqlserver/changelogs/fragments/.keep
new file mode 100644
index 000000000..e69de29bb
--- /dev/null
+++ b/ansible_collections/lowlydba/sqlserver/changelogs/fragments/.keep