Support for Windows Postgres provisioning on hono test cases

[rak3rman]

Discussed in https://github.com/radicalplatforms/shafa/discussions/114

^{Originally posted by **vincentdo1** March 11, 2024} This is the error I get after installing packages and postgres 16. Was wondering if there is a work around for windows. 

Description

Ah, this is (partially) intended behavior of the test utility that provisions the Postgres database locally. In this case, I wasn't able to test these scripts against a Windows machine (I use Mac and Ubuntu for development) so the script intentionally throws a fatal error if it detects a Windows environment.

Running on Windows will require an addition to the getInstallationScript() function located in shafa/hono/test/utils/db.ts. I'll go ahead and open a new issue requesting this implementation.

https://github.com/radicalplatforms/shafa/blob/main/hono/test/utils/db.ts#L98

Originally posted by @rak3rman in https://github.com/radicalplatforms/shafa/discussions/114#discussioncomment-8753394

• [ ] Modify getInstallationScript() in shafa/hono/test/utils/db.ts to support Postgres provisioning and startup in Windows environments
• [ ] Modify getCreateDbScript() in shafa/hono/test/utils/db.ts to support Postgres database creation in Windows environments
• [ ] Modify getStopScript() in shafa/hono/test/utils/db.ts to support Postgres teardown in Windows environments
• [ ] Modify the .github/workflows/hono_integration.yml workflow or create a new workflow to run all smoke tests on Linux and Windows and MacOS in a Matrix form only when files in shafa/hono/test/utils/* are updated/committed to

Acceptance Criteria

Generated by Zenhub AI

• [ ] Scenario: Support for Windows Postgres provisioning on hono test cases
  • Given the getInstallationScript() function in shafa/hono/test/utils/db.ts is modified to support Postgres provisioning and startup in Windows environments
  • When the test utility is run on a Windows machine
  • Then the test utility should successfully provision, create, and teardown the Postgres database without throwing a fatal error
  • And the .github/workflows/hono_integration.yml workflow should be modified (or a new workflow created) to run all smoke tests on Linux, Windows, and MacOS in a Matrix form when files in shafa/hono/test/utils/* are updated/committed to

[rak3rman]

Marking as "won't fix" since getting Postgres configured on the command line on Windows is more trouble than it's worth. However, three tasks still remain that should be opened as new issue(s):

• [ ] Modify the .github/workflows/hono_integration.yml workflow or create a new workflow to run all smoke tests on Linux and MacOS in a Matrix form only when files in shafa/hono/test/utils/* are updated/committed to
• [ ] Update the README to describe Hono/Postgres setup on different OS'es in more detail (maybe provide a command for one step install)