SQL_CALC_FOUND_ROWS don't work?

[leandrocombr]

Is there a way to use

SELECT SQL_CALC_FOUND_ROWS
column ORDER BY ASC LIMIT 5 OFFSET 0;
SELECT FOUND_ROWS();

no Mojo::mysql?

I already searched and couldn't find it, chatGPT just gives wrong codes

[Grinnz]

You can pass any custom query to ->query or ->query_p.

[leandrocombr]

->query_p

[leandrocombr]

    # Consulta SQL
    my $query = 'SELECT SQL_CALC_FOUND_ROWS column FROM `table` ORDER BY `column` ASC LIMIT 5 OFFSET 0';

    # Executa a consulta assíncrona com promessas
    my $dataPromise = $mysql->db->query_p($query)->then(sub {
        my $results = shift;
        my $resultado = $results->hashes->to_array;
        my $totalFiltrado = scalar @$resultado;

        # Consulta para obter o total de registros encontrados
        return $mysql->db->query_p('SELECT FOUND_ROWS()')->then(sub {
            my $found_rows = shift;
            my $totalRegistros = $found_rows->array->[0];

            # Renderiza a resposta JSON
            return $sel->render(json => { 
                data => $resultado, 
                totalRegistros => $totalRegistros, 
                totalFiltrado => $totalFiltrado 
            });
        });
    })->catch(sub {
        # Tratamento de erro
        my $error = shift;
        return $sel->render(json => { error => 'Erro na consulta: ' . $error });
    });