package invidious

const createQueryVideos = `
CREATE TABLE IF NOT EXISTS videos (
    videoId TEXT PRIMARY KEY,
    title TEXT NOT NULL,
    description TEXT NOT NULL,
    uploader TEXT NOT NULL,
    duration int NOT NULL,
    url TEXT NOT NULL,
    timestamp DATETIME DEFAULT (datetime('now')),
    expire DATETIME NOT NULL
);`

const getVideoQuery = "SELECT * FROM videos WHERE videoId = (?);"

const cacheVideoQuery = "INSERT OR REPLACE INTO videos (videoId, title, description, uploader, duration, url, expire) VALUES (?, ?, ?, ?, ?, ?, ?);"

const clearQuery = "DELETE FROM videos;"