Add unix socket test (PyMySQL#1061)

SergeantMenacingGarlic · web-flow · commit 3dc1abbdaf7a · 2022-10-11T16:06:18.000+09:00
diff --git a/.github/workflows/test.yaml b/.github/workflows/test.yaml
@@ -45,9 +45,18 @@ jobs:
         env:
           MYSQL_ALLOW_EMPTY_PASSWORD: yes
         options: "--name=mysqld"
+        volumes:
+          - /run/mysqld:/run/mysqld
 
     steps:
       - uses: actions/checkout@v2
+
+      - name: Workaround MySQL container permissions
+        if: startsWith(matrix.db, 'mysql')
+        run: |
+          sudo chown 999:999 /run/mysqld
+          /usr/bin/docker ps --all --filter status=exited --no-trunc --format "{{.ID}}" | xargs -r /usr/bin/docker start
+
       - name: Set up Python ${{ matrix.py }}
         uses: actions/setup-python@v2
         with:
diff --git a/ci/docker.json b/ci/docker.json
@@ -1,4 +1,5 @@
 [
     {"host": "127.0.0.1", "port": 3306, "user": "root",  "password": "", "database": "test1",  "use_unicode": true, "local_infile": true},
-    {"host": "127.0.0.1", "port": 3306, "user": "test2", "password": "some password", "database": "test2" }
+    {"host": "127.0.0.1", "port": 3306, "user": "test2", "password": "some password", "database": "test2" },
+    {"host": "localhost", "port": 3306, "user": "test2", "password": "some password", "database": "test2", "unix_socket": "/run/mysqld/mysqld.sock"}
 ]

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,5 @@`
`1`	`1`	`[`
`2`	`2`	`{"host": "127.0.0.1", "port": 3306, "user": "root", "password": "", "database": "test1", "use_unicode": true, "local_infile": true},`
`3`		`- {"host": "127.0.0.1", "port": 3306, "user": "test2", "password": "some password", "database": "test2" }`
	`3`	`+ {"host": "127.0.0.1", "port": 3306, "user": "test2", "password": "some password", "database": "test2" },`
	`4`	`+ {"host": "localhost", "port": 3306, "user": "test2", "password": "some password", "database": "test2", "unix_socket": "/run/mysqld/mysqld.sock"}`
`4`	`5`	`]`