Python execute Examples

Example #1

File: interface.py Project: BackupTheBerlios/pymud-svn

def updateLocation(cursor, userid, location):
	queryDict = {
		DC.UserID: userid,
		DC.Location: location,
	}
	query = Q.UpdateLocation % queryDict
	pgDB.execute(cursor, query)

Example #2

File: interface.py Project: Cloudxtreme/pymud

def updateUserLocation(cursor, userid, roomid):
    queryDict = {
        DC.UserID: userid,
        DC.RoomID: roomid,
    }
    query = Q.UpdateUserRoomID % queryDict
    pgDB.execute(cursor, query)

Example #3

File: interface.py Project: BackupTheBerlios/pymud

def updateUserLocation(cursor, userid, roomid):
	queryDict = {
		DC.UserID: userid,
		DC.RoomID: roomid,
	}
	query = Q.UpdateUserRoomID % queryDict
	pgDB.execute(cursor, query)

Example #4

File: interface.py Project: BackupTheBerlios/pymud-svn

def createUser(cursor, nickname, charname, password, userlevel = Player):
	password = sha.new(password).hexdigest()
	queryDict = {
		DC.UserID: userid,
		DC.UserLevel: userlevel,
		DC.NickName: nickname,
		DC.FullName: charname,
		DC.Password: password,
	}
	query = Q.CreateUser % queryDict
	pgDB.execute(query)

Example #5

File: interface.py Project: Cloudxtreme/pymud

def createUser(cursor, nickname, charname, password, userlevel=Player):
    password = sha.new(password).hexdigest()
    queryDict = {
        DC.UserID: userid,
        DC.UserLevel: userlevel,
        DC.NickName: nickname,
        DC.FullName: charname,
        DC.Password: password,
    }
    query = Q.CreateUser % queryDict
    pgDB.execute(query)

Example #6

File: interface.py Project: BackupTheBerlios/pymud-svn

def setThreadID(cursor, userid, threadid):
	query = Q.SetThreadID % {DC.UserID: userid, DC.CurrentThreadID: threadid}
	pgDB.execute(cursor, query)

Example #7

File: interface.py Project: BackupTheBerlios/pymud-svn

def clearLoggedInUsers(cursor):
	query = Q.ClearLoggedInUsers
	pgDB.execute(cursor, query)

Example #8

File: interface.py Project: Cloudxtreme/pymud

def setThreadID(cursor, userid, threadid):
    query = Q.SetThreadID % {DC.UserID: userid, DC.CurrentThreadID: threadid}
    pgDB.execute(cursor, query)

Example #9

File: interface.py Project: Cloudxtreme/pymud

def clearLoggedInUsers(cursor):
    query = Q.ClearLoggedInUsers
    pgDB.execute(cursor, query)