[View] [Edit] [Lock] [References] [Attachments] [History] [Home] [Changes] [Search] [Help]
test[FMDB] 004 Insert some records
| db databasePath |
databasePath := 'Sample.sqlite' asLocalPathName.
db := FMDatabase withPath: databasePath.
db open ifTrue: [
db executeUpdate: 'insert into Books (Title, Author, Pages) values (?,?,?)' withArgumentsInArray: #('Smalltalk-80: The Language and its Implementation' 'Adele Goldberg' 714).
db executeUpdate: 'insert into Books (Title, Author, Pages) values (?,?,?)' withArgumentsInArray: #('Smalltalk, Objects, and Design' 'Chamond Liu' 289).
db executeUpdate: 'insert into Books (Title, Author, Pages) values (?,?,?)' withArgumentsInArray: #('Smalltalk With Style' 'Edward Klimas' 127).
db executeUpdate: 'insert into Books (Title, Author, Pages) values (?,?,?)' withArgumentsInArray: #('Smalltalk Best Practice Patterns 1st Edition' 'Kent Beck' 240).
db close.
].
! !