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}"); | |
} | |
}); |
This comment has been minimized.
This comment has been minimized.
Does anyone know if any other options are supported? I.E. can I tell TP to use the "local" color scheme when it opens? I don't want to save a permanent connection, but it'd be cool to mimic some of the same features. |
This comment has been minimized.
This comment has been minimized.
Apparently there are other features. I blogged about it here: Advanced TablePlus Command Line Usage |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
You inspire me, I convert your script to bash script as function in my
~/.zshrc