seed.py

import sqlite3

from flask import Blueprint

seed_db = Blueprint("seed", __name__)


@seed_db.cli.command("create-tables")
def create_tables():
    connection = sqlite3.connect("webmentions.db")

    with connection:
        cursor = connection.cursor()

        cursor.execute(
            """CREATE TABLE webmentions (
            id integer primary key autoincrement,
            source,
            target,
            property,
            contents,
            author_name,
            author_photo,
            author_url,
            content_html,
            received_date,
            status,
            vouch,
            
            approved_to_show integer default 0);
        """
        )

        cursor.execute(
            """CREATE TABLE sent_webmentions (
            id integer primary key autoincement,
            source,
            target,
            sent_date,
            status_code,
            response,
            webmention_endpoint);
        """
        )

        cursor.execute(
            """CREATE TABLE pending_webmentions (
            id integer primary key autoincrement,
            to_check);
        """
        )

        cursor.execute(
            """CREATE TABLE webhooks (
            feed_url text,
            last_url_sent text);
        """
        )

        cursor.execute(
            """CREATE TABLE vouch (
            domain text,
            added_date text);
        """
        )

    print("created database tables")