SchemaCrawler | Free database schema discovery and comprehension tool | DB Client library

I'm currently ugrading all my projects that use Schemacrawler. The last version I used was 15.06.01 and I'm upgrading to 16.9.4. A lot of changes were done, I'm looking for the object that replace LintedCatalog.java. The aim is to get the list of lints detected during a db analaysis.

The project I'm currently working on is : https://github.com/adriens/schemacrawler-additional-command-lints-as-csv.git, if you want to have a look.

Thanks in advance

I'd like to be able to get columns on which the table I'm getting metadata on has constraints. In order to do that, I'd have to look up the value of the columns field for a Constraint (or, in my case, MutableTableConstraint), and constraints are retrieved via table.tableConstraints call (or, in Java, getTableConstraints()).

However, whether the columns list is actually populated seems to depend on SchemaRetrievalOptions (or, more precisely, on the result of a informationSchemaViews.hasQuery(CONSTRAINT_COLUMN_USAGE) call in method retrieveTableConstraintsColumns in file TableConstraintRetriever.java of the SchemaCrawler sources; informationSchemaViews seems to be constructed from SchemaRetrievalOptions in some way), which is constructed from the connection parameter of the SchemaCrawlerUtility.getCatalog() method, unlike SchemaCrawlerOptions, which are constructed manually by the user.

SchemaRetrievalOptions depend on the particular DB that is used: if the schemacrawler-postgresql dependency is included, the options will depend on the contents of that .jar file; and that file has files like postgresql.information_schema/CHECK_CONSTRAINTS.sql, etc, which is where some of the retrieval options come from.

So, the question is, is there a way for me to influence, programmatically, SchemaRetrievalOptions, to include an option for CONSTRAINT_COLUMN_USAGE? Apparently the command line interface of SchemaCrawler can achieve this by using a config file, but I'm using the Java API and the .jar files corresponding to each DB dialect, and I can't really manually update the .jar with the .sql file containing the SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE query that I need (I mean, for local usage I can, but not for distribution).

(SchemaCrawler version: 16.9.3)

Per this question and its comments, in order to obtain constraints (I'm particularly interested in check constraints), one must do the following:

1. Include a .jar corresponding to their DB driver of choice, like schemacrawler-postgresql or schemacrawler-sqlite.

2. Set detail level to detailed (or higher), like so:

I am trying to use SchemaCrawler to extract schema information on db2 test database.

When running the schema command with text or html format, things work as expected:

I'm trying to create a Java code that creates a nifi customized processor ! so in order to do that I need to use windows cmd windows and launch mvn archetype:generate then choose the modele nifi by typing nifi then choose the project by typing1 the I need to write the groupeId, the artifact ...

I need to do all that automatically by using a java code : I tryed this code :

I am working on a Rails application where I need to add some of the Foreign keys for existing columns from Rails migrations and few people working on same as well. I am adding this way:

When I add this to the pom.xml:

If we have oldDatabase and newDatabase. In newDatabase table cats was renamed to kittens and was added extra table puppies. Would SchemaCrawler be able to transfer data from oldDatabase to newDatabase, recognising new table names and if there are any extra fields, just leaving them empty?

I'm using SQLite/Hibernate. Idea is to check each time app starts whether database structure is up to date. I have my existing database in "DB" folder and each time app start I'm creating up to date database in "DB/structure" folder.

I want to compare them and if my existing database is old, copy data to up to date database. Get rid of old database and move fresh one in it's place.

So far I've tried SchemaCrawler, but I was getting errors with it and couldn't figure it out.

UPDATE:

I connected with SchemaCrawler to both databases: