src/Pure/Admin/component_sqlite.scala
author wenzelm
Sat, 20 Jan 2024 22:18:29 +0100
changeset 79506 dcddfe4f43a3
parent 78287 a915e15af0d9
child 79954 475074795dca
permissions -rw-r--r--
updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
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
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
     4
Build Isabelle sqlite-jdbc component from official download.
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 =
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    14
    "https://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/3.45.0.0/sqlite-jdbc-3.45.0.0.jar"
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
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    38
    val component_dir =
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    39
      Components.Directory(target_dir + Path.basic(main_name)).create(progress = progress)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    40
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    41
    def download(url: String): Path = {
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    42
      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
    43
      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
    44
      path
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    45
    }
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    46
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
    /* README */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    49
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    50
    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
    51
      "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
    52
      "\ntogether with " + logger_name + " from\n" + logger_url +
72444
2d9a70b85009 tuned whitespace;
wenzelm
parents: 72377
diff changeset
    53
        "\n\n        Makarius\n        " + Date.Format.date(Date.now()) + "\n")
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    54
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
    /* settings */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    57
76548
0af64cc2eee9 tuned signature;
wenzelm
parents: 76547
diff changeset
    58
    component_dir.write_settings("""
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    59
ISABELLE_SQLITE_HOME="$COMPONENT"
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    60
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    61
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
    62
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
    63
classpath "$ISABELLE_SQLITE_HOME/lib/""" + nop_name(logger_name) + """.jar"
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    64
""")
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
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    67
    /* main jar */
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    68
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    69
    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
    70
    val jar = download(main_url)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    71
75491
47d790984e82 tuned names;
wenzelm
parents: 75394
diff changeset
    72
    Isabelle_System.with_tmp_dir("build") { jar_dir =>
76543
fef0195f8d8e clarified signature: prefer Scala functions instead of shell scripts;
wenzelm
parents: 76518
diff changeset
    73
      Isabelle_System.extract(jar, jar_dir)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    74
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    75
      val jar_files =
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    76
        List(
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    77
          "META-INF/maven/org.xerial/sqlite-jdbc/LICENSE" -> ".",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    78
          "META-INF/maven/org.xerial/sqlite-jdbc/LICENSE.zentus" -> ".",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    79
          "org/sqlite/native/Linux/aarch64/libsqlitejdbc.so" -> "arm64-linux",
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    80
          "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
    81
          "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
    82
          "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
    83
          "org/sqlite/native/Windows/x86_64/sqlitejdbc.dll" -> "x86_64-windows")
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    84
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    85
      for ((file, dir) <- jar_files) {
76518
b30b8e23383c clarified signature: more explicit types;
wenzelm
parents: 75491
diff changeset
    86
        val target = Isabelle_System.make_directory(component_dir.path + Path.explode(dir))
73317
df49ca5da9d0 clarified modules: more like ML;
wenzelm
parents: 73000
diff changeset
    87
        Isabelle_System.copy_file(jar_dir + Path.explode(file), target)
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    88
      }
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    89
78158
8b5a2e4b16d4 tuned signature;
wenzelm
parents: 77593
diff changeset
    90
      File.set_executable(component_dir.path + Path.explode("x86_64-windows/sqlitejdbc.dll"))
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
    91
    }
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    92
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
    /* logger jars */
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    95
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    96
    download(logger_url)
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
    97
    download(nop_name(logger_url))
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
    98
  }
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
  /* Isabelle tool wrapper */
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   102
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   103
  val isabelle_tool =
77566
2a99fcb283ee renamed administrative tools to build Isabelle components (unrelated to "isabelle build");
wenzelm
parents: 77035
diff changeset
   104
    Isabelle_Tool("component_sqlite", "build Isabelle sqlite-jdbc component from official download",
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   105
      Scala_Project.here,
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   106
      { args =>
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   107
        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
   108
        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
   109
        var logger_url = default_logger_url
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   110
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   111
        val getopts = Getopts("""
77566
2a99fcb283ee renamed administrative tools to build Isabelle components (unrelated to "isabelle build");
wenzelm
parents: 77035
diff changeset
   112
Usage: isabelle component_sqlite [OPTIONS] DOWNLOAD
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   113
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   114
  Options are:
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   115
    -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
   116
    -U URL       main URL
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   117
                 (default: """" + default_main_url + """")
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   118
    -V URL       logger URL
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   119
                 (default: """" + default_logger_url + """")
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   120
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   121
  Build sqlite-jdbc 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
   122
  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
   123
  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
   124
""",
76544
b10926dbb763 more standard component build process;
wenzelm
parents: 76543
diff changeset
   125
          "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
   126
          "U:" -> (arg => main_url = arg),
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   127
          "V:" -> (arg => logger_url = arg))
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   128
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   129
        val more_args = getopts(args)
76544
b10926dbb763 more standard component build process;
wenzelm
parents: 76543
diff changeset
   130
        if (more_args.nonEmpty) getopts.usage()
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   131
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   132
        val progress = new Console_Progress()
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   133
79506
dcddfe4f43a3 updated to sqlite-jdbc-3.45.0.0, including slf4j-1.7.36;
wenzelm
parents: 78287
diff changeset
   134
        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
   135
          progress = progress, target_dir = target_dir)
75394
42267c650205 tuned formatting;
wenzelm
parents: 75393
diff changeset
   136
      })
72346
93e533198bf6 build Isabelle sqlite-jdbc component from official download;
wenzelm
parents:
diff changeset
   137
}