WebSVN – Iphone Microlearning - Nuevo Interface – Diff – /twogetskills/Dao/SlideDao.swift



//  twogetskills
//
//  Created by Efrain Yanez Recanatini on 2/21/22.
//

 
import SwiftUI

import SQLite3
 
class SlideDao {
 
 
 
 
 
 
 
 
 

    private var database = Environment(\.database).wrappedValue
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
 
    func getCountByCapsuleUuid(capsuleUuid: String) -> Int {

            if(sqlite3_step(statement) == SQLITE_ROW){
                count = Int(sqlite3_column_int(statement, 0))
                //print("\(count)")
            }
        } else {
 
           
        }
        sqlite3_finalize(statement)
        return count
    }

            if(sqlite3_step(statement) == SQLITE_ROW){
                count = Int(sqlite3_column_int(statement, 0))
                //print("\(count)")
            }
        } else {
 
           
        }
        sqlite3_finalize(statement)
        return count
    }

                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))
                records.append(model)
            }
        } else {
 
           
        }
        sqlite3_finalize(statement)
        return records
    }

                model.position = Int(sqlite3_column_int(statement, 9))
                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))
            }
        } else {
 
           
        }
        sqlite3_finalize(statement)
        return model
    }

            sqlite3_bind_text(statement,11, slide.addedOn , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 12, slide.updatedOn, -1, SQLITE_TRANSIENT)

 
           if sqlite3_step(statement) != SQLITE_DONE {
 
                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")
               
           }
        } else {
 
            print("Fallo la preparación de insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")
           

        }
       

        query = query + " WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(slide.uuid)'  ;"
        var statement : OpaquePointer? = nil
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
            if sqlite3_step(statement) != SQLITE_DONE {
                print("No se puedo actualizar un registro en la tabla: \(Constants.TABLE_SLIDE) ")
 
               
            }
        } else {
            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_SLIDE)")
 
           
        }
        sqlite3_finalize(statement)
    }

 

            " WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(uuid)' ;"
        var statement : OpaquePointer? = nil
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
            if sqlite3_step(statement) != SQLITE_DONE {
                print("No se pudo borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")
 
               
            }
        } else {
            print("Fallo la preparación de borrar un registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")
 
           
        }
        sqlite3_finalize(statement)
    }

 

        let query = "DELETE FROM " + Constants.TABLE_SLIDE + ";"
        var statement : OpaquePointer? = nil
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
            if sqlite3_step(statement) != SQLITE_DONE {
                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE)")
 
               
            }
        } else {
            print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE) ")
 
           
        }
        sqlite3_finalize(statement)
    }

    

Rev 19	Rev 61
Línea 3...	Línea 3...
3	`// twogetskills`	3	`// twogetskills`
4	`//`	4	`//`
5	`// Created by Efrain Yanez Recanatini on 2/21/22.`	5	`// Created by Efrain Yanez Recanatini on 2/21/22.`
6	`//`	6	`//`
Línea 7...	Línea 7...
7		7
8	`import UIKit`	8	`import SwiftUI`
Línea 9...	Línea 9...
9	`import SQLite3`	9	`import SQLite3`
-		10
10		11	`class SlideDao {`
11	`class SlideDao {`	-
12	`private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)`	-
13	`private var database = Database.sharedInstance`	-
14		-
15	`static let sharedInstance: SlideDao = {`	-
16	`let instance = SlideDao()`	-
17		-
18	`// setup code`	-
19	`return instance`	-
Línea 20...	Línea 12...
20	`}()`	12	`private var database = Environment(\.database).wrappedValue`
21		13	`private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)`
22		14
23	`func getCountByCapsuleUuid(capsuleUuid: String) -> Int {`	15	`func getCountByCapsuleUuid(capsuleUuid: String) -> Int {`
Línea 33...	Línea 25...
33	`if(sqlite3_step(statement) == SQLITE_ROW){`	25	`if(sqlite3_step(statement) == SQLITE_ROW){`
34	`count = Int(sqlite3_column_int(statement, 0))`	26	`count = Int(sqlite3_column_int(statement, 0))`
35	`//print("\(count)")`	27	`//print("\(count)")`
36	`}`	28	`}`
37	`} else {`	29	`} else {`
38	`database.printError()`	-
-		30
39	`}`	31	`}`
40	`sqlite3_finalize(statement)`	32	`sqlite3_finalize(statement)`
41	`return count`	33	`return count`
42	`}`	34	`}`
Línea 54...	Línea 46...
54	`if(sqlite3_step(statement) == SQLITE_ROW){`	46	`if(sqlite3_step(statement) == SQLITE_ROW){`
55	`count = Int(sqlite3_column_int(statement, 0))`	47	`count = Int(sqlite3_column_int(statement, 0))`
56	`//print("\(count)")`	48	`//print("\(count)")`
57	`}`	49	`}`
58	`} else {`	50	`} else {`
59	`database.printError()`	-
-		51
60	`}`	52	`}`
61	`sqlite3_finalize(statement)`	53	`sqlite3_finalize(statement)`
62	`return count`	54	`return count`
63	`}`	55	`}`
Línea 100...	Línea 92...
100	`model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))`	92	`model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))`
101	`model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))`	93	`model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))`
102	`records.append(model)`	94	`records.append(model)`
103	`}`	95	`}`
104	`} else {`	96	`} else {`
105	`database.printError()`	-
-		97
106	`}`	98	`}`
107	`sqlite3_finalize(statement)`	99	`sqlite3_finalize(statement)`
108	`return records`	100	`return records`
109	`}`	101	`}`
Línea 142...	Línea 134...
142	`model.position = Int(sqlite3_column_int(statement, 9))`	134	`model.position = Int(sqlite3_column_int(statement, 9))`
143	`model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))`	135	`model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))`
144	`model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))`	136	`model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 11)))`
145	`}`	137	`}`
146	`} else {`	138	`} else {`
147	`database.printError()`	-
-		139
148	`}`	140	`}`
149	`sqlite3_finalize(statement)`	141	`sqlite3_finalize(statement)`
150	`return model`	142	`return model`
151	`}`	143	`}`
Línea 185...	Línea 177...
185	`sqlite3_bind_text(statement,11, slide.addedOn , -1, SQLITE_TRANSIENT)`	177	`sqlite3_bind_text(statement,11, slide.addedOn , -1, SQLITE_TRANSIENT)`
186	`sqlite3_bind_text(statement, 12, slide.updatedOn, -1, SQLITE_TRANSIENT)`	178	`sqlite3_bind_text(statement, 12, slide.updatedOn, -1, SQLITE_TRANSIENT)`
Línea 187...	Línea 179...
187		179
188	`if sqlite3_step(statement) != SQLITE_DONE {`	180	`if sqlite3_step(statement) != SQLITE_DONE {`
189	`print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")`	-
-		181	`print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")`
190	`database.printError()`	182
191	`}`	183	`}`
192	`} else {`	184	`} else {`
193	`print("Fallo la preparación de insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")`	-
-		185	`print("Fallo la preparación de insertar un registro en la tabla: \(Constants.TABLE_SLIDE)")`
194	`database.printError()`	186
Línea 195...	Línea 187...
195	`}`	187	`}`
196		188
Línea 212...	Línea 204...
212	`query = query + " WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(slide.uuid)' ;"`	204	`query = query + " WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(slide.uuid)' ;"`
213	`var statement : OpaquePointer? = nil`	205	`var statement : OpaquePointer? = nil`
214	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`	206	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`
215	`if sqlite3_step(statement) != SQLITE_DONE {`	207	`if sqlite3_step(statement) != SQLITE_DONE {`
216	`print("No se puedo actualizar un registro en la tabla: \(Constants.TABLE_SLIDE) ")`	208	`print("No se puedo actualizar un registro en la tabla: \(Constants.TABLE_SLIDE) ")`
217	`database.printError()`	-
-		209
218	`}`	210	`}`
219	`} else {`	211	`} else {`
220	`print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_SLIDE)")`	212	`print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_SLIDE)")`
221	`database.printError()`	-
-		213
222	`}`	214	`}`
223	`sqlite3_finalize(statement)`	215	`sqlite3_finalize(statement)`
224	`}`	216	`}`
Línea 225...	Línea 217...
225		217
Línea 229...	Línea 221...
229	`" WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(uuid)' ;"`	221	`" WHERE " + Constants.TABLE_SLIDE_FIELD_UUID + " = '\(uuid)' ;"`
230	`var statement : OpaquePointer? = nil`	222	`var statement : OpaquePointer? = nil`
231	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`	223	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`
232	`if sqlite3_step(statement) != SQLITE_DONE {`	224	`if sqlite3_step(statement) != SQLITE_DONE {`
233	`print("No se pudo borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")`	225	`print("No se pudo borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")`
234	`database.printError()`	-
-		226
235	`}`	227	`}`
236	`} else {`	228	`} else {`
237	`print("Fallo la preparación de borrar un registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")`	229	`print("Fallo la preparación de borrar un registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_SLIDE)")`
238	`database.printError()`	-
-		230
239	`}`	231	`}`
240	`sqlite3_finalize(statement)`	232	`sqlite3_finalize(statement)`
241	`}`	233	`}`
Línea 242...	Línea 234...
242		234
Línea 245...	Línea 237...
245	`let query = "DELETE FROM " + Constants.TABLE_SLIDE + ";"`	237	`let query = "DELETE FROM " + Constants.TABLE_SLIDE + ";"`
246	`var statement : OpaquePointer? = nil`	238	`var statement : OpaquePointer? = nil`
247	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`	239	`if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{`
248	`if sqlite3_step(statement) != SQLITE_DONE {`	240	`if sqlite3_step(statement) != SQLITE_DONE {`
249	`print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE)")`	241	`print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE)")`
250	`database.printError()`	-
-		242
251	`}`	243	`}`
252	`} else {`	244	`} else {`
253	`print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE) ")`	245	`print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_SLIDE) ")`
254	`database.printError()`	-
-		246
255	`}`	247	`}`
256	`sqlite3_finalize(statement)`	248	`sqlite3_finalize(statement)`
257	`}`	249	`}`
Línea 258...	Línea 250...
258		250

Proyectos de Subversion Iphone Microlearning - Nuevo Interface

(root)/twogetskills/Dao/SlideDao.swift – Rev 19 → 61