backends.sql.query

query

This clause defines an SQL query operation that retrieves data from the database. The query clause is configured with a name.

Example configuration of a query:

# SQL query named "FIND_USER"
query "FIND_USER" {
    # SQL statement
    statement "SELECT USERID, PASSWORD FROM USERIDS WHERE USERID = ?";

    # Query argument binding in order
    bindings {
        aaa.identity;
    }

    # Result value mapping
    mapping {
        user.username = USERID;
        user.password = PASSWORD;
    }
}

query

Parents