84   public func execute(sql: String, withArgs args: [Any?]?) throws -> [[String: Any?]] {  in execute()
86 …return try UpdatesDatabaseUtils.execute(sql: sql, withArgs: args, onDatabase: db.require("Missing …  in execute()
89   public func executeForObjC(sql: String, withArgs args: [Any]?) throws -> [Any] {  in executeForObjC()
90     return try execute(sql: sql, withArgs: args)  in executeForObjC()
94     let sql = """  in addUpdate()  variable
99       sql: sql,  in addUpdate()
124           sql: assetInsertSql,  in addNewAssets()
148           _ = try execute(sql: updateSql, withArgs: [updateId])  in addNewAssets()
159         _ = try execute(sql: updateInsertSql, withArgs: [updateId])  in addNewAssets()
179     let rows = try execute(sql: assetSelectSql, withArgs: [key])  in addExistingAsset()
186         _ = try execute(sql: insertSql, withArgs: [updateId, assetId.intValue])  in addExistingAsset()
195           _ = try execute(sql: updateSql, withArgs: [assetId.intValue, updateId])  in addExistingAsset()
217       sql: assetUpdateSql,  in updateAsset()
266     _ = try execute(sql: updateSql, withArgs: [update.status.rawValue, update.updateId])  in markUpdateFinished()
272     _ = try execute(sql: updateSql, withArgs: [update.lastAccessed, update.updateId])  in markUpdateAccessed()
278     _ = try execute(sql: updateSql, withArgs: [update.successfulLaunchCount, update.updateId])  in incrementSuccessfulLaunchCountForUpdate()
284     _ = try execute(sql: updateSql, withArgs: [update.failedLaunchCount, update.updateId])  in incrementFailedLaunchCountForUpdate()
289     _ = try execute(sql: updateSql, withArgs: [scopeKey, update.updateId])  in setScopeKey()
294     _ = try execute(sql: updateSql, withArgs: [commitTime, update.updateId])  in setUpdateCommitTime()
303 …    _ = try execute(sql: updateSql, withArgs: [UpdateStatus.StatusPending.rawValue, asset.assetId])  in markMissingAssets()
319         _ = try execute(sql: updateSql, withArgs: [update.updateId])  in deleteUpdates()
339       _ = try execute(sql: update1Sql, withArgs: nil)  in deleteUnusedAssets()
347       _ = try execute(sql: update2Sql, withArgs: nil)  in deleteUnusedAssets()
356       _ = try execute(sql: update3Sql, withArgs: nil)  in deleteUnusedAssets()
365       rows = try execute(sql: selectSql, withArgs: nil)  in deleteUnusedAssets()
377       _ = try execute(sql: deleteSql, withArgs: nil)  in deleteUnusedAssets()
389     let sql = "SELECT * FROM updates;"  in allUpdates()  variable
390     let rows = try execute(sql: sql, withArgs: nil)  in allUpdates()
397     let sql = "SELECT * FROM updates WHERE status = ?1;"  in allUpdates()  variable
398     let rows = try execute(sql: sql, withArgs: [status.rawValue])  in allUpdates()
405     let sql = "SELECT id FROM updates WHERE status = ?1;"  in allUpdateIds()  variable
406     let rows = try execute(sql: sql, withArgs: [status.rawValue])  in allUpdateIds()
416     let sql = String(  in launchableUpdates()  variable
423     let rows = try execute(sql: sql, withArgs: [config.scopeKey])  in launchableUpdates()
430     let sql = "SELECT * FROM updates WHERE updates.id = ?1;"  in update()  variable
431     let rows = try execute(sql: sql, withArgs: [updateId])  in update()
439     let sql = "SELECT * FROM assets;"  in allAssets()  variable
440     let rows = try execute(sql: sql, withArgs: nil)  in allAssets()
447 …let sql = "SELECT assets.*, launch_asset_id FROM assets INNER JOIN updates_assets ON updates_asset…  in assets()  variable
448     let rows = try execute(sql: sql, withArgs: [updateId])  in assets()
459     let sql = """  in asset()  variable
463     let rows = try execute(sql: sql, withArgs: [key])  in asset()
471     let sql = """  in jsonData()  variable
474     let rows = try execute(sql: sql, withArgs: [key, scopeKey])  in jsonData()
492       _ = try execute(sql: deleteSql, withArgs: [key, scopeKey])  in setJsonData()
504 …_ = try execute(sql: insertSql, withArgs: [key, data, Date().timeIntervalSince1970 * 1000, scopeKe…  in setJsonData()