Code: Alles auswählen
#!/usr/bin/env python
"""1st Test in SQLite
"""
import sqlite3
import sys
DBPATH='/usr/data/digikam/digikam4.db'
try:
conn = sqlite3.connect(DBPATH)
c=conn.cursor()
except: //natürlich noch ausbaufähig!!
print('Error')
sys.exit
c.execute('''select * from Albums
order by caption
limit 20;''')
for item in c.fetchall():
print item
conn.close()
Code: Alles auswählen
(1, 1, u'/', u'2016-02-03', None, None, None)
(9, 1, u'/Logo', u'2012-12-12', None, None, None)
(25, 1, u'/Poster', u'2013-06-07', None, None, None)
(26, 1, u'/Project20110918 Weddingstedt', u'2011-09-18', None, u'xyz', None)
(27, 1, u'/Project20110918 Weddingstedt/NEF', u'2011-09-18', None, u'xyz', None)
(28, 1, u'/Project20110918 Weddingstedt/bibble', u'2011-10-07', None, u'xyz', None)
(29, 1, u'/Project20110919 Signe', u'2012-05-17', None, u'Portrait', None)
(30, 1, u'/Project20110919 Signe/Grafik', u'2012-05-17', None, u'Portrait', None)
(31, 1, u'/Project20110919 Signe/NEF', u'2012-05-17', None, u'Portrait', None)
(32, 1, u'/Project20110919 Signe/RT4', u'2012-05-17', None, u'Portrait', None)
(33, 1, u'/Project20110919 Signe/bibble', u'2011-09-19', None, u'Portrait', None)
Code: Alles auswählen
c.execute('''select * from Albums
where caption like "%Signe%"
order by caption
limit 20;''')