17 my $ref = $db->fetch_assoc($sth);
495 while ( my $ref = $self->fetch_assoc($sth) ) {
550 my $ref = $self->fetchOne('SELECT sql FROM sqlite_master
+ WHERE tbl_name = ?', $src_table);
661 selectOne($q) is a shortcut to prepare and execute a structu
+re select, and fetch the first row
668 $self->select(@q)->fetchrow_hashref;
740 while ( my @arr = $sth->fetchrow_array() ) {
802 while ( my $ref = $self->fetch_assoc($sth) ) {
840 my $ref = $self->fetchOne($self->_count_sql($table, $whe
+re));
856 =item fetchOne
858 fetchOne($q) is a shortcut to prepare and execute a query, a
+nd fetch the first row
862 sub fetchOne {
864 $self->query(@q)->fetchrow_hashref;
867 =item fetch_assoc
873 sub fetch_assoc {
877 my $row = $sth->fetchrow_hashref;
879 $self->die("fetching row failed ".$sth->err);
|