CRUD GET

Get data from 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: "get",
            query: {
                limit: 10,
            },
        },
    })
    .then((response) => {
        console.log(response);
    });

Using curl:

CURL https://datasquirel.com/api/v1/social_network/users?limit=10 \
-H "Authorization:READ_ONLY_API_KEY"

Resulting SQL:

SELECT * FROM users LIMIT 10;

Return Response:

{
    success: true,
    payload: [
        {
            id: 1,
            name: "John",
            email: "[email protected]",
        },
        {
            id: 2,
            name: "Jane",
            email: "[email protected]",
        },
    ],
    "queryRes": {
        "string": "SELECT * FROM users LIMIT 10",
        "values": []
    }
}