Skip to content

Instantly share code, notes, and snippets.

@djekl
Forked from calebporzio/artisan_db_open.php
Created February 1, 2020 20:51
Show Gist options
  • Save djekl/b54267d1b8d98d5eecd10f068bd69e9a to your computer and use it in GitHub Desktop.
Save djekl/b54267d1b8d98d5eecd10f068bd69e9a to your computer and use it in GitHub Desktop.
An artisan command for opening the project's database in TablePlus
<?php
Artisan::command('db:open {connection?}', function ($connection = null) {
if (! file_exists('/Applications/TablePlus.app')) {
$this->warn('This command uses TablePlus, are you sure it\'s installed?');
$this->line("Install here: https://tableplus.com/\n");
}
$driver = $connection ?: config('database.default');
$host = config("database.connections.{$driver}.host");
$user = config("database.connections.{$driver}.username");
$password = config("database.connections.{$driver}.password");
$database = config("database.connections.{$driver}.database");
if ($driver === 'sqlite') {
exec("open {$database}");
} else {
exec("open {$driver}://{$user}:{$password}@{$host}/{$database}");
}
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment