Commit Graph

215 Commits

Author SHA1 Message Date
Dave M. 4df9ececba - Fixed a bug occuring when a field was already escaped 2021-04-23 03:03:01 +00:00
Dave M. 1469d167c4 - Added a closure on key to EntityCollection buildArray method.
- Some bugfixes done.
2021-03-29 20:01:31 +00:00
Dave M. 317d62ceaa - Some more work done to allow more flexibility for other plugins 2021-03-24 13:48:09 +00:00
Dave M. 3905047111 - A lot of bugfixes, mainly with escaping (still working on it to get 100% coverage) 2021-03-15 13:42:52 +00:00
Dave M. e3d0e45a4e - Some work done on correcting LDAP package compatibility 2021-03-09 15:25:46 +00:00
Dave M. 71de0a8ac1 Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus
- Reworked the removeQueryFragment.
2021-03-01 16:31:26 +00:00
Dave M. 16c6eb57fb - Added a MssqlRepository
- Adapter some code to allow more flexibility for the new LDAP adapter from ulmus-ldap.
- Insert's fields are now escaped by default.
- A new RelationBuilder was added, a lot of code from the EntityTrait was moved into this. Some code from the Repository class will need to be moved there too.
2021-03-01 16:26:06 +00:00
Dave M. e7d5d5965b - Fixed the missing DISTINCT keyword while rendering select()
- Added a fragment remover in Repository
2021-03-01 16:10:15 +00:00
Dave M. 8f9332fbad Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus 2021-01-26 16:59:29 +00:00
Dave M. e465ecdf32 - Work done on Join and using the @Relation annotation in case there is no join.
- Added some field type (date, Datetime, Time)
- Added a new @Filter annotation which allows to filter repository from relation into a method.
2021-01-26 16:48:40 +00:00
Dave M. b76f6ff9d4 - Work to add compatibility of PHP 8.0 2021-01-06 20:06:20 +00:00
Dave M. 7dd64abf29 - Added a LoadRelation for the repository.
- Added a new @Filter() annotation to the relation; adding it to JOIN is also coming.
- Some bugfixes done within the Where and ConditionTrait.
2021-01-06 19:35:45 +00:00
Dave M. 65de1dd849 - Fixed some mssql caused bugs within Insert and Create into querybuilding
- Added some methods to EntityCollection
2020-12-07 17:26:51 +00:00
Dave Mc Nicoll 9e84bd3536 - Set ID as a bigint by default now.
- EntityCollection now transforms array received from append() into entity and then append them.
- Corrected a big bug within QueryBuilder which was missed when it was made compatible with MSSQL.
2020-12-04 13:21:59 -05:00
Dave Mc Nicoll f74d1907d9 Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus 2020-11-27 12:21:10 -05:00
Dave Mc Nicoll 30a0a80cbe - Added some new method to EntityCollection (replaceWith, mergeWith, randomize, sort)
- WIP on virtual fields
- Some minor bugfixes
2020-11-27 12:09:15 -05:00
Dave M. bcbf65e0b3 - Fixed in the query builder (still a big WIP) 2020-10-20 19:40:44 +00:00
Dave M. efa957fe58 - Merged stash after pull 2020-10-16 15:27:54 +00:00
Dave M. 114fa5be09 - Had to fix a changed behaviour from PHP 7.4 and 7.4.x where __isset() and __get is not called on initialized properties anymore. 2020-10-16 15:04:05 +00:00
Dave M. c8397484e6 - Fixed missed file conflict 2020-10-06 18:06:44 +00:00
Dave M. 6f558f2923 Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus 2020-10-06 17:55:31 +00:00
Dave M. 5be0c8cc01 - Array type can now be assign directly (not as json or serialized)\n- Fixed a bug within WHERE when open() and close() where called without a condition 2020-10-06 17:46:34 +00:00
Dave Mc Nicoll 27d5fd0b08 Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus 2020-10-06 11:46:00 -04:00
Dave Mc Nicoll 5d00a7e394 - Fixed GroupBy 2020-10-06 11:43:31 -04:00
Dave Mc Nicoll 47953a6165 Merge branch 'master' of https://git.mcnd.ca/mcndave/ulmus 2020-10-06 11:39:01 -04:00
Dave Mc Nicoll 07ba3f611b - Refractored Date/time fields
- Added an implode function on EntityCollection
2020-10-06 11:35:54 -04:00
Dave Mc Nicoll 139504f8dd - Added the HAVING and TRUNCATE keyword
- Fixed GroupBy which was not implemented yet
- Added a new SQL raw() function
- From statement now accepts subqueries
2020-10-06 11:00:12 -04:00
Dave Mc Nicoll 538af38769 - Added a new EntityCollection factory 2020-06-29 11:36:41 -04:00
Dave Mc Nicoll 8e521025d3 - Some bugfixes made in Relation
- Fixed search() methods in EntityCollection
- Work done on Relations of EntityTrait ; a lot of work still to be done. It must also move to another file.
2020-06-11 08:47:15 -04:00
Dave Mc Nicoll 4d221859fc - Added Events to repository and entitytrait objects. Some more work to be done on this.
- Diverses bug fixes linked to join and relations
- Field date and datetime are now outputed using given locale.
2020-05-20 15:34:50 -04:00
Dave Mc Nicoll 1839726dc0 - Fixed string's length based on annotation (if set) 2020-04-14 11:36:55 -04:00
Dave Mc Nicoll 2c7449b733 - Fixed a bug within table's name output of Insert and Update where old code was causing a crash. 2020-04-14 10:32:41 -04:00
Dave Mc Nicoll 026a0f4f83 - Fixed the QueryBuilder's escaping problem - adapters are now responsible for escaping identifiers.
- Added a MsSQL offset query fragment. There is still a problem with the way the Repository must act within another adapter.
2020-04-14 09:47:09 -04:00
Dave Mc Nicoll 3ff97f3bf0 - Added identifier escaping to match differents PDO drivers 2020-04-09 13:20:07 -04:00
Dave Mc Nicoll def8decb4e Merge remote-tracking branch 'origin' into dev-sql-escape 2020-04-09 10:00:48 -04:00
Dave Mc Nicoll c64c7778bd - Work done on many-to-many relations - code must still be refactored out of the EntityTrait.
- Fixed Entity::field("propertyname") function to look for name into @Field() annotation and returns it if it exists.
- A lot of bug fixes made into SQL fragments.
2020-04-09 09:50:09 -04:00
Dave Mc Nicoll 1456fe91f2 - Fixed the SearchRequestInterface missing filter() function. 2020-04-09 09:46:22 -04:00
Dave M. 84da4dbb7b - Bugfixes done linked to SearchRequest and Searchable features.
- Fixed a bug introduced into PdoObject exception on latest commit.
- Corrected the open() close() enclosure of query condition.
2020-03-31 13:24:15 -04:00
Dave Mc Nicoll f98cb2ded0 Merge branch 'master' of https://github.com/mcNdave/ulmus 2020-03-28 22:16:45 -04:00
Dave Mc Nicoll 938639a590 - Multiple bugfixe linked to query fragments
- Added a new SearchRequest package to handle search request efficiently
2020-03-28 22:13:29 -04:00
Dave Mc Nicoll 6e84fc7195 - Fixed a bug while retrieving a non-existing field (from a table which has a field not included within your entity) 2020-03-26 16:28:03 -04:00
Dave Mc Nicoll 4b29232543 - Bugfix within PdoObject and Repository
- Added some utilities methods to EntityCollection
2020-03-19 09:55:00 -04:00
Dave Mc Nicoll d03f9ece36 - Removed debug lines 2020-02-17 08:25:09 -05:00
Dave Mc Nicoll d1961ec807 - Work done on insert() and update() function from QueryBuilder.
- Fixed save() and saveAll() from repository
- QueryBuilder can now be flushed after queries.
2020-02-17 08:23:41 -05:00
Dave M. 79fdabe786 - Worked on support for multiple adapters based on @Table() annotation's entity 2020-02-12 22:56:53 -05:00
Dave M. d01e99b18f Merge branch 'master' of https://github.com/mcNdave/ulmus 2020-02-10 15:20:47 -05:00
Dave M. 8a16ab8062 - Fixed Datetime output 2020-02-10 15:19:46 -05:00
Dave Mc Nicoll bd027610f4 - Removed a debug line 2020-02-10 08:27:48 -05:00
Dave Mc Nicoll 2f43fb4559 - More work done on Update, Insert and Delete clause
- Added TOP property to select and delete to fit MSSQL limit's term.
- Added a new interface allowing object's manipulation on save() and load() queries
2020-02-07 16:36:38 -05:00
Dave M. 3dc82b1f0d - Still working on Update and Insert statements 2020-02-05 23:41:57 -05:00