jyiosapp/ios/JianYuIOS/JianYuIOS/BaseClass1/LXDataBaseManager.h

//
//  NMDataBaseManager.h
//  NMHomes
//
//  Created by mac book air on 16/8/6.
//  Copyright © 2016年 mac book air. All rights reserved.
//

#import <Foundation/Foundation.h>

@interface LXDataBaseManager : NSObject


// 类方法创建单例类
+(id)shareDataBaseManager;
// 创建路径和数据库
-(void)makeDBWithPath:(NSString *)path;
// 建table
-(void)makeTableWithName:(NSString *)tableName;
// 插资料
-(void)insertMessage:(id)entity toTable:(NSString *)table;
// 更新资料
//-(void)updateMessage:(id)entity toTable:(NSString *)table;
// 取数据
-(id)getMessageWithKey:(NSString *)key openid:(NSString *)openid fromTable:(NSString *)table start:(int)start length:(int)length;
// 删除一条数据
-(void)deleteMessage:(NSNumber *)key fromTable:(NSString *)table;
// 删除全部数据
-(void)deleteAllMessageFromTable:(NSString *)table;
// 查询 是否在库
-(BOOL)returnKey:(NSString *)key inTable:(NSString *)table;
// 是否在库
-(BOOL)returnURL:(NSString *)url openid:(NSString *)openid inTable:(NSString *)table;
// 通过id改未读状态
-(void)changeReadedWithID:(NSNumber *)key state:(NSNumber *)state;
//通过openid和url改未读状态
-(void)changeReadedWithURL:(NSString *)url openid:(NSString *)openid;
//全部置为已读状态
-(void)updateAllUnReadMessage:(NSString *)openid;
// 取未读空数据id
-(NSArray *)getIdsWithOpenid:(NSString *)openid FromTable:(NSString *)table;
//-(id)selectMessageWithKey:(NSString *)key table:(NSString *)table;


/**

 @param table 表名字

 @return 是否存在
 */
-(BOOL)isNotClearWithTable:(NSString *)table;

-(int)getUnReadMessageCount:(NSString *)openid;

// 清空数据
-(void)clearAll;

// 删除某个表
-(void)dropTable:(NSString *)table;


@end