get_rows_handler

axum_sql_viewer::api::rows

Function get_rows_handler 

Source 
pub async fn get_rows_handler<DB: DatabaseProvider>(
    __arg0: State<Arc<DB>>,
    __arg1: Path<String>,
    __arg2: Query<RowQuery>,
) -> Response
Expand description

Handler for GET /api/tables/:name/rows

Fetches rows from a table with pagination, sorting, and filtering.

Query parameters:

  • offset: Starting row offset (default: 0)
  • limit: Maximum rows to return (default: 100, max: 500)
  • sortBy: Column name to sort by (optional)
  • sortOrder: “ascending” or “descending” (optional, default: “ascending”)
  • filtercolumn: Filter value for specific column (supports % wildcards)

§Arguments

  • database - Database provider from state
  • table_name - Name of the table to fetch rows from
  • query - Query parameters for pagination, sorting, and filtering

§Returns

JSON response containing rows, columns, and pagination metadata