MySQLPlugin.swift

//
//  MySQLPlugin.swift
//  MySQLDriverPlugin
//
//  MySQL/MariaDB database driver plugin using libmariadb (MariaDB Connector/C)
//

import CMariaDB
import Foundation
import os
import TableProPluginKit

// MARK: - Plugin Entry Point

final class MySQLPlugin: NSObject, TableProPlugin, DriverPlugin {
    static let pluginName = "MySQL Driver"
    static let pluginVersion = "1.0.0"
    static let pluginDescription = "MySQL/MariaDB support via libmariadb"
    static let capabilities: [PluginCapability] = [.databaseDriver]

    static let databaseTypeId = "MySQL"
    static let databaseDisplayName = "MySQL"
    static let iconName = "cylinder.fill"
    static let defaultPort = 3306
    static let additionalConnectionFields: [ConnectionField] = []
    static let additionalDatabaseTypeIds: [String] = ["MariaDB"]

    // MARK: - UI/Capability Metadata

    static let urlSchemes: [String] = ["mysql"]
    static let brandColorHex = "#FF9500"
    static let systemDatabaseNames: [String] = ["information_schema", "mysql", "performance_schema", "sys"]
    static let columnTypesByCategory: [String: [String]] = [
        "Integer": ["TINYINT", "SMALLINT", "MEDIUMINT", "INT", "INTEGER", "BIGINT"],
        "Float": ["FLOAT", "DOUBLE", "DECIMAL", "NUMERIC", "REAL"],
        "String": ["CHAR", "VARCHAR", "TINYTEXT", "TEXT", "MEDIUMTEXT", "LONGTEXT", "ENUM", "SET"],
        "Date": ["DATE", "TIME", "DATETIME", "TIMESTAMP", "YEAR"],
        "Binary": ["BINARY", "VARBINARY", "TINYBLOB", "BLOB", "MEDIUMBLOB", "LONGBLOB", "BIT"],
        "Boolean": ["BOOLEAN", "BOOL"],
        "JSON": ["JSON"],
        "Spatial": ["GEOMETRY", "POINT", "LINESTRING", "POLYGON"]
    ]

    func createDriver(config: DriverConnectionConfig) -> any PluginDatabaseDriver {
        MySQLPluginDriver(config: config)
    }
}