Creating schema file for use with gnatcoll_db2ada involving array

Creating schema file for use with gnatcoll_db2ada involving array

[Gavin McCord]

I've created a database (for invoicing purposes) in
postgresql (running on Slackware 14.2), with a few tables
and all is working so far.

Now I want to start using Ada (currently on GNAT 2020) as
the interface and also have managed to do basic querying.

But I come unstuck having added another table which
includes an array (in this case one of bigint).

Part of the schema file all-schema.txt) looks like this:


| TABLE        | invoices      | invoice      |        ||
| inv_num      | AUTOINCREMENT | PK, NOT_NULL |        || 
| inv_date     | TIMESTAMP     |              |        ||
| cust_id      | VARCHAR(15)   | NOT_NULL     | 'SHOP' ||
| item_list    | BIGINT[]      |              |        ||
| tot_price    | BIGINT        | NOT_NULL     | 0      ||
| posted       | BOOLEAN       | NOT_NULL     | FALSE  ||

The "item_list" column is where it falls down. The command:

  gnatcoll_db2ada -dbmodel all-schema.txt

Gives me the following:

  Error: unknown field type "BIGINT[]"
  all-schema.txt:33 gnatcoll-sql-inspect.adb:1420
  gnatcoll-sql-inspect.adb:1420

Is what I'm trying to do even possible?

Thanks for any assistance.

Gavin