#!/usr/bin/perl

use warnings;
use strict;              

use DBI;

my $db_host = "mysql";
my $db_port = "3306";
my $db_user = 'web-user';
my $db_pass = 'pass4monks';
my $db_name = 'order_dev';

my $dbh = DBI->connect(
    "DBI:mysql:database=$db_name;host=$db_host;port=$db_port",
    $db_user, $db_pass
) || die ("ERROR: Unable to connect to '$db_name': $DBI::errstr" );

my ($enum_qry) = $dbh->prepare(
    "SELECT column_type
       FROM information_schema.columns
      WHERE table_name = 'orders' AND column_name = 'request_status'
      LIMIT 1;"
);

$enum_qry->execute;

my $enum_ref = $enum_qry->fetchrow_hashref;

(my $enum_types = $$enum_ref{'column_type'}) =~ s/^enum\((.*)\).*/$1/;

foreach my $enum_type ( eval $enum_types ) {
    print qq[<option value="$enum_type">$enum_type</option>\n];
}