use lib 't';

BEGIN {
    # to handle systems with no installed Test module
    # we include the t dir (where a copy of Test.pm is located)
    # as a fallback
    eval { require Test; };
    use Test;    
    plan tests => 1;
}
use Data::Stag;
use FileHandle;

my $moviedata = getmoviedata();
my ($hdr, @data) = process($moviedata);


# by director
my $dirstruct =
  Data::Stag->normalize(-top=>"director-set",
                        -rows=>\@data,
                        -cols=>$hdr,
                        -path=>"(director(film(actor(character 1))))");
print $dirstruct->xml;
my $ss = <<EOM
(schema
 (cols
  (col
   (group "dir")
   (name "lname"))
  (col
   (group "dir")
   (name "fname"))
  (col
   (group "dir")
   (name "country"))
  (col
   (group "movie")
   (name "name"))
  (col
   (group "movie")
   (name "genre"))
  (col
   (group "star")
   (name "lname"))
  (col
   (group "star")
   (name "fname"))
  (col
   (group "character")
   (name "name")))
 (constraints
  (primarykey
   (group "movie")
   (col "name"))
  (primarykey
   (group "dir")
   (col "lname")
   (col "fname")))
 (top "mset")
 (path
  (movie
   (dir 1)
   (character
    (star 1)))))
EOM
;
my $mstruct =
  Data::Stag->normalize($ss, \@data);
print $mstruct->xml;

($hdr, @data) = process(getanimaldata());
my $struct =
  Data::Stag->normalize(-top=>"animal-set",
                        -rows=>\@data,
                        -cols=>$hdr,
                        -path=>"'(rel 1)");

print $struct->xml;
ok(1);
exit 0;

#

sub process{
    my $data = shift;
    my @data = map {chomp;[split(/\,\s*/, $_)]} split(/\n/,$data);
    # first line is header line
    my $hdr = shift @data;
    $hdr->[0] =~ s/^\#//;
    return ($hdr, @data);
}


sub getmoviedata {

return <<EOM
#director.lname, director.fname, dir.country, film.name, film.genre, actor.lname, actor.fname, character.name
lucas, george, US, star wars, sci-fi, ford, harrison, han solo
lucas, george, US, star wars, sci-fi, fisher, carrie, princess leia
lucas, george, US, star wars, sci-fi, hamill, mark, luke skywalker
lucas, george, US, star wars, sci-fi, earl-jones, james, darth vader
lucas, george, US, star wars, sci-fi, prowse, david, darth vader
lucas, george, US, star wars, sci-fi, guiness, alec, obi-wan kenobi
lucas, george, US, attack of the clones, sci-fi, mcgregor, ewan, obi-wan kenobi
lucas, george, US, attack of the clones, sci-fi, portman, natalie, princess amigdala
jackson, peter, new zealand, braindead, horror, -, -, -, -
jackson, peter, new zealand, lord of the rings, fantasy, lee, christopher, saruman
jackson, peter, new zealand, lord of the rings, fantasy, kellan, ian, gandalf
kurosawa, akira, japan, seven samurai, samurai, mifune, toshiro, Kikuchiyo
cameron, john, US, terminator, sci-fi, schwarzenegger, arnold, terminator
cameron, john, US, terminator2, sci-fi, schwarzenegger, arnold, terminator
coen, joel, US, barton fink, odd, turturro, john, barton fink
coen, ethan, US, barton fink, odd, turturro, john, barton fink
coen, joel, US, barton fink, odd, goodman, john, charlie meadows
coen, ethan, US, barton fink, odd, goodman, john, charlie meadows
EOM
}

sub getcharacterdata {
    return <<EOM
gandalf, goody, staff
luke skywalker, goody, lightsaber
darth vader, baddy, lightsaber
EOM
}

sub getanimaldata {
    return <<EOM
#rel.t, rel.subj, rel.obj
isa, dog, mammal
isa, cat, mammal
isa, mammal, animal
isa, zebra, horse
isa, horse, mammal
isa, unicorn, horse
isa, unicorn, imaginary-animal
instance-of, rover, dog
instance-of, whiskers, cat
instance-of, spot, dog
parent-of, spot, rover
EOM
}