Component Details
appmixer.postgres.db.UpdateRow
1.0.0
Public
Dynamic fields loaded from /component/appmixer/postgres/db/ListColumns?outPort=columns
{ "name": "appmixer.postgres.db.UpdateRow", "author": "Appmixer <info@appmixer.com>", "description": "Update an existing row in PostgreSQL database table.", "private": false, "auth": { "service": "appmixer:postgres" }, "properties": { "schema": { "properties": { "table": { "type": "string" } }, "required": [ "table" ] }, "inspector": { "inputs": { "table": { "type": "text", "label": "Table", "index": 1, "source": { "url": "/component/appmixer/postgres/db/ListTables?outPort=tables", "data": { "transform": "./ListTables#toSelectArray" } } } } } }, "inPorts": [ { "name": "row", "inspector": { "inputs": { "filter": { "type": "expression", "label": "Filter", "tooltip": "Specify a WHERE condition.", "index": 1, "levels": [ "AND", "OR" ], "fields": { "column": { "type": "text", "label": "Column", "index": 1, "source": { "url": "/component/appmixer/postgres/db/ListColumns?outPort=columns", "data": { "properties": { "table": "properties/table" }, "transform": "./ListColumns#columnsToSelectArray" } } }, "operator": { "type": "select", "label": "Operator", "defaultValue": "=", "index": 2, "options": [ { "label": "Equal", "value": "=" }, { "label": "Greater than", "value": ">" }, { "label": "Less than", "value": "<" }, { "label": "Greater than or equal", "value": ">=" }, { "label": "Less than or equal", "value": "<=" }, { "label": "Not equal", "value": "<>" }, { "label": "Contains", "value": "CONTAINS" }, { "label": "Does not contain", "value": "NOT CONTAINS" }, { "label": "Starts with", "value": "STARTS WITH" }, { "label": "Does not start with", "value": "NOT STARTS WITH" }, { "label": "Ends with", "value": "ENDS WITH" }, { "label": "Does not end with", "value": "NOT ENDS WITH" }, { "label": "Matches any value in a list (comma-separated)", "value": "IN" }, { "label": "Matches any value not in a list (comma-separated)", "value": "NOT IN" }, { "label": "Matches a pattern", "value": "LIKE" }, { "label": "Does not matche a pattern", "value": "NOT LIKE" }, { "label": "Is Null", "value": "IS NULL" }, { "label": "Is Not Null", "value": "IS NOT NULL" } ] }, "value": { "type": "text", "label": "Value", "index": 3, "when": { "in": { "./operator": [ "=", ">", "<", ">=", "<=", "<>", "CONTAINS", "NOT CONTAINS", "STARTS WITH", "NOT STARTS WITH", "ENDS WITH", "NOT ENDS WITH", "IN", "NOT IN", "BETWEEN", "NOT BETWEEN", "LIKE", "NOT LIKE" ] } } } } } } }, "source": { "url": "/component/appmixer/postgres/db/ListColumns?outPort=columns", "data": { "properties": { "table": "properties/table" }, "transform": "./ListColumns#columnsToInspectorUpdate" } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Row Count", "value": "rowCount", "schema": { "type": "integer", "example": 1 } } ] } ], "icon": "data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCAyMDAgMjA2Ij48ZyB0cmFuc2Zvcm09InRyYW5zbGF0ZSgwLjAwMDAwMCwyMDYuMDAwMDAwKSBzY2FsZSgwLjEwMDAwMCwtMC4xMDAwMDApIiBmaWxsPSIjMDAwMDAwIj48cGF0aCBkPSJNMTI4MCAyMDQ0IGMtNDQgLTkgLTk4IC0xMiAtMTcwIC04IC0xMTQgNyAtMTkzIC00IC0yNzIgLTM4IGwtNDYgLTIwIC04NCAyMiBjLTEwNSAyOCAtMjkzIDM4IC0zNjkgMjAgLTI1NyAtNjAgLTM3OSAtMjkzIC0zMjQgLTYyMSA3MiAtNDM0IDIyMSAtNzg3IDM1OSAtODUzIDQ3IC0yMiAxMjMgLTIxIDE2MyA0IGwzMyAyMCAzNSAtMjQgYzYzIC00MyAyMjcgLTYwIDI5NyAtMzEgMTQgNiAxNyAtNSAyMiAtODIgMjUgLTM1MSAxMjIgLTQ2OSAzNDggLTQyMiAyMDIgNDMgMjg3IDE3MSAzMDYgNDY0IGw3IDEwMCA3NiA2IGMyMzQgMTkgNDA0IDE3MCAzMTQgMjc3IC0zMSAzNyAtNjIgNDQgLTE0OCAzMCAtMzcgLTYgLTY5IC05IC03MiAtNyAtMiAyIDI1IDYyIDYwIDEzMyAxMTcgMjM2IDE4MSA0NzMgMTczIDY0NiAtNSAxMTggLTIyIDE1MyAtMTEyIDIzNyAtMTQ4IDEzOSAtMzczIDE5NCAtNTk2IDE0N3oiLz48L2c+PGcgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoMC4wMDAwMDAsMjA2LjAwMDAwMCkgc2NhbGUoMC4xMDAwMDAsLTAuMTAwMDAwKSIgZmlsbD0iI2ZmZmZmZiI+PHBhdGggZD0iTTEyODggMTk5NSBjLTM3IC04IC03MiAtMTYgLTc3IC0xOSAtNCAtMyAtNDcgMCAtOTMgNiAtMTAzIDE0IC0xOTUgMiAtMjcyIC0zNiBsLTUxIC0yNSAtODUgMjYgYy0xMzIgNDEgLTM0OCA0MCAtNDM4IC0xIC0xMjEgLTU2IC0xOTAgLTE2MiAtMjEzIC0zMjQgLTMzIC0yMzQgMTM1IC04MjAgMjc4IC05NzMgOTIgLTk4IDE1OCAtODkgMjY3IDQwIDExMiAxMzMgMTE0IDEzNCAxNzUgMTE4IGw1MyAtMTQgLTIzIC0yNiBjLTE3IC0xOSAtNDcgLTM0IC05OSAtNDggLTgzIC0yMyAtMTEwIC00MSAtMTEwIC03NCAwIC04MSAyMDEgLTExOSAzMTEgLTU5IGw1NCAzMCAtMyAtMzIgYy05IC03NiAxOCAtMzQ1IDM5IC0zOTQgNTkgLTEzNyAyMDAgLTE3NiAzNTYgLTk5IDEwOSA1MyAxMzMgMTAyIDE2NCAzNDMgMTEgODggMjIgMTcxIDI1IDE4MiAzIDIwIDEyIDIyIDEwNyAyNiAxMjAgNSAxODcgMzAgMjU1IDk1IDQ1IDQzIDUwIDU4IDI5IDg3IC0xNSAyMSAtMzIgMjIgLTE1MyAxMSAtNDUgLTQgLTkzIC01IC0xMDggLTEgbC0yNiA2IDM3IDU3IGMxNDMgMjI1IDI2NyA2MTQgMjQ5IDc4NiAtMjMgMjIzIC0zMzYgMzc0IC02NDggMzEyeiIvPjwvZz48ZyB0cmFuc2Zvcm09InRyYW5zbGF0ZSgwLjAwMDAwMCwyMDYuMDAwMDAwKSBzY2FsZSgwLjEwMDAwMCwtMC4xMDAwMDApIiBmaWxsPSIjMzM2NzkxIj48cGF0aCBkPSJNMTM5MyAyMDAzIGMyNiAtMiA2OCAtMiA5NSAwIDI2IDIgNCAzIC00OCAzIC01MiAwIC03NCAtMSAtNDcgLTN6IE0xMzM4IDE5NDMgYy0yMSAtMiAtMzggLTkgLTM4IC0xNSAwIC01IDggLTcgMTcgLTQgMTAgNCAxNCA0IDExIDAgLTQgLTMgMTkgLTIzIDUwIC00NCAxMDIgLTY2IDIwNiAtMTk0IDI1MyAtMzEyIDE5IC00NyAyMCAtNjMgMTMgLTE0OCAtOCAtMTAyIC04IC0xMzMgLTMgLTMxMCA0IC0xMDIgMiAtMTIwIC0xOCAtMTYzIC0xNCAtMjkgLTE4IC00NyAtMTAgLTQ0IDYgMiAxMSAxMCAxMCAxNiAtMiA2IDEgMTEgNiAxMSAxNSAwIDk1IDE1NSAxNDQgMjgwIDc4IDE5OCAxMTYgMzg5IDk3IDQ5MyAtOCA0NSAtMTcgNTkgLTY5IDEwOCAtMTE2IDExMSAtMjYzIDE1MyAtNDYzIDEzMnogTTk1MCAxOTE3IGMtMTY3IC0zOCAtMjY3IC0xNzMgLTMwNSAtNDE0IGwtNyAtNDMgNDUgMjAgYzIxMyA5NCAzMTEgOSAzMTEgLTI3MCBsMSAtMTI1IC00OCAtMTE3IGMtNTIgLTEyNyAtNTIgLTEyOCAtMzYgLTEyOCA1IDAgOCA0IDUgOSAtNCA1IDEyIDEgMzQgLTEwIDczIC0zNSA3NCAtNDIgODAgLTMyNCA2IC0yMzQgNyAtMjUzIDI5IC0zMDMgNDMgLTk1IDExMCAtMTIwIDIyOSAtODMgMTMzIDQwIDE1NSA5NiAxOTIgNDg2IDE1IDE1NyAyNCAxOTEgNTggMjEyIDE1IDkgMjkgMTggMzEgMjAgMyAyIC01IDE2IC0xNiAzMSAtMzcgNTAgLTE2MSAyOTUgLTE4MyAzNjIgLTU5IDE3NyAtMyAyODAgMTU0IDI4MCA0MCAwIDY2IDQgNjYgMTEgMCA1IC01IDcgLTEyIDMgLTcgLTQgLTggLTMgLTQgNCAyMiAzNyAtMTM0IDIzOCAtMjM0IDMwMiAtMTA4IDY5IC0yNzYgMTAyIC0zOTAgNzd6IE0zNTQgMTkxMSBjLTI0NyAtNjQgLTI5NSAtMzAxIC0xNTkgLTc5NSA4NiAtMzEzIDE5OSAtNTA1IDI3OCAtNDY5IDEyIDYgNjQgNTggMTE0IDExNSBsOTIgMTA1IC0yOSAyOCBjLTM3IDM2IC02OSAxMTAgLTcwIDE2NiAtOCA0MjYgMjMgNjE5IDEyNiA3NjEgMTkgMjggMzQgNTEgMzIgNTMgLTI4IDI3IC0zMTUgNTQgLTM4NCAzNnogTTE0NTUgMTQ1NiBjLTg1IC0zNyAtNjYgLTE2NSA1NyAtMzk0IDcwIC0xMzEgNzIgLTEyOCA3NCAxNDggMSAxMTggMyAyMjQgNSAyMzUgNCAxOCAtMiAyMCAtNTEgMjIgLTMwIDIgLTY5IC0zIC04NSAtMTF6IG04MSAtMjggYzkgLTE1IC0yOCAtNDkgLTQ5IC00NiAtMjUgNCAtNDggMzkgLTI5IDQ1IDYgMyAxMCA4IDggMTIgLTMgNCAxMSA1IDMwIDMgMTkgLTIgMzcgLTggNDAgLTE0eiBNNzQ0IDE0NDYgYy0yMiAtNyAtNTQgLTIxIC03MSAtMzEgbC0zMCAtMTggLTYgLTE3NCBjLTMgLTExNCAtMiAtMTg2IDYgLTIwNiAyOCAtODMgOTkgLTE0OCAxNjQgLTE1MiBsMzcgLTMgNDUgMTEyIGM1MSAxMjYgNjQgMjQxIDQyIDM2NiAtMjEgMTE0IC03MSAxNDIgLTE4NyAxMDZ6IG0xNDQgLTM5IGM2IC01IDEyIC02IDEyIC0yIDAgNSAzIDUgNiAyIDEwIC0xMCAtMzggLTQ2IC02MCAtNDcgLTIyIDAgLTU2IDI3IC01NiA0NiAwIDI0IDY4IDI1IDk4IDF6IE0xNTgyIDc4OSBjLTEyIC01IC0yMiAtMTEgLTIyIC0xNCAwIC00IDYgLTMgMTMgMCA2IDQgNCAwIC02IC04IC0xMSAtOSAtMTcgLTI1IC0xNSAtMzkgNyAtNDkgMjUxIC0yMCAyOTcgMzYgOCA5IC0xMiAxMSAtODIgOCAtNjYgLTMgLTEwMiAwIC0xMjcgMTAgLTIzIDEwIC00MyAxMiAtNTggN3ogTTg2MyA3MzcgYy0zOSAtNDEgLTYxIC01NiAtOTkgLTY2IC0yNyAtNyAtNjAgLTE3IC03NCAtMjEgbC0yNSAtOCAyOCAtMTEgYzEzMiAtNTIgMzQ0IDY1IDI1OSAxNDIgLTI3IDI1IC0zMyAyMiAtODkgLTM2eiBNOTQ5IDYxMyBjLTkgLTEwIC05IC0xNCAtMiAtMTAgOSA2IDEzIC0xMiAxNiAtNjUgbDMgLTczIDEgODMgYzAgNDUgLTEgODIgLTIgODIgLTEgMCAtOSAtOCAtMTYgLTE3eiIvPjwvZz48L3N2Zz4=" }