CRUD POST

Create data in your database

Using node/bun:

import datasquirel from "@moduletrace/datasquirel";

datasquirel.api
    .crud({
        database: "social_network",
        table: "users",
        key: process.env.READ_ONLY_API_KEY,
        params: {
            action: "insert",
            data: {
                name: "John",
                email: "[email protected]",
            },
        },
    })
    .then((response) => {
        console.log(response);
    });

Using curl:

CURL -X POST https://datasquirel.com/api/v1/social_network/users \
-H "Authorization:READ_ONLY_API_KEY" \
-H "Content-Type: application/json" \
-d '{"name": "John", "email": "[email protected]"}'

Resulting SQL:

INSERT INTO users (name, email) VALUES ('John', '[email protected]');

Return Response:

{
    success: true,
    payload: {
        insertId: 1,
        affectedRows: 1,
        info: "",
        serverStatus: 2,
        warningStatus: 0,
    },
    "queryRes": {
        "string": "INSERT INTO users (name, email) VALUES (?, ?)",
        "values": ["John", "[email protected]"]
    }
}