package MSOOMoose;


use Moose;


has 'query' => (
	is => 'rw',
	isa => 'Str'
);
has 'commit' => (
	is => 'rw',
	isa => 'Int'
);
has 'insertcount' => (
	is => 'rw',
	isa => 'Int'
);



sub setQuery
{
	my $self = shift;
	my $value = shift;
	$self->{query} = $value;
}


sub committoDB
{
	my $self = shift;
	print "Dit is subroutine: committoDB\n";
	
	# RESET COUNTER
	#$self->{insertcount} = 0;
	print $self->insertcount, "***\n";
}


sub insertQuery
{
	my $self = shift;
	my $commitvalue = shift;
	$self->{insertcount} += 1;
	my $counter = $self->insertcount;
	print "Count: $counter\tInsertQuery: ", $self->query, "\n";
	# ADD TO HASH: FOR LATER
	if (defined($commitvalue) && ($commitvalue == 1))
	{
		print "Yes, commit! Commitvalue = $commitvalue\n";
		committoDB;
	}
	elsif ($counter == $self->commit)
	{
		committoDB;
	}
}


no Moose;

1;

##</code><code>##


#!/usr/bin/perl -w


use strict;
use warnings;


use MSOOMoose;

my $sqlsyntax;


my $msoo = MSOOMoose->new(
	commit => 5
);


$msoo->setQuery("INSERT INTO groupinsert (number) VALUES ('2')");
$msoo->insertQuery(1); # 1 means: force commit


for ($a = 0; $a < 10; $a += 1)
{
	$sqlsyntax = qq{INSERT INTO groupinsert (number) VALUES ('$a')};
	$msoo->setQuery($sqlsyntax);
	$msoo->insertQuery();
	
}


exit(0);