//
// DbManager.h
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "KCSingleton.h"

@interface KCDbManager : NSObject

singleton_interface(KCDbManager);

#pragma mark - 屬性
#pragma mark 數(shù)據(jù)庫(kù)引用，使用它進(jìn)行數(shù)據(jù)庫(kù)操作
@property (nonatomic) sqlite3 *database;


#pragma mark - 共有方法
/**
 * 打開(kāi)數(shù)據(jù)庫(kù)
 *
 * @param dbname 數(shù)據(jù)庫(kù)名稱
 */
-(void)openDb:(NSString *)dbname;

/**
 * 執(zhí)行無(wú)返回值的sql
 *
 * @param sql sql語(yǔ)句
 */
-(void)executeNonQuery:(NSString *)sql;

/**
 * 執(zhí)行有返回值的sql
 *
 * @param sql sql語(yǔ)句
 *
 * @return 查詢結(jié)果
 */
-(NSArray *)executeQuery:(NSString *)sql;
@end

//
// DbManager.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCDbManager.h"
#import <sqlite3.h>
#import "KCSingleton.h"
#import "KCAppConfig.h"

#ifndef kDatabaseName

#define kDatabaseName @"myDatabase.db"

#endif

@interface KCDbManager()
@end

@implementation KCDbManager

singleton_implementation(KCDbManager)

#pragma mark 重寫(xiě)初始化方法
-(instancetype)init{
  KCDbManager *manager;
  if((manager=[super init]))
  {
    [manager openDb:kDatabaseName];
  }
  return manager;
}

-(void)openDb:(NSString *)dbname{
  //取得數(shù)據(jù)庫(kù)保存路徑，通常保存沙盒Documents目錄
  NSString *directory=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) firstObject];
  NSLog(@"%@",directory);
  NSString *filePath=[directory stringByAppendingPathComponent:dbname];
  //如果有數(shù)據(jù)庫(kù)則直接打開(kāi)，否則創(chuàng)建并打開(kāi)（注意filePath是ObjC中的字符串，需要轉(zhuǎn)化為C語(yǔ)言字符串類型）
  if (SQLITE_OK ==sqlite3_open(filePath.UTF8String, &_database)) {
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)成功!");
  }else{
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗!");
  }
}

-(void)executeNonQuery:(NSString *)sql{
  char *error;
  //單步執(zhí)行sql語(yǔ)句，用于插入、修改、刪除
  if (SQLITE_OK!=sqlite3_exec(_database, sql.UTF8String, NULL, NULL,&error)) {
    NSLog(@"執(zhí)行SQL語(yǔ)句過(guò)程中發(fā)生錯(cuò)誤！錯(cuò)誤信息：%s",error);
  }
}

-(NSArray *)executeQuery:(NSString *)sql{
  NSMutableArray *rows=[NSMutableArray array];//數(shù)據(jù)行
  
  //評(píng)估語(yǔ)法正確性
  sqlite3_stmt *stmt;
  //檢查語(yǔ)法正確性
  if (SQLITE_OK==sqlite3_prepare_v2(_database, sql.UTF8String, -1, &stmt, NULL)) {
    //單步執(zhí)行sql語(yǔ)句
    while (SQLITE_ROW==sqlite3_step(stmt)) {
      int columnCount= sqlite3_column_count(stmt);
      NSMutableDictionary *dic=[NSMutableDictionary dictionary];
      for (int i=0; i<columnCount; i++) {
        const char *name= sqlite3_column_name(stmt, i);//取得列名
        const unsigned char *value= sqlite3_column_text(stmt, i);//取得某列的值
        dic[[NSString stringWithUTF8String:name]]=[NSString stringWithUTF8String:(const char *)value];
      }
      [rows addObject:dic];
    }
  }
  
  //釋放句柄
  sqlite3_finalize(stmt);
  
  return rows;
}
@end

//
// KCDatabaseCreator.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCDatabaseCreator.h"
#import "KCDbManager.h"

@implementation KCDatabaseCreator

+(void)initDatabase{
  NSString *key=@"IsCreatedDb";
  NSUserDefaults *defaults=[[NSUserDefaults alloc]init];
  if ([[defaults valueForKey:key] intValue]!=1) {
    [self createUserTable];
    [self createStatusTable];
    [defaults setValue:@1 forKey:key];
  }
}

+(void)createUserTable{
  NSString *sql=@"CREATE TABLE User (Id integer PRIMARY KEY AUTOINCREMENT,name text,screenName text, profileImageUrl text,mbtype text,city text)";
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

+(void)createStatusTable{
  NSString *sql=@"CREATE TABLE Status (Id integer PRIMARY KEY AUTOINCREMENT,source text,createdAt date,\"text\" text,user integer REFERENCES User (Id))";
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}
@end

//
// KCUser.h
// UrlConnection
//
// Created by Kenshin Cui on 14-3-22.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import <Foundation/Foundation.h>

@interface KCUser : NSObject

#pragma mark 編號(hào)
@property (nonatomic,strong) NSNumber *Id;

#pragma mark 用戶名
@property (nonatomic,copy) NSString *name;

#pragma mark 用戶昵稱
@property (nonatomic,copy) NSString *screenName;

#pragma mark 頭像
@property (nonatomic,copy) NSString *profileImageUrl;

#pragma mark 會(huì)員類型
@property (nonatomic,copy) NSString *mbtype;

#pragma mark 城市
@property (nonatomic,copy) NSString *city;

#pragma mark - 動(dòng)態(tài)方法

/**
 * 初始化用戶
 *
 * @param name 用戶名
 * @param city 所在城市
 *
 * @return 用戶對(duì)象
 */
-(KCUser *)initWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city;

/**
 * 使用字典初始化用戶對(duì)象
 *
 * @param dic 用戶數(shù)據(jù)
 *
 * @return 用戶對(duì)象
 */
-(KCUser *)initWithDictionary:(NSDictionary *)dic;

#pragma mark - 靜態(tài)方法
+(KCUser *)userWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city;
@end
KCUser.m

//
// KCUser.m
// UrlConnection
//
// Created by Kenshin Cui on 14-3-22.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCUser.h"

@implementation KCUser

-(KCUser *)initWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city{
  if (self=[super init]) {
    self.name=name;
    self.screenName=screenName;
    self.profileImageUrl=profileImageUrl;
    self.mbtype=mbtype;
    self.city=city;
  }
  return self;
}


-(KCUser *)initWithDictionary:(NSDictionary *)dic{
  if (self=[super init]) {
    [self setValuesForKeysWithDictionary:dic];
  }
  return self;
}

+(KCUser *)userWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city{
  KCUser *user=[[KCUser alloc]initWithName:name screenName:screenName profileImageUrl:profileImageUrl mbtype:mbtype city:city];
  return user;
}

@end

//
// KCStatus.h
// UITableView
//
// Created by Kenshin Cui on 14-3-1.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "KCUser.h"

@interface KCStatus : NSObject

#pragma mark - 屬性
@property (nonatomic,strong) NSNumber *Id;//微博id
@property (nonatomic,strong) KCUser *user;//發(fā)送用戶
@property (nonatomic,copy) NSString *createdAt;//創(chuàng)建時(shí)間
@property (nonatomic,copy) NSString *source;//設(shè)備來(lái)源
@property (nonatomic,copy) NSString *text;//微博內(nèi)容

#pragma mark - 動(dòng)態(tài)方法

/**
 * 初始化微博數(shù)據(jù)
 *
 * @param createAt    創(chuàng)建日期
 * @param source     來(lái)源
 * @param text      微博內(nèi)容
 * @param user      發(fā)送用戶
 *
 * @return 微博對(duì)象
 */
-(KCStatus *)initWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text user:(KCUser *)user;

/**
 * 初始化微博數(shù)據(jù)
 *
 * @param profileImageUrl 用戶頭像
 * @param mbtype     會(huì)員類型
 * @param createAt    創(chuàng)建日期
 * @param source     來(lái)源
 * @param text      微博內(nèi)容
 * @param userId     用戶編號(hào)
 *
 * @return 微博對(duì)象
 */
-(KCStatus *)initWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text userId:(int)userId;
/**
 * 使用字典初始化微博對(duì)象
 *
 * @param dic 字典數(shù)據(jù)
 *
 * @return 微博對(duì)象
 */
-(KCStatus *)initWithDictionary:(NSDictionary *)dic;

#pragma mark - 靜態(tài)方法
/**
 * 初始化微博數(shù)據(jù)
 *
 * @param createAt    創(chuàng)建日期
 * @param source     來(lái)源
 * @param text      微博內(nèi)容
 * @param user      發(fā)送用戶
 *
 * @return 微博對(duì)象
 */
+(KCStatus *)statusWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text user:(KCUser *)user;
/**
 * 初始化微博數(shù)據(jù)
 *
 * @param profileImageUrl 用戶頭像
 * @param mbtype     會(huì)員類型
 * @param createAt    創(chuàng)建日期
 * @param source     來(lái)源
 * @param text      微博內(nèi)容
 * @param userId     用戶編號(hào)
 *
 * @return 微博對(duì)象
 */
+(KCStatus *)statusWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text userId:(int)userId;

@end

//
// KCStatus.m
// UITableView
//
// Created by Kenshin Cui on 14-3-1.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCStatus.h"

@implementation KCStatus

-(KCStatus *)initWithDictionary:(NSDictionary *)dic{
  if (self=[super init]) {
    [self setValuesForKeysWithDictionary:dic];
    self.user=[[KCUser alloc]init];
    self.user.Id=dic[@"user"];
  }
  return self;
}

-(KCStatus *)initWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text user:(KCUser *)user{
  if (self=[super init]) {
    self.createdAt=createAt;
    self.source=source;
    self.text=text;
    self.user=user;
  }
  return self;
}

-(KCStatus *)initWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text userId:(int)userId{
  if (self=[super init]) {
    self.createdAt=createAt;
    self.source=source;
    self.text=text;
    KCUser *user=[[KCUser alloc]init];
    user.Id=[NSNumber numberWithInt:userId];
    self.user=user;
  }
  return self;
}

-(NSString *)source{
  return [NSString stringWithFormat:@"來(lái)自 %@",_source];
}

+(KCStatus *)statusWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text user:(KCUser *)user{
  KCStatus *status=[[KCStatus alloc]initWithCreateAt:createAt source:source text:text user:user];
  return status;
}

+(KCStatus *)statusWithCreateAt:(NSString *)createAt source:(NSString *)source text:(NSString *)text userId:(int)userId{
  KCStatus *status=[[KCStatus alloc]initWithCreateAt:createAt source:source text:text userId:userId];
  return status;
}
@end

//
// KCUserService.h
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "KCUser.h"
#import "KCSingleton.h"

@interface KCUserService : NSObject
singleton_interface(KCUserService)

/**
 * 添加用戶信息
 *
 * @param user 用戶對(duì)象
 */
-(void)addUser:(KCUser *)user;

/**
 * 刪除用戶
 *
 * @param user 用戶對(duì)象
 */
-(void)removeUser:(KCUser *)user;

/**
 * 根據(jù)用戶名刪除用戶
 *
 * @param name 用戶名
 */
-(void)removeUserByName:(NSString *)name;

/**
 * 修改用戶內(nèi)容
 *
 * @param user 用戶對(duì)象
 */
-(void)modifyUser:(KCUser *)user;

/**
 * 根據(jù)用戶編號(hào)取得用戶
 *
 * @param Id 用戶編號(hào)
 *
 * @return 用戶對(duì)象
 */
-(KCUser *)getUserById:(int)Id;

/**
 * 根據(jù)用戶名取得用戶
 *
 * @param name 用戶名
 *
 * @return 用戶對(duì)象
 */
-(KCUser *)getUserByName:(NSString *)name;

@end

//
// KCUserService.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCUserService.h"
#import "KCUser.h"
#import "KCDbManager.h"

@implementation KCUserService
singleton_implementation(KCUserService)

-(void)addUser:(KCUser *)user{
  NSString *sql=[NSString stringWithFormat:@"INSERT INTO User (name,screenName, profileImageUrl,mbtype,city) VALUES('%@','%@','%@','%@','%@')",user.name,user.screenName, user.profileImageUrl,user.mbtype,user.city];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(void)removeUser:(KCUser *)user{
  NSString *sql=[NSString stringWithFormat:@"DELETE FROM User WHERE Id='%@'",user.Id];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(void)removeUserByName:(NSString *)name{
  NSString *sql=[NSString stringWithFormat:@"DELETE FROM User WHERE name='%@'",name];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(void)modifyUser:(KCUser *)user{
  NSString *sql=[NSString stringWithFormat:@"UPDATE User SET name='%@',screenName='%@',profileImageUrl='%@',mbtype='%@',city='%@' WHERE Id='%@'",user.name,user.screenName,user.profileImageUrl,user.mbtype,user.city,user.Id];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(KCUser *)getUserById:(int)Id{
  KCUser *user=[[KCUser alloc]init];
  NSString *sql=[NSString stringWithFormat:@"SELECT name,screenName,profileImageUrl,mbtype,city FROM User WHERE Id='%i'", Id];
  NSArray *rows= [[KCDbManager sharedKCDbManager] executeQuery:sql];
  if (rows&&rows.count>0) {
    [user setValuesForKeysWithDictionary:rows[0]];
  }
  return user;
}

-(KCUser *)getUserByName:(NSString *)name{
  KCUser *user=[[KCUser alloc]init];
  NSString *sql=[NSString stringWithFormat:@"SELECT Id, name,screenName,profileImageUrl,mbtype,city FROM User WHERE name='%@'", name];
  NSArray *rows= [[KCDbManager sharedKCDbManager] executeQuery:sql];
  if (rows&&rows.count>0) {
    [user setValuesForKeysWithDictionary:rows[0]];
  }
  return user;
}
@end

//
// KCStatusService.h
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "KCSingleton.h"
@class KCStatus;

@interface KCStatusService : NSObject
singleton_interface(KCStatusService)

/**
 * 添加微博信息
 *
 * @param status 微博對(duì)象
 */
-(void)addStatus:(KCStatus *)status;

/**
 * 刪除微博
 *
 * @param status 微博對(duì)象
 */
-(void)removeStatus:(KCStatus *)status;

/**
 * 修改微博內(nèi)容
 *
 * @param status 微博對(duì)象
 */
-(void)modifyStatus:(KCStatus *)status;

/**
 * 根據(jù)編號(hào)取得微博
 *
 * @param Id 微博編號(hào)
 *
 * @return 微博對(duì)象
 */
-(KCStatus *)getStatusById:(int)Id;

/**
 * 取得所有微博對(duì)象
 *
 * @return 所有微博對(duì)象
 */
-(NSArray *)getAllStatus;
@end

//
// KCStatusService.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCStatusService.h"
#import "KCDbManager.h"
#import "KCStatus.h"
#import "KCUserService.h"
#import "KCSingleton.h"

@interface KCStatusService(){
  
}

@end

@implementation KCStatusService
singleton_implementation(KCStatusService)


-(void)addStatus:(KCStatus *)status{
  NSString *sql=[NSString stringWithFormat:@"INSERT INTO Status (source,createdAt,\"text\" ,user) VALUES('%@','%@','%@','%@')",status.source,status.createdAt,status.text,status.user.Id];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(void)removeStatus:(KCStatus *)status{
  NSString *sql=[NSString stringWithFormat:@"DELETE FROM Status WHERE Id='%@'",status.Id];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(void)modifyStatus:(KCStatus *)status{
  NSString *sql=[NSString stringWithFormat:@"UPDATE Status SET source='%@',createdAt='%@',\"text\"='%@' ,user='%@' WHERE Id='%@'",status.source,status.createdAt,status.text,status.user, status.Id];
  [[KCDbManager sharedKCDbManager] executeNonQuery:sql];
}

-(KCStatus *)getStatusById:(int)Id{
  KCStatus *status=[[KCStatus alloc]init];
  NSString *sql=[NSString stringWithFormat:@"SELECT Id, source,createdAt,\"text\" ,user FROM Status WHERE Id='%i'", Id];
  NSArray *rows= [[KCDbManager sharedKCDbManager] executeQuery:sql];
  if (rows&&rows.count>0) {
    [status setValuesForKeysWithDictionary:rows[0]];
    status.user=[[KCUserService sharedKCUserService] getUserById:[(NSNumber *)rows[0][@"user"] intValue]] ;
  }
  return status;
}

-(NSArray *)getAllStatus{
  NSMutableArray *array=[NSMutableArray array];
  NSString *sql=@"SELECT Id, source,createdAt,\"text\" ,user FROM Status ORDER BY Id";
  NSArray *rows= [[KCDbManager sharedKCDbManager] executeQuery:sql];
  for (NSDictionary *dic in rows) {
    KCStatus *status=[self getStatusById:[(NSNumber *)dic[@"Id"] intValue]];
    [array addObject:status];
  }
  return array;
}
@end

//
// KCMainTableViewController.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCMainTableViewController.h"
#import "KCDbManager.h"
#import "KCDatabaseCreator.h"
#import "KCUser.h"
#import "KCStatus.h"
#import "KCUserService.h"
#import "KCStatusService.h"
#import "KCStatusTableViewCell.h"

@interface KCMainTableViewController (){
  NSArray *_status;
  NSMutableArray *_statusCells;
}

@end

@implementation KCMainTableViewController

- (void)viewDidLoad {
  [super viewDidLoad];
  [KCDatabaseCreator initDatabase];
  
//  [self addUsers];
//  [self removeUser];
//  [self modifyUserInfo];
  
//  [self addStatus];
  
  [self loadStatusData];
  
}

-(void)addUsers{
  KCUser *user1=[KCUser userWithName:@"Binger" screenName:@"冰兒" profileImageUrl:@"binger.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user1];
  KCUser *user2=[KCUser userWithName:@"Xiaona" screenName:@"小娜" profileImageUrl:@"xiaona.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user2];
  KCUser *user3=[KCUser userWithName:@"Lily" screenName:@"麗麗" profileImageUrl:@"lily.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user3];
  KCUser *user4=[KCUser userWithName:@"Qianmo" screenName:@"阡陌" profileImageUrl:@"qianmo.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user4];
  KCUser *user5=[KCUser userWithName:@"Yanyue" screenName:@"炎月" profileImageUrl:@"yanyue.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user5];
}

-(void)addStatus{
  KCStatus *status1=[KCStatus statusWithCreateAt:@"9:00" source:@"iPhone 6" text:@"一只雪猴在日本邊泡溫泉邊玩iPhone的照片，獲得了\"2014年野生動(dòng)物攝影師\"大賽特等獎(jiǎng)。一起來(lái)為猴子配個(gè)詞" userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status1];
  KCStatus *status2=[KCStatus statusWithCreateAt:@"9:00" source:@"iPhone 6" text:@"一只雪猴在日本邊泡溫泉邊玩iPhone的照片，獲得了\"2014年野生動(dòng)物攝影師\"大賽特等獎(jiǎng)。一起來(lái)為猴子配個(gè)詞" userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status2];
  KCStatus *status3=[KCStatus statusWithCreateAt:@"9:30" source:@"iPhone 6" text:@"【我們送iPhone6了 要求很簡(jiǎn)單】真心回饋粉絲，小編覺(jué)得現(xiàn)在最好的獎(jiǎng)品就是iPhone6了。今起到12月31日，關(guān)注我們，轉(zhuǎn)發(fā)微博，就有機(jī)會(huì)獲iPhone6(獎(jiǎng)品可能需要等待)！每月抽一臺(tái)[鼓掌]。不費(fèi)事，還是試試吧，萬(wàn)一中了呢" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status3];
  KCStatus *status4=[KCStatus statusWithCreateAt:@"9:45" source:@"iPhone 6" text:@"重大新聞：蒂姆庫(kù)克宣布出柜后，ISIS戰(zhàn)士怒扔iPhone，沙特神職人員呼吁人們換回iPhone 4。[via Pan-Arabia Enquirer]" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status4];
  KCStatus *status5=[KCStatus statusWithCreateAt:@"10:05" source:@"iPhone 6" text:@"小伙伴們，有誰(shuí)知道怎么往Iphone4S里倒東西？倒入的東西又該在哪里找？用了Iphone這么長(zhǎng)時(shí)間，還真的不知道怎么弄！有誰(shuí)知道??？謝謝！" userId:4];
  [[KCStatusService sharedKCStatusService] addStatus:status5];
  KCStatus *status6=[KCStatus statusWithCreateAt:@"10:07" source:@"iPhone 6" text:@"在音悅臺(tái)iPhone客戶端里發(fā)現(xiàn)一個(gè)悅單《Infinite 金明洙》，推薦給大家! " userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status6];
  KCStatus *status7=[KCStatus statusWithCreateAt:@"11:20" source:@"iPhone 6" text:@"如果sony吧mp3播放器產(chǎn)品發(fā)展下去，不貪圖手頭節(jié)目源的現(xiàn)實(shí)利益，就木有蘋(píng)果的ipod，也就木有iphone。柯達(dá)類似的現(xiàn)實(shí)利益，不自我革命的案例也是一種巨頭的宿命。" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status7];
  KCStatus *status8=[KCStatus statusWithCreateAt:@"13:00" source:@"iPhone 6" text:@"【iPhone 7 Plus】新買的iPhone 7 Plus ，如何？夠酷炫么？" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status8];
  KCStatus *status9=[KCStatus statusWithCreateAt:@"13:24" source:@"iPhone 6" text:@"自拍神器#卡西歐TR500#，tr350S～價(jià)格美麗，行貨，全國(guó)聯(lián)?！玦Phone6 iPhone6Plus卡西歐TR150 TR200 TR350 TR350S全面到貨 招收各種代理！[給力]微信：39017366" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status9];
  KCStatus *status10=[KCStatus statusWithCreateAt:@"13:26" source:@"iPhone 6" text:@"猜到猴哥玩手機(jī)時(shí)所思所想者，再獎(jiǎng)iPhone一部。（獎(jiǎng)品由“2014年野生動(dòng)物攝影師”評(píng)委會(huì)頒發(fā)）" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status10];
}

-(void)removeUser{
  //注意在SQLite中區(qū)分大小寫(xiě)
  [[KCUserService sharedKCUserService] removeUserByName:@"Yanyue"];
}

-(void)modifyUserInfo{
  KCUser *user1= [[KCUserService sharedKCUserService]getUserByName:@"Xiaona"];
  user1.city=@"上海";
  [[KCUserService sharedKCUserService] modifyUser:user1];
  
  KCUser *user2= [[KCUserService sharedKCUserService]getUserByName:@"Lily"];
  user2.city=@"深圳";
  [[KCUserService sharedKCUserService] modifyUser:user2];
}

#pragma mark 加載數(shù)據(jù)
-(void)loadStatusData{
  _statusCells=[[NSMutableArray alloc]init];
  _status=[[KCStatusService sharedKCStatusService]getAllStatus];
  [_status enumerateObjectsUsingBlock:^(id obj, NSUInteger idx, BOOL *stop) {
    KCStatusTableViewCell *cell=[[KCStatusTableViewCell alloc]init];
    cell.status=(KCStatus *)obj;
    [_statusCells addObject:cell];
  }];
  NSLog(@"%@",[_status lastObject]);
}


#pragma mark - Table view data source

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
  return 1;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
  return _status.count;
}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
  static NSString *identtityKey=@"myTableViewCellIdentityKey1";
  KCStatusTableViewCell *cell=[self.tableView dequeueReusableCellWithIdentifier:identtityKey];
  if(cell==nil){
    cell=[[KCStatusTableViewCell alloc]initWithStyle:UITableViewCellStyleValue1 reuseIdentifier:identtityKey];
  }
  cell.status=_status[indexPath.row];

  return cell;
}

-(CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath{
  return ((KCStatusTableViewCell *)_statusCells[indexPath.row]).height;
}

-(CGFloat)tableView:(UITableView *)tableView heightForHeaderInSection:(NSInteger)section{
  return 20.0f;
}
@end

//
// User.h
// CoreData
//
// Created by Kenshin Cui on 14/03/27.
// Copyright (c) 2014年 cmjstudio. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <CoreData/CoreData.h>

@class Status;

@interface User : NSManagedObject

@property (nonatomic, retain) NSString * city;
@property (nonatomic, retain) NSString * mbtype;
@property (nonatomic, retain) NSString * name;
@property (nonatomic, retain) NSString * profileImageUrl;
@property (nonatomic, retain) NSString * screenName;
@property (nonatomic, retain) NSSet *statuses;
@end

@interface User (CoreDataGeneratedAccessors)

- (void)addStatusesObject:(Status *)value;
- (void)removeStatusesObject:(Status *)value;
- (void)addStatuses:(NSSet *)values;
- (void)removeStatuses:(NSSet *)values;

@end

//
// User.m
// CoreData
//
// Created by Kenshin Cui on 14/03/27.
// Copyright (c) 2014年 cmjstudio. All rights reserved.
//

#import "User.h"
#import "Status.h"


@implementation User

@dynamic city;
@dynamic mbtype;
@dynamic name;
@dynamic profileImageUrl;
@dynamic screenName;
@dynamic statuses;

@end

//
// Status.h
// CoreData
//
// Created by Kenshin Cui on 14/03/27.
// Copyright (c) 2014年 cmjstudio. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <CoreData/CoreData.h>


@interface Status : NSManagedObject

@property (nonatomic, retain) NSDate * createdAt;
@property (nonatomic, retain) NSString * source;
@property (nonatomic, retain) NSString * text;
@property (nonatomic, retain) NSManagedObject *user;

@end

//
// Status.m
// CoreData
//
// Created by Kenshin Cui on 14/03/27.
// Copyright (c) 2014年 cmjstudio. All rights reserved.
//

#import "Status.h"


@implementation Status

@dynamic createdAt;
@dynamic source;
@dynamic text;
@dynamic user;

@end

-(NSManagedObjectContext *)createDbContext{
  NSManagedObjectContext *context;
  //打開(kāi)模型文件，參數(shù)為nil則打開(kāi)包中所有模型文件并合并成一個(gè)
  NSManagedObjectModel *model=[NSManagedObjectModel mergedModelFromBundles:nil];
  //創(chuàng)建解析器
  NSPersistentStoreCoordinator *storeCoordinator=[[NSPersistentStoreCoordinator alloc]initWithManagedObjectModel:model];
  //創(chuàng)建數(shù)據(jù)庫(kù)保存路徑
  NSString *dir=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) firstObject];
  NSLog(@"%@",dir);
  NSString *path=[dir stringByAppendingPathComponent:@"myDatabase.db"];
  NSURL *url=[NSURL fileURLWithPath:path];
  //添加SQLite持久存儲(chǔ)到解析器
  NSError *error;
  [storeCoordinator addPersistentStoreWithType:NSSQLiteStoreType configuration:nil URL:url options:nil error:&error];
  if(error){
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗！錯(cuò)誤:%@",error.localizedDescription);
  }else{
    context=[[NSManagedObjectContext alloc]init];
    context.persistentStoreCoordinator=storeCoordinator;
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)成功！");
  }
  return context;
}

-(void)addUserWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city{
  //添加一個(gè)對(duì)象
  User *us= [NSEntityDescription insertNewObjectForEntityForName:@"User" inManagedObjectContext:self.context];
  us.name=name;
  us.screenName=screenName;
  us.profileImageUrl=profileImageUrl;
  us.mbtype=mbtype;
  us.city=city;
  NSError *error;
  //保存上下文
  if (![self.context save:&error]) {
    NSLog(@"添加過(guò)程中發(fā)生錯(cuò)誤,錯(cuò)誤信息：%@！",error.localizedDescription);
  }
}

-(NSArray *)getStatusesByUserName:(NSString *)name{
  NSFetchRequest *request=[NSFetchRequest fetchRequestWithEntityName:@"Status"];
  request.predicate=[NSPredicate predicateWithFormat:@"user.name=%@",name];
  NSArray *array=[self.context executeFetchRequest:request error:nil];
  return array;
}

-(NSArray *)getStatusesByUserName:(NSString *)name{
  NSFetchRequest *request=[NSFetchRequest fetchRequestWithEntityName:@"Status"];
  request.predicate=[NSPredicate predicateWithFormat:@"user.name=%@",name];
  NSArray *array=[self.context executeFetchRequest:request error:nil];
  return array;
}

-(void)addUserWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city{
  //添加一個(gè)對(duì)象
  User *us= [NSEntityDescription insertNewObjectForEntityForName:@"User" inManagedObjectContext:self.context];
  us.name=name;
  us.screenName=screenName;
  us.profileImageUrl=profileImageUrl;
  us.mbtype=mbtype;
  us.city=city;
  NSError *error;
  //保存上下文
  if (![self.context save:&error]) {
    NSLog(@"添加過(guò)程中發(fā)生錯(cuò)誤,錯(cuò)誤信息：%@！",error.localizedDescription);
  }
}

-(void)removeUser:(User *)user{
  [self.context deleteObject:user];
  NSError *error;
  if (![self.context save:&error]) {
    NSLog(@"刪除過(guò)程中發(fā)生錯(cuò)誤，錯(cuò)誤信息：%@!",error.localizedDescription);
  }
}

-(void)modifyUserWithName:(NSString *)name screenName:(NSString *)screenName profileImageUrl:(NSString *)profileImageUrl mbtype:(NSString *)mbtype city:(NSString *)city{
  User *us=[self getUserByName:name];
  us.screenName=screenName;
  us.profileImageUrl=profileImageUrl;
  us.mbtype=mbtype;
  us.city=city;
  NSError *error;
  if (![self.context save:&error]) {
    NSLog(@"修改過(guò)程中發(fā)生錯(cuò)誤,錯(cuò)誤信息：%@",error.localizedDescription);
  }

}

-(void)openDb:(NSString *)dbname{
  //取得數(shù)據(jù)庫(kù)保存路徑，通常保存沙盒Documents目錄
  NSString *directory=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) firstObject];
  NSLog(@"%@",directory);
  NSString *filePath=[directory stringByAppendingPathComponent:dbname];
  //創(chuàng)建FMDatabase對(duì)象
  self.database=[FMDatabase databaseWithPath:filePath];
  //打開(kāi)數(shù)據(jù)上
  if ([self.database open]) {
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)成功!");
  }else{
    NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗!");
  }
}

-(void)executeNonQuery:(NSString *)sql{
  //執(zhí)行更新sql語(yǔ)句，用于插入、修改、刪除
  if (![self.database executeUpdate:sql]) {
    NSLog(@"執(zhí)行SQL語(yǔ)句過(guò)程中發(fā)生錯(cuò)誤！");
  }
}

-(NSArray *)executeQuery:(NSString *)sql{
  NSMutableArray *array=[NSMutableArray array];
  //執(zhí)行查詢sql語(yǔ)句
  FMResultSet *result= [self.database executeQuery:sql];
  while (result.next) {
    NSMutableDictionary *dic=[NSMutableDictionary dictionary];
    for (int i=0; i<result.columnCount; ++i) {
      dic[[result columnNameForIndex:i]]=[result stringForColumnIndex:i];
    }
    [array addObject:dic];
  }
  return array;
}

-(void)openDb:(NSString *)dbname{
  //取得數(shù)據(jù)庫(kù)保存路徑，通常保存沙盒Documents目錄
  NSString *directory=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) firstObject];
  NSLog(@"%@",directory);
  NSString *filePath=[directory stringByAppendingPathComponent:dbname];
  //創(chuàng)建FMDatabaseQueue對(duì)象
  self.database=[FMDatabaseQueue databaseQueueWithPath:filePath];
}

-(void)executeNonQuery:(NSString *)sql{
  //執(zhí)行更新sql語(yǔ)句，用于插入、修改、刪除
  [self.database inDatabase:^(FMDatabase *db) {
    [db executeUpdate:sql];
  }];
}
-(NSArray *)executeQuery:(NSString *)sql{
  NSMutableArray *array=[NSMutableArray array];
  [self.database inDatabase:^(FMDatabase *db) {
    //執(zhí)行查詢sql語(yǔ)句
    FMResultSet *result= [db executeQuery:sql];
    while (result.next) {
      NSMutableDictionary *dic=[NSMutableDictionary dictionary];
      for (int i=0; i<result.columnCount; ++i) {
        dic[[result columnNameForIndex:i]]=[result stringForColumnIndex:i];
      }
      [array addObject:dic];
    }
  }];
  return array;
}