sqler 1.2.0 copy "sqler: ^1.2.0" to clipboard
sqler: ^1.2.0 copied to clipboard

Published 2 months ago • verified publisherfinchdart.com
SDKDartFlutter
PlatformAndroidiOSLinuxmacOSwebWindows
→

Metadata

Package for building SQL queries in Dart, focusing on MySQL support.

More...

1.2.0 #

  • Sqler().toSQL<Sqlite>()

  • BREAKING CHANGE: Renamed mysql_query.dart to sql_query.dart and mysql_model.dart to sql_model.dart for better generic SQL support
  • NEW: Added SQLite support alongside existing MySQL functionality
  • NEW: Introduced generic SQL types (Mysql and Sqlite) for database-specific SQL generation
  • NEW: All toSQL() methods now accept a generic type parameter to generate database-specific SQL
  • NEW: Added SQLite-specific field types (INTEGER, REAL) in FieldTypes enum
  • NEW: Proper quotation handling - backticks for MySQL, double quotes for SQLite
  • NEW: SQLite-compatible auto-increment syntax (AUTOINCREMENT vs AUTO_INCREMENT)
  • NEW: Added sqlite3 dependency for SQLite testing support
  • IMPROVED: Updated all test cases to validate both MySQL and SQLite SQL generation
  • IMPROVED: Enhanced MFieldInt to automatically use correct integer type based on target database
  • IMPROVED: Modified all SQL component classes to extend SQL instead of implementing it
  • IMPROVED: Better abstraction for cross-database compatibility while maintaining existing API

1.1.4 #

  • Added add() and clear() methods to the Where class.
  • Added allSelectFields() function to MTable to generate a list of all columns for selection.
  • Added whereAnd, whereOr, and whereOne methods to the Sqler class.
  • Added OnOne method to summarize On when there is only one.
  • Added Sqler as a new value for QVar to allow using the Sqler class as a value in conditions.

1.1.3 #

  • Fixed table name for JOIN's #23, #21

1.1.2 #

  • Password QVar QVar.password('test', hashType: HashType.sha1) support sha1, md5(default), sha256, sha512, HMAC-SHA256
  • SqlExplain class able to generate EXPLAIN details from other SQL. SqlExplain(sqlerQuery).toSQL()

1.1.0 #

  • Added DISTINCT for QField #16
  • Improve the Aggregate Functions #1
  • Added Validator functionalty for input variables in MField and MTable

1.0.1 #

  • Added MTable and MField classes for table and field abstraction.
  • Implemented SQL generation for CREATE TABLE statements.
  • Improved code structure for easier table definition and management.

1.0.0 #

  • Initial version.

← Metadata

14
likes
150
points
3.43k
downloads

Publisher

verified publisherfinchdart.com

Weekly Downloads

Metadata

Package for building SQL queries in Dart, focusing on MySQL support.

Repository (GitHub)
View/report issues
Contributing

Topics

#sql #mysql #sqlite #sql-builder #dart

Documentation

API reference

Funding

Consider supporting this project:

github.com

License

MIT (license)

Dependencies

crypto, intl

More

Packages that depend on sqler

Back