Nodejs Programming Tutorials, Guides & Best Practices

Now that the "accounts" table is set up, you can insert data into it. This process involves preparing an SQL statement and executing it with the desired values.

Add the following code to your app.js file within the db.serialize() block, after the table creation:

In the PostController (app/Http/Controllers/PostController.php), define methods to manage posts:

namespace App\Http\Controllers;

use App\Models\Post;
use Illuminate\Http\Request;

class PostController extends Controller
{
    public function index()
    {
        return Post::all();
    }

    public function store(Request $request)
    {
        $post = Post::create($request->all());
        return response()->json($post, 201);
    }

    public function show($id)
    {
        return Post::findOrFail($id);
    }

    public function update(Request $request, $id)
    {
        $post = Post::findOrFail($id);
        $post->update($request->all());
        return response()->json($post, 200);
    }

    public function destroy($id)
    {
        Post::destroy($id);
        return response()->json(null, 204);
    }
}

• Add a Book

     mutation {
       addBook(title: "1984", author: "George Orwell") {
         title
         author
       }
     }