The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

 / 
Mojo-MySQL5-0.09
River stage zero No dependents
/ Mojo::MySQL5::URL

NAME

Mojo::MySQL5::URL - Connection URL

SYNOPSIS


            

              
              
use Mojo::MySQL5::URL;
# Parse
my $url = Mojo::MySQL5::URL->new('mysql://sri:foo@server:3306/test?foo=bar');
say $url->username;
say $url->password;
say $url->host;
say $url->port;
say $url->database;
say $url->options;
# Build
my $url = Mojo::MySQL5::URL->new;
$url->scheme('mysql');
$url->userinfo('sri:foobar');
$url->host('server');
$url->port(3306);
$url->database('test');
$url->options(foo => 'bar');
say "$url";

DESCRIPTION

Mojo::MySQL5::URL implements MySQL Connection string URL for using in Mojo::MySQL5.

ATTRIBUTES

Mojo::MySQL5::URL inherits all attributes from Mojo::URL and implements the following new ones.

database


            

              
              
my $db       = $url->database;
$url         = $url->database('test');

Database name.

options


            

              
              
my $options  = $url->options;
$url         = $url->options->{PrintError} = 1;

Database options.

password


            

              
              
my $password = $url->password;
$url         = $url->password('s3cret');

Password part of URL.

username


            

              
              
my $username = $url->username;
$url         = $url->username('batman');

Username part of URL.

METHODS

Mojo::MySQL5::URL inherits all methods from Mojo::URL and implements the following new ones.

dsn


            

              
              
my $url = Mojo::MySQL5::URL->new('mysql://server:3000/test');
# dbi:mysql:dbname=test;host=server;port=3000
say $url->dsn;

Convert URL to DBI Data Source Name.

parse


            

              
              
$url->parse('mysql://server:3000/test');

Parse URL string.

new


            

              
              
my $url = Mojo::MySQL5::URL->new;
$url->parse('mysql://server:3000/test');
my $url = Mojo::MySQL5::URL->new('mysql://server:3000/test');

SEE ALSO

Mojo::MySQL5, Mojo::URL.