# FMDB_MoreList

**Repository Path**: git_China_/FMDB_MoreList

## Basic Information

- **Project Name**: FMDB_MoreList
- **Description**: 对数据库中的数据进行：增删改查，操作。并且：给数据表绑定触发器，监听数据的，增加／修改／删除操作。
- **Primary Language**: Objective-C
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2017-04-11
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# FMDB_MoreListTest-
对数据库中的数据进行：增删改查，操作。并且：给数据表绑定触发器，监听数据的，增加／修改／删除操作。

// 创建日志数据表
[db executeUpdate:@"create table IF NOT EXISTS SYSTEM_SYNC_LOG( 
PK_VAL    VARCHAR(50)        not null,   
T_NAME    VARCHAR(50)    not null,                                
ACTION    VARCHAR(10)    not null,                                     
CREATE_DATE    TIMESTAMP   DEFAULT CURRENT_TIMESTAMP,                    
primary key (PK_VAL, T_NAME));       
create unique index SYSTEM_SYNC_LOG_PK on SYSTEM_SYNC_LOG (  PK_VAL ASC, T_NAME  ASC );"];

// 查询所有的系统日志
- (NSMutableArray *)searchAllSYSTEM_SYNC_LOG
{
    NSMutableArray *arrM = [NSMutableArray array];
    [self.queue inTransaction:^(FMDatabase *db, BOOL *rollback) {
        
        NSString *sql1 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' JOIN 'T_Person' ON SYSTEM_SYNC_LOG.PK_VAL = T_Person.personId";
        FMResultSet *rs = [db executeQuery:sql1];
        while ([rs next]) {
            
            int personId = [rs intForColumn:@"personId"];
            NSString *personName = [rs stringForColumn:@"personName"];
            int age = [rs intForColumn:@"age"];
            NSString *phoneNo = [rs stringForColumn:@"phoneNo"];
            int companyId = [rs intForColumn:@"companyId"];
            NSString * createDate = [rs stringForColumn:@"CREATE_DATE"];
            
            if ([phoneNo isEqualToString:@""] || [phoneNo isEqualToString:@"(null)"]) {
                phoneNo = @"0";
            }
            if ([personName isEqualToString:@""] || [personName isEqualToString:@"(null)"]) {
                personName = @"0";
            }
            if ([[NSString stringWithFormat:@"%d", age] isEqualToString:@""] || [[NSString stringWithFormat:@"%d", age] isEqualToString:@"(null)"]) {
                age = 0;
            }
            
            NSDictionary *dict = @{@"personId" : @(personId),
                                   @"personName" : personName,
                                   @"age" : @(age),
                                   @"phoneNo" : phoneNo,
                                   @"companyId" : @(companyId),
                                   @"createDate" : createDate
                                   };
            [arrM addObject:dict];
        }
        
        
        NSString *sql2 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' WHERE ACTION = 'D'";
        FMResultSet *rs1 = [db executeQuery:sql2];
        while ([rs1 next]) {
            NSString * t_name = [rs1 stringForColumn:@"T_NAME"];
            
            NSString * action = [rs1 stringForColumn:@"ACTION"];
            
            NSString * namelistId = [rs1 stringForColumn:@"PK_VAL"];
            
            NSString * createDate = [rs1 stringForColumn:@"CREATE_DATE"];
            
            NSDictionary * dict=@{
                                  @"tableName":t_name
                                  ,@"action":action
                                  ,@"namelistId":namelistId
                                  ,@"createDate":createDate
                                  };
            [arrM addObject:dict];
        }
        
        
        NSString *sql3 = @"SELECT * FROM 'SYSTEM_SYNC_LOG' JOIN 'T_Company' ON SYSTEM_SYNC_LOG.PK_VAL = T_Company.companyId";
        FMResultSet *rs3 = [db executeQuery:sql3];
        while ([rs3 next]) {
            
            int companyId = [rs3 intForColumn:@"companyId"];
            NSString *companyName = [rs3 stringForColumn:@"companyName"];
            NSString * createDate = [rs3 stringForColumn:@"CREATE_DATE"];
            
            NSDictionary *dict = @{@"companyId" : @(companyId),
                                   @"companyName" : companyName,
                                   @"createDate" : createDate
                                   };
            [arrM addObject:dict];
        }
    }];
    
    return arrM;
}

//删除日志表
- (void)deleteAllSYSTEM_SYNC_LOG
{
    [self.queue inTransaction:^(FMDatabase *db, BOOL *rollback) {
        
        [db executeUpdate:@"DELETE FROM SYSTEM_SYNC_LOG"];
    }];
    
}
@end