來考一下SQL知識
如果兩個Table,size分別是m跟n,m>0 請問inner join的話最多會產生多少record?
- max(m, n)
- min(m, n)
- m + n
NSString* docPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject]; | |
NSString* dbPath = [docPath stringByAppendingPathComponent:@"mydatabase.db"]; | |
NSFileManager *fm = [NSFileManager defaultManager]; | |
// Check if the database is existed. | |
if(![fm fileExistsAtPath:dbPath]) | |
{ | |
// If database is not existed, copy from the database template in the bundle | |
NSString* dbTemplatePath = [[NSBundle mainBundle] pathForResource:@"mydatabase" ofType:@"db"]; | |
NSError* error = nil; |
#import <Foundation/Foundation.h> | |
@interface NSInvocation (PopcornyLu) | |
+ (NSInvocation*) invocationWithTarget:(id)target | |
selector:(SEL)selector; | |
+ (NSInvocation*) invocationWithTarget:(id)target | |
selector:(SEL)selector | |
arguments:(id)firstArg, ... NS_REQUIRES_NIL_TERMINATION; | |
@end |
#import "NSString+template.h" | |
@implementation NSString (template) | |
+(NSString*)stringWithTemplate:(NSString*)template | |
fromMap:(NSDictionary*)map | |
{ | |
NSString* retStr = nil; | |
NSMutableString* buffer = [NSMutableString new]; | |
NSScanner* scanner = [[NSScanner alloc] initWithString:template]; |
#Referecne: | |
# 1. https://gist.github.com/zenorocha/7159780 | |
# 2. | |
#install xcode command tool | |
xcode-select --install | |
# check |
import java.util.function.Function; | |
public class Iterables { | |
public static <F, T> Iterable<T> map( | |
Iterable<F> iterable, | |
Function<F, T> mapper) | |
{ | |
return null; | |
} | |
} |
import java.util.LinkedList; | |
import java.util.Random; | |
import java.util.concurrent.CompletableFuture; | |
import java.util.concurrent.Executor; | |
import java.util.concurrent.ExecutorService; | |
import java.util.concurrent.Executors; | |
import java.util.function.BiConsumer; | |
import java.util.function.Supplier; | |
public class ThrottlingInvoker{ |
#!/bin/bash | |
set -euo pipefail | |
if [[ $# -ne 2 ]]; then | |
echo "Usage: kubectl-mvpvc <ns1/pvc1> <ns2/pvc2>" | |
exit 1 | |
fi | |
NS_PVC_FROM=$1 | |
NS_PVC_TO=$2 |
The new added output is mark as +
$ piperider compare
...
[ OK ] orders.customer_id not_null_orders_customer_id
[ OK ] orders.gift_card_amount not_null_orders_gift_card_amount
[ OK ] orders.order_id not_null_orders_order_id
[ OK ] orders.order_id unique_orders_order_id