Spaces:
Sleeping
Sleeping
File size: 3,217 Bytes
9837d3b | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | from flask import Flask, render_template, request, redirect, url_for, session
import sqlite3
import os
from werkzeug.security import generate_password_hash, check_password_hash
app = Flask(__name__)
app.secret_key = 'your_secret_key' # Replace with a secure key
# Database setup
def get_db_connection():
conn = sqlite3.connect('traffic_management.db')
conn.row_factory = sqlite3.Row
return conn
# Create database and users table if not exists
def init_db():
conn = get_db_connection()
conn.execute('''
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
password TEXT NOT NULL
)
''')
conn.commit()
conn.close()
# Initialize database
init_db()
# Upload folder setup
UPLOAD_FOLDER = 'uploads'
app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
if not os.path.exists(UPLOAD_FOLDER):
os.makedirs(UPLOAD_FOLDER)
# Routes
@app.route('/')
def index():
return render_template('index.html')
@app.route('/main')
def main_dashboard():
if 'username' not in session:
session['referrer'] = 'main'
return redirect(url_for('login'))
return render_template('main.html')
@app.route('/login', methods=['GET', 'POST'])
def login():
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
conn = get_db_connection()
user = conn.execute('SELECT * FROM users WHERE username = ?', (username,)).fetchone()
conn.close()
if user and check_password_hash(user['password'], password):
session['username'] = user['username']
redirect_page = session.pop('referrer', 'index')
return redirect(url_for(redirect_page))
else:
return render_template('login.html', error="Invalid username or password.")
else:
if 'referrer' not in session and request.referrer and 'login' not in request.referrer and 'signup' not in request.referrer:
session['referrer'] = request.referrer.split('/')[-1] or 'index'
return render_template('login.html')
@app.route('/signup', methods=['GET', 'POST'])
def signup():
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
confirm_password = request.form['confirm_password']
if password != confirm_password:
return "<script>alert('Passwords do not match!'); window.history.back();</script>"
hashed_password = generate_password_hash(password)
conn = get_db_connection()
try:
conn.execute('INSERT INTO users (username, password) VALUES (?, ?)', (username, hashed_password))
conn.commit()
return redirect(url_for('login'))
except sqlite3.IntegrityError:
return "<script>alert('Username already exists!'); window.history.back();</script>"
finally:
conn.close()
return render_template('signup.html')
@app.route('/logout')
def logout():
session.clear()
return redirect(url_for('index'))
if __name__ == '__main__':
app.run(host='0.0.0.0', port=7860, debug=True) |