Page MenuHomeDevCentral
Create Task
Maniphest T2160

Read from Orbeon Forms and annotate with an Obsidian collection
Open, NormalPublic
Actions

Description

Plan:

  • Add support to PDO PostgreSQL in Keruald Databases -> D3804
  • Create a limited, read-only access for specific Orbeon views (and underlying table) -> D3817
  • Create a new application for Obsidian Workspaces "Orbeon Forms" or "Orbeon Forms reader"
    • Configuration -> P378
    • Read views from PostgreSQL -> D3835
    • Create a navigation for all the entries of a form -> D3835
    • Annotate with a collection
  • Deploy to obsidian.n.o (subdomain still to create)

Revisions and Commits

rKERUALD Keruald libraries development repository
D3804rKERUALD2c856afe0202 Support PDO PostgreSQL
rOPS Nasqueron Operations
D3871rOPS47112fed3d75 Allow Obsidian to read Orbeon attachment table
D3815rOPS71f3e3e60397 Create PostgreSQL user for Obsidian Worspaces
D3817rOPSf0926ba01bc5 Define ORBEON_DB_* entries to Obsidian .env
D3816rOPS25e8202bcd7b Allow several DB_ entries in .env
rKDB Keruald Database
D3804rKDB17c68efa8844 Support PDO PostgreSQL
rOBSIDIAN Obsidian Workspaces
D3835rOBSIDIAN329bc358fc01 Read from Orbeon Forms
D3826rOBSIDIAN7d698fd913a6 Add onAfterInitialize event method

Related Objects
Search...

Event Timeline

dereckson triaged this task as Normal priority.Oct 27 2025, 21:00
dereckson created this task.
dereckson added commits: rKDB17c68efa8844: Support PDO PostgreSQL, rKERUALD2c856afe0202: Support PDO PostgreSQL.
dereckson added a revision: D3804: Support PDO PostgreSQL.
dereckson updated the task description. (Show Details)Oct 27 2025, 21:05
dereckson added a revision: D3815: Create PostgreSQL user for Obsidian Worspaces.Oct 27 2025, 22:07
dereckson added a revision: D3816: Allow several DB_ entries in .env.Oct 28 2025, 01:20
dereckson added a revision: D3817: Define ORBEON_DB_* entries to Obsidian .env.Oct 28 2025, 01:22
dereckson added a commit: rOPS25e8202bcd7b: Allow several DB_ entries in .env.Oct 29 2025, 21:26
dereckson added a commit: rOPSf0926ba01bc5: Define ORBEON_DB_* entries to Obsidian .env.
dereckson added a revision: D3826: Add onAfterInitialize event method.Oct 29 2025, 22:41
dereckson added a commit: rOBSIDIAN7d698fd913a6: Add onAfterInitialize event method.Oct 29 2025, 22:41
dereckson updated the task description. (Show Details)Oct 29 2025, 22:42
dereckson updated the task description. (Show Details)

YAML configuration for namespace nasqueron-join using the new application:

P378 workspace.yml
1_pdo_fetch_modes:
2 assoc: &fetch_mode_assoc 2
3
4applications:
5 - bind: forms
6 icon: list-alt
7 name: Waystone\Apps\OrbeonForms\Reader\Application
8 nav: Forms
9 orbeonDatabase:
10 engine: Keruald\Database\Engines\PostgreSQLPDOEngine
11 host: !env ORBEON_DB_HOST
12 username: !env ORBEON_DB_USER
13 password: !env ORBEON_DB_PASSWORD
14 database: forms
15 fetch_mode: *fetch_mode_assoc
16
17 forms:
18 - name: Nasqueron Contact Form
19 slug: contact-form
20 view: orbeon_f_nasqueron_j_contact_1
21 fields:
22 section_contact_contact_name: Name
23 section_contact_contact_mail: E-mail
24 section_contac_contact_usernam: Username
25
26 section_applic_application_sco: Scope
27 section_applic_application_int: Interests
28 section_applic_application_doc: Documents
29 section_applic_application_tex: Message
30 index:
31 - section_contact_contact_name
32 - section_contact_contact_mail
33 - section_applic_application_sco

dereckson added a commit: rOPS71f3e3e60397: Create PostgreSQL user for Obsidian Worspaces.Oct 29 2025, 22:46
dereckson updated the task description. (Show Details)Oct 29 2025, 22:47
dereckson updated the task description. (Show Details)
dereckson closed subtask T2164: Parse YAML configuration as Resolved.
dereckson updated the task description. (Show Details)Oct 30 2025, 20:29
dereckson added a revision: D3835: Read from Orbeon Forms.Oct 31 2025, 00:17
dereckson updated the task description. (Show Details)Oct 31 2025, 00:18
dereckson closed subtask T2169: Support prepared statement for PDO drivers as Resolved.Nov 2 2025, 00:59
dereckson added a commit: rOBSIDIAN329bc358fc01: Read from Orbeon Forms.Nov 2 2025, 01:03
dereckson moved this task from Backlog to Working on on the Obsidian board.Nov 2 2025, 01:04
dereckson added a comment.Nov 11 2025, 01:59

rOBSIDIAN329bc358fc01 refers to table orbeon_form_data_attach, permission is needed for that one too, but missing in rOPS (was a hotfix on Complector)

dereckson added a revision: D3871: Allow Obsidian to read Orbeon attachment table.Nov 11 2025, 02:01
dereckson added a commit: rOPS47112fed3d75: Allow Obsidian to read Orbeon attachment table.Nov 11 2025, 02:02
dereckson removed dereckson as the assignee of this task.Mon, Mar 23, 09:23

Unassigning this task to make it available for others.

As I'm not currently working actively on this issue, reset the assignee.

Contributions opportunity. If you’re interested, go ahead and assign yourself. I’m available to share context, review early approaches, or pair if helpful—just tag me.

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator