NAME

Mojo::MySQL5::Util - Utility functions

SYNOPSIS

  use Mojo::MySQL5::Util qw(quote quote_id);
 
  my $str = "I'm happy\n";
  my $escaped = quote $str;
 

DESCRIPTION

Mojo::MySQL5::Util provides utility functions for Mojo::MySQL5.

FUNCTIONS

Mojo::MySQL5::Util implements the following functions, which can be imported individually.

expand_sql

  my $sql = expand_sql("select name from table where id=?", $id);
 

Replace ? in SQL query with quoted arguments.

flag_list \@names, $int, $separator

  say flag_list(['one' 'two' 'three'], 3, ',');   # one,two
  say flag_list(['one' 'two' 'three'], 4, ',');   # three
  say flag_list(['one' 'two' 'three'], 6);        # one|two|three

List bit flags that are set in integer.

flag_set \@names, @flags

  say flag_set(['one' 'two' 'three'], 'one', 'two');  # 3
  say flag_set(['one' 'two' 'three'])                 # 0

Set named bit flags.

flag_is \@names, $int, $flag

  say flag_is(['one' 'two' 'three'], 1, 'one');     # true
  say flag_is(['one' 'two' 'three'], 3, 'two');     # true
  say flag_is(['one' 'two' 'three'], 3, 'three');   # false

Check if named bit flag is set.

quote

  my $escaped = quote $str;
 

Quote string value for passing to SQL query.

quote_id

  my $escaped = quote_id $id;
 

Quote identifier for passing to SQL query.