aliens/scuttle/src/SemanticScuttle/Service/Factory.php, branch oni My fork of SemanticScuttle https://code.ryuslash.org/aliens/scuttle/atom?h=oni 2024-06-11T06:38:09Z Fix using SQLite as a database engine 2024-06-11T06:38:09Z Tom Willemse 2024-06-11T06:38:09Z urn:sha1:eb81d7b851f51ab5919be78493737ef2abf49aab - The ‘sqlite_*’ functions don't exist anymore in PHP 8. They have been replaced with several ‘SQLite3*’ classes. - There are some differences between MySQL and SQLite queries that showed up while doing this work. These differences have been pushed into a QueryBuilder class so that the other database engines don't have to be modified. This is done in an ad-hoc basis for now, just to get things working. - SQLite doesn't support the ‘!’ negation operator used as ‘!ISNULL(...)’, instead I use ‘IIF(...)’. - SQLite doesn't support a ‘LEFT(...)’ function, instead I use ‘SUBSTRING(..., 0, ...)’. - The SQLite3 module doesn't provide a connection identifier, instead you use an object that represents the connection. - SQLite doesn't support the ‘ALL’ keyword (or at least doesn't support it in the same way MySQL does). Instead of ‘<> ALL <subquery>’ I use ‘NOT IN <subquery>’. - The ‘SQLite3*’ classes don't provide any way to determine how many rows have been returned without iterating through all of them, so any place that tries to figure out the rows beforehand just doesn't anymore. - All the database engine classes require a ‘QueryBuilder’ instance. The sqlite one uses a specialized one. I can't test most of these database engines, so I'm focusing on SQLite and MySQL/MariaDB for now. first test for service factory 2011-04-12T06:47:44Z Christian Weiske 2011-04-12T06:47:44Z urn:sha1:90f29d6e671f4c24f75bdc4774f223c53bf0a46c new config option to disable "SET NAMES UTF8" sql call 2010-02-20T11:23:07Z cweiske 2010-02-20T11:23:07Z urn:sha1:01c792a78969dcfa3e9dd99a4491ccb6836ca8c1 git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@671 b3834d28-1941-0410-a4f8-b48e95affb8f make serviceoverrides user-configurable 2010-02-02T19:25:35Z cweiske 2010-02-02T19:25:35Z urn:sha1:6f7316e4216a19c5b8957a0f397d3aff1919f1f7 git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@626 b3834d28-1941-0410-a4f8-b48e95affb8f tell people how to debug database queries 2009-11-05T08:58:08Z cweiske 2009-11-05T08:58:08Z urn:sha1:5976acf7d1a883cd8ae00a46dbc8ba8346f4ad4a git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@525 b3834d28-1941-0410-a4f8-b48e95affb8f convert tabs to spaces 2009-10-24T09:12:10Z cweiske 2009-10-24T09:12:10Z urn:sha1:9f53c3325c99c1602f570efdaf0b6e0df2944f95 git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@407 b3834d28-1941-0410-a4f8-b48e95affb8f rename ServiceFactory::getServiceInstance() to get() - much easier to write 2009-10-23T17:13:16Z cweiske 2009-10-23T17:13:16Z urn:sha1:68c01cda10ef49b05fffb6e323fa2d34ba5dd2f4 git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@396 b3834d28-1941-0410-a4f8-b48e95affb8f make the file PEAR CS compliant 2009-10-23T16:56:59Z cweiske 2009-10-23T16:56:59Z urn:sha1:3df99a0aec0b926464449e8ca33c808c63d903df git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@395 b3834d28-1941-0410-a4f8-b48e95affb8f revamp service factory 2009-10-23T16:54:51Z cweiske 2009-10-23T16:54:51Z urn:sha1:91eb43bec6dfdd2e16012f0fb56b6eaa87105e3f git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@393 b3834d28-1941-0410-a4f8-b48e95affb8f make the application work again 2009-10-03T21:52:30Z cweiske 2009-10-03T21:52:30Z urn:sha1:d5f09b7e4d802cdc2d5f3f876c48ea918c961488 git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@388 b3834d28-1941-0410-a4f8-b48e95affb8f