Leaf DB rewrite - Githubissues

leafsphp / db

🗄 Leaf PHP db module

https://leafphp.dev/modules/db/

6 stars 8 forks source link

Leaf DB rewrite #2

Closed mychidarko closed 2 years ago

mychidarko commented 2 years ago

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
Fixed #1

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