Gwendal Roué
4decdd7dea
SQL Interpolation: add support for collations
2021-01-28 08:10:30 +01:00
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é
befeb07234
Clarify FTS5Pattern(matchingPrefixPhrase:) behavior
2021-01-20 07:51:00 +01:00
Gwendal Roué
267bfb29fe
Merge pull request #892 from eburns-vmware/dev/data_passphrase
...
Provide SQLCipher passphrase as Data
2021-01-09 14:33:46 +01:00
Gwendal Roué
4e551c8c6e
Fix Swiftlint errors
2021-01-09 13:09:44 +01:00
wuyueyang
c86d2d654f
Fix failed to create unicode61 tokenizer as a wrapped tokenizer
2021-01-01 02:13:11 +08: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é
ed32e44bc2
DRY
2020-12-23 10:31:16 +01:00
Gwendal Roué
60a9494434
Fix Swiftlint warnings
2020-12-23 10:10:10 +01:00
Gwendal Roué
51991213ef
Stop observing pragma tables
2020-12-23 10:09:00 +01:00
Gwendal Roué
dc16fae72e
Documentation
2020-12-23 10:08:30 +01:00
Gwendal Roué
b485d4d3dc
forSingleResult is no longer mandatory
2020-12-23 10:08:16 +01:00
Gwendal Roué
7634d3f950
Documentation
2020-12-23 09:23:37 +01:00
Gwendal Roué
6abbf82a89
So long, visitor pattern!
2020-12-23 09:02:17 +01:00
Ed Burns
2de9b2d9ed
Cleaned up documentation and addressed review comments.
2020-12-22 11:29:26 -06:00
Gwendal Roué
0d6f68646c
Turn warning into a TODO
2020-12-19 13:07:24 +01:00
Ed Burns
5546961c8c
Test fixes and cleanup.
2020-12-17 17:10:39 -06:00
Ed Burns
d09571c0ad
Added option to specify passphrase as a Data object, added section to README.
2020-12-17 11:19:05 -06:00
Gwendal Roué
9b15011f17
Move singularity test to SQLAssociationCardinality
2020-12-13 18:29:48 +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é
6a68e31903
Clarify handling of NULL in foreign keys
2020-12-12 12:40:50 +01:00
Gwendal Roué
618be9b5e4
Do not support null in foreign keys more than SQLite itself
2020-12-12 12:40:50 +01:00
Gwendal Roué
4a6a2c5495
Fix typo
2020-12-12 12:40:50 +01:00
Gwendal Roué
4e8d129162
Only use the CTE technique if foreign key columns are not null
2020-12-12 12:40:50 +01:00
Gwendal Roué
cad788e59e
Revert "Prefer CommonTableExpression.contains(_:)"
...
This reverts commit 87a0921586e319ccd4ee02e991ec555c6a915c13.
2020-12-12 12:40:49 +01:00
Gwendal Roué
5eff2448bb
Documentation
2020-12-12 12:40:49 +01:00
Gwendal Roué
aabf6e6247
Prefer CommonTableExpression.contains(_:)
2020-12-12 12:40:49 +01:00
Gwendal Roué
732ec36b67
Documentation
2020-12-12 12:40:49 +01:00
Gwendal Roué
f1196bf924
Limit availability of _SQLRowValue.isAvailable
2020-12-12 12:40:49 +01:00
Gwendal Roué
fcd6a453f0
Replace CTE request with its table name
2020-12-12 12:40:49 +01:00
Gwendal Roué
85af2deced
Document TODOs with row values
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é
c36539adb3
CTEs can enter UPDATE and DELETE queries
2020-12-12 11:06:51 +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é
cc68ef5872
Caveat documentation
2020-12-05 16:13:48 +01:00
Gwendal Roué
63255cabf8
SQL interpolation of CTEs
2020-12-05 13:40:56 +01:00
Gwendal Roué
9d1bcec132
Cleanup filtering of trivially true joining conditions
2020-12-05 12:49:31 +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é
5464d64180
Prevent an infinite loop of self-proxying TableAlias I saw once
2020-12-05 12:24:05 +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