CodeTutor AI

import hashlib
import sqlite3

def authenticate_user(username, password):
    # Connect to database
    conn = sqlite3.connect('users.db')
    cursor = conn.cursor()
    
    # Get user from database
    query = "SELECT * FROM users WHERE username = '" + username + "'"
    cursor.execute(query)
    user = cursor.fetchone()
    
    if user:
        # Check password
        stored_password = user[2]
        if password == stored_password:
            conn.close()
            return True
        else:
            conn.close()
            return False
    else:
        conn.close()
        return False

def hash_password(password):
    return hashlib.md5(password.encode()).hexdigest()

def create_user(username, password):
    conn = sqlite3.connect('users.db')
    cursor = conn.cursor()
    
    hashed_pw = hash_password(password)
    
    query = "INSERT INTO users VALUES (NULL, '" + username + "', '" + hashed_pw + "')"
    cursor.execute(query)
    conn.commit()
    conn.close()
    
    return "User created successfully"