#! /usr/bin/perl
use warnings;
use strict;
use DBI;
use Data::Dumper;
my $dbfile = '1.db';
my $db = 'DBI'->connect("dbi:SQLite:dbname=$dbfile", q(), q());
END { unlink $dbfile }
$db->do('CREATE TABLE text (id INT, line_n VARCHAR, word VARCHAR, word_position INT)');
my $insert = $db->prepare('INSERT INTO text VALUES(?, ?, ?, ?)');
{ no warnings 'qw';
$insert->execute(@$_) for [qw[1 a1 Lorem 1]],
[qw[2 a1 ipsum 2]],
[qw[3 a1 dolor 3]],
[qw[4 a1 sit 4]],
[qw[5 a1 amet, 5]],
[qw[6 b2 consectetuer 1]],
[qw[7 b2 adipiscing 2]],
[qw[8 b2 elit. 3]],
[qw[9 c3 Phasellus 1]],
[qw[10 c3 non 2]],
[qw[11 c3 erat 3]];
}
####
my $select = $db->prepare('SELECT line_n, word, word_position FROM text');
$select->execute;
my $text;
while (my ($line, $word, $pos) = $select->fetchrow_array) {
$text->{$line}[$pos - 1] = $word;
}
print Dumper($text);
####
($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord
}map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,