← 输入框|github.com|刷新
Skip to content

CI: Add Windows GHA build with MSSQL driver - #7693

Open
geographika wants to merge 1 commit into
MapServer:mainfrom
geographika:windows-build-gha
Open

geographika wants to merge 1 commit into
MapServer:mainfrom
geographika:windows-build-gha

Conversation

@geographika

Copy link
Copy Markdown
Member

This adds a Windows build on GitHub Actions (GHA). Currently Windows builds are tested on Appveyor. The advantage of the GHA build is that it can be run in private repositories, which helps testing security patches before they are made public.

The PowerShell scripts are based on local scripts I already use for Windows builds. Using scripts limits reliance on GHA if we want to move to another CI engine in the future, and also allows testing locally.

Other changes in this PR:

  • updates the MSSQL tests to use the ODBC Driver 18 for SQL Server rather than the default (and out-of-date) SQL Server driver, which has several issues and is not recommended.
  • updates the MSSQL tests to connect to localhost rather than the Appveyor-specific (local)\SQL2019 instance. On Appveyor the SQL2019 instance is set to listen on port 1433 so the same connection works on both.
  • replaces create_mssql_db.bat with create_mssql_db.ps1, used by both builds.
  • updates msautotest/etc/mapserv.conf to load the MSSQL plugin by file name rather than the Appveyor build path.
  • updates the appveyor.yml build so it continues to run with the same test files and scripts as the GHA version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant