Untitled

<body>
    <div class="m-6 p-12 text-white bg-gray-700 rounded-xl">
        <h1 class="font-bold text-6xl mb-12">
            Targetlist
        </h1>
        <span style="line-height: 3rem;" class="text-2xl">
            <py-script>
                import sqlite3 as sql

                con = sql.connect('products.db')
                c = con.cursor()

                amount = c.execute("SELECT COUNT(*) FROM targets").fetchone()[0]
                i = 1

                while i < amount+1:
                    print(c.execute("SELECT * FROM targets WHERE ID='"+str(i)+"'").fetchone())
                    i += 1

                con.close()
            </py-script>
        </span>
    </div>
    <div class="m-6 p-12 text-white bg-gray-700 rounded-xl">
        <h1 class="font-bold text-6xl mb-12">
            Neues Target
        </h1>
        <span style="line-height: 3rem;" class="text-2xl text-black">
            <input type="text" required id="url" placeholder="url">
            <input type="text" required id="shop" placeholder="shop">
            <input type="text" required id="size" placeholder="size">
            <input type="text" required id="releasedate" placeholder="releasedate tt/mm/jjjj">
            <input type="text" required id="releasetime" placeholder="releasetime ss:mm">
            <button type="button" class="text-white" id="submit">Registrieren</button>
            <py-script>
                from js import document
                from pyodide import create_proxy
                import sqlite3 as sql

                con = sql.connect('products.db')
                c = con.cursor()
                amount = c.execute("SELECT COUNT(*) FROM targets").fetchone()[0]
                new_id = amount+1

                def main(self):
                    url = document.getElementById("url").value
                    shop = document.getElementById("shop").value
                    size = document.getElementById("size").value
                    releasedate = document.getElementById("releasedate").value
                    releasetime = document.getElementById("releasetime").value
                    print(url + shop + size + releasedate + releasetime)
                    c.execute("INSERT INTO targets VALUES ("+str(new_id)+", '"+url+"', '"+shop+"', '"+size+"', '"+releasedate+"', '"+releasetime+"')")
                    con.commit()
                    con.close()

                function_proxy = create_proxy(main)
                document.getElementById("submit").addEventListener("click", function_proxy)
            </py-script>
        </span>
    </div>

</body>