Hello Thomas, Unfortunately i don't know anything about python excepted that i should learn it ! Could you give me an estimation of the time needed by a newbie to script a MySql reader for pd ?

MySQL-Python modules can be found here: http://www.mysql.com/downloads/api-python.html and examples are given in http://www.devshed.com/Server_Side/Python/PythonMySQL/print_html

e.g.

#!/usr/bin/python

# import MySQL module import MySQLdb

# connect db = MySQLdb.connect(host="localhost", user="joe", passwd="secret",db="db56a")

# create a cursor cursor = db.cursor()

# execute SQL statement cursor.execute("SELECT * FROM animals")

# get the resultset as a tuple result = cursor.fetchall()

# iterate through resultset for record in result: print record[0] , "-->", record[1]

For simplicity you should probably start with py (instead of pyext) - have a look at the examples.

best greetings, Thomas

CK wrote:

I read:

...

Unfortunately i don't know anything about python excepted that i should learn it ! Could you give me an estimation of the time needed by a newbie to script a MySql reader for pd ?

I did some pyext/mysql stuff if you want I can dig it out and probably help you to tailor it to suit your needs.

regards,

x

Hello,

Thank you very much for your help, i really do appreciate ! As i won't have enough time to dig into python scripting, i'm going to use php and SVG instead of pd.

But as i really want to be able to use MySql with pd i'll try later to solve this problem.

All the best,

Jean Jacques http://tecfa.unige.ch/perso/staf/duclaux/blog/

On Fri, 26 Dec 2003, Alexandre Castonguay wrote:

It turns out we had a similar problem and Mathieu was kind enough to add a mysql object to GridFlow. It is not a standard object so you will have to add it to a .gridflow_startup file.

Hi. Since it's to be put in a .gridflow_startup file it's not "added to GridFlow" but rather "written for GridFlow".

It's written for GridFlow because part of GridFlow is to the Ruby language what PyExt is to Python.

However, just as one written in Python would require a mysql-for-python module, you will need a mysql-for-ruby with mine. You may download that at:

http://raa.ruby-lang.org/list.rhtml?name=mysql-ruby

Mathieu Bouchard http://artengine.ca/matju

Hallo, Jean Jacques hat gesagt: // Jean Jacques wrote:

Unfortunately i don't know anything about python excepted that i should learn it ! Could you give me an estimation of the time needed by a newbie to script a MySql reader for pd ?

This very much depends on how comfortable and experienced you are with programming. I learned the basics of Python in about an afternoon, and I was only slightly experienced in Perl at that time. Start with Guido van Rossums Python tutorial, it's a short read and lots of fun, too.

For Database access I would highly recommend using SQLObject from http://sqlobject.org/, which is a wrapper around several databases. It makes getting started with database programming in Python *very* fast.

This is a complete DB app in Python:

# start from SQLObject import *

__connection__ = MySQLConnection( host='localhost', db='sqlobject_test', user='sqlobject_test', passwd='sqltest')

class Person(SQLObject):

firstName = StringCol(length=100)
middleInitial = StringCol(length=1, default=None)
lastName = StringCol(length=100)

if __name__ == "__main__": Person.createTables() msp = Person.new("Miller", "S", "Puckettte") print "%s wrote Pd" % msp.lastName print "Oops, spelling error!" msp.lastName = "Puckette" print msp

# end

After that, msp is correctly saved in the Database, because all DB-actions are transparent and automatically written or read when accessing the attributes like "msp.lastName"

ciao

Frank Barknecht _ ______footils.org__

Hallo, Marc Lavallée hat gesagt: // Marc Lavallée wrote:

On Wed, Dec 17, 2003 at 10:51:50AM -0500, B. Bogart wrote:

...

There is "sqlsingle" on the net somwhere, I think its meant for postgres, but it may be easy to modify.

I'd like a SQLite external... (that would be a really cool project).

Works with pyext, and if you use SQLObject as I suggested, you could even use the same code for it, as you'd use for MySQL, PostgreSQL, Firebird, DBM-files, ...

But of course an external would be nice, too, although the string handling in Pd is a bit, well, orthogonal to SQL.

ciao

Frank Barknecht _ ______footils.org__