use function Minnow\Core\Hook\{on, emit, onFilter, filter};

// Register a listener
on('user.created', function(User $user) {
    sendWelcomeEmail($user);
});

// With priority (lower runs first, default is 10)
on('app.boot', $earlyHandler, 5);
on('app.boot', $lateHandler, 15);

// Emit an event
emit('user.created', $user);

// Register a filter
onFilter('post.title', function(string $title): string {
    return htmlspecialchars($title);
});

// Chain multiple filters
onFilter('post.content', fn($c) => nl2br($c));
onFilter('post.content', fn($c) => linkify($c));

// Apply filters to a value
$safeTitle = filter('post.title', $rawTitle);
$html = filter('post.content', $markdown);

// Remove a listener
off('user.created', $callback);

// Check if listeners exist
if (hasListener('custom.event')) { ... }

// Execution counts
$count = emitCount('page.viewed');

// Currently executing hook
$current = current(); // Returns hook name or null

// Check if hook is running
if (isRunning('data.save')) { ... }

// Core events
on('app.boot', ...);
on('app.shutdown', ...);

// Entity events
on('entity.post.created', ...);
on('entity.user.updated', ...);

// Plugin events
on('plugin.gravity-forms.entry.submitted', ...);
on('plugin.woocommerce.order.completed', ...);

use Minnow\Core\Database\Connection;
use function Minnow\Core\Database\{db, query, schema, transaction};

// Initialize from config
$connection = Connection::fromConfig([
    'host' => 'localhost',
    'database' => 'minnow',
    'username' => 'root',
    'password' => '',
    'prefix' => 'wp_',
]);
Connection::setInstance($connection);

// Or use DSN directly
$connection = new Connection(
    'mysql:host=localhost;dbname=minnow;charset=utf8mb4',
    'username',
    'password',
    'wp_'
);

// Select queries
$posts = query('posts')
    ->select('ID', 'post_title', 'post_status')
    ->where('post_status', 'publish')
    ->where('post_type', 'post')
    ->orderByDesc('post_date')
    ->limit(10)
    ->get();

// Single row
$user = query('users')->where('ID', 1)->first();

// Single value
$title = query('posts')->where('ID', 1)->value('post_title');

// Column values
$emails = query('users')->where('status', 'active')->pluck('user_email');

// Aggregates
$count = query('posts')->where('post_status', 'publish')->count();
$exists = query('users')->where('user_email', $email)->exists();

// Where clauses
query('posts')
    ->where('status', 'publish')           // status = 'publish'
    ->where('views', '>', 100)             // views > 100
    ->orWhere('featured', 1)               // OR featured = 1
    ->whereIn('type', ['post', 'page'])    // type IN ('post', 'page')
    ->whereNull('deleted_at')              // deleted_at IS NULL
    ->whereLike('title', '%hello%')        // title LIKE '%hello%'
    ->whereBetween('price', 10, 50);       // price BETWEEN 10 AND 50

// Pagination
$page1 = query('posts')->forPage(1, 20)->get();  // First 20
$page2 = query('posts')->forPage(2, 20)->get();  // Next 20

// Insert (returns ID)
$id = db()->insert('posts', [
    'post_title' => 'Hello World',
    'post_status' => 'draft',
]);

// Update (returns affected rows)
$affected = db()->update('posts',
    ['post_status' => 'publish'],  // SET
    ['ID' => $id]                   // WHERE
);

// Delete (returns affected rows)
$affected = db()->delete('posts', ['ID' => $id]);

// Via query builder
query('posts')->where('status', 'trash')->delete();
query('posts')->where('ID', $id)->update(['views' => 100]);

transaction(function($db) {
    $postId = $db->insert('posts', ['post_title' => 'New Post']);
    $db->insert('postmeta', [
        'post_id' => $postId,
        'meta_key' => '_thumbnail_id',
        'meta_value' => 123,
    ]);
    // Auto-commits on success, rolls back on exception
});

// Create table
schema()->create('items', function($table) {
    $table->id();                           // BIGINT AUTO_INCREMENT PRIMARY KEY
    $table->string('title', 200);           // VARCHAR(200)
    $table->text('description')->nullable(); // TEXT NULL
    $table->decimal('price', 10, 2);        // DECIMAL(10,2)
    $table->boolean('active')->default(1);  // TINYINT(1) DEFAULT 1
    $table->timestamps();                    // created_at, updated_at
    $table->index('title');                 // INDEX
    $table->unique('sku');                  // UNIQUE INDEX
});

// Check existence
if (!schema()->hasTable('items')) { ... }
if (!schema()->hasColumn('items', 'sku')) { ... }

// Drop table
schema()->dropIfExists('items');

use Minnow\Core\Entity\{Post, User, Comment};

// Find by primary key
$post = Post::find(1);
$user = User::findOrFail(1);  // Throws EntityNotFoundException if not found

// Find by condition
$user = User::firstWhere('user_email', 'admin@example.com');

// Find all
$posts = Post::all();

// Query with conditions
$published = Post::where('post_status', 'publish');
$recent = Post::where('post_date', '>', '2024-01-01');

// Create new entity
$post = Post::create([
    'post_title' => 'Hello World',
    'post_status' => 'draft',
    'post_type' => 'post',
    'post_author' => 1,
]);

// Or build and save
$post = new Post([
    'post_title' => 'Another Post',
]);
$post->post_status = 'publish';
$post->save();

// Update existing
$post->post_title = 'Updated Title';
$post->save();

// Delete
$post->delete();

$posts = Post::where('post_status', 'publish');

// Iteration
foreach ($posts as $post) { ... }

// Utility methods
$titles = $posts->pluck('post_title');
$byAuthor = $posts->groupBy('post_author');
$first = $posts->first();
$count = $posts->count();

// Filtering and sorting
$featured = $posts->filter(fn($p) => $p->menu_order > 0);
$sorted = $posts->sortBy('post_date', 'desc');
$top5 = $posts->take(5);

// Conversion
$array = $posts->toArray();
$json = $posts->toJson();

use Minnow\Core\Entity\Entity;

class Product extends Entity
{
    protected static string $table = 'products';
    protected static string $primaryKey = 'id';

    // Mass-assignable attributes
    protected static array $fillable = ['name', 'price', 'sku', 'status'];

    // Hidden from toArray/toJson output
    protected static array $hidden = ['cost', 'supplier_id'];

    // Type casting
    protected static array $casts = [
        'id' => 'int',
        'price' => 'float',
        'active' => 'bool',
        'metadata' => 'json',      // Auto JSON encode/decode
        'created_at' => 'datetime', // Returns DateTime object
    ];

    // Auto-manage created_at/updated_at
    protected static bool $timestamps = true;

    // Custom methods
    public function isInStock(): bool
    {
        return $this->quantity > 0;
    }
}

// Posts
$posts = Post::published();
$pages = Post::ofType('page');
$author = $post->author();  // Returns User
$children = $post->children();

// Users
$user = User::findByEmail('admin@example.com');
$user = User::findByLogin('admin');
$posts = $user->posts();

// Comments
$comments = Comment::forPost($postId);
$approved = Comment::approved();
$replies = $comment->replies();

use function Minnow\Core\Auth\{
    auth, user, authenticated, guest, can, hasRole, isAdmin,
    attempt, logout, hashPassword, verifyPassword
};

// Attempt login with email or username
if (attempt('admin@example.com', 'password')) {
    echo "Logged in as " . user()->display_name;
}

// Check authentication
if (authenticated()) {
    $currentUser = user();
    $userId = userId();
}

if (guest()) {
    // Not logged in
}

// Logout
logout();

// Check capabilities (WordPress-compatible)
if (can('manage_options')) {
    // Show admin settings
}

if (can('edit_posts')) {
    // Allow post editing
}

// Check roles
if (hasRole('administrator')) { ... }
if (hasRole('editor')) { ... }

// Shortcut for admin check
if (isAdmin()) {
    // Full admin access
}

// Hash a new password (uses bcrypt by default)
$hash = hashPassword('secret123');

// Verify a password (works with both WordPress and modern hashes)
if (verifyPassword('secret123', $hash)) {
    // Password correct
}

// WordPress passwords are automatically rehashed to bcrypt on login

$session = auth()->session();

// Store data
$session->set('cart', ['item1', 'item2']);

// Retrieve data
$cart = $session->get('cart', []);

// Flash messages (available for one request)
$session->flash('success', 'Post saved!');
$message = $session->getFlash('success');

// Destroy session
$session->destroy();