Packages

lotus

0.16.2
0.16.6 0.16.5 0.16.4 0.16.3 0.16.2 0.16.1 0.16.0 0.15.0 0.14.0 0.13.1 0.13.0 0.12.0 0.11.0 0.10.0 0.9.2 0.9.1 0.9.0 0.8.0 0.7.0 0.6.0 0.5.4 0.5.3 0.5.2 0.5.1 0.5.0 0.4.0 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.0

Embeddable business intelligence engine for Elixir — run SQL queries, build dashboards, and manage analytics directly in your Phoenix app with Ecto.

HexDocs

Current section

Files

Jump to
Readme
32 Versions
11 Dependencies
Dependants
Files
Activity
lotus lib lotus ai actions validate_sql.ex
Raw

lib/lotus/ai/actions/validate_sql.ex 

defmodule Lotus.AI.Actions.ValidateSQL do

  @moduledoc """

  Validates SQL syntax against the database without executing.



  Uses EXPLAIN to parse the query server-side, catching syntax errors

  and missing table/column references before the query is run.

  """



  @behaviour Lotus.AI.Action



  alias Lotus.SQL.Validator



  @impl true

  def name, do: "validate_sql"



  @impl true

  def description,

    do:

      "Validate SQL syntax against the database without executing it. " <>

        "Use this to check your query for syntax errors before returning it. " <>

        "Variables ({{var}}) and optional clauses ([[...]]) are handled automatically."



  @impl true

  def schema do

    [

      sql: [type: :string, required: true, doc: "The SQL query to validate"],

      data_source: [

        type: :string,

        required: true,

        doc: "Name of the data source to validate against"

      ]

    ]

  end



  @impl true

  def run(params, _context) do

    case Validator.validate(params.sql, params.data_source) do

      :ok ->

        {:ok, %{valid: true}}



      {:error, reason} ->

        {:ok, %{valid: false, error: reason}}

    end

  end

end