#! /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]];
}