在 Firebase 函数中运行查询时,我的查询无法正常工作。它在客户端完美运行,但不适用于函数。想知道是否有办法让它也与 Admin SDK 一起工作。我的查询有什么可怕的错误吗?
参数:
searchQuery = {
start:
"[native Date Fri Feb 08 2019 00:00:00 GMT+0200 (Itä-Euroopan normaaliaika)]",
end:
"[native Date Fri Feb 08 2019 23:59:59 GMT+0200 (Itä-Euroopan normaaliaika)]",
cafeIds: ["LI088001"],
textSearch: "",
time: { time: "00-24", label: "Kokopäivä" }
}
sort = {
"column": "created",
"value": "asc"
}
询问:
let ref = firestoreDB.collection('events')
ref = ref.where('created', '>=', searchQuery.start).where('created', '<=', searchQuery.end)
for (const cafe of searchQuery.cafeIds) {
ref = ref.where('cafeId', '==', cafe)
}
ref = ref.where(`time.${searchQuery.time.time}`, '==', true)
if (searchQuery.textSearch !== '') {
ref = ref.where(
'products.',
'array-contains',
lowerCase(searchQuery.textSearch)
)
}
if (sort.field === 'created') {
ref = ref.orderBy('created', sort.value)
} else if (sort.field === 'productCount') {
ref = ref
.orderBy('created', 'asc')
.orderBy('productCount', sort.value)
} else if (sort.field === 'total') {
ref = ref
.orderBy('created', 'asc')
.orderBy('total', sort.value)
} else {
ref = ref.orderBy('created', 'asc').orderBy('eventId', 'asc')
}
const query = await ref.limit(10).get()
将相同的代码放入用打字稿编写的函数时,我收到以下错误:
src/storage/exportCsv.f.ts:25:5 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
Property 'id' is missing in type 'Query'.
25 ref = ref.where('created', '>=', searchQuery.start).where('created', '<=', searchQuery.end)
~~~
src/storage/exportCsv.f.ts:28:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
28 ref = ref.where('cafeId', '==', cafe)
~~~
src/storage/exportCsv.f.ts:31:5 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
31 ref = ref.where(`time.${searchQuery.time.time}`, '==', true)
~~~
src/storage/exportCsv.f.ts:34:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
34 ref = ref.where(
~~~
src/storage/exportCsv.f.ts:42:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
42 ref = ref.orderBy('created', sort.value)
~~~
src/storage/exportCsv.f.ts:44:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
44 ref = ref
~~~
src/storage/exportCsv.f.ts:48:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
48 ref = ref
~~~
src/storage/exportCsv.f.ts:52:7 - error TS2322: Type 'Query' is not assignable to type 'CollectionReference'.
52 ref = ref.orderBy('created', 'asc').orderBy('eventId', 'asc')
看起来您在 Admin SDK 中遇到了一些 TypeScript 错误。因此,要么您没有在客户端 JavaScript 中使用 TypeScript,要么服务器上的编译器更加严格。无论哪种方式,您都需要解决每个问题,或者也切换到在 Cloud Functions 中使用纯 JavaScript。
有很多错误,但最常见的似乎是:
类型 'Query' 不能分配给类型 'CollectionReference'。
28 ref = ref.where('cafeId', '==', cafe)
你ref
先在这里定义:
let ref = firestoreDB.collection('events')
由于collection('events
) 返回 a CollectionReference
,因此ref
成为该类型。然后,当您稍后尝试分配ref.where('cafeId', '==', cafe)
给它时,它的类型为Query
( 的祖先CollectionReference
)。所以这是一个类型错误。
解决方案是立即制作ref
类型Query
:
let ref: Query = firestoreDB.collection('events')
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句