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")