Gwendal Roué
8bf9e5e30f
Decouple associations from TableRecord
...
Associations is generic for type safety, not for defining the association (just as QueryInterfaceRequest)
2021-01-23 09:48:18 +01:00
Gwendal Roué
836efb120f
Xcode 12.3 formatting
2020-12-23 12:13:05 +01:00
Gwendal Roué
3a76b84eae
Documentation
2020-12-23 11:16:09 +01:00
Gwendal Roué
ae17e9f893
Documentation
2020-12-23 11:11:27 +01:00
Gwendal Roué
dc16fae72e
Documentation
2020-12-23 10:08:30 +01:00
Gwendal Roué
6abbf82a89
So long, visitor pattern!
2020-12-23 09:02:17 +01:00
Gwendal Roué
9b15011f17
Move singularity test to SQLAssociationCardinality
2020-12-13 18:29:48 +01:00
Gwendal Roué
ab502baa20
CommonTableExpression.contains(_:)
2020-12-13 18:29:28 +01:00
Gwendal Roué
6a68e31903
Clarify handling of NULL in foreign keys
2020-12-12 12:40:50 +01:00
Gwendal Roué
f1196bf924
Limit availability of _SQLRowValue.isAvailable
2020-12-12 12:40:49 +01:00
Gwendal Roué
b70f85d94b
Fix #871
2020-12-12 12:40:49 +01:00
Gwendal Roué
b715206502
Row values
2020-12-12 12:40:49 +01:00
Gwendal Roué
cc68ef5872
Caveat documentation
2020-12-05 16:13:48 +01:00
Gwendal Roué
b60f39e7cc
Merge branch 'development' into dev/cte
...
# Conflicts:
# GRDB/QueryInterface/Request/Association/Association.swift
# GRDB/QueryInterface/Request/QueryInterfaceRequest.swift
# GRDB/QueryInterface/SQL/SQLQuery.swift
# GRDB/QueryInterface/SQLGeneration/SQLGenerationContext.swift
# GRDB/QueryInterface/SQLGeneration/SQLQueryGenerator.swift
2020-12-05 12:31:52 +01:00
Gwendal Roué
1e2d07a16f
Simplify SQLSource
...
SQLSource used to be more or less able to deal with subqueries, as in SELECT ... FROM (SELECT ...).
But we had only one use case for it, the "trivial count query": SELECT COUNT(*) FROM (SELECT ...). And many opportunities for fatal errors, because such subqueries were not generally supported.
So we simplify SQLSource, and implement the trivial count query in another way.
2020-12-05 12:21:14 +01:00
Gwendal Roué
66b23d423f
Cleanup JoinAssociation
2020-12-05 10:54:31 +01:00
Gwendal Roué
378279ee1a
Move the isRecursive flag where it belongs
2020-12-05 10:32:46 +01:00
Gwendal Roué
836a0a5e37
Documentation
2020-12-03 19:15:57 +01:00
Gwendal Roué
91dd13e2be
Merge cte support into AllColumns
2020-12-03 18:51:26 +01:00
Gwendal Roué
64776682fe
Drop USING clause until actually needed
2020-12-03 09:21:19 +01:00
Gwendal Roué
4ee6f3293a
CTE columns are provided as strings
2020-12-03 08:34:43 +01:00
Gwendal Roué
17b884b3dc
Recursive CTEs
2020-12-03 08:28:14 +01:00
Gwendal Roué
0f6d36bfc2
Cleanup
2020-12-03 07:07:39 +01:00
Gwendal Roué
eb2346dfce
Couting requests with CTE uses trivial SQL
2020-12-02 08:26:35 +01:00
Gwendal Roué
2c42d0129c
CTE columns: WITH cte(a, b) AS ...
2020-12-02 05:36:56 +01:00
Gwendal Roué
a70b42cbf5
Extract SQLAssociationCondition.using
2020-12-01 20:30:36 +01:00
Gwendal Roué
1238843a44
Cleanup
2020-12-01 19:33:43 +01:00
Gwendal Roué
c36fc2813b
Include a raw SQL CTE
2020-11-30 19:29:54 +01:00
Gwendal Roué
ec2640a459
CommonTableExpression is a table, after all
2020-11-30 19:21:46 +01:00
Gwendal Roué
96951b3d4e
Remove dead code
2020-11-30 18:10:06 +01:00
Gwendal Roué
36a8cd1352
CTE merging WIP: we need to postpone TableAlias creation
2020-11-29 19:33:46 +01:00
Gwendal Roué
2bb9f5ce0d
First joins with CommonTableExpression
2020-11-29 19:05:12 +01:00
Gwendal Roué
e1d3c1d7dc
Give CommonTableExpression a key, for joins
2020-11-29 18:23:41 +01:00
Gwendal Roué
e7dcf25063
CTE aliases
2020-11-29 15:49:55 +01:00
Gwendal Roué
d2b7b4240a
CTE basis
2020-11-29 15:06:45 +01:00
Gwendal Roué
b6ef89c116
Prefetch cleanup
2020-11-29 11:58:15 +01:00
Gwendal Roué
9529939262
Documentation
2020-07-27 06:40:18 +02:00
Gwendal Roué
6ee7db48c8
Take care of indexes on expressions as well
...
sqlite> create table t(a,b);
sqlite> create index i on t(a like '%a', a, b);
sqlite> explain query plan select * from t where a like '%a';
QUERY PLAN
`--SCAN TABLE t
sqlite> explain query plan select * from t where a not like '%a';
QUERY PLAN
`--SCAN TABLE t
sqlite> explain query plan select * from t where (a like '%a') = 1;
QUERY PLAN
`--SEARCH TABLE t USING COVERING INDEX i (<expr>=?)
sqlite> explain query plan select * from t where (a like '%a') = 0;
QUERY PLAN
`--SEARCH TABLE t USING COVERING INDEX i (<expr>=?)
2020-07-26 16:04:02 +02:00
Gwendal Roué
c532b8709c
Refactor boolean tests ( fix #816 )
2020-07-26 14:19:31 +02:00
Gwendal Roué
845ae7e0e4
Merge pull request #814 from groue/dev/views
...
Fix regression with views
2020-07-23 18:59:16 +02:00
Gwendal Roué
2f54eda08a
Fix #812
2020-07-23 08:46:05 +02:00
Gwendal Roué
e2816905bb
OSX 11 is OSX 10.16
2020-07-22 20:22:03 +02:00
Gwendal Roué
ee2d8eae50
Expose ascNullLast and descNullFirst
...
This is because iOS 14 runs SQLite 3.31.1
2020-07-22 20:17:52 +02:00
Gwendal Roué
7f229468d2
Documentation
2020-07-12 15:12:04 +02:00
Gwendal Roué
07092169bf
Documentation
2020-07-12 14:17:58 +02:00
Gwendal Roué
df92e350c0
Documentation
2020-07-11 20:29:47 +02:00
Gwendal Roué
f9bd457cbd
Cleanup
2020-07-11 18:33:43 +02:00
Gwendal Roué
002287ca28
Close FetchRequest, make it visitable
2020-07-11 17:30:11 +02:00
Gwendal Roué
31e8d926a8
Remove _SQLExpressionVisitor default handling of _SQLExpressionCollate
2020-07-11 13:41:44 +02:00
Gwendal Roué
99ed742555
"row id" -> "rowid"
2020-07-11 13:21:14 +02:00