Swift SQLITE3 Insertion / Selection Issue

Question

I have spent days trying to figure out why slqlite3 using Swift either inserts a string with the last character missing or just empty all together. Research online has also proven itself to be a defeat; I just cannot understand that by following the standard procedure of:

Open the connection to the database.
Prepare the statement & bind the variables.
Execute the statement & finalize it.
Close the connection to the database.

Note: This is according to Apress' Beginning iPhone Development with Swift book.

Would anyone have an idea as to why the strings are not being inserted properly (or maybe the issue arises during selection?) ? Any help would be greatly appreciated.

The code used in my application is as follows:

Assume necessary variables have been created.

var database:COpaquePointer = nil
var result: Int32 = Int32()


    func create () {
    connect()
    let createSQL = "CREATE TABLE IF NOT EXISTS artists (id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(100) NOT NULL, last_updated INTEGER, created INTEGER);"
    var errMsg:UnsafeMutablePointer<Int8> = nil
    if sqlite3_exec(database, createSQL, nil, nil, &errMsg) != SQLITE_OK { println(errMsg) }
    disconnect()
}

func connect () -> Bool { println("Connected to the db."); return sqlite3_open(path, &database) == SQLITE_OK }

func create () { connect() let createSQL = "CREATE TABLE IF NOT EXISTS artists (id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(100) NOT NULL, last_updated INTEGER, created INTEGER);" var errMsg:UnsafeMutablePointer = nil if sqlite3_exec(database, createSQL, nil, nil, &errMsg) != SQLITE_OK { println(errMsg) } disconnect() }

func addArtist (title: String) -> Int32 {
    connect()
    var newItemId: Int32 = 0
    let query = "INSERT INTO artists (title, last_updated, created) VALUES (?, ?, ?);"
    var statement:COpaquePointer = nil
    if sqlite3_prepare_v2(database, query, -1, &statement, nil) == SQLITE_OK {
        sqlite3_bind_text(statement, 1, title, -1, nil)
        sqlite3_bind_int(statement, 2, 0)
        sqlite3_bind_int(statement, 3, Int32(NSDate().timeIntervalSince1970))
    }
    if sqlite3_step(statement) == SQLITE_DONE { newItemId = Int32(sqlite3_last_insert_rowid(database)) }
    sqlite3_finalize(statement)
    disconnect()
    return newItemId
}

al_qaysee · Accepted Answer · 2021-01-17 01:23:24Z

0

Try change the create table settings.

Replace the VARCHAR(100) to TEXT ... not sure if this is fixing it, but it worth to give it a shot.

answered Jan 17, 2021 at 1:23

al_qaysee

811 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Swift SQLITE3 Insertion / Selection Issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related