首页 \ 问答 \ 如何在Firebase Android中查询SQL IN子句(How to perfom query SQL IN clause in Firebase Android)

如何在Firebase Android中查询SQL IN子句(How to perfom query SQL IN clause in Firebase Android)

 如何在Firebase Android中查询SQL IN子句？ 我想在Firebase Recycler适配器中使用它来根据某些条件仅检索一些子项。 类似于以下声明：  
SQL----> select * from posts where city in(10 cities comes here)
 
 我需要Firebase查询才能在Firebase Recycler适配器中使用它。 

How do I query SQL IN clause in Firebase Android? I want to use it in a Firebase Recycler adapter to retrieve only some children based on some condition. Something like the following statement: 
SQL----> select * from posts where city in(10 cities comes here)
 
I need a Firebase query to use that in the Firebase Recycler adapter.

原文：https://stackoverflow.com/questions/40910884

更新时间：2023-05-29 13:05

最满意答案

 FYI，我将Keremk的答案与我的原始大纲相结合，清理了打字错误，将其归纳为返回一系列颜色，并将整个事情进行编译。 结果如下：  
+ (NSArray*)getRGBAsFromImage:(UIImage*)image atX:(int)x andY:(int)y count:(int)count
{
    NSMutableArray *result = [NSMutableArray arrayWithCapacity:count];

    // First get the image into your data buffer
    CGImageRef imageRef = [image CGImage];
    NSUInteger width = CGImageGetWidth(imageRef);
    NSUInteger height = CGImageGetHeight(imageRef);
    CGColorSpaceRef colorSpace = CGColorSpaceCreateDeviceRGB();
    unsigned char *rawData = (unsigned char*) calloc(height * width * 4, sizeof(unsigned char));
    NSUInteger bytesPerPixel = 4;
    NSUInteger bytesPerRow = bytesPerPixel * width;
    NSUInteger bitsPerComponent = 8;
    CGContextRef context = CGBitmapContextCreate(rawData, width, height,
                    bitsPerComponent, bytesPerRow, colorSpace,
                    kCGImageAlphaPremultipliedLast | kCGBitmapByteOrder32Big);
    CGColorSpaceRelease(colorSpace);

    CGContextDrawImage(context, CGRectMake(0, 0, width, height), imageRef);
    CGContextRelease(context);

    // Now your rawData contains the image data in the RGBA8888 pixel format.
    NSUInteger byteIndex = (bytesPerRow * y) + x * bytesPerPixel;
    for (int i = 0 ; i < count ; ++i)
    {
        CGFloat alpha = ((CGFloat) rawData[byteIndex + 3] ) / 255.0f;
        CGFloat red   = ((CGFloat) rawData[byteIndex]     ) / alpha;
        CGFloat green = ((CGFloat) rawData[byteIndex + 1] ) / alpha;
        CGFloat blue  = ((CGFloat) rawData[byteIndex + 2] ) / alpha;
        byteIndex += bytesPerPixel;

        UIColor *acolor = [UIColor colorWithRed:red green:green blue:blue alpha:alpha];
        [result addObject:acolor];
    }

  free(rawData);

  return result;
}

FYI, I combined Keremk's answer with my original outline, cleaned-up the typos, generalized it to return an array of colors and got the whole thing to compile. Here is the result: 
+ (NSArray*)getRGBAsFromImage:(UIImage*)image atX:(int)x andY:(int)y count:(int)count
{
    NSMutableArray *result = [NSMutableArray arrayWithCapacity:count];

    // First get the image into your data buffer
    CGImageRef imageRef = [image CGImage];
    NSUInteger width = CGImageGetWidth(imageRef);
    NSUInteger height = CGImageGetHeight(imageRef);
    CGColorSpaceRef colorSpace = CGColorSpaceCreateDeviceRGB();
    unsigned char *rawData = (unsigned char*) calloc(height * width * 4, sizeof(unsigned char));
    NSUInteger bytesPerPixel = 4;
    NSUInteger bytesPerRow = bytesPerPixel * width;
    NSUInteger bitsPerComponent = 8;
    CGContextRef context = CGBitmapContextCreate(rawData, width, height,
                    bitsPerComponent, bytesPerRow, colorSpace,
                    kCGImageAlphaPremultipliedLast | kCGBitmapByteOrder32Big);
    CGColorSpaceRelease(colorSpace);

    CGContextDrawImage(context, CGRectMake(0, 0, width, height), imageRef);
    CGContextRelease(context);

    // Now your rawData contains the image data in the RGBA8888 pixel format.
    NSUInteger byteIndex = (bytesPerRow * y) + x * bytesPerPixel;
    for (int i = 0 ; i < count ; ++i)
    {
        CGFloat alpha = ((CGFloat) rawData[byteIndex + 3] ) / 255.0f;
        CGFloat red   = ((CGFloat) rawData[byteIndex]     ) / alpha;
        CGFloat green = ((CGFloat) rawData[byteIndex + 1] ) / alpha;
        CGFloat blue  = ((CGFloat) rawData[byteIndex + 2] ) / alpha;
        byteIndex += bytesPerPixel;

        UIColor *acolor = [UIColor colorWithRed:red green:green blue:blue alpha:alpha];
        [result addObject:acolor];
    }

  free(rawData);

  return result;
}

如何在Firebase Android中查询SQL IN子句(How to perfom query SQL IN clause in Firebase Android)

最满意答案

相关问答

如何从UIImage（Cocoa Touch）或CGImage（Core Graphics）获取像素数据？(How to get pixel data from a UIImage (Cocoa Touch) or CGImage (Core Graphics)?)[2024-02-14]

核心图形对CGImage的效果(Core Graphics pointillize effect on CGImage)[2023-12-11]

如何从UIImage或CGImage获取基础像素数据？(How can I get the underlying pixel data from a UIImage or CGImage?)[2022-01-04]

使用CGImage.ScreenImage和UIImagePickerController Mono Touch的内存问题(Memory issue using CGImage.ScreenImage and UIImagePickerController Mono Touch)[2022-06-30]

用Core Graphics绘制UIImage？(Draw an UIImage with Core Graphics?)[2022-10-26]

从drawRect获取UIImage（或CGImage）(get the UIImage (or CGImage) from drawRect)[2023-08-13]

Re：在swift中从UIImage / CGImage获取像素数据作为数组(Re: Get pixel data as array from UIImage/CGImage in swift)[2023-08-27]

如何从UIImage NSLog像素RGB？(How to NSLog pixel RGB from a UIImage?)[2024-01-19]

Swift 3 CGImage内存问题(Swift 3 CGImage Memory issue)[2022-03-08]

从包含CGImage的UIImage对象获取NSData(Getting NSData from UIImage object that contains CGImage)[2022-07-26]

相关文章

最新问答