PgSqlDriver (materialized views, partitioned tables)

nette / database

💾 A database layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.

https://doc.nette.org/database

Other

502 stars 107 forks source link

PgSqlDriver (materialized views, partitioned tables) #287

Closed milo closed 2 years ago

milo commented 2 years ago

new feature
BC break? no
doc PR: not needed

Updated PgSqlDriver and SqlsrvDriver to use explicitly PDO::FETCH_ASSOC - tests were failing because of both ASSOC & NUMERIC fetching.

PgSqlDriver::getColumns() now returns columns of materialized view too.

Improved @otuhacek's commit (#286) and covered by test.

dg commented 2 years ago

Thanks