SimpleMysql

SimpleMysql is actually a wrapper for MYSQLdb, an advanced MySQL client for Python developers.

SimpleMysql does nothing more than to simplify some of its syntax and narrow down support only to the common MySQL transactions.

Just as the original, to run SQL commands on a MySQL database developers only have to use a series of ready-made Python commands.

SimpleMysql will convert these commands into actual MySQL transactions and send them to the server to be executed.

Features:

• Methods:
• getOne() - get a single row
• getAll() - get all rows
• insert() - insert a row
• insertOrUpdate() - insert a row or update it if it exists
• update() - update rows
• delete() - delete rows
• query() - run a raw SQL query
• leftJoin() - do an inner left join query and get results