Skip to content

Create a API clone (Suggestion) #4

Description

@RodrigoNet0

Language Suggestion NodeJS

const express = require('express');
const sqlite3 = require('sqlite3').verbose();

const app = express();
const PORT = 3000;

// Database configuration
const db = new sqlite3.Database('database.db');

// Create users table (if not exists)
db.run('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, email TEXT)');

// Middleware to parse JSON request bodies
app.use(express.json());

// Endpoint to create a new user
app.post('/users', (req, res) => {
const { name, email } = req.body;

db.run('INSERT INTO users (name, email) VALUES (?, ?)', [name, email], function(err) {
    if (err) {
        return res.status(500).json({ error: err.message });
    }
    res.json({ message: 'User created successfully!', userId: this.lastID });
});

});

// Endpoint to get all users
app.get('/users', (req, res) => {
db.all('SELECT * FROM users', [], (err, rows) => {
if (err) {
return res.status(500).json({ error: err.message });
}
res.json({ users: rows });
});
});

// Start the server
app.listen(PORT, () => {
console.log(Server is running on port ${PORT});
});

  • Example by AI

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions