| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
|
|
| |
database
I was testing and another process had the database open, so it couldn't commit
changes. This wasn't apparent from the UI because it would just silently assume
a commit went fine.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- 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.
|
| |
|
| |
|
|
|
|
| |
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@599 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
| |
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@430 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
| |
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@423 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
|
|
| |
hard task, but worth it
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@414 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
| |
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@407 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
| |
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@406 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
|
|
|
|
| |
much easier to write
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@396 b3834d28-1941-0410-a4f8-b48e95affb8f
|
|
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@388 b3834d28-1941-0410-a4f8-b48e95affb8f
|