WebSVN – Iphone Microlearning - Inconcert – Diff – /twogetskills/Database/Database.swift

 import Foundation
 import SQLite3
-class Database {
+class Database {
-    private var conn : OpaquePointer?
+    private var path : String = Constants.DATABASE_NAME
-    private var path : String = Constants.DATABASE_NAME
+    public let db : OpaquePointer?
     static let sharedInstance: Database = {
-           let instance = Database()
+    static let sharedInstance: Database = {
-           // setup code
-           return instance
-    }()
-    public func printError()
            let instance = Database()
-    }
+           return instance
     }()
     public func createTables()
     public func createTables()
         self.conn = open()
+        }
+    }
     public func open() -> OpaquePointer? {
-        if self.conn == nil {
+        if self.db == nil {
-            let filePath = try! FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false)
-                .appendingPathComponent(path)
+            let filePath = try! FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false)
-            print("Database FilePath : \(filePath.path)")
+                    .appendingPathComponent(path)
             if sqlite3_open(filePath.path, &self.conn) != SQLITE_OK {
+            if sqlite3_open(filePath.path, &self.db) == SQLITE_OK {
-                print("No se pudo abrir la DB : \(path) ")
+                print("Se abrio la conexión con la db : \(path) ")
                 return conn
-                self.printError()
+            } else {
+                print("No se pudo abrir la db : \(path) ")
+                return nil
+            }
+        }
+    }
-                return nil
-            } else {
+    public func close() -> Void
+    {
+        if self.db == nil {
+            print("No se pudo cerrar la conexión, no es un recurso valida")
+            return
+        }
-                return self.conn
+        if sqlite3_close(db) == SQLITE_OK {
-            }
+            print("Se cerro la conexión de la base de datos")
-        } else {
+            self.db = nil
-            return self.conn
+        } else {
-        }
+            print("No se pudo cerrar la conexión de la base de datos")
+        }
+    }
     func executeMultiQuery(queries: [String]) -> Bool {
     func executeMultiQuery(queries: [String]) {
+        queries.forEach { query in
-        queries.forEach { query in
+            var statement : OpaquePointer? = nil
             var statement : OpaquePointer? = nil
             if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
-            if sqlite3_prepare_v2(self.conn, query, -1, &statement, nil) == SQLITE_OK {
-                if sqlite3_step(statement) != SQLITE_DONE {
-                    print("Fallo la consulta: \(query) ")
+                if sqlite3_step(statement) == SQLITE_DONE {
-                    self.printError()
+                    return true
                 } else {
-            } else {
+                    print("Fallo la consulta: \(query) ")
-                print("Fallo la preparación: \(query) ")
+                    return false
+                }
         var statement : OpaquePointer? = nil
-            } else {
+            } else {
                 print("No se pudo crear la tabla: \(Constants.TABLE_APP)")
                 self.printError()
-            }
+            }
         } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_APP)")
             self.printError()
+        }
+    }
         var statement : OpaquePointer? = nil
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
                 self.printError()
+            }
-        } else {
+        } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
-            self.printError()
+        }
+    }
-    private func createTableUserExtended()
+    private func createTableUserExtended() -> Void
+    {
         var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_USER_EXTENDED + "("
         sql = sql + Constants.TABLE_USER_EXTENDED_FIELD_UUID + " TEXT UNIQUE, "
         sql = sql + Constants.TABLE_USER_EXTENDED_FIELD_COMPANY_UUID + " TEXT,"
         sql = sql + Constants.TABLE_USER_EXTENDED_FIELD_LABEL + " TEXT,"
         sql = sql + Constants.TABLE_USER_EXTENDED_FIELD_VALUE + " TEXT"
         sql = sql + ");"
         var statement : OpaquePointer? = nil
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_USER_EXTENDED)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_USER_EXTENDED)")
                 self.printError()
+            }
-        } else {
+        } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_USER_EXTENDED)")
-            self.printError()
+        }
+    }
-    private func createTableSync()  {
+    private func createTableSync() -> Void {
         var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_SYNC + "("
         sql = sql + Constants.TABLE_SYNC_FIELD_ID +  " INTEGER PRIMARY KEY, "
         sql = sql + Constants.TABLE_SYNC_FIELD_TYPE + " INTEGER,"
         sql = sql + Constants.TABLE_SYNC_FIELD_DATA + " TEXT"
-        sql = sql + ");"
+        sql = sql + ");"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
             if sqlite3_step(statement) != SQLITE_DONE {
                 print("No se pudo crear la tabla: \(Constants.TABLE_SYNC)")
                 self.printError()
+            }
         } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_SYNC)")
             self.printError()
+        }
+    }
-    private func createTableCompany()  {
+    private func createTableCompany() -> Void  {
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_COMPANY)");
+                print("No se pudo crear la tabla: \(Constants.TABLE_COMPANY)");
                 self.printError()
+            }
-        } else {
+        } else {
             print("Fallo la preparación de la creación de la tabla: \(Constants.TABLE_COMPANY)")
-            self.printError()
+        }
+    }
-    private func createTableTopic()  {
+    private func createTableTopic() -> Void  {
         sql = sql + ");"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
             if sqlite3_step(statement) == SQLITE_DONE {
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_TOPIC)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_TOPIC)")
                 self.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_TOPIC)")
             self.printError()
+        }
+    }
         sql = sql + ");"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_CAPSULE)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_CAPSULE)")
                 self.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación de la creación de la tabla: \(Constants.TABLE_CAPSULE)")
-            self.printError()
+        }
+    }
-    private func createTableSlide()  {
+    private func createTableSlide() -> Void {
         var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_SLIDE + " ("
         var statement : OpaquePointer? = nil
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_SLIDE)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_SLIDE)")
                 self.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación para crear la tabla: \(Constants.TABLE_SLIDE)")
-            self.printError()
+        }
+    }
-    private func createTableProgress()  {
+    private func createTableProgress() -> Void  {
         print("sql : \(sql)")
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
                 executeMultiQuery(queries: queries)
             } else {
                 print("No se pudo crear la tabla: \(Constants.TABLE_PROGRESS)")
-                print(sql)
+                print(sql)
                 self.printError()
+           }
         } else {
-            print("Fallo la preparación para la creación de la tabla: \(Constants.TABLE_PROGRESS)")
+            print("Fallo la preparación para la creación de la tabla: \(Constants.TABLE_PROGRESS)")
             self.printError()
         }
+    }
-    private func createTableUserLog()  {
+    private func createTableUserLog() -> Void  {
         var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_USER_LOG + "("
         sql = sql + Constants.TABLE_USER_LOG_FIELD_ID + " INTEGER PRIMARY KEY, "
         sql = sql + ");"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_USER_LOG)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_USER_LOG)")
                 self.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación de la creación de la tabla: \(Constants.TABLE_USER_LOG)")
-            self.printError()
+        }
+    }
         sql = sql + Constants.TABLE_QUIZ_FIELD_UPDATED_ON + " TEXT);"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
             if sqlite3_step(statement) == SQLITE_DONE {
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_QUIZ)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_QUIZ)")
                 self.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación de la creación de la tabla: \(Constants.TABLE_QUIZ)")
-            self.printError()
+        }
+    }
-    private func createTableQuestion()  {
+    private func createTableQuestion() -> Void  {
         sql = sql + Constants.TABLE_QUESTION_FIELD_ADDED_ON + " TEXT,"
         sql = sql + Constants.TABLE_QUESTION_FIELD_UPDATED_ON + " TEXT);"
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
             if sqlite3_step(statement) == SQLITE_DONE {
                 let queries = [
                     "CREATE INDEX IF NOT EXISTS `idx_questions_quiz_uuid` ON " +  Constants.TABLE_QUIZ + "` (`" +  Constants.TABLE_QUIZ_FIELD_UUID + "` );"
+                ]
                 executeMultiQuery(queries: queries)
             } else {
                 print("No se pudo crear la tabla: \(Constants.TABLE_QUESTION)")
                 self.printError()
+           }
         } else {
             print("Fallo la preparación de la creación  de la tabla: \(Constants.TABLE_QUESTION)")
             self.printError()
+        }
+    }
         sql = sql + Constants.TABLE_ANSWER_FIELD_UPDATED_ON + " TEXT); "
         var statement : OpaquePointer? = nil
-        if sqlite3_prepare_v2(self.conn, sql, -1, &statement, nil) == SQLITE_OK {
+        if sqlite3_prepare_v2(db, sql, -1, &statement, nil) == SQLITE_OK {
             if sqlite3_step(statement) == SQLITE_DONE {
                 let queries = [
                     "CREATE INDEX IF NOT EXISTS `idx_answers_question_uuid` ON `" +  Constants.TABLE_QUESTION + "` (`" +  Constants.TABLE_QUESTION_FIELD_UUID + "` );"
+                ]
                 executeMultiQuery(queries: queries)
             } else {
-                print("No se pudo crear la tabla: \(Constants.TABLE_ANSWER)")
+                print("No se pudo crear la tabla: \(Constants.TABLE_ANSWER)")
                 self.printError()

Proyectos de Subversion Iphone Microlearning - Inconcert

(root)/twogetskills/Database/Database.swift – Rev 14 → 15