The preface of my project is to create something similar to c-rpg but without a PvP focus. I guess you can say it's nore similar in context to Full Invasion with persistance handled with database extensions.
I've created several functions that call Stored Procedures within my databse (MSSQL) which work just fine by themselves. Here is an example of my code:
import _mssql
SQLServer = 'SQLServer\INSTANCE1'
Login = 'Login'
Password = 'xxxx'
Database = 'xxx'
conn = _mssql.connect(server=SQLServer, user=Login, password=Password, database=Database)
def CreateNewCharacter(UniqueID,Name):
conn.execute_scalar("""exec CreateNewCharacter %s, %s""",(UniqueID,Name)) # calls stored procedure to handle transactions within the database
conn.close()