# HYDatabaseManager

**Repository Path**: Ianhwu/HYDatabaseManager

## Basic Information

- **Project Name**: HYDatabaseManager
- **Description**: db manager
- **Primary Language**: Objective-C
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-05-19
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: ios-modules

**Tags**: None

## README

# HYDatabaseManager
Avoid multi thread makes the sqlite sleep.
# Install
`pod 'HYDatabaseManager'`

`pod install`

# Usage
```
NSString *sql = @"CREATE TABLE IF NOT EXISTS data ('id' INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL  UNIQUE, 'start' DATETIME, 'end' DATETIME);";
    dispatch_async(dispatch_get_global_queue(DISPATCH_QUEUE_PRIORITY_DEFAULT, 0), ^{
        NSMutableArray *array = [NSMutableArray array];
        [array addObject:sql];
        for (int i = 0; i < 10000; i++) {
            [array addObject:@"INSERT into data (start, end) VALUES (1, 2)"];
        }
        // execute sqls
        [HYDatabaseManager executeSqls:[array copy] finished:^(BOOL result) {
            NSLog(@"finished");
        }];
        // select sqls results is dictionarys
        [HYDatabaseManager selectSql:@"SELECT * FROM data" keys:@[@"start"] finished:^(NSArray *results) {
            NSLog(@"end");
        }];
        // select sqls results is models
        [HYDatabaseManager selectSql:@"SELECT * FROM data limit 20" class:Model.class keys:@[@"start"] finished:^(NSArray *results) {
            for (Model *model in results) {
                NSLog(@"%@", model.start);
            }
        }];
    });
```