Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

Rev 1 | Rev 11 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 8
Línea 26... Línea 26...
26
26
27 
    public func createTables()
 27 
    public func createTables()
28 
    {
 28 
    {
29 
        self.db = open()
 29 
        self.db = open()
- 
 
 30 
        if(self.db != nil) {
30 
        if(self.db != nil) {
 31 
            self.createTableApp()
31 
            self.createTableSync()
 32 
            self.createTableSync()
32 
            self.createTableProgress()
 33 
            self.createTableProgress()
33 
            self.createTableUserLog()
 34 
            self.createTableUserLog()
34 
            self.createTableCompany()
 35 
            self.createTableCompany()
Línea 88... Línea 89...
88 
    /*
 89 
    /*
Línea 89... Línea 90...
89 
 
 90 
 
90 
     var addedOn: String
 91 
     var addedOn: String
Línea -... Línea 92...
- 
 
 92 
     */
- 
 
 93
- 
 
 94 
    private func createTableApp()
- 
 
 95 
    {
- 
 
 96 
        var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_APP + " ("
- 
 
 97 
        sql = sql + Constants.TABLE_APP_FIELD_ID + " INTEGER NOT NULL, "
- 
 
 98 
        sql = sql + Constants.TABLE_APP_FIELD_DEVICE_UUID + " TEXT, "
- 
 
 99 
        sql = sql + Constants.TABLE_APP_FIELD_DEVICE_AES + " TEXT, "
- 
 
 100 
        sql = sql + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + " TEXT, "
- 
 
 101 
        sql = sql + Constants.TABLE_APP_FIELD_USER_UUID + " TEXT, "
- 
 
 102 
        sql = sql + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + " TEXT, "
- 
 
 103 
        sql = sql + Constants.TABLE_APP_FIELD_USER_LASTNAME + " TEXT, "
- 
 
 104 
        sql = sql + Constants.TABLE_APP_FIELD_USER_EMAIL + " TEXT, "
- 
 
 105 
        sql = sql + Constants.TABLE_APP_FIELD_USER_IMAGE + " TEXT, "
- 
 
 106 
        sql = sql + Constants.TABLE_APP_FIELD_FCM_TOKEN + " TEXT, "
- 
 
 107 
        sql = sql + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " TEXT, "
- 
 
 108 
        sql = sql + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " TEXT, "
- 
 
 109 
        sql = sql + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " TEXT, "
- 
 
 110 
        sql = sql + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " TEXT, "
- 
 
 111 
        sql = sql + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + " INTEGER, "
- 
 
 112 
        sql = sql + " PRIMARY KEY(`" +  Constants.TABLE_APP_FIELD_ID + "`) "
- 
 
 113 
        sql = sql + ");"
- 
 
 114
- 
 
 115 
        let sql1 = "CREATE INDEX `idx_app_id` ON `" +  Constants.TABLE_APP + "` (`" +  Constants.TABLE_APP_FIELD_ID + "` );"
- 
 
 116
- 
 
 117 
        let sql2 = "CREATE INDEX `idx_app_user_uuid` ON `" +  Constants.TABLE_APP + "` (`" +  Constants.TABLE_APP_FIELD_USER_UUID + "` );"
- 
 
 118
- 
 
 119 
        let sql3 = "CREATE INDEX `idx_app_device_uuid` ON `" +  Constants.TABLE_APP + "` (`" +  Constants.TABLE_APP_FIELD_DEVICE_UUID + "` );"
- 
 
 120
- 
 
 121 
        let query = sql + sql1 + sql2 + sql3
- 
 
 122 
        var statement : OpaquePointer? = nil
- 
 
 123
- 
 
 124 
        if sqlite3_prepare_v2(self.db, query, -1, &statement, nil) == SQLITE_OK {
- 
 
 125 
            if sqlite3_step(statement) != SQLITE_DONE {
- 
 
 126 
                print("No se pudo crear la tabla: \(Constants.TABLE_APP)")
- 
 
 127 
            }
- 
 
 128 
        } else {
- 
 
 129 
            print("Fallo la preparación para crear la tabla: \(Constants.TABLE_APP)")
- 
 
 130
- 
 
 131 
        }
91 
     */
 132 
    }
92
133
93 
    private func createTableUserNotification()
 134 
    private func createTableUserNotification()
94 
    {
 135 
    {
95 
        var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_USER_NOTIFICATION + "("
 136 
        var sql = "CREATE TABLE IF NOT EXISTS " + Constants.TABLE_USER_NOTIFICATION + "("