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é
60a9494434
Fix Swiftlint warnings
2020-12-23 10:10:10 +01:00
Gwendal Roué
b485d4d3dc
forSingleResult is no longer mandatory
2020-12-23 10:08:16 +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é
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é
3094c274df
Enhance error message
2020-12-05 10:34:32 +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é
6f409f2140
Fix typo
2020-12-03 09:22:15 +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é
0dc9215df6
Documentation
2020-12-02 22:15:50 +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é
992e8f3423
Remove header
2020-12-02 06:25:18 +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é
2b6c3fb868
Remove misleading comment
2020-12-01 20:38:19 +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é
f31dd0033c
Remove non-composable cte association methods
2020-12-01 08:21:04 +01:00
Gwendal Roué
b7b89c5fa9
CTE associations
2020-11-30 21:51:17 +01:00
Gwendal Roué
c776ee8d47
Association: remove TableRecord requirement
2020-11-30 21:50:18 +01:00
Gwendal Roué
c36fc2813b
Include a raw SQL CTE
2020-11-30 19:29:54 +01:00