I have taken an objective c file and somewhat customised it.
Sqlite3Wrapper.h
#ifndef SqliteWrap_Sqlite3Wrapper_h
#define SqliteWrap_Sqlite3Wrapper_h
struct sqlite3;
@class SqlStatement;
@interface Sqlite3Wrapper : NSObject
-(id)initWithFileName: (NSString*) databaseFileName;
-(BOOL) openDatabase;
-(BOOL) closeDatabase;
-(BOOL) isOpen;
-(BOOL) executeStatement: (NSString*) sqlStatement;
-(SqlStatement*) prepareStatement: (NSString*) sqlStatement;
@end
#endif
Sqlite3Wrapper.m
#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "Sqlite3Wrapper.h"
#import "SqlStatement.h"
@implementation Sqlite3Wrapper {
sqlite3* _database;
NSString* _databaseFileName;
}
-(id) initWithFileName:(NSString *)databaseFileName {
self = [super init];
if (self) {
_databaseFileName = databaseFileName;
}
return self;
}
-(BOOL) openDatabase {
int returnValue = sqlite3_open([_databaseFileName UTF8String], &_database);
if (returnValue == SQLITE_OK) {
return YES;
}
return NO;
}
-(BOOL) closeDatabase {
if (_database) {
if (sqlite3_close(_database) == SQLITE_OK) {
_database = nil;
return YES;
}
}
return NO;
}
-(BOOL) isOpen {
return (_database != nil);
}
-(BOOL) executeStatement: (NSString *)sqlStatement {
if (_database == nil) {
return NO;
}
return (sqlite3_exec(_database, [sqlStatement UTF8String], nil, nil, nil) == SQLITE_OK);
// sqlite3_stmt* statement;
// if (sqlite3_prepare_v2(_database, [sqlStatement UTF8String], -1, &statement, nil) == SQLITE_OK) {
// BOOL success = (sqlite3_step(statement) == SQLITE_OK);
// sqlite3_finalize(statement);
// return success;
// }
// return NO;
}
-(SqlStatement*) prepareStatement:(NSString *)sqlStatement {
if (_database == nil) {
return nil;
}
sqlite3_stmt* pStmt = nil;
if (sqlite3_prepare_v2(_database, [sqlStatement UTF8String], -1, &pStmt, nil) == SQLITE_OK) {
return [[SqlStatement alloc] initWithStatement: pStmt];
}
return nil;
}
@end
I am using this wrapper file and created a swift file.
Logger.swift
import Foundation
public class Logger {
var dbWrapper:Sqlite3Wrapper
var dataAccess = [String:AnyObject]()
public init(dbName:String) {
let docDirPath = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as NSString
let dbPath:NSString = docDirPath.stringByAppendingString(dbName)
let fileManager:NSFileManager = NSFileManager.defaultManager()
dbWrapper = Sqlite3Wrapper(fileName: dbName)
if !fileManager.fileExistsAtPath(dbPath) {
if dbWrapper.openDatabase() == false {
NSLog("Database not opened")
let sql:NSString = "CREATE TABLE IF NOT EXISTS CONTACTS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, ADDRESS TEXT, PHONE TEXT)"
if dbWrapper.executeStatement(sql) {
NSLog("Table Created")
}
dbWrapper.closeDatabase()
} else {
NSLog("Database opened")
}
} else {
NSLog("Database exists")
}
}
public func open() -> Bool {
return dbWrapper.openDatabase()
}
public func test(dbName:NSString) {
let docDirPath = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as NSString
let dbPath:NSString = docDirPath.stringByAppendingString(dbName)
let fileManager:NSFileManager = NSFileManager.defaultManager()
if !fileManager.fileExistsAtPath(dbPath) {
if Sqlite3Wrapper(fileName: dbPath) == false {
NSLog("Database not opened")
let sql:NSString = "CREATE TABLE IF NOT EXISTS CONTACTS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, ADDRESS TEXT, PHONE TEXT)"
if dbWrapper.executeStatement(sql) {
NSLog("Table Created")
}
dbWrapper.closeDatabase()
} else {
NSLog("Database opened")
}
} else {
NSLog("Database exists")
}
}
}
public func logMessage(message: NSString ) {
NSLog("Message is printed")
}
public func createDatabase(dbName: NSString ) {
Data(dbName: dbName)
}
Last 2 functions createDatabase and logMessage are just temporary to test if I can access these functions directly or not.
I have created an "Aggregated Target" as well for universal framework for both device and simulator. But when I use this universal framework, I am unable to import Logger and receives error "No such module 'Logger'". But when I package framework for device and try to add the same framework, I am able to do the import thing.
Finally, the issue is once I import Logger, I am unable to access any function or Data class from the framework. I only can access Sqlite3Wrapper which is written in Objective C. I want to use that Data class or public functions.
Please let me know if you think I have doing something wrong.