In <[EMAIL PROTECTED]>, Gabriel
Genellina wrote:
> En Thu, 12 Apr 2007 08:43:49 -0300, Marc 'BlackJack' Rintsch
> <[EMAIL PROTECTED]> escribió:
>
>> In <[EMAIL PROTECTED]>, Jorgen Bodde
>> wrote:
>>
>> r = c.execute('select * from song where id = 1')
>> for s in r:
>>> ... print
En Thu, 12 Apr 2007 08:43:49 -0300, Marc 'BlackJack' Rintsch
<[EMAIL PROTECTED]> escribió:
> In <[EMAIL PROTECTED]>, Jorgen Bodde
> wrote:
>
> r = c.execute('select * from song where id = 1')
> for s in r:
>> ... print s
>> ...
>> (1, u'Spikedrivers Blues', u'Mississippi John Hurt')
Thanks,
This is how I did it in the end as well. Yes i use the connection
object, abbreviated as 'c' for ease of typing.
In my real app the connection is kept inside a singleton object and I
use the DB like
result = GuitarDB().connection.execute('select * from song where id =
1').fetchone()
if r
On Thu, 2007-04-12 at 13:43 +0200, Marc 'BlackJack' Rintsch wrote:
> In <[EMAIL PROTECTED]>, Jorgen Bodde
> wrote:
>
> r = c.execute('select * from song where id = 1')
> for s in r:
> > ... print s
> > ...
> > (1, u'Spikedrivers Blues', u'Mississippi John Hurt')
> >
> >
In <[EMAIL PROTECTED]>, Jorgen Bodde
wrote:
r = c.execute('select * from song where id = 1')
for s in r:
> ... print s
> ...
> (1, u'Spikedrivers Blues', u'Mississippi John Hurt')
>
> That works. But when I can't restore the row by e.g. an ID that does
> not exist, I cannot see any
En Thu, 12 Apr 2007 04:38:06 -0300, Jorgen Bodde
<[EMAIL PROTECTED]> escribió:
> I am using sqlite3 in python, and I wonder if there is a way to know
> if there are valid rows returned or not. For example I have a table
> song with one entry in it. The ID of that entry is 1, so when I do;
>
Jorgen Bodde wrote:
> All I can think of is a 'crappy' construction where I use the iterator
> to see if there was something in there, but surely, there must be a
> better way to know?
>
> >>> r = c.execute('select * from song where id = 2')
> >>> notfound = True
> >>> for s in r:
> ... notfoun
