[AI] Undefined in Database Single Query

Wappler General Bugs
1

OS info

  • Operating System : Windows 10.0.19045
  • Wappler Version : 7.0.0-rc.4

Problem description

AI Manager generated.

wappler-single-query-undefined
wappler-single-query-undefined1020×600 60.7 KB

{
        "name": "query",
        "module": "dbconnector",
        "action": "single",
        "options": {
          "connection": "db",
          "sql": {
            "type": "SELECT",
            "columns": [
              {
                "table": "vendors",
                "column": "*"
              }
            ],
            "table": {
              "name": "vendors"
            },
            "joins": [],
            "query": "SELECT * FROM vendors WHERE id = :P1",
            "params": [
              {
                "operator": "equal",
                "type": "expression",
                "name": ":P1",
                "value": "{{$_POST.id}}",
                "test": ""
              }
            ],
            "wheres": [
              {
                "id": "vendors.id",
                "type": "expression",
                "operator": "equal",
                "value": "{{$_POST.id}}",
                "data": {
                  "table": "vendors",
                  "column": "id"
                }
              }
            ]
          }
        },
2

For this bug report I expect Wappler to have more strict validation to the generated DB query step JSON