//
//  IPUDatabaseHelper.h
//  IPUMobileFunc
//
//  Created by 秋林 on 2019/1/18.
//  Copyright © 2019 Asiainfo. All rights reserved.
//

#import <Foundation/Foundation.h>

#import <IPUMobile/FMDatabase.h>

// 数据库后缀名
#define DB_SUFFIX   @".db"

@interface IPUDatabaseHelper : NSObject

// 打开并返回指定数据库(dbName)
+ (FMDatabase *)openDB:(NSString *)dbName;

// 将目标字典解析为条件字符串，字典中得键作为条件，值作为值
+ (NSString *)parseDicToStr:(NSDictionary *) dic;

// 判断指定字符串是否为纯数字
+ (BOOL)isPureInt:(NSString*)srcString;

// 解析数据库(dbName)下表(tableName)的表结构，并以键值对(字段:类型)的方式返回
+ (NSMutableDictionary *)parseDB:(NSString *)dbName andTabName:(NSString *)tableName;

// 根据sql语句，获取操作表结构
+ (BOOL)isQuerySQL:(NSString *)sql;

// 根据sql语句，获取操作表结构
+ (NSString *)parseTabName:(NSString *)sql;

// 获取可执行SQL
+ (NSArray *)getExecSql:(NSArray *)args
              withLimit:(NSString *)limit
              andOffset:(NSString *)offset;

// 解析SQL中表名
+ (NSString *)parseTabName:(NSString *)sql
                 withRegex:(NSString *)regex
                  startStr:(NSString *)startStr
                    endStr:(NSString *)endStr;

// 生成可执行sql；以表结构(tabCols)为基础，根据绑定参数，生成查询字段；根据条件参数，生成查询条件
+ (NSString *)combinaSql:(NSString *)operate
                 tabName:(NSString *)tableName
                 qryCols:(NSMutableDictionary *)qryCols
                    cods:(NSDictionary *)conds
                 tabCols:(NSDictionary *)tabCols;

// 绑定参数，以表结构(tabCols)为基础，将sql和参数(param)进行绑定，生成可执行sql
+ (NSString *)bindSql:(NSString *)sql
            withParam:(NSDictionary *)param
           andTabInfo:(NSDictionary *)tabCols;

// 处理查询结果集；根据查询字段信息（qryCols），组装查询结果
+ (NSMutableArray *)dealResultData:(FMResultSet *)rs withColumn:(NSArray *)qryCols;

@end