[PD] accessing mysql database

[Luigi Rensinghoff]

Yes i can acces the database from python, entering some lines of python:

db = MySQLdb.connect("localhost", "root", "gigiroot", "sfx_database")
sql = """SELECT * FROM soundfile where description like '%birds%"""
cursor.execute(sql)
data = cursor.fetchall()
print data.



but from PD it does not work




Am 08.04.2007 um 16:17 schrieb David Powers:

> Hi Luigi,
>
> Just to be clear: Can you connect to the database with just Python? If
> not, I will try to help later today. This gives me a good excuse to
> try such a thing, I've been doing PHP+MySQL typical web programming
> lately, but Python is (in my opinion) a far nicer language than PHP
> and I've wanted to try this.
>
> ~David
>
> On 4/8/07, Luigi Rensinghoff <luigi.rensinghoff at freenet.de> wrote:
>> Hi List,
>>
>> i successfully installed "py/pyext" on an intel macbook, and got
>> pyhton, mysql and mysqldb running.
>>
>> The patch by georg holzmann i was trying to use is attached.
>>
>> Since i have no clue about python and sql and all of that i need some
>> help to get started.
>>
>> i managed to create a database with mysql, its called "sfx_database"
>>
>>
>>
>>
>> but when i try to connect via the patch i get the error:
>>
>>
>> PD mysql: could not log into MySQL server
>>
>>
>> in python i imported MySQldb, i think that is necessary and i
>> executed dir(MySQLdb), but i am not sure if it is really loaded.
>>
>> Who could help me debug/troubleshoot that ??
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> PD-list at iem.at mailing list
>> UNSUBSCRIBE and account-management -> http://lists.puredata.info/ 
>> listinfo/pd-list
>>
>>
>>
>
> _______________________________________________
> PD-list at iem.at mailing list
> UNSUBSCRIBE and account-management -> http://lists.puredata.info/ 
> listinfo/pd-list
>