Lawrence-git
diff --git a/.coveragerc b/.coveragerc
@@ -2,6 +2,7 @@
 branch = True
 source =
     pymysql
+    tests
 omit = pymysql/tests/*
        pymysql/tests/thirdparty/test_MySQLdb/*
 

diff --git a/.github/FUNDING.yml b/.github/FUNDING.yml
@@ -0,0 +1,12 @@
+# These are supported funding model platforms
+
+github: ["methane"] # Replace with up to 4 GitHub Sponsors-enabled usernames e.g., [user1, user2]
+patreon: # Replace with a single Patreon username
+open_collective: # Replace with a single Open Collective username
+ko_fi: # Replace with a single Ko-fi username
+tidelift: "pypi/PyMySQL" # Replace with a single Tidelift platform-name/package-name e.g., npm/babel
+community_bridge: # Replace with a single Community Bridge project-name e.g., cloud-foundry
+liberapay: # Replace with a single Liberapay username
+issuehunt: # Replace with a single IssueHunt username
+otechie: # Replace with a single Otechie username
+custom: # Replace with up to 4 custom sponsorship URLs e.g., ['link1', 'link2']
diff --git a/.github/ISSUE_TEMPLATE.md b/.github/ISSUE_TEMPLATE.md
diff --git a/.github/ISSUE_TEMPLATE/bug_report.md b/.github/ISSUE_TEMPLATE/bug_report.md
@@ -0,0 +1,39 @@
+---
+name: Bug report
+about: Create a report to help us improve
+title: ''
+labels: ''
+assignees: ''
+
+---
+
+**Describe the bug**
+A clear and concise description of what the bug is.
+
+**To Reproduce**
+Complete steps to reproduce the behavior:
+
+Schema:
+
+```
+CREATE DATABASE ...
+CREATE TABLE ...
+```
+
+Code:
+
+```py
+import pymysql
+con = pymysql.connect(...)
+```
+
+**Expected behavior**
+A clear and concise description of what you expected to happen.
+
+**Environment**
+ - OS: [e.g. Windows, Linux]
+ - Server and version: [e.g. MySQL 8.0.19, MariaDB]
+ - PyMySQL version: 
+
+**Additional context**
+Add any other context about the problem here.
diff --git a/.github/workflows/django.yaml b/.github/workflows/django.yaml
@@ -0,0 +1,66 @@
+name: Django test
+
+on:
+  push:
+    # branches: ["main"]
+  # pull_request:
+
+jobs:
+  django-test:
+    name: "Run Django LTS test suite"
+    runs-on: ubuntu-latest
+    # There are some known difference between MySQLdb and PyMySQL.
+    continue-on-error: true
+    env:
+      PIP_NO_PYTHON_VERSION_WARNING: 1
+      PIP_DISABLE_PIP_VERSION_CHECK: 1
+      # DJANGO_VERSION: "3.2.19"
+    strategy:
+      fail-fast: false
+      matrix:
+        include:
+          # Django 3.2.9+ supports Python 3.10
+          # https://docs.djangoproject.com/ja/3.2/releases/3.2/
+          - django: "3.2.19"
+            python: "3.10"
+
+          - django: "4.2.1"
+            python: "3.11"
+
+    steps:
+      - name: Start MySQL
+        run: |
+          sudo systemctl start mysql.service
+          mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -proot mysql
+          mysql -uroot -proot -e "set global innodb_flush_log_at_trx_commit=0;"
+          mysql -uroot -proot -e "CREATE USER 'scott'@'%' IDENTIFIED BY 'tiger'; GRANT ALL ON *.* TO scott;"
+          mysql -uroot -proot -e "CREATE DATABASE django_default; CREATE DATABASE django_other;"
+
+      - uses: actions/checkout@v4
+
+      - name: Set up Python
+        uses: actions/setup-python@v5
+        with:
+          python-version: ${{ matrix.python }}
+
+      - name: Install mysqlclient
+        run: |
+          #pip install mysqlclient  # Use stable version
+          pip install .[rsa]
+
+      - name: Setup Django
+        run: |
+          sudo apt-get install libmemcached-dev
+          wget https://github.com/django/django/archive/${{ matrix.django }}.tar.gz
+          tar xf ${{ matrix.django }}.tar.gz
+          cp ci/test_mysql.py django-${{ matrix.django }}/tests/
+          cd django-${{ matrix.django }}
+          pip install . -r tests/requirements/py3.txt
+
+      - name: Run Django test
+        run: |
+          cd django-${{ matrix.django }}/tests/
+          # test_runner does not using our test_mysql.py
+          # We can't run whole django test suite for now.
+          # Run olly backends test
+          DJANGO_SETTINGS_MODULE=test_mysql python runtests.py backends
diff --git a/.github/workflows/lint.yaml b/.github/workflows/lint.yaml
@@ -0,0 +1,24 @@
+name: Lint
+
+on:
+  push:
+    branches: ["main"]
+    paths:
+      - '**.py'
+  pull_request:
+    paths:
+      - '**.py'
+
+jobs:
+  lint:
+    runs-on: ubuntu-latest
+    steps:
+      - uses: actions/checkout@v4
+
+      - uses: astral-sh/ruff-action@v3
+
+      - name: format
+        run: ruff format --diff
+
+      - name: lint
+        run: ruff check --diff
diff --git a/.github/workflows/test.yaml b/.github/workflows/test.yaml
@@ -0,0 +1,110 @@
+name: Test
+
+on:
+  push:
+  pull_request:
+
+concurrency:
+  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.sha }}
+  cancel-in-progress: true
+
+env:
+  FORCE_COLOR: 1
+
+jobs:
+  test:
+    runs-on: ubuntu-latest
+    strategy:
+      fail-fast: false
+      matrix:
+        include:
+          - db: "mariadb:10.4"
+            py: "3.13"
+
+          - db: "mariadb:10.5"
+            py: "3.11"
+
+          - db: "mariadb:10.6"
+            py: "3.10"
+
+          - db: "mariadb:10.6"
+            py: "3.9"
+
+          - db: "mariadb:lts"
+            py: "3.8"
+
+          - db: "mysql:5.7"
+            py: "pypy-3.10"
+
+          - db: "mysql:8.0"
+            py: "3.13"
+            mysql_auth: true
+
+          - db: "mysql:8.4"
+            py: "3.8"
+            mysql_auth: true
+
+    services:
+      mysql:
+        image: "${{ matrix.db }}"
+        ports:
+          - 3306:3306
+        env:
+          MYSQL_ALLOW_EMPTY_PASSWORD: yes
+          MARIADB_ALLOW_EMPTY_ROOT_PASSWORD: yes
+        options: "--name=mysqld"
+        volumes:
+          - /run/mysqld:/run/mysqld
+
+    steps:
+      - uses: actions/checkout@v4
+
+      - 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@v5
+        with:
+          python-version: ${{ matrix.py }}
+          allow-prereleases: true
+          cache: 'pip'
+          cache-dependency-path: 'requirements-dev.txt'
+
+      - name: Install dependency
+        run: |
+          pip install --upgrade -r requirements-dev.txt
+
+      - name: Set up MySQL
+        run: |
+          while :
+          do
+              sleep 1
+              mysql -h127.0.0.1 -uroot -e 'select version()' && break
+          done
+          mysql -h127.0.0.1 -uroot -e "SET GLOBAL local_infile=on"
+          mysql -h127.0.0.1 -uroot --comments < ci/docker-entrypoint-initdb.d/init.sql
+          mysql -h127.0.0.1 -uroot --comments < ci/docker-entrypoint-initdb.d/mysql.sql
+          mysql -h127.0.0.1 -uroot --comments < ci/docker-entrypoint-initdb.d/mariadb.sql
+          cp ci/docker.json pymysql/tests/databases.json
+
+      - name: Run test
+        run: |
+          pytest -v --cov --cov-config .coveragerc pymysql
+          pytest -v --cov-append --cov-config .coveragerc --doctest-modules pymysql/converters.py
+
+      - name: Run MySQL8 auth test
+        if: ${{ matrix.mysql_auth }}
+        run: |
+          docker cp mysqld:/var/lib/mysql/public_key.pem "${HOME}"
+          docker cp mysqld:/var/lib/mysql/ca.pem "${HOME}"
+          docker cp mysqld:/var/lib/mysql/server-cert.pem "${HOME}"
+          docker cp mysqld:/var/lib/mysql/client-key.pem "${HOME}"
+          docker cp mysqld:/var/lib/mysql/client-cert.pem "${HOME}"
+          pytest -v --cov-append --cov-config .coveragerc tests/test_auth.py;
+
+      - name: Upload coverage reports to Codecov
+        if: github.repository == 'PyMySQL/PyMySQL'
+        uses: codecov/codecov-action@v5
diff --git a/.gitignore b/.gitignore
@@ -13,3 +13,4 @@
 /pymysql/tests/databases.json
 __pycache__
 Pipfile.lock
+pdm.lock
diff --git a/.readthedocs.yaml b/.readthedocs.yaml
@@ -0,0 +1,17 @@
+# .readthedocs.yaml
+# Read the Docs configuration file
+# See https://docs.readthedocs.io/en/stable/config-file/v2.html for details
+version: 2
+
+build:
+  os: ubuntu-22.04
+  tools:
+    python: "3.12"
+
+python:
+  install:
+    - requirements: docs/requirements.txt
+
+# Build documentation in the docs/ directory with Sphinx
+sphinx:
+  configuration: docs/source/conf.py
diff --git a/.travis.yml b/.travis.yml
diff --git a/.travis/database.json b/.travis/database.json
diff --git a/.travis/docker.json b/.travis/docker.json