Tonkatsu
04/14/2023, 6:24 AMcodehex
04/18/2023, 8:53 AMcodehex
04/18/2023, 8:55 AMTyler
04/18/2023, 10:09 AMcodehex
04/18/2023, 10:17 AMmax-zaki
04/19/2023, 3:53 AMmax-zaki
04/19/2023, 3:57 AMFuture<List<String>> createSignedUrls(List<String> paths) async {
if (paths.isEmpty) {
return <String>[];
}
final String storageUrl = _supabaseStorageClient.storage.url;
final List<SignedUrl> values = await _supabaseStorageClient.storage
.from(_buckeId)
.createSignedUrls(paths, expiresIn);
return values.map((SignedUrl value) {
// 本番環境ではこちら
return value.signedUrl == null ? '' : '$storageUrl${value.signedUrl}';
// ローカル環境ではこちら
return value.signedUrl == null ? '' : '${value.signedUrl}';
}).toList();
}
a.sinn
04/22/2023, 6:39 AMTyler
04/23/2023, 12:17 AMてつぺい
05/01/2023, 2:23 AMCalculusAce
05/01/2023, 5:00 PMkouwasi
05/07/2023, 10:17 AMkouwasi
05/07/2023, 10:22 AMts
function getPostsFilter(filterBy, keyword) {
switch(filterBy) {
case 'email':
return { column: 'user.email', operator: 'ilike', value: keyword }
case 'user_id':
return { column: 'user_id', operator: 'eq', value: keyword }
default:
throw new Error()
}
}
function getPosts(filterBy, keyword) {
let builder = supabase.from('posts, user:users!inner(*)')
if (filterBy) {
const filter = getPostsFilter(filterBy, keyword)
builder = builder.filter(filter.column, filter.operator, filter.value)
}
builder.then(console.log)
}
kouwasi
05/07/2023, 10:29 AMts
function getPostsFilter(filterBy, keyword) {
switch(filterBy) {
case 'fullName':
return { column: [`first_name.ilike.${keyword}`, `last_name.ilike.${keyword}`], operator: 'or', foreignTable: 'users' }
case 'email':
return { column: 'user.email', operator: 'ilike', value: keyword }
case 'userId':
return { column: 'user_id', operator: 'eq', value: keyword }
default:
throw new Error()
}
}
function getPosts(filterBy, keyword) {
let builder = supabase.from('posts, user:users!inner(*)')
if (filterBy) {
const filter = getPostsFilter(filterBy, keyword)
if (filter.operator === 'or') {
builder = builder.or(filter.column, { foreignTable: filter.foreignTable })
} else {
builder = builder.filter(filter.column, filter.operator, filter.value)
}
}
builder.then(console.log)
}
kouwasi
05/07/2023, 10:33 AMてつぺい
05/08/2023, 9:52 AMてつぺい
05/08/2023, 10:01 AMTonkatsu
05/09/2023, 8:55 AMTyler
05/10/2023, 4:45 AMTonkatsu
05/10/2023, 4:52 AMhiroshi nishio
05/10/2023, 8:19 AMInvalid permissions requested
unapproved_scope
KoBaGo
05/12/2023, 7:54 AMkouwasi
05/12/2023, 1:34 PMkouwasi
05/12/2023, 1:55 PMkouwasi
05/12/2023, 1:55 PMKoBaGo
05/15/2023, 1:42 AMADAM
05/17/2023, 4:41 AMADAM
05/17/2023, 5:09 AMkouwasi
05/21/2023, 9:31 PMkouwasi
05/21/2023, 9:32 PM