Improve query when getting consuming GET /api/records

[mcruzdev]

Actually the query log is:

[Hibernate] 
    select
        count(*) 
    from
        records r1_0 
    where
        r1_0.userId=?

[Hibernate] 
    select
        r1_0.id,
        r1_0.amount,
        r1_0.category,
        r1_0.createdAt,
        r1_0.description,
        r1_0.transaction,
        r1_0.userId 
    from
        records r1_0 
    where
        r1_0.userId=? 
    offset
        ? rows 
    fetch
        first ? rows only

[Hibernate] 
    select
        r1_0.id,
        r1_0.amount,
        r1_0.category,
        r1_0.createdAt,
        r1_0.description,
        r1_0.transaction,
        r1_0.userId 
    from
        records r1_0 
    where
        r1_0.userId=? 
        and r1_0.createdAt>=? 
        and r1_0.createdAt<=?

It would be great if we have it in a unique select.

[kotlalokeshwari098]

Hi @mcruzdev,
I’m exploring Spring Boot for backend development and would love to work on this issue to learn more.
As I’m new to the stack, is it okay if I reach out for guidance if needed?
Thank you!

[mcruzdev]

Hi @mcruzdev,
I’m exploring Spring Boot for backend development and would love to work on this issue to learn more.
As I’m new to the stack, is it okay if I reach out for guidance if needed?
Thank you!

Hello @kotlalokeshwari098, of course, please ping me with you need any help.

It is a Quarkus application, and we are using Hibernate ORM Panache https://quarkus.io/guides/hibernate-orm-panache

[kotlalokeshwari098]

Hi @mcruzdev,
I followed Execute the infrastructure and then Execute the timeless-api
I have everything running successfully, but during signup I am getting a timezone-related error.
I tried setting the timezone in application.properties, but it still doesn’t seem to work. Could you please advise how to fix this so that signup works correctly?

[mcruzdev]

Could you share with me the error? If you want, you do not need to execute the infrastructure to run locally (Ok, we have a gap in the documentation to explain how to do it)

You can set quarkus.sqs.devservices.enabled to true and Quarkus will execute the necessary infrastructure through a feature called DevService.

[mcruzdev]

Please, get the news commited changes, I added a default secret to avoid some problems when running locally.

[kotlalokeshwari098]

Hi @mcruzdev ,
I set the OPENAI_API_KEY and enabled quarkus.sqs.devservices.enabled=true as suggested. However, when running the app, it still fails with missing config errors for whatsapp.messages-processed.queue-url and whatsapp.incoming-messages.queue-url. Should these be explicitly set, or should DevServices handle them automatically?

[mcruzdev]

Hi @mcruzdev , I set the OPENAI_API_KEY and enabled quarkus.sqs.devservices.enabled=true as suggested. However, when running the app, it still fails with missing config errors for whatsapp.messages-processed.queue-url and whatsapp.incoming-messages.queue-url. Should these be explicitly set, or should DevServices handle them automatically?

Hi @kotlalokeshwari098, I think we need to create it manually using an script, take a look here https://docs.quarkiverse.io/quarkus-amazon-services/dev/dev-services.html#quarkus-amazon_quarkus-aws-devservices-localstack-init-scripts-folder

Again, we need to update the documentation for contributors that do not want to use a real service, I will create an issue for it, the same thing for OpenAI, we can use ollama locally.