database.js

const { Client } = require('pg');
const fetch = require('node-fetch');

const dbConfig = {
  host: 'localhost',
  user: 'postgres',
  port: 5432,
  password: 'Insert',
  database: 'Insert'
};

const formatDate = () => {
  const now = new Date();
  const day = String(now.getDate()).padStart(2, '0');
  const month = String(now.getMonth() + 1).padStart(2, '0');
  const year = now.getFullYear();
  return `${day}-${month}-${year}`;
};

const logBitcoinPrice = async () => {
  const client = new Client(dbConfig);
  try {
    await client.connect();
    const response = await fetch('https://api.binance.com/api/v3/ticker/price?symbol=BTCUSDT');
    const data = await response.json();
    const price = Math.round(parseFloat(data.price));
    const date = formatDate();
    await client.query('INSERT INTO history (date, value) VALUES ($1, $2)', [date, price]);
    console.log(`Logged BTC price ${price} USD on ${date}`);
  } catch (err) {
    console.error('Error logging price:', err.message);
  } finally {
    await client.end();
  }
};

// Run every 10 seconds
setInterval(logBitcoinPrice, 10000);