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

@interface DbHelper : NSObject {
    FMDatabase *db;
}
- (BOOL)initDatabase;
- (void)closeDatabase;
- (FMDatabase *)getDatabase;

@end

#import "DbHelper.h"
#define DB_NAME @"menu.db"

@implementation DbHelper

- (BOOL)initDatabase
{
    BOOL success;
    NSError *error;
    NSFileManager *fm = [NSFileManager defaultManager];
    NSArray  *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *writableDBPath = [documentsDirectory stringByAppendingPathComponent:DB_NAME];
    
    success = [fm fileExistsAtPath:writableDBPath];
    
    if(!success){
        NSString *defaultDBPath = [[[NSBundle mainBundle] bundlePath] stringByAppendingPathComponent:DB_NAME];
        NSLog(@"%@",defaultDBPath);
        success = [fm copyItemAtPath:defaultDBPath toPath:writableDBPath error:&error];
        if(!success){
            NSLog(@"error: %@", [error localizedDescription]);
        }
        success = YES;
        NSLog(@"Success to open database.");
    }
    
    if(success){
        db = [[FMDatabase databaseWithPath:writableDBPath] retain];
        if ([db open]) {
            [db setShouldCacheStatements:YES];
        }else{
            NSLog(@"Failed to open database.");
            success = NO;
        }
    }
    
    return success;
}

- (void)closeDatabase
{
    [db close];
}

- (FMDatabase *)getDatabase
{
    if ([self initDatabase]){
        return db;
    }    
    return NULL;
}

- (void)dealloc
{
    [self closeDatabase];
    [db release];
    [super dealloc];
}
@end

-(BOOL) UpdataData:(NSArray *)list
{

DbHelper *dbhelper=[[

DbHelper alloc] init];
    FMDatabase *db=[dbhelper getDatabase];
    [db beginTransaction];
    
    [db executeUpdate: @"DELETE FROM DishType"];
    if ([db hadError]) {
       NSLog(@"Err %d: %@", [db lastErrorCode], [db lastErrorMessage]);
       [db rocback];
    }
    for(id model in list)
    {
        [self insertWithModel:model db:db];
    }
  [db commit];
  [dbhelper release];
}