src/Pure/Admin/component_sqlite.scala
author Fabian Huch <huch@in.tum.de>
Thu, 06 Jun 2024 13:37:27 +0200
changeset 80260 ed9b1598d293
parent 79954 475074795dca
permissions -rw-r--r--
manage components of ci builds;
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
77566
2a99fcb283ee renamed administrative tools to build Isabelle components (unrelated to "isabelle build");
wenzelm
parents: 77035
diff changeset
     1
/*  Title:      Pure/Admin/component_sqlite.scala
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     2
    Author:     Makarius
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     3
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
     4
Build Isabelle sqlite component from official download.
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     5
*/
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     6
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     7
package isabelle
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     8
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     9
77566
2a99fcb283ee renamed administrative tools to build Isabelle components (unrelated to "isabelle build");
wenzelm
parents: 77035
diff changeset
    10
object Component_SQLite {
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    11
  /* build sqlite */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    12
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    13
  val default_main_url =
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
    14
    "https://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/3.45.2.0/sqlite-jdbc-3.45.2.0.jar"
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    15
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    16
  val default_logger_url =
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    17
    "https://repo1.maven.org/maven2/org/slf4j/slf4j-api/1.7.36/slf4j-api-1.7.36.jar"
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    18
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    19
  private def jar_name(url: String): String = {
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    20
    Url.get_base_name(url, suffix = ".jar") getOrElse
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    21
      error("Malformed jar URL: " + quote(url))
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    22
  }
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    23
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    24
  private def nop_name(s: String): String = s.replace("-api", "-nop")
76544
b10926dbb763 more standard component build process;
wenzelm
parents: 76543
diff changeset
    25
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    26
  def build_sqlite(
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    27
    main_url: String = default_main_url,
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    28
    logger_url: String = default_logger_url,
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    29
    progress: Progress = new Progress,
75393
87ebf5a50283 clarified formatting, for the sake of scala3;
wenzelm
parents: 73566
diff changeset
    30
    target_dir: Path = Path.current
87ebf5a50283 clarified formatting, for the sake of scala3;
wenzelm
parents: 73566
diff changeset
    31
  ): Unit = {
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    32
    val main_name = jar_name(main_url)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    33
    val logger_name = jar_name(logger_url)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    34
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    35
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    36
    /* component */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    37
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
    38
    val component_name = main_name.replace("-jdbc", "")
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    39
    val component_dir =
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
    40
      Components.Directory(target_dir + Path.basic(component_name)).create(progress = progress)
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    41
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    42
    def download(url: String): Path = {
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    43
      val path = component_dir.lib + Path.basic(Url.get_base_name(url).get)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    44
      Isabelle_System.download_file(url, path, progress = progress)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    45
      path
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    46
    }
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    47
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    48
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    49
    /* README */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    50
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    51
    File.write(component_dir.README,
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    52
      "This is " + main_name + " from\n" + main_url +
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    53
      "\ntogether with " + logger_name + " from\n" + logger_url +
72444
2d9a70b85009 tuned whitespace;
wenzelm
parents: 72377
diff changeset
    54
        "\n\n        Makarius\n        " + Date.Format.date(Date.now()) + "\n")
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    55
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    56
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    57
    /* settings */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    58
76548
0af64cc2eee9 tuned signature;
wenzelm
parents: 76547
diff changeset
    59
    component_dir.write_settings("""
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    60
ISABELLE_SQLITE_HOME="$COMPONENT"
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    61
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    62
classpath "$ISABELLE_SQLITE_HOME/lib/""" + main_name + """.jar"
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    63
classpath "$ISABELLE_SQLITE_HOME/lib/""" + logger_name + """.jar"
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    64
classpath "$ISABELLE_SQLITE_HOME/lib/""" + nop_name(logger_name) + """.jar"
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    65
""")
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    66
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    67
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    68
    /* main jar */
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    69
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    70
    Isabelle_System.make_directory(component_dir.lib)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    71
    val jar = download(main_url)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    72
75491
47d790984e82 tuned names;
wenzelm
parents: 75394
diff changeset
    73
    Isabelle_System.with_tmp_dir("build") { jar_dir =>
76543
fef0195f8d8e clarified signature: prefer Scala functions instead of shell scripts;
wenzelm
parents: 76518
diff changeset
    74
      Isabelle_System.extract(jar, jar_dir)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    75
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    76
      val jar_files =
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    77
        List(
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    78
          "META-INF/maven/org.xerial/sqlite-jdbc/LICENSE" -> ".",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    79
          "META-INF/maven/org.xerial/sqlite-jdbc/LICENSE.zentus" -> ".",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    80
          "org/sqlite/native/Linux/aarch64/libsqlitejdbc.so" -> "arm64-linux",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    81
          "org/sqlite/native/Linux/x86_64/libsqlitejdbc.so" -> "x86_64-linux",
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    82
          "org/sqlite/native/Mac/aarch64/libsqlitejdbc.dylib" -> "arm64-darwin",
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    83
          "org/sqlite/native/Mac/x86_64/libsqlitejdbc.dylib" -> "x86_64-darwin",
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    84
          "org/sqlite/native/Windows/x86_64/sqlitejdbc.dll" -> "x86_64-windows")
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    85
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    86
      for ((file, dir) <- jar_files) {
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    87
        val target = Isabelle_System.make_directory(component_dir.path + Path.explode(dir))
73317
df49ca5da9d0 clarified modules: more like ML;
wenzelm
parents: 73000
diff changeset
    88
        Isabelle_System.copy_file(jar_dir + Path.explode(file), target)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    89
      }
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    90
78158
8b5a2e4b16d4 tuned signature;
wenzelm
parents: 77593
diff changeset
    91
      File.set_executable(component_dir.path + Path.explode("x86_64-windows/sqlitejdbc.dll"))
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
    92
    }
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    93
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    94
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    95
    /* logger jars */
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    96
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    97
    download(logger_url)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    98
    download(nop_name(logger_url))
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    99
  }
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   100
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   101
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   102
  /* Isabelle tool wrapper */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   103
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   104
  val isabelle_tool =
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
   105
    Isabelle_Tool("component_sqlite", "build Isabelle sqlite component from official download",
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   106
      Scala_Project.here,
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   107
      { args =>
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   108
        var target_dir = Path.current
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   109
        var main_url = default_main_url
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   110
        var logger_url = default_logger_url
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   111
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   112
        val getopts = Getopts("""
77566
2a99fcb283ee renamed administrative tools to build Isabelle components (unrelated to "isabelle build");
wenzelm
parents: 77035
diff changeset
   113
Usage: isabelle component_sqlite [OPTIONS] DOWNLOAD
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   114
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   115
  Options are:
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   116
    -D DIR       target directory (default ".")
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   117
    -U URL       main URL
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   118
                 (default: """" + default_main_url + """")
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   119
    -V URL       logger URL
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   120
                 (default: """" + default_logger_url + """")
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   121
79954
475074795dca update to sqlite-3.45.2.0: clarified component name, following postgresql;
wenzelm
parents: 79506
diff changeset
   122
  Build sqlite component from the specified download URL (JAR), see also
73000
a4efee8f8842 updated to sqlite-jdbc-3.34.0, with support for native arm64-darwin;
wenzelm
parents: 72763
diff changeset
   123
  https://github.com/xerial/sqlite-jdbc and
a4efee8f8842 updated to sqlite-jdbc-3.34.0, with support for native arm64-darwin;
wenzelm
parents: 72763
diff changeset
   124
  https://oss.sonatype.org/content/repositories/releases/org/xerial/sqlite-jdbc
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   125
""",
76544
b10926dbb763 more standard component build process;
wenzelm
parents: 76543
diff changeset
   126
          "D:" -> (arg => target_dir = Path.explode(arg)),
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   127
          "U:" -> (arg => main_url = arg),
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   128
          "V:" -> (arg => logger_url = arg))
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   129
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   130
        val more_args = getopts(args)
76544
b10926dbb763 more standard component build process;
wenzelm
parents: 76543
diff changeset
   131
        if (more_args.nonEmpty) getopts.usage()
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   132
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   133
        val progress = new Console_Progress()
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   134
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   135
        build_sqlite(main_url = main_url, logger_url = logger_url,
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   136
          progress = progress, target_dir = target_dir)
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   137
      })
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   138
}