The Perl Toolchain Summit 2025 Needs You: You can help 🙏 Learn more

 / 
Slick-0.007
River stage zero No dependents
/ Slick::Database

NAME

Slick::Database

SYNOPSIS

An OO wrapper around DBI and SQL::Abstract.

Currently Slick::Database supports MySQL and PostgreSQL. Note, you will need to install the driver that you'd like to use manually, as Slick does not come bundled with any.

See Slick::DatabaseExecutor for lower level information on how Slick::Database works.

API

dbi

Returns the underlying DBI driver object associated with the database.

execute

Runs some statement against the underlying DBI driver object associated with the database.

select, select_one, update, delete, insert


            

              
              
my $users = $s->database('my_postgres')
            ->select('users', [ 'id', 'name' ]); # SELECT id, name FROM users;
my $user = $s->database('my_postgres')
            ->select_one('users', [ 'id', 'name', 'age' ], { id => 1 }); # SELECT id, name, age FROM users WHERE id = 1;
$s->database('my_postgres')
  ->insert('users', { name => 'Bob', age => 23 }); # INSERT INTO users (name, age) VALUES ('Bob', 23);
$s->database('my_postgres')
  ->update('users', { name => 'John' }, { id => 2 }); # UPDATE users SET name = 'John' WHERE id = 2;
$s->database('my_postgres')
  ->delete('users', { id => 2 }); # DELETE FROM users WHERE id = 2;

Wrapper around SQL::Abstract, see SQL::Abstract for more information on how to use these methods.

See "dbi" if you would like to directly use the DBI connection instead of SQL::Abstract.

migrations


            

              
              
$s->database('db')->migrations;

Returns a HashRef with all of the migrations associated with the database.

migration


            

              
              
$s->database('db')->migration(
    'migration_id', # id
    'CREATE TABLE foo (id INT PRIMARY KEY);', # up
    'DROP TABLE foo;' # down
);

Create a migration and associate it with the database.

migrate_up


            

              
              
$s->database('db')->migrate_up;

Runs all pending migrations against the database.

If you wish to only migrate a single migration, you can provide the id of the migration you'd like to run:


            

              
              
$s->database('db')->migrate_up('migration_id');

migrate_down


            

              
              
$s->database('db')->migrate_down;

Migrates all migrations down effectively destroying your database.

If you wish to only de-migrate a single migration, you can provide the id of the migration you'd like to run:


            

              
              
$s->database('db')->migrate_down('migration_id');

See also

2 POD Errors

The following errors were encountered while parsing the POD:

Around line 284:

Unknown directive: =over2

Around line 286:

'=item' outside of any '=over'