susom / database Goto Github PK

Are there any plans to add support to array arguments to be passed onto queries?

Using PK sequences is error prone, as nothing prevents the user from accidentally specifying the wrong sequence in a call to argPkSeq. Identity columns are supported by almost all of the databases.

On the insert side, the API might be insertReturningPkDefault(columnName). For Schema, maybe have primaryKeyDefaultIdentity or just primaryKeyIdentity.

It would be very great to add this nice project to vertx-awesome page!

Not sure if this is a bug or if I'm calling Schema() incorrectly:

new Schema().addTable("raw_log")
    .addColumn("upload_uuid").asString(64).primaryKey()
    .table().addColumn("subject_uuid").asString(64)
    .table().addColumn("study_uuid").asString(64)

    .schema().addTable("payload")
    .addColumn("upload_uuid").asString(64).foreignKey("upload_uuid").references("raw_log")
    .table().addColumn("size").asInteger()
    .table().addColumn("key").asString(1024)

    .schema().addTable("kv")
    .addColumn("upload_uuid").asString(64).foreignKey("upload_uuid").references("raw_log")
    .table().addColumn("size").asInteger()
    .table().addColumn("key").asString(1024)

    .schema().addTable("key_value_pairs")
    .addColumn("upload_uuid").asString(64).foreignKey("upload_uuid").references("raw_log")
    .table().addColumn("file").asString(1024)

    .schema().execute(db);

Fails with:
Caused by: org.postgresql.util.PSQLException: ERROR: relation "upload_uuid_ix" already exists.

Worked around this issue for now by adding .withoutForeignKeyIndexing() to the last two tables.

DebugSql.logMiddle calls printSql on query strings that have already had parameter substitution performed. If those strings had escaped parameter indicators (?? or ::), printSql sees them unescaped and thinks there are missing parameters.

would you make a blog post for vertx.io that introduces this new project ?

Looks like this repository has been highlighted as needing an upgrade to fix a security vulnerability in com.fasterxml.jackson.core:jackson-databind. We need to go to version 2.9.9.2 or later.