what-the-diff[bot]
commented
4 months ago PR Summary
-
AbstractPdoConnection.php Changes
- The connection class has been updated to use a new library for database operation. This change improves connectivity with the database.
-
AbstractDDLQueryBuilder.php Updates
- A method for adding dimensions was introduced to this class in order to make it more flexible. The function can handle additional types of input.
-
AbstractDMLQueryBuilder.php Modifications
- Altered a method that handles data typing to make it more versatile. As a result, data input and output operations should become more efficient.
-
AbstractQueryBuilder.php Changes
- Enhanced the building of queries by adding better data pattern detection. This provides more reliable data manipulation and extraction.
-
New Files - ColumnDefinitionBuilder & ColumnDefinitionBuilderInterface
- These new files were added for the sake of managing column definitions. They make it easier to specify what each column in a database table should be like.
-
DDLQueryBuilderInterface.php Updates
- The
addColumnmethod was expanded to support a wider variety of input, improving our usage of the method as it now can accept more types of inputs.
- The
-
QueryBuilderInterface.php Adjustments
- We improved the ability to build column definitions via an added method. This allows column definitions to be formulated more easily.
-
Removal of AbstractColumnSchema.php
- An old file was removed due to obsolescence.
-
Changes to AbstractTableSchema.php & AbstractSchema.php
- The construction and column handling methods of table schema classes were significantly adjusted, leading to improved flexibility and greater clarity in code usage.
-
Additions of New Column Files
- A variety of new column classes (like
BigIntColumn,BinaryColumn, etc.) were introduced for better handling of database attributes.
- A variety of new column classes (like
-
Additions of New Schema Column Files
- Several files were added for a more robust column creation process. They contain classes and interfaces for creating column schemas based on database column types.
-
Changes to Column, ColumnBuilder, ColumnFactory Files
- These files were updated with methods for creating and managing columns based on database or abstract types.
-
Renaming and Moving of ColumnSchemaInterface
- The interface was renamed and relocated to better align with its purpose. Several new features were also added to expand its functionality.
-
Addition of New Column Classes
- Several new column classes were added, each handling specific data types, which extends our ability to handle varied types of database attributes better.
-
Adjustment to SchemaInterface
- New methods were added allowing for creation and defining values for various column types.
-
Modification to TableSchemaInterface
- Altered column-related methods to use the new
ColumnInterfacefor a more optimal database operation experience.
- Altered column-related methods to use the new
-
Test Case Updates
- The changes were reflected in corresponding test cases to ensure the new code works as intended, enhancing code reliability.
-
Addition and Changes to Test Files
- New test associated files were added or updated to efficiently verify the changes in code and ensure its efficacy. It includes test methods for a range of column schemas and operations, which improves the testing process.
All these changes collectively aim to expand capabilities of database operations, making the system much more versatile. From running queries in a more effective way to handling a wide variety of column types, these updates bring greater flexibility and utility to the table.
codecov[bot]
This is a draft to see new concept of columns for version 2.0
Main changes:
ColumnSchema::$nameandColumnSchema::$precision(useColumnSchema::$size)ColumnSchema::$enumValuestoColumnSchema::$values(related with some issues)ColumnSchema::getFullDbType()method to get full name of the type, e.g.varchar(20)pkabstract type constantsColumnSchemaInterface::...pkuseColumnBuilder::...pk()insteadAbstractColumnandColumnInterfacemarked as deprecated till version 3.0.0AbstractColumnSchemarenamed toColumnTypeColumnclasses (IntegerColumn,StringColumn, etc)ColumnFactory,ColumnBuilderandColumnDefinitionBuilderTableSchema(instead ofAbstractSchema::resolveTableName())The changes will solve few issues and after related improvements it will solve few more issues. It will allow specify any php type or object type for any db type or table column.