# SQLinker

**Repository Path**: rain-third-floor/SQLinker

## Basic Information

- **Project Name**: SQLinker
- **Description**: sqlite 
- **Primary Language**: Objective-C
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-01-12
- **Last Updated**: 2022-01-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQLinker



## Create

```objective-c
Model* model = [Model new];
[model creatTableWithConstrain:^(ConstraintStatement *make) {
}];
```



## Search sync

```objective-c
NSArray* res = [[Model new] selectFormDB:@"stu" with:^(SQSatemet *context) {
    [context.where(@"age").equalTo(@(i+1000)) end];
}];
```



## Search async

```objective-c
[[Model new] selectFormDBAsync:@"stu" with:^(SQSatemet *context) {
	[context.where(@"age").equalTo(@(i+1000)) end];	
} complite:^(NSArray *res) {
	NSLog(@"%@",[NSDate new]);
}];

```



## Delete

```objective-c
[[Model new] deleteDataFormDB:@"stu" context:^(SQSatemet *make) {
	[make.where(@"age").equalTo(@600) end];
}];
```



## Update

```objective-c
[[Model new] updateDataToDB:@"stu" context:^(SQSatemet *make) {
    [make.set(@"name").equalTo(@"ljj").where(@"name").equalTo(@"mubai") end];
}];
```



## Transaction

```objective-c
[SQTransaction transaction:^BOOL{
    for (int i =0; i< 100000; i++) {
        Model* mode1 = [Model new];
        mode1.age = i+100;
        mode1.sex = i%2;
        mode1.name = @"mubai";
        mode1.birthday = [NSDate new];
        mode1.num = [NSNumber numberWithInteger:i];
        if (![mode1 insert]) {
            return NO;
        }
    }
    return YES;
}];
```