Test Case: python-instruct-1761

  1import sqlite3  2​  3def create_player_profile(db_path):  4    """  5    Creates a new player profile in the database.  6​  7    Args:  8        db_path (str): The path to the SQLite database file.  9​ 10    Returns: 11        int: The player's ID. 12    """ 13​ 14    try: 15        conn = sqlite3.connect(db_path) 16        cursor = conn.cursor() 17​ 18        # Get user input 19        username = input("Enter username: ") 20        password = input("Enter password: ") 21        first_name = input("Enter first name: ") 22        last_name = input("Enter last name: ") 23        email = input("Enter email: ") 24        acl_number = input("Enter ACL number: ") 25        district_id = input("Enter district ID: ") 26​ 27        # Insert player information into the players table 28        cursor.execute( 29            """ 30            INSERT INTO players (username, password, first_name, last_name, email, acl_number, district_id) 31            VALUES (?, ?, ?, ?, ?, ?, ?) 32            """, 33            (username, password, first_name, last_name, email, acl_number, district_id), 34        ) 35​ 36        # Get the player's ID 37        player_id = cursor.lastrowid 38​ 39        # Create a new player statistics entry 40        cursor.execute( 41            """ 42            INSERT INTO player_statistics (player_id) 43            VALUES (?) 44            """, 45            (player_id,), 46        ) 47​ 48        # Commit the changes to the database 49        conn.commit() 50​ 51        print(f"Player profile created successfully with ID: {player_id}") 52        return player_id 53​ 54    except sqlite3.Error as e: 55        print(f"Database error: {e}") 56        return None 57​ 58    finally: 59        if conn: 60            conn.close() 61​ 62​ 63if __name__ == "__main__": 64    # Example usage: 65    db_file = "mydatabase.db"  # Replace with your database file path 66​ 67    # Create the tables if they don't exist (example) 68    conn = sqlite3.connect(db_file) 69    cursor = conn.cursor() 70​ 71    cursor.execute( 72        """ 73        CREATE TABLE IF NOT EXISTS players ( 74            player_id INTEGER PRIMARY KEY AUTOINCREMENT, 75            username TEXT NOT NULL UNIQUE, 76            password TEXT NOT NULL, 77            first_name TEXT, 78            last_name TEXT, 79            email TEXT, 80            acl_number TEXT, 81            district_id INTEGER 82        ) 83        """ 84    ) 85​ 86    cursor.execute( 87        """ 88        CREATE TABLE IF NOT EXISTS player_statistics ( 89            statistic_id INTEGER PRIMARY KEY AUTOINCREMENT, 90            player_id INTEGER NOT NULL, 91            games_played INTEGER DEFAULT 0, 92            wins INTEGER DEFAULT 0, 93            losses INTEGER DEFAULT 0, 94            FOREIGN KEY (player_id) REFERENCES players(player_id) 95        ) 96        """ 97    ) 98​ 99    conn.commit()100    conn.close()101​102    player_id = create_player_profile(db_file)103​104    if player_id:105        print(f"New player created with ID: {player_id}")106    else:107        print("Failed to create player profile.")

None

  1from django.contrib.auth.hashers import make_password  2from django.db import transaction  3from django.core.exceptions import ValidationError  4from django.core.validators import validate_email  5​  6def create_player_profile(username, password, first_name, last_name, email, acl_number, district_id):  7    """  8    Creates a new player profile in the database.  9​ 10    Args: 11        username (str): The player's username. 12        password (str): The player's password. 13        first_name (str): The player's first name. 14        last_name (str): The player's last name. 15        email (str): The player's email address. 16        acl_number (str): The player's ACL number. 17        district_id (int): The player's district ID. 18​ 19    Returns: 20        int: The player's ID. 21​ 22    Raises: 23        ValidationError: If any of the input data is invalid. 24        Exception: If any other error occurs during the database transaction. 25    """ 26​ 27    # Import models here to avoid circular imports 28    from .models import Player, PlayerStatistics, District  # Replace .models with your actual app name 29​ 30    # Input validation 31    if not username: 32        raise ValidationError("Username cannot be empty.") 33    if not password: 34        raise ValidationError("Password cannot be empty.") 35    if not first_name: 36        raise ValidationError("First name cannot be empty.") 37    if not last_name: 38        raise ValidationError("Last name cannot be empty.") 39    if not email: 40        raise ValidationError("Email cannot be empty.") 41    try: 42        validate_email(email) 43    except ValidationError: 44        raise ValidationError("Invalid email address.") 45    if not acl_number: 46        raise ValidationError("ACL number cannot be empty.") 47    try: 48        district = District.objects.get(pk=district_id) 49    except District.DoesNotExist: 50        raise ValidationError("Invalid district ID.") 51​ 52    try: 53        with transaction.atomic(): 54            # Create the player 55            hashed_password = make_password(password) 56            player = Player.objects.create( 57                username=username, 58                password=hashed_password, 59                first_name=first_name, 60                last_name=last_name, 61                email=email, 62                acl_number=acl_number, 63                district=district, 64            ) 65​ 66            # Create player statistics 67            PlayerStatistics.objects.create(player=player) 68​ 69            return player.id 70    except Exception as e: 71        raise Exception(f"Error creating player profile: {e}")

None