A lightweight and open source Python microframework designed to simplify multi-database management through intuitive, object-oriented class structures.

Download latest version Version 1.0.0.0

View on GitHub Read the documentation

Python.org MySQL Developer Guide

                
# Import Pody modules.
                
from
 pody.configuration 
import
 
Configuration
                
from
 pody.connection 
import
 
Connection

                
# Import database table class.
                
from
 db.user 
import
 
User

                
# Database configuration.
                
config
 = 
Configuration
(
'db'
, 
'root'
, 
''
, 
'localhost'
, 
3306
)

                
# Connect to the database.
                
socket
 = 
Connection
(
config
)

                
# Creating a user.
                
User
(
None
, 
'Newell'
, 
'Gabe'
, 
'gaben@valvesoftware.com'
).
create
()

                
# Retrieving a user.
                
user
 = 
User
(
1
).
read
()

                
# Update a user.
                
user
.name = 
'Gates'
                
user
.
update
()

                
# Delete a user.
                
user
.
delete
()

                
# Disconnect from the database.
                
socket
.
closeSocket
()