laconic_mysql 1.1.0

MySQL driver for the Laconic query builder.

1.1.0

Features

• Implement compileIncrement() / compileDecrement() - Grammar methods for increment/decrement SQL generation with ? placeholders
• JoinClause BETWEEN Support - Add between and betweenColumns type handling in _compileJoinConditions()

Bug Fixes

• Fix Transaction Isolation - Use transactional() method to ensure all queries within a transaction use the same connection
• Fix insertAndGetId() Method - Replace prepared statement with direct execute() call to fix parameter binding issue

1.0.1

Bug Fixes

• Fix insertAndGetId() Placeholder Conversion - Now properly uses _convertPlaceholders() and _createNamedParams() for parameter binding, previously passed raw SQL with ? placeholders to prepared statements
• Fix Prepared Statement Leak - Use try-finally to ensure stmt.deallocate() is always called even when execution fails
• Improved Transaction Error Handling - Rollback failures are now caught and reported alongside the original error instead of silently replacing it

Improvements

• Grammar Singleton - MysqlGrammar is now a static singleton instance, avoiding unnecessary allocations on each access
• Enhanced Exception Handling - All catch blocks now preserve the original exception cause and stackTrace in LaconicException

1.0.0

Initial release of the MySQL driver for Laconic query builder.

Features

• MysqlDriver - MySQL database driver implementing DatabaseDriver interface

  • Connection pooling with configurable max connections (default: 10)
  • Automatic ? to :p0, :p1, ... parameter placeholder conversion
  • Transaction support
  • Proper connection pool cleanup on close

• MysqlGrammar - MySQL-specific SQL grammar extending SqlGrammar

  • Standard SQL syntax compilation
  • ? placeholder parameter binding

• MysqlConfig - Configuration class for MySQL connections

  • host - Database server host (default: localhost)
  • port - Database server port (default: 3306)
  • database - Database name (required)
  • username - Database username (default: root)
  • password - Database password (required)
  • secure - Use secure connection (default: true)

Usage

import 'package:laconic/laconic.dart';
import 'package:laconic_mysql/laconic_mysql.dart';

final laconic = Laconic(MysqlDriver(MysqlConfig(
  database: 'database',
  password: 'password',
)));

final users = await laconic.table('users').get();

await laconic.close();

Dependencies

• laconic: ^2.0.0
• mysql_client: ^0.0.27