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 structure 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, $where)); 856 =item fetchOne 858 fetchOne($q) is a shortcut to prepare and execute a query, and 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);