Skip to content

Instantly share code, notes, and snippets.

@ericcgu
Created January 21, 2015 03:32
Show Gist options
  • Save ericcgu/091b1b55da042d1fe6e2 to your computer and use it in GitHub Desktop.
Save ericcgu/091b1b55da042d1fe6e2 to your computer and use it in GitHub Desktop.
SQL Swift Raw Query
// let table = db["STOCKS_CORN_LOCATION"];
//
//
// var query = "SELECT LOCATION, \"2011301_ON\", \"2011301_OFF\", \"2011301_TOTAL\" FROM STOCKS_CORN_LOCATION"
// let statement = db.prepare(query)
// while ((statement.next()) != nil){
// let row = statement.row![0]!
// var dataFieldImport = DataFieldObject(fieldOne: statement.row![0]! as String,
// fieldTwo: statement.row![1]! as String,
// fieldThree: statement.row![2]! as String,
// fieldFour: statement.row![3]! as String,
// fieldFive: frequency)
// tableData.append(dataFieldImport)
// }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment