# To verify the change, run the build with:
# @bot-gradle test ReadyForNightly
# ```
# stopGradleDaemons=true
# ```
version: "v1"
jdks:
  - params:
      - "linux.java8.openjdk.64bit"
      - "linux.java8.oracle.64bit"
    os: "linux"
    arch: "amd64"
    vendor: "oracle"
    version: "8u401"
    sha256: "19684fccd7ff32a8400e952a643f0049449a772ef63b8037d5b917cbd137d173"
  - params:
      - "linux.java11.openjdk.64bit"

            "-Dorg.gradle.java.installations.auto-detect=false",
            "-Porg.gradle.java.installations.auto-detect=false",
            "\"-Dorg.gradle.java.installations.paths=$expectedInstallationPaths\"",
            "\"-Porg.gradle.java.installations.paths=$expectedInstallationPaths\"",
        ).joinToString(" ")
    }

                "-PteamCityBuildId=%teamcity.build.id%",
                "-Dorg.gradle.java.installations.auto-download=false",
                "-Porg.gradle.java.installations.auto-download=false",
                "-Dorg.gradle.java.installations.auto-detect=false",
                "-Porg.gradle.java.installations.auto-detect=false",
                "\"-Dorg.gradle.java.installations.paths=$expectedInstallationPaths\"",

                "-Dorg.gradle.java.installations.auto-download=false",
                "-Porg.gradle.java.installations.auto-download=false",
                "\"-Dorg.gradle.java.installations.paths=$expectedInstallationPaths\"",
                "\"-Porg.gradle.java.installations.paths=$expectedInstallationPaths\"",
                "\"-Porg.gradle.performance.branchName=%teamcity.build.branch%\"",

    assertThat(CipherSuite.TLS_RSA_WITH_AES_128_CBC_SHA256.toString())
      .isEqualTo(CipherSuite.TLS_RSA_WITH_AES_128_CBC_SHA256.javaName)
  }

  /**
   * On the Oracle JVM some older cipher suites have the "SSL_" prefix and others have the "TLS_"
   * prefix. On the IBM JVM all cipher suites have the "SSL_" prefix.
   *

    return try {
      // Attempt to get the trust manager from an OpenJDK socket factory. We attempt this on all
      // platforms in order to support Robolectric, which mixes classes from both Android and the
      // Oracle JDK. Note that we don't support HTTP/2 or other nice features on Robolectric.
      val sslContextClass = Class.forName("sun.security.ssl.SSLContextImpl")

import gradlebuild.basics.BuildParams.VENDOR_MAPPING
import org.gradle.api.JavaVersion
import org.gradle.api.Project
import org.gradle.api.provider.Provider
import org.gradle.internal.os.OperatingSystem
import org.gradle.jvm.toolchain.JvmVendorSpec
import org.gradle.jvm.toolchain.internal.LocationListInstallationSupplier.JAVA_INSTALLATIONS_PATHS_PROPERTY

///

As SQLModel is based on SQLAlchemy, you can easily use **any database supported** by SQLAlchemy (which makes them also supported by SQLModel), like:

* PostgreSQL
* MySQL
* SQLite
* Oracle
* Microsoft SQL Server, etc.

In this example, we'll use **SQLite**, because it uses a single file and Python has integrated support. So, you can copy this example and run it as is.

///

SQLModel は SQLAlchemy をベースにしているため、SQLAlchemy がサポートする任意のデータベース（SQLModel からもサポートされます）を簡単に使えます。例えば:

* PostgreSQL
* MySQL
* SQLite
* Oracle
* Microsoft SQL Server など

この例では、単一ファイルで動作し、Python に統合サポートがあるため、SQLite を使います。つまり、この例をそのままコピーして実行できます。

本番アプリでは、PostgreSQL のようなデータベースサーバーを使いたくなるかもしれません。

/// tip | 豆知識

///

因為 SQLModel 建立在 SQLAlchemy 之上，你可以輕鬆使用 SQLAlchemy 所支援的任何資料庫（因此 SQLModel 也支援），例如：

* PostgreSQL
* MySQL
* SQLite
* Oracle
* Microsoft SQL Server，等等。

在這個範例中，我們會使用 SQLite，因為它只用到單一檔案，而且 Python 內建支援。你可以直接複製這個範例並原樣執行。

之後，在你的正式環境應用中，你可能會想使用像 PostgreSQL 這類的資料庫伺服器。

/// tip | 提示