This example shows how to implement a REST API with TypeScript using Hono / Sutando / Cloudflare Workers / Cloudflare D1.

Clone this repository:

git clone git@github.com:sutandojs/sutando-examples.git --depth=1

Install npm dependencies:

cd sutando-examples/typescript/rest-hono-cf-d1
npm install

Run the command to create your D1 database

npx wrangler d1 create test-sutando

Update wrangler.toml database_id

Import test data to local database

npx wrangler d1 execute test-sutando --local --file=./migrations/0000_lucky_gideon.sql 

npm run dev --local

The server is now running on http://localhost:8787. You can send the API requests implemented in index.js, e.g. http://localhost:8787/posts.

You can access the REST API of the server using the following endpoints:

• /posts/:id: Fetch a single post by its id
• /posts?searchString={searchString}&page={page}&perPage={perPage}&orderBy={orderBy}: Fetch all published posts
  • Query Parameters
    • searchString (optional): This filters posts by title or content
    • page (optional): This specifies which page should be returned to
    • perPage (optional): This specifies how many objects should be returned per page
    • orderBy (optional): The sort order for posts in either ascending or descending order. The value can either asc or desc
• /users/:id/drafts: Fetch user's drafts by their id
• /users: Fetch all users

• /posts: Create a new post
  • Body:
    • title: String (required): The title of the post
    • content: String (optional): The content of the post
    • authorEmail: String (required): The email of the user that creates the post
• /users: Create a new user
  • Body:
    • email: String (required): The email address of the user
    • name: String (optional): The name of the user

• /publish/:id: Toggle the publish value of a post by its id
• /posts/:id/views: Increases the views_count of a Post by one id

• /posts/:id: Delete a post by its id

• Check out the Sutando docs
• Create issues and ask questions on GitHub