The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

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.