skip to navigation
skip to content

Not Logged In

MySQLObject 1.2

A Python class to convert a simple object in a MySQL connection driver.

Latest Version: 1.3.1

MySQL Object
============

A Python class to convert a simple object in a MySQL connection driver.

**Latest version: 1.2**

It provides a set of functions to interact with a MySQL server directly
from a class. These functions are designed in a natural way that allows
an user to forget about implementation details.

How to use it
-------------

It is pretty simple to instance it:

    from mysqlobject import mysqlobject

    class myclass (mysqlobject):
        def __init__(self):
            super(myclass, self).__init__()
            self.mysqlobject_params["host"] = "localhost",
            self.mysqlobject_params["port"] = 3306,
            self.mysqlobject_params["user"] = "root",
            self.mysqlobject_params["passwd"] = "$ecre7",
            self.mysqlobject_params["db"] = "test",
            self.mysqlobject_params["use_unicode"] = True,
            self.mysqlobject_params["charset"] = "utf8",
            self.mysqlobject_params["compress"] = False,
            self.mysqlobject_params["cursor"] = "DictCursor",

It is also easy to use it:

    try:
        all = myclass.mysql_select("SELECT VERSION();")
        one = myclass.mysql_select_one("SELECT VERSION();")
        lastid = myclass.mysql_insert(
            "INSERT INTO test (name) VALUES (%s)",
            ['test'],
        )
        affected = myclass.mysql_update("UPDATE test SET name = %s", ['test2'])
        deleted = myclass.mysql_delete("DELETE FROM test")
    except Exception, e
        print e

You can also execute many queries:

    query = "INSERT INTO test (name) VALUES (%s);"
    data = ['test', 'test2']
    affected = mysql_query_many(query, data)

What functions do I have?
-------------------------

### mysql\_select

It returns all the rows from the query.

### mysql\_select\_one

It returns one row from the given query.

### mysql\_insert

It returns the last inserted ID from your insertion query.

### mysql\_update

It returns the number of affected rows.

### mysql\_delete

It returns the number of deleted rows.

Source
------
The source can be browsed at "http://github.com/rfc83/python-mysqlobject"


Contact me
----------
For any requests, please contact me at: rfuentealbac.83@gmail.com
 
File Type Py Version Uploaded on Size
MySQLObject-1.2.tar.gz (md5) Source 2012-07-04 3KB
  • Downloads (All Versions):
  • 7 downloads in the last day
  • 77 downloads in the last week
  • 499 downloads in the last month