bareos: master 1a8c0b97

Diff Back to Repository
Author Committer Branch Timestamp Parent
pstorz Sebastian Sura master 2025-01-28 18:14 master e8a95469 Pending
Changeset systemtests: add mssqlvdi-plugin test

We use a standard DB called `DBNormalTest` with simple table
`samples` and a `Filestream` feature enabled database `DBFilestreamTest`
with two tables `samples` and `files`

- setup license on all testrunner and sqlfiles
- find_program SQLCMD: remove HINTS
- use recommend primary key for filestream table
  `UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE`
- environment.in: move SQLCMD upwards
- minimize configuration files
- properly escape all variables (shellcheck)
- remove set -x in testrunner-01-DBNormal-prepare
  testrunner-11-DBFileStream-prepare
- make tests portable on `CORE` so use `regedit.exe` and `write.exe`
  as sample for Filestream `files` table

Co-authored-by: Philipp Storz <philipp.storz@bareos.com>
Signed-off-by: Bruno Friedmann <bruno.friedmann@bareos.com>
mod - CMakeLists.txt Diff File
mod - core/src/filed/verify.cc Diff File
mod - systemtests/cmake/BareosSystemtestFunctions.cmake Diff File
mod - systemtests/environment.in Diff File
mod - systemtests/tests/CMakeLists.txt Diff File
add - systemtests/tests/mssqlvdi-plugin/CMakeLists.txt Diff File
add - systemtests/tests/mssqlvdi-plugin/environment.local Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/catalog/MyCatalog.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/client/bareos-fd.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/director/bareos-dir.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/fileset/Catalog.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/fileset/DBNormalFileset.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/fileset/DBStreamFileset.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/fileset/SelfTest.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/job/RestoreFiles.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/job/backup-DBNormal.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/job/backup-DBStream.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/job/backup-bareos-fd.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/jobdefs/DefaultJob.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/messages/Daemon.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/messages/Standard.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/pool/Differential.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/pool/Full.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/pool/Incremental.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/pool/Scratch.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/profile/operator.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-dir.d/storage/File.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-fd.d/client/myself.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-fd.d/director/bareos-dir.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-fd.d/messages/Standard.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-sd.d/device/FileStorage.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-sd.d/director/bareos-dir.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-sd.d/messages/Standard.conf Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bareos-sd.d/storage/bareos-sd.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/etc/bareos/bconsole.conf.in Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_add_data.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_create_bareos_login_user.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_create_schema_tables.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_create_schema_tables_stream.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_db_filestream_drop_create.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_db_normal_drop_create.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_drop_db.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_drop_tables_schemas.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_load_data.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/sqlfiles/SQL_load_data_stream.sql Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-01-DBNormal-prepare Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-02-DBNormal-FullBackup Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-03-DBNormal-IncBackup Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-04-DBNormal-DropDB Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-05-DBNormal-Restore Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-11-DBFileStream-prepare Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-12-DBFileStream-FullBackup Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-13-DBFileStream-IncBackup Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-14-DBFileStream-DropDB Diff File
add - systemtests/tests/mssqlvdi-plugin/testrunner-15-DBFileStream-Restore Diff File