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é
6abbf82a89
So long, visitor pattern!
2020-12-23 09:02:17 +01:00
Gwendal Roué
e72007c1dd
Make SQLiteral.subquery a promise
...
This allows us to postpone CTEs definition until a db connection is available
2020-12-13 18:29:43 +01:00
Gwendal Roué
ab502baa20
CommonTableExpression.contains(_:)
2020-12-13 18:29:28 +01:00
Gwendal Roué
992f2a2d83
Revert "CommonTableExpression.contains(_:)"
...
This reverts commit f94cecb329 .
We can't expose a raw table name like that, because it may be used several times, and need an alias.
2020-12-08 18:36:51 +01:00
Gwendal Roué
f94cecb329
CommonTableExpression.contains(_:)
2020-12-06 19:22:30 +01:00
Gwendal Roué
86cfee4e23
Fix typo
2020-12-05 19:57:54 +01:00
Gwendal Roué
a3351513ce
Optimize inclusion of CTE association
...
In order to count the selected columns of a CTE, we do not need to have SQLite compile the whole CTE request when we have information about the selected columns.
2020-12-05 19:50:47 +01:00
Gwendal Roué
f18bcb67e4
Documentation
2020-12-05 17:56:39 +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é
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é
a1f0f2c9b7
TODO
2020-12-03 09:24:56 +01:00
Gwendal Roué
64776682fe
Drop USING clause until actually needed
2020-12-03 09:21:19 +01:00
Gwendal Roué
a21e6575d8
_AllCTEColumns delegates to AllColumns and _SQLQualifiedAllColumns
2020-12-03 08:37:55 +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é
333ffc1ebe
Documentation
2020-12-02 21:55:51 +01:00
Gwendal Roué
5e8f95ca09
Improve CTE columns counting
2020-12-02 08:09:07 +01:00
Gwendal Roué
b085a29c8c
Cleanup
2020-12-02 08:02:42 +01:00
Gwendal Roué
49e6923156
Prepare recursive CTEs
2020-12-02 06:22:55 +01:00
Gwendal Roué
a7a4858364
Refactor CommonTableExpression initializers
2020-12-02 06:12:55 +01:00
Gwendal Roué
3a38cbe87f
Create CTE without request
2020-12-02 06:00:04 +01:00
Gwendal Roué
2c42d0129c
CTE columns: WITH cte(a, b) AS ...
2020-12-02 05:36:56 +01:00
Gwendal Roué
da5ef961d6
Expose CTE creation method at a documented level
2020-12-02 05:14:26 +01:00
Gwendal Roué
adc6ba1226
Delete dead code
2020-12-01 20:45:11 +01:00
Gwendal Roué
a70b42cbf5
Extract SQLAssociationCondition.using
2020-12-01 20:30:36 +01:00
Gwendal Roué
06000abbfd
Type-safe CTE associations, part 2
2020-12-01 20:04:35 +01:00
Gwendal Roué
67bc47c3b5
Type-safe CTE associations
2020-12-01 20:00:04 +01:00
Gwendal Roué
5c34ab19e2
API rationalization
2020-12-01 19:50:16 +01:00
Gwendal Roué
1238843a44
Cleanup
2020-12-01 19:33:43 +01:00
Gwendal Roué
8000332ec4
Gather CTE methods
2020-12-01 19:29:39 +01:00
Gwendal Roué
0191676063
Using clause for CTE associations
2020-12-01 09:17:05 +01:00
Gwendal Roué
c16da693df
More cte association api experiments
2020-12-01 08:38:39 +01:00
Gwendal Roué
b7b89c5fa9
CTE associations
2020-11-30 21:51:17 +01:00
Gwendal Roué
ec2640a459
CommonTableExpression is a table, after all
2020-11-30 19:21:46 +01:00
Gwendal Roué
755782759a
Cleanup
2020-11-30 18:14:03 +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