implement filter() for types that had their own compare()

streamline select and filter

both should use the same parameter names

isset is not good for testing an array containing NULL

method signature adjustments in mock objects

integrate select() into SchemaData

Because the signature of buildGetDataSQL() had to change a lot of tests
are breaking currently. Those tests need to be adjusted first, then we
can see if the imple

integrate select() into SchemaData

Because the signature of buildGetDataSQL() had to change a lot of tests
are breaking currently. Those tests need to be adjusted first, then we
can see if the implemention itself is correct.

After this has been done, the select has to be adjusted to select the
pageid as PID to make it available to possible select() implementations
that rely on the availability of that alias.

show more ...

group by the alias not the raw column

since the type may do somthing more fancy than accessing the column

have types define the column selection

introduce getSelectStatement to modify selects later on

introduce getColName vs. getFullColName

register a JSON function in sqlite

This way types could select multiple columns into a single return value.

It probably makes sense to register a similar function as a AGGREGATE
function as well.

store page titles in DB for reference

All page titles are now stored in the database to reference them later
in queries for the page type.

add a titles table

simplify compare switch

rename $type to $op to avoid confusion about what a type is

Test miscellaneous syntax Like group by and order by

Run tests on stable again

With the new stable release Elenor of Tsort, struct should run with out
out problems.

first idea for passing the QueryBuilder to types

this is not final but a base for discussion

use generic where in Search

Ensure Exception on conflicting or missing alias

make generic where() available to use

this makes it easier to pass the logic operator dynamically

Test overwriting in SELECTs and arbitrary SELECTs

Test Select functionality

addSelectStatement has yet to get tests

code style adjustment, no single line exceptions

Ensure Exception on duplicate alias and fix comma

Add test for QueryBuilder joins