Is it necessary to create test database in distributing assembly scripts?

[qyl27]

Description

I am trying to build SchemaCrawler in riscv64 platform which has no sqlite-jdbc native library build.
Maybe I should continue distributing assembly without SQLite jdbc driver, but I found the script for creating SQLite test database in the distributing assembly script.

SchemaCrawler/schemacrawler-distrib/src/assembly/distribution.xml

Lines 81 to 97 in c69049f

	<!-- Create SQLite test database -->
	<java classname="schemacrawler.testdb.TestSchemaCreatorMain"
	failonerror="true">
	<arg value="--url" />
	<arg value="jdbc:sqlite:${schemacrawler.base-distribution}/sc.db" />
	<classpath>
	<fileset dir="${SchemaCrawler.home}/schemacrawler-testdb/target">
	<include name="schemacrawler-testdb-${SchemaCrawler.version}.jar" />
	</fileset>
	<fileset dir="${SchemaCrawler.home}/schemacrawler-utility/target">
	<include name="schemacrawler-utility-${SchemaCrawler.version}.jar" />
	</fileset>
	<fileset dir="${schemacrawler.base-distribution}/lib">
	<include name="**/*.jar" />
	</fileset>
	</classpath>
	</java>

Is the test database necessary in runtime, or just for testing?

How to Reproduce

No response

Relevant log output

No response

SchemaCrawler Version

16.21.4

Java Version

openjdk 17

Operating System and Version

Arch Linux

Relational Database System and Version

SQLite

JDBC Driver and Version

N/A

[sualeh]

@qyl27 The SchemaCrawler distribution may build way more than you need. SQLite is definitely not needed if you do not need it. Only build the submodules that you need and comment out the rest in the aggregator POM. I can guide you if you let me know exactly what functionality you need to use.

[sualeh]

You need to comment out everywhere where SQLite is used. Please search through every *.xml file in the source tree to find references.

[qyl27]

My pr for sqlite-jdbc to support RISC-V is merged, and ver 3.46.0.1 was released, would you like to update it in the source?

[sualeh]

Yes, I will be releasing SchemaCrawler soon with the new SQLite JDBC driver version. Stay tuned. Please send me a link to your PR as well.

[sualeh]

xerial/sqlite-jdbc#1150

[qyl27]

Thank you.

[sualeh]

Also, the new SchemaCrawler will support compiling in Java 21. It will still generate Java 8 class files, though.

[sualeh]

@qyl27 Please use SchemaCrawler v16.22.1