Help for this page

Select Code to Download


  1. or download this
    sub insert_unique( $table, $column, $value ) {
        state %sths;
        if ( !exists $sths{$table} ) {
             die "Bad table '$table'" unless $table =~ /^[a-z0-9_]+$/;
             die "Bad column '$column'" unless $column =~ /^[a-z0-9_]+$/;
    
  2. or download this
    sub insert_unique( $table, $column, $value ) {
        use Carp;
    ...
        state %good_table = map { $_ => 1 } qw/foo bar baz/;
        if ( !exists $sths{$table} ) {
            confess "Bad table '$table'" unless $good_table{$table};