#!/usr/bin/perl -w
# vim:filetype=perl
# Before `make install' is performed this script should be runnable with
# `make test'. After `make install' it should work as `perl test.pl'
local $^W = 0;
use strict;
use Test::More;
use Test::Exception;
use Test::SQL::Translator qw(maybe_plan);
use Data::Dumper;
my %opt;
BEGIN {
  map { $opt{$_} = 1 if s/^-// } @ARGV;
}
use constant DEBUG => (exists $opt{d} ? 1 : 0);
use constant TRACE => (exists $opt{t} ? 1 : 0);
use FindBin qw/$Bin/;
my $file = "$Bin/data/mysql/sqlfxml-producer-basic.sql";
local $SIG{__WARN__} = sub {
  CORE::warn(@_)
      unless $_[0] =~ m!XML/Writer!;
};
# Testing 1,2,3,4...
#=============================================================================
BEGIN {
  maybe_plan(14, 'XML::Writer', 'Test::Differences', 'SQL::Translator::Producer::XML::SQLFairy');
}
use Test::Differences;
use SQL::Translator;
use SQL::Translator::Producer::XML::SQLFairy;
# Due to formatters being able to change style, e.g. by entries in .rc files
# in $HOME, the layout and or indent might differ slightly. As leading white
# is not important in XML, strip it when comparing
sub xml_equals {
  my ($got, $expect, $msg) = (@_, "XML looks right");
  $got    =~ s/^ +//gm;
  $expect =~ s/^ +//gm;
  eq_or_diff $got, $expect, $msg, { context => 1 };
}
#
# basic stuff
#
{
  my ($obj, $ans, $xml);
  $ans = <<EOXML;
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
  <extra />
  <tables>
    <table name="Basic" order="1">
      <extra />
      <fields>
        <field name="id" data_type="integer" size="10" is_nullable="0" is_auto_increment="1" is_primary_key="1" is_foreign_key="0" order="1">
          <extra />
          <comments>comment on id field</comments>
        </field>
        <field name="title" data_type="varchar" size="100" is_nullable="0" default_value="hello" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="2">
          <extra />
          <comments></comments>
        </field>
        <field name="description" data_type="text" size="65535" is_nullable="1" default_value="" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="3">
          <extra />
          <comments></comments>
        </field>
        <field name="email" data_type="varchar" size="255" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="4">
          <extra />
          <comments></comments>
        </field>
      </fields>
      <indices>
        <index name="titleindex" type="NORMAL" fields="title" options="">
          <extra />
        </index>
      </indices>
      <constraints>
        <constraint name="" type="PRIMARY KEY" fields="id" reference_table="" reference_fields="" on_delete="" on_update="" match_type="" expression="" options="" deferrable="1">
          <extra />
        </constraint>
        <constraint name="" type="UNIQUE" fields="email" reference_table="" reference_fields="" on_delete="" on_update="" match_type="" expression="" options="" deferrable="1">
          <extra />
        </constraint>
      </constraints>
      <comments></comments>
    </table>
  </tables>
  <views></views>
  <triggers></triggers>
  <procedures></procedures>
</schema>
EOXML
  $obj = SQL::Translator->new(
    debug          => DEBUG,
    trace          => TRACE,
    show_warnings  => 1,
    add_drop_table => 1,
    from           => "MySQL",
    to             => "XML-SQLFairy",
  );
  $xml = $obj->translate($file) or die $obj->error;
  ok("$xml" ne "", "Produced something!");
  print "XML:\n$xml" if DEBUG;
  # Strip sqlf header with its variable date so we diff safely
  $xml =~ s/^([^\n]*\n){7}//m;
  xml_equals $xml, $ans;
}    # end basic stuff
#
# View
#
# Thanks to Ken for the schema setup lifted from 13schema.t
{
  my ($obj, $ans, $xml);
  $ans = <<EOXML;
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
  <extra />
  <tables></tables>
  <views>
    <view name="foo_view" fields="name,age" order="1">
      <sql>select name, age from person</sql>
      <extra hello="world" />
    </view>
  </views>
  <triggers></triggers>
  <procedures></procedures>
</schema>
EOXML
  $obj = SQL::Translator->new(
    debug          => DEBUG,
    trace          => TRACE,
    show_warnings  => 1,
    add_drop_table => 1,
    from           => "MySQL",
    to             => "XML-SQLFairy",
  );
  my $s      = $obj->schema;
  my $name   = 'foo_view';
  my $sql    = 'select name, age from person';
  my $fields = 'name, age';
  my $v      = $s->add_view(
    name   => $name,
    sql    => $sql,
    fields => $fields,
    extra  => { hello => "world" },
    schema => $s,
  ) or die $s->error;
  # As we have created a Schema we give translate a dummy string so that
  # it will run the produce.
  lives_ok { $xml = $obj->translate("FOO"); } "Translate (View) ran";
  ok("$xml" ne "", "Produced something!");
  print "XML attrib_values=>1:\n$xml" if DEBUG;
  # Strip sqlf header with its variable date so we diff safely
  $xml =~ s/^([^\n]*\n){7}//m;
  xml_equals $xml, $ans;
}    # end View
#
# Trigger
#
# Thanks to Ken for the schema setup lifted from 13schema.t
{
  my ($obj, $ans, $xml);
  $ans = <<EOXML;
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
  <extra />
  <tables>
    <table name="Basic" order="1">
      <extra />
      <fields></fields>
      <indices></indices>
      <constraints></constraints>
      <comments></comments>
    </table>
  </tables>
  <views></views>
  <triggers>
    <trigger name="foo_trigger" database_events="insert" on_table="Basic" perform_action_when="after" order="1" scope="row">
      <action>update modified=timestamp();</action>
      <extra hello="world" />
    </trigger>
  </triggers>
  <procedures></procedures>
</schema>
EOXML
  $obj = SQL::Translator->new(
    debug          => DEBUG,
    trace          => TRACE,
    show_warnings  => 1,
    add_drop_table => 1,
    from           => "MySQL",
    to             => "XML-SQLFairy",
  );
  my $s                   = $obj->schema;
  my $name                = 'foo_trigger';
  my $perform_action_when = 'after';
  my $database_event      = 'insert';
  my $action              = 'update modified=timestamp();';
  my $table               = $s->add_table(name => "Basic") or die $s->error;
  my $t                   = $s->add_trigger(
    name                => $name,
    perform_action_when => $perform_action_when,
    database_events     => [$database_event],
    table               => $table,
    action              => $action,
    scope               => 'row',
    extra               => { hello => "world" },
  ) or die $s->error;
  # As we have created a Schema we give translate a dummy string so that
  # it will run the produce.
  lives_ok { $xml = $obj->translate("FOO"); } "Translate (Trigger) ran";
  ok("$xml" ne "", "Produced something!");
  print "XML attrib_values=>1:\n$xml" if DEBUG;
  # Strip sqlf header with its variable date so we diff safely
  $xml =~ s/^([^\n]*\n){7}//m;
  xml_equals $xml, $ans;
}    # end Trigger
#
# Procedure
#
# Thanks to Ken for the schema setup lifted from 13schema.t
{
  my ($obj, $ans, $xml);
  $ans = <<EOXML;
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
  <extra />
  <tables></tables>
  <views></views>
  <triggers></triggers>
  <procedures>
    <procedure name="foo_proc" parameters="foo,bar" owner="Nomar" order="1">
      <sql>select foo from bar</sql>
      <comments>Go Sox!</comments>
      <extra hello="world" />
    </procedure>
  </procedures>
</schema>
EOXML
  $obj = SQL::Translator->new(
    debug          => DEBUG,
    trace          => TRACE,
    show_warnings  => 1,
    add_drop_table => 1,
    from           => "MySQL",
    to             => "XML-SQLFairy",
  );
  my $s          = $obj->schema;
  my $name       = 'foo_proc';
  my $sql        = 'select foo from bar';
  my $parameters = 'foo, bar';
  my $owner      = 'Nomar';
  my $comments   = 'Go Sox!';
  my $p          = $s->add_procedure(
    name       => $name,
    sql        => $sql,
    parameters => $parameters,
    owner      => $owner,
    comments   => $comments,
    extra      => { hello => "world" },
  ) or die $s->error;
  # As we have created a Schema we give translate a dummy string so that
  # it will run the produce.
  lives_ok { $xml = $obj->translate("FOO"); } "Translate (Procedure) ran";
  ok("$xml" ne "", "Produced something!");
  print "XML attrib_values=>1:\n$xml" if DEBUG;
  # Strip sqlf header with its variable date so we diff safely
  $xml =~ s/^([^\n]*\n){7}//m;
  xml_equals $xml, $ans;
}    # end Procedure
#
# Field.extra
#
{
  my ($obj, $ans, $xml);
  $ans = <<EOXML;
<schema name="" database="" xmlns="http://sqlfairy.sourceforge.net/sqlfairy.xml">
  <extra />
  <tables>
    <table name="Basic" order="1">
      <extra />
      <fields>
        <field name="foo" data_type="integer" size="10" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="1">
          <extra ZEROFILL="1" />
          <comments></comments>
        </field>
        <field name="bar" data_type="numeric" size="10,2" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="2">
          <extra />
          <comments></comments>
        </field>
        <field name="baz" data_type="decimal" size="8,3" is_nullable="1" is_auto_increment="0" is_primary_key="0" is_foreign_key="0" order="3">
          <extra />
          <comments></comments>
        </field>
      </fields>
      <indices></indices>
      <constraints></constraints>
      <comments></comments>
    </table>
  </tables>
  <views></views>
  <triggers></triggers>
  <procedures></procedures>
</schema>
EOXML
  $obj = SQL::Translator->new(
    debug          => DEBUG,
    trace          => TRACE,
    show_warnings  => 1,
    add_drop_table => 1,
    from           => "MySQL",
    to             => "XML-SQLFairy",
  );
  my $s = $obj->schema;
  my $t = $s->add_table(name => "Basic") or die $s->error;
  my $f = $t->add_field(
    name      => "foo",
    data_type => "integer",
    size      => "10",
  ) or die $t->error;
  $f->extra(ZEROFILL => "1");
  $t->add_field(
    name      => "bar",
    data_type => "numeric",
    size      => "10,2",
  ) or die $t->error;
  $t->add_field(
    name      => "baz",
    data_type => "decimal",
    size      => [ 8, 3 ],
  ) or die $t->error;
  # As we have created a Schema we give translate a dummy string so that
  # it will run the produce.
  lives_ok { $xml = $obj->translate("FOO"); } "Translate (Field.extra) ran";
  ok("$xml" ne "", "Produced something!");
  print "XML:\n$xml" if DEBUG;
  # Strip sqlf header with its variable date so we diff safely
  $xml =~ s/^([^\n]*\n){7}//m;
  xml_equals $xml, $ans;
}    # end extra