Das deutsche Python-Forum

Code: Alles auswählen

data_inserter = {
"player_id" : player_id, "login_name" : login_name, "login_password" : login_password
}
        
sql_inserter = "INSERT INTO players VALUES (:player_id, :login_name , :login_password, null, null)"
        
cursor.execute(sql_inserter, data_inserter)

Code: Alles auswählen

update players set chr_name=WERT, chr_jop=WERT2 where player_id=PLAYERID

Code: Alles auswählen

# Django
player = Player.objects.create(name="Conan", job="König von Aquilonien")
player.save()

--oder--

# SQLalchemy
session = Session()
session.add(Player("Conan", "König von Aquilonien"))
session.commit()

Code: Alles auswählen

from string import digits, ascii_letters, punctuation
import hmac
import random

def create_salt(chars=digits+ascii_letters+punctuation, length=8):
    if length <= 0:
        raise ValueError('Can\'t create a str with less than 1 character')
    return ''.join(random.choice(chars) for _ in xrange(length))

def create_password_hash(password, salt=None):
    salt = salt or create_salt()
    salt = salt.replace('$', '')
    h = hmac.new(password, salt).hexdigest()
    return 'sha1${salt}${hash}'.format(salt=salt, hash=h)

def check_password_hash(password, password_hash):
    method, salt, h = password_hash.split('$')
    return h == hmac.new(password, salt).hexdigest()

Code: Alles auswählen

class Player(Model):
    __tablename__ = 'players'

    id = Column(Integer, primary_key=True, autoincrement=True)
    username = Column(String(30))
    password_hash = Column(String(150))
    char_name = Column(String(30))
    char_job = Column(String(50))
    
    def __init__(self, username, password, char_name, char_job):
      self.username = username
      self.pasword_hash = create_password_hash(password)
      self.char_name = char_name
      self.char_job = char_job

Code: Alles auswählen

player = Player.query.filter_by(username=login_name).first()
if player and check_password_hash(login_password, player.password_hash):
    local.application.current_player = player

Code: Alles auswählen

#!/usr/bin/env python

import random
from string import letters, digits

def generate_salt(length=8, include=letters + digits, exclude="$"):
    chars = list(set(include) ^ set(exclude))
    return "".join(random.sample(chars, length))

Code: Alles auswählen

#! C:\\Python26\game
# -*- coding: iso-8859-15 -*-

import sqlite3
import random
import hmac
from string import letters, digits

def create_salt(length=8, include=letters + digits, exclude="$"):
    chars = list(set(include) ^ set(exclude))
    return "".join(random.sample(chars, length)) 

def create_password_hash(password):
    salt = create_salt()
    h = hmac.new(password, salt).hexdigest()
    return 'sha1${salt}${hash}'.format(salt=salt, hash=h)

def check_password_hash(password, password_hash):
    method, salt, h = password_hash.split('$')
    return h == hmac.new(password, salt).hexdigest()

class Player(object):
    Players_total = 0
    
    def __init__(self, login_name, password_hash):
        self.Login_name = login_name
        self.Login_password_hash = password_hash
        self.Chr_firstname = None
        self.Chr_lastname = None
        self.Chr_sex =  None
        self.Chr_occupation = None
        self.Chr_charisma = 0
        self.Chr_endurance = 0
        self.Chr_intelligence = 0
        self.Chr_knowledge = 0
        self.Chr_psyche = 0
        self.Chr_reflexes = 0
        self.Chr_experience = 0
        self.Chr_credits = 100
        self.Chr_fame = 0
        Player.Players_total += 1

        chr_experience = self.Chr_experience
        chr_credits = self.Chr_credits
        chr_fame = self.Chr_fame

        data_inserter = {
        "login_name" : login_name, "password_hash" : password_hash, "chr_experience" : chr_experience, "chr_credits" : chr_credits, "chr_fame" : chr_fame
        }
        
        sql_inserter = "INSERT INTO players VALUES (null, :login_name , :password_hash, null, null, null, null, null, null, null, null, null, null, :chr_experience, :chr_credits, :chr_fame)"
        
        connection = sqlite3.connect("players.db")
        cursor = connection.cursor()
        cursor.execute(sql_inserter, data_inserter)
        connection.commit()

Code: Alles auswählen

# -*- coding: iso-8859-15 -*-

Code: Alles auswählen

while True:
    login_password = getpass.getpass("""
Please choose and enter a password: """).decode('iso-8859-15')
    if len(login_password) >= 4:
        break
    else:
        print """
Your password must be at least 4 characters long!.
"""
        continue

# Add random parameter to password and save it as a hash
password_hash = create_password_hash(login_password)
player = Player(login_name, password_hash)