71 lines
1.6 KiB
PHP
71 lines
1.6 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Database\Factories\SourceDatabaseFactory;
|
|
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
|
|
class SourceDatabase extends Model
|
|
{
|
|
use HasFactory;
|
|
|
|
protected $fillable = [
|
|
'name',
|
|
'host',
|
|
'port',
|
|
'database',
|
|
'username',
|
|
'password',
|
|
'driver',
|
|
'description',
|
|
'is_active',
|
|
'last_synced_at',
|
|
];
|
|
|
|
protected $casts = [
|
|
'port' => 'integer',
|
|
'is_active' => 'boolean',
|
|
'last_synced_at' => 'datetime',
|
|
];
|
|
|
|
protected static function newFactory(): SourceDatabaseFactory
|
|
{
|
|
return SourceDatabaseFactory::new();
|
|
}
|
|
|
|
public function tables(): HasMany
|
|
{
|
|
return $this->hasMany(Table::class);
|
|
}
|
|
|
|
public function migrationSchedules(): HasMany
|
|
{
|
|
return $this->hasMany(MigrationSchedule::class, 'source_database_id');
|
|
}
|
|
|
|
public function getConnectionConfig(): array
|
|
{
|
|
$config = [
|
|
'driver' => $this->driver,
|
|
'host' => $this->host,
|
|
'port' => $this->port,
|
|
'database' => $this->database,
|
|
'username' => $this->username,
|
|
'password' => $this->password,
|
|
'charset' => 'utf8',
|
|
'prefix' => '',
|
|
'prefix_indexes' => true,
|
|
];
|
|
|
|
// Add PostgreSQL-specific options
|
|
if ($this->driver === 'pgsql') {
|
|
$config['search_path'] = 'public';
|
|
$config['sslmode'] = 'prefer';
|
|
}
|
|
|
|
return $config;
|
|
}
|
|
}
|