register.py

from flask import Flask
from markupsafe import escape
from flask import url_for
from flask import render_template
from flask import request
from flask import redirect
from flask import abort
from flask import make_response
import sqlite3

app = Flask(__name__)

  @app.route('/register', methods=['GET', 'POST'])

  

  def register():
      if request.method == 'POST':
          return do_the_registration(request.form['uname'], request.form['pwd'])
      else:
          return show_the_registration_form();

  def show_the_registration_form():
    return render_template('register.html',page=url_for('register'))

  def do_the_registration(u,p):
    con = sqlite3.connect('registered_users.db')
    try:
        con.execute('CREATE TABLE users (name TEXT, pwd TEXT)')
        #print ('Table created successfully');
    except:
        pass
    
    con.close()  
    
    con = sqlite3.connect('registered_users.db')
    con.execute("INSERT INTO users values(?,?);", (u, p))
    con.commit()
    con.close()  

    return show_the_login_form()