import sqlite3
import random
from datetime import datetime, timedelta

conn = sqlite3.connect(r"C:\Users\Allan\Desktop\BDD_Allan\Reseau_soc.db")
cursor = conn.cursor()

start = datetime(2023, 1, 1, 0, 0, 0)
end = datetime(2023, 2, 2, 0, 0, 0)

cursor.execute("SELECT id FROM publications")
ids = cursor.fetchall()

for (pub_id,) in ids:
    delta = end - start
    random_seconds = random.randint(0, int(delta.total_seconds()))
    random_date = start + timedelta(seconds=random_seconds)
    formatted = random_date.strftime("%Y-%m-%d %H:%M:%S")
    cursor.execute("UPDATE publications SET date_publication = ? WHERE id = ?", (formatted, pub_id))

conn.commit()
conn.close()

print("Dates de publication modifiées avec succès.")