[READ-ONLY] Flexible and powerful Database abstraction library with a familiar PDO-like API. This r…

Repo Url https://github.com/cakephp/database
Clone Url:
Watchers 11
Issues 0
Forks 2
Last Pushed At 2016-04-11
Tags has:composer has:license has:readme keyword:abstraction keyword:database keyword:pdo license:mit version:4.x
Last fetched: on 1/3/20

Recent Activity

Date Commit Message
2025-04-06 Include comments in generated column sql (#18256)
2025-04-06 Update composer branch aliases for split packages. (#18259)
2025-04-06 Update composer branch aliases for split packages. (#18259)
2025-04-06 Include comments in generated column sql (#18256)
2025-04-06 Fixed typos and cleanup.
2025-04-06 Fix update queries with expressions Apply suggested fixes from #18274 along with a couple tests for future us.
2025-03-29 Add comment reflection for sqlserver driver (#18228)
2025-03-29 Being adding SchemaDialect::columnDefinitionSql (#18248) In order to remove duplication between migrations and cakephp/database, we need a method to generate column SQL fragments for DDL operations. The current method in SchemaDialect isn't well suited for this as it requires an `TableSchema` instance which we don't always have in migrations. This new with consumes the output of describeColumns() which migrations will also start using. I've also added `onUpdate` to `TableSchema` reflection for datetime/timestamp columns so that schema generation is consistent between the two APIs. These changes only contain an implementation for MySQL. Other drivers will be implemented in follow up pull requests. * Fix phpstan * Add sqlite implementation of columnDefinitionSql
2025-03-29 Fix CS errors
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 Bump up codesniffer version and fix reported issues. (#18240)
2025-03-29 Retain field comments for SQLserver (#18230) This helps provide more functionality that migrations currently provides in cakephp/database.
2025-03-29 Merge remote-tracking branch 'origin/5.x' into 5.next
2025-03-29 Expand postgres schema reflection (#18227) Add ability to reflect identity generation strategy.
2025-03-29 Expand schema reflection for MySQL (#18226) We needed a few more attributes to reach parity with what migrations will need. Any additional keys should be considered public API but will not be exposed in CakePHP's Database/Table object. This should probably change in the future.
2025-03-29 Add SSL support to Postgres driver (#18222) Implement SSL connection options for the Postgres driver. Add `ssl`, `ssl_key`, `ssl_cert`, `ssl_ca`, and `ssl_mode` configuration options. Update connection DSN generation to include SSL parameters when enabled. Rename `ssl_crt` connection option to `ssl_cert` to align with PostgreSQL. Update related tests and connection string building logic. Fixes #18221 --------- Co-authored-by: Mark Story
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 Fix constraints
2025-03-29 assure updates work with provided types
2025-03-29 fix SQL UPDATE with columns containing spaces The set clause of update queries are always a ComparisonExpression. No need to to use the QueryExpression::_parseCondition method.
2025-03-29 Added support for native uuid type.
2025-03-29 Update dependency constraints for the split packages. This should allow using/testing the 5.next branch of the split packages.
2025-03-29 Add SchemaDialect::describeOptions() Part of #18123.
2025-03-29 Add SchemaDialect::describeForeignKeys() Another step of #18123. TableSchema requires columns to be present for foreignkeys to reference them. This requires reflecting columns in order to get foreign key data. I'm planning on doing more refactoring on SchemaDialect to remove the ephemeral `TableSchema` and to avoid reflecting columns for indexes and foreign keys once all the new reflection methods are complete.
2025-03-29 Add SchemaDialect::describeIndexes Add more of the api from #18123. This formalizes an array API for index reflection. Because `TableSchema` is being used to shim dialects together, we need to reflect the columns in order to build index data.
2025-03-29 Add describeColumns I don't want to break the abstract interface between dialect operations right now, so I'm using a `TableSchema` to shim operations together. Refs #18123
2025-03-29 Fix mistakes
2025-03-29 Move several schema reflection methods to Dialect I want to use cake's schema reflection more extensively in migrations. This will let us reduce the number of schema reflection implementations we need to maintain by one, and also give the framework an improved schema reflection toolkit. Refs #18123
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 phpstan 2.0 (#18014) * get ready for phpstan 2.0 * undo array_values fix * add review changes * fix stan * phpstan 2.0 * fix phpstan for split packages * fix phpstan for tests * re-add method_exists * Apply suggestions from code review Co-authored-by: ADmad --------- Co-authored-by: ADmad
2025-03-29 Add branch alias for 5.next. Update composer.json for sub packages.
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 Add JsonType::setDecodingOptions(). The allows setting the `flags` argument for json_decode() calls.
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 Merge branch '5.x' into 5.next
2025-03-29 Merge 5.x into 5.next
2025-03-29 Merge 5.x into 5.next
2025-03-29 Fix up list array.
2025-03-29 Merge 5.x into 5.next
2025-03-29 Merge branch '5.x' into 5.next