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"
Frank Barknecht _ ______footils.org__