Open-source social media scheduler built for AI agents and the teams behind them. Create, schedule and publish posts to every network through MCP or the REST API, or write them yourself in a composer your team will love.
PHP ai-agentsblueskyfacebookinstagramlaravellinkedinmastodonmcpmcp-serveropen-sourcerest-apiself-hostedsocial-mediasocial-media-managementsocial-media-schedulerthreadstiktokvuejsxyoutube
<?php
declare(strict_types=1);
use App\Enums\Post\CreatedVia;
use App\Models\Post;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
beforeEach(function () {
$this->tables = [
'automations' => '2026_05_22_211640_create_automations_table',
'automation_trigger_items' => '2026_05_22_211641_create_automation_trigger_items_table',
'automation_runs' => '2026_05_22_211642_create_automation_runs_table',
'automation_node_runs' => '2026_05_22_211643_create_automation_node_runs_table',
'automation_node_states' => '2026_05_23_164734_create_automation_node_states_table',
];
foreach ($this->tables as $table => $migration) {
if (! Schema::hasTable($table)) {
(require database_path("migrations/{$migration}.php"))->up();
}
}
});
test('rewrites automation-created posts to web and drops the automation tables in FK order', function () {
$post = Post::factory()->create(['created_via' => CreatedVia::Web]);
DB::table('posts')->where('id', $post->id)->update(['created_via' => 'automation']);
foreach (array_keys($this->tables) as $table) {
expect(Schema::hasTable($table))->toBeTrue();
}
$migration = require database_path('migrations/2026_09_05_124637_drop_automation_tables.php');
$migration->up();
expect($post->fresh()->created_via)->toBe(CreatedVia::Web);
foreach (array_keys($this->tables) as $table) {
expect(Schema::hasTable($table))->toBeFalse();
}
});