connect to postgresql (existing db) and create endpoints

[agaitan026]

Any doc to connect to postgresql (existing db) and create endpoints with pagination limit offset? thank you

[ujjwalguptaofficial]

Current there is no doc for this, but allow me sometime - i will write a doc for this.

[ujjwalguptaofficial]

Here is link to the database guide - https://fortjs.net/docs/guides/database

I hope this helps - let me know what else do you need.

[ujjwalguptaofficial]

Here is a snippet for pagination -

class UserService {
  async getAllUsers(page = 1, pageSize = 10) {
    const offset = (page - 1) * pageSize;
    return User.findAll({
      offset,
      limit: pageSize,
    });
  }

  // ... other methods remain unchanged
}

[ujjwalguptaofficial]

You can check out rest examples for more clarification on end points - https://github.com/ujjwalguptaofficial/fortjs-examples/tree/master/rest

In the rest api, i am using the memory just replace with your database models.

Happy Coding. Feel free to ask anything.

[agaitan026]

You used a orm? I cant see the sql query just findall, what if i need to query a specific Id from a table and also create new record

[ujjwalguptaofficial]

yes i have used ORM but sql query can be also executed in the similar way. You can use CHATGPT also to generate sql query.

[ujjwalguptaofficial]

Please stargaze the repo and share with your friends. Every stars means a lot and motivate me.

[agaitan026]

Any other way for contact faster? Discord or slack maybe? Im looking to do many things with framework but need a hand. Its very faster btw thank you

[ujjwalguptaofficial]

I am available most of the time on github and looking out on discussion