package mantra.sql.orm

MySQLAdapter

CLASS public class MySQLAdapter implements DatabaseAdapter

MySQL 8.0 InnoDB adapter supporting connection pooling, prepared statements, and caching_sha2_password authentication.

🏗️ Constructor Summary

Constructor Signature
def __init__(self, host: String, port: Int, db_name: String, user: String)

⚙️ Method Summary

Modifier & Return Type Method Signature Description
Bool connect() Connects to MySQL server via TCP socket.
String execute(sql: String) Executes query against InnoDB engine.
String get_driver_name() Returns 'MySQL 8.0 Adapter'.

🔍 Detailed Method Specifications

pub def connect() -> Bool
Connects to MySQL server via TCP socket.
pub def execute(sql: String) -> String
Executes query against InnoDB engine.
pub def get_driver_name() -> String
Returns 'MySQL 8.0 Adapter'.

💡 Example Usage

mysqladapter_example.mantra
let db = MySQLAdapter("127.0.0.1", 3306, "app_db", "root")
db.connect()
db.execute("SELECT * FROM users")