我正在使用DBI来查询SQLite3数据库。我的代码可以工作,但是它没有按照指定的顺序返回列。例如:
Query: select col1, col2, col3, col4 from some_view;
Output:
col3, col2, col1, col4
3, 2, 1, 4
3, 2, 1, 4
3, 2, 1, 4
3, 2, 1, 4
...
(values and columns are just for illustration)
我知道发生这种情况是因为我正在使用哈希表,但如果我只使用一个数组,我怎么才能获取列名呢?我想要的只是对于任何任意的查询都能得到如下类似的结果:
col1, col2, col3, col4
1, 2, 3, 4
1, 2, 3, 4
1, 2, 3, 4
1, 2, 3, 4
...
(也就是说,我需要输出按正确顺序排列并带有列名。)
我是一个Perl新手,但我真的认为这应该是个简单的问题。(我以前在Ruby和PHP中做过这件事,但我在Perl文档中找不到我要找的东西。)
这是目前我所拥有的简化版本:
use Data::Dumper;
use DBI;
my $database_path = '~/path/to/db.sqlite3';
$database = DBI->connect(
"dbi:SQLite:dbname=$database_path",
"",
"",
{
RaiseError => 1,
AutoCommit => 0,
}
) or die "Couldn't connect to database: " . DBI->errstr;
my $result = $database->prepare('select col1, col2, col3, col4 from some_view;')
or die "Couldn't prepare query: " . $database->errstr;
$result->execute
or die "Couldn't execute query: " . $result->errstr;
###########################################################################################
# What goes here to print the fields that I requested in the query?
# It can be totally arbitrary or '*' -- "col1, col2, col3, col4" is just for illustration.
# I would expect it to be called something like $result->fields
###########################################################################################
while (my $row = $result->fetchrow_hashref) {
my $csv = join(',', values %$row);
print "$csv\n";
}
$result->finish;
$database->disconnect;
@{ $result->{NAME} }
这样的东西不太友好。 - Benjamin Oakes