Mysql && Perl / [ toGenerate_TIME | Show ]

toGenerate_TIME.pl
-------------------------------------------------------------------------------------------------------------------------
#!/usr/bin/perl
use strict;
use warnings;

my $myInterval = shift or die print "Usage : ./toGenerate_TIME.pl 30\n $!";

my $Time_start = 0;

my $Time_stop = 23;

my $interval = 0;

print "create table horas(id int(10) primary key  auto_increment, horario time);\n";

while($Time_start <= $Time_stop){
        if($interval){
                if( $Time_start < 10){
                        print "INSERT INTO horas (horario) VALUES ('0$Time_start:$interval:00');\n";
                }else{
                        print "INSERT INTO horas (horario) VALUES ('$Time_start:$interval:00');\n";
                }
        }else{
                if($Time_start < 10){
                        print "INSERT INTO horas (horario) VALUES ('0$Time_start:00:00');\n";
                }else{
                        print "INSERT INTO horas (horario) VALUES ('$Time_start:00:00');\n";
                }
        }

        $interval += $myInterval;

        if($interval >= 60) {

                $Time_start++;
                $interval = 0;
        }
}

-------------------------------------------------------------------------------------------------------------------------

$ perl toGenerate_TIME.pl 30

create table horas(id int(10) primary key  auto_increment, horario time);

INSERT INTO horas (horario) VALUES ('00:00:00');

INSERT INTO horas (horario) VALUES ('00:30:00');

INSERT INTO horas (horario) VALUES ('01:00:00');

INSERT INTO horas (horario) VALUES ('01:30:00');

INSERT INTO horas (horario) VALUES ('02:00:00');

INSERT INTO horas (horario) VALUES ('02:30:00');

INSERT INTO horas (horario) VALUES ('03:00:00');

INSERT INTO horas (horario) VALUES ('03:30:00');

INSERT INTO horas (horario) VALUES ('04:00:00');

INSERT INTO horas (horario) VALUES ('04:30:00');

INSERT INTO horas (horario) VALUES ('05:00:00');

INSERT INTO horas (horario) VALUES ('05:30:00');

INSERT INTO horas (horario) VALUES ('06:00:00');

INSERT INTO horas (horario) VALUES ('06:30:00');

INSERT INTO horas (horario) VALUES ('07:00:00');

INSERT INTO horas (horario) VALUES ('07:30:00');

INSERT INTO horas (horario) VALUES ('08:00:00');

INSERT INTO horas (horario) VALUES ('08:30:00');

INSERT INTO horas (horario) VALUES ('09:00:00');

INSERT INTO horas (horario) VALUES ('09:30:00');

INSERT INTO horas (horario) VALUES ('10:00:00');

INSERT INTO horas (horario) VALUES ('10:30:00');

INSERT INTO horas (horario) VALUES ('11:00:00');

INSERT INTO horas (horario) VALUES ('11:30:00');

INSERT INTO horas (horario) VALUES ('12:00:00');

INSERT INTO horas (horario) VALUES ('12:30:00');

INSERT INTO horas (horario) VALUES ('13:00:00');

INSERT INTO horas (horario) VALUES ('13:30:00');

INSERT INTO horas (horario) VALUES ('14:00:00');

INSERT INTO horas (horario) VALUES ('14:30:00');

INSERT INTO horas (horario) VALUES ('15:00:00');

INSERT INTO horas (horario) VALUES ('15:30:00');

INSERT INTO horas (horario) VALUES ('16:00:00');

INSERT INTO horas (horario) VALUES ('16:30:00');

INSERT INTO horas (horario) VALUES ('17:00:00');

INSERT INTO horas (horario) VALUES ('17:30:00');

INSERT INTO horas (horario) VALUES ('18:00:00');

INSERT INTO horas (horario) VALUES ('18:30:00');

INSERT INTO horas (horario) VALUES ('19:00:00');

INSERT INTO horas (horario) VALUES ('19:30:00');

INSERT INTO horas (horario) VALUES ('20:00:00');

INSERT INTO horas (horario) VALUES ('20:30:00');

INSERT INTO horas (horario) VALUES ('21:00:00');

INSERT INTO horas (horario) VALUES ('21:30:00');

INSERT INTO horas (horario) VALUES ('22:00:00');

INSERT INTO horas (horario) VALUES ('22:30:00');

INSERT INTO horas (horario) VALUES ('23:00:00');

INSERT INTO horas (horario) VALUES ('23:30:00');