🥙 Flashy

What's Changed

• Add Offset Query Builder #20 by @rohit267 in #23
• Sqlsrv connection string missing port and dbname by @mieszkou in #22
• feat: added transactions support by @ibnsultan in #24

New Contributors

• @rohit267 made their first contribution in #23
• @mieszkou made their first contribution in #22

Full Changelog: v2.2...v2.2.1

💾 Floppy Disk

v2.2 - 25 August 2024

Fixed

• orderBy method chaining fix by @Bazowsky
• add support for client_encoding option with pgsql (fix #16) by @haruspeks
• Patch up config inconsistency

Changed

• Switched to new Leaf Config API

New Contributors

• @Bazowsky made their first contribution
• @haruspeks made their first contribution

💿 Compact Disc '1'

v2.1.1 - 1 Sep 2023

Added

• Added support for database urls

💿 Compact Disc

v2.1.0 - 27 Feb 2023

Added

• Added tableExists method to check if a table exists
• Added createTable method
• Added dropTable method
• Added backup method
• AddedcreateTableIfNotExists method
• Added groupBy method
• Added tests & linting
• Add last insert id

Fixed

• Patch up array to string conversion

Removed

• Remove dummy/unused code

🌿 Chloroplast '2'

v2.0.2 - 29 May 2022

Fixed

• Fixed reading of DB_PORT env
• Fixed array parameter for db init
• Fixed single state for db core

🌿 Chloroplast

v2.0.1 - 24 Jan 2022

Fixed

• fixed inconsistent where blocks
• fixed single unique bug
• fixed update query bug

Changed

• improve instance loading

Removed

• clean up spaces in query

v2.0

Added

• Added support for more database types
• Added support for leaf 3's functional mode
• Added create method
• Added drop method
• Added support for inserting multiple rows
• Added results method
• Added aliases for older commands
• Added find method
• Added better typing

Fixed

• orderBy now modifies the query instead of simply appending ORDER BY...
• limit now modifies the query instead of simply appending LIMIT...
• first now modifies the query instead of running the query and returning the first entry
• last now modifies the query instead of running the query and returning the last entry

Changed

• Switched from mysqli to PDO
• Restructured leaf db
• Updated gitignore
• Moved search wildcards to utils
• Moved heavy query building to Leaf\Db\Builder class
• execute no longer takes in the params types
• where blocks now take in an operator (optional)

Removed

• Removed validate method
• Removed leaf db
• Removed method tracking
• Removed base where builders

v1.0

20 Sep, 2021