Querying MariaDB from python
Ervin Hegedüs
airween at gmail.com
Tue Oct 2 11:47:27 EDT 2018
hi,
On Tue, Oct 02, 2018 at 04:14:45PM +0100, Tony van der Hoff wrote:
> I'm writing a database application, in python 3,5 under Debian9.
>
> My code:
>
> def get_albums(self, parent_id = 0 ):
> cursor = self.cnx.cursor()
cursor = self.cnx.cursor(pymysql.cursors.DictCursor)
> sql =( "select"
> " id"
> ", parent_id"
> ", title"
> ", ifnull( description, '' )"
> ", path"
> ", date( from_unixtime( date_created ) ) as date"
> " from album"
> " where parent_id = %(parent_id)s"
> " order by date_created"
> )
sql = ("""SELECT
id,
parent_id,
...
""")
> cursor.execute( sql, {'parent_id': parent_id } )
> rows = cursor.fetchall()
now rows will looks like this:
({'id':...,...},{'id':...,}...)
a.
More information about the Python-list
mailing list