index.js

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

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

// Connect to your SQLite database
let db = new sqlite3.Database('./db.sqlite', sqlite3.OPEN_READONLY, (err) => {
  if (err) {
    console.error(err.message);
  }
  console.log('Connected to the SQLite database.');
});

// Capture all incoming URLs
app.get('*', (req, res) => {
  const url = req.originalUrl;

  // Query the database for the incoming URL
  db.get(`SELECT redirectUrl FROM urls WHERE incomingUrl = ?`, [url], (err, row) => {
    if (err) {
      return console.error(err.message);
    }

    // If a match is found, redirect to the stored URL
    if (row) {
      res.redirect(row.redirectUrl);
    } else {
      // If no match is found, send a 404 response
      res.status(404).send('URL not found');
    }
  });
});

app.listen(port, () => {
  console.log(`App listening at http://localhost:${port}`);
});