A third-party, type-safe, Swift-language layer over SQLite.
A third-party, type-safe, Swift-language layer over SQLite.
Questions tagged [sqlite.swift]
252 questions
0
votes
1 answer
How can I get the results of filter
Sorry, but I'm new in Swift and I stuck
let timestamp = Table("time_stamps")
let t_tabelle = Expression("tabelle")
let t_stamp = Expression("TIME_STAMP")
let stmt = timestamp.filter(t_tabelle == "member")
print ("Stamp:…
chazon
- 1
- 1
0
votes
0 answers
filtering Tables and put it into an array , some new in Xcode 7?
I've got Xcode 7 but since there are many errors in my old Project,
I stuck with one Problem:
xcode 6:
var myData: Array = []
var my_mData: Array = []
var m_mitglieder : Query!
var m_firmen : Query!
var stmt_m : Query!
var stmt_f :…
chazon
- 1
- 1
0
votes
1 answer
How to pass Row of sqlite.swift to another controller using NSNotification
I am using sqlite.swift in my project.
let inputdata = row as Row
NSNotificationCenter.defaultCenter().postNotificationName("navigateToProductDetail",object: inputdata)
I cant pass "inputdata"
inputdata would be AnyObject , in my case its Row
so…
Velu Loganathan
- 241
- 2
- 11
0
votes
1 answer
SQLite.swift Value of type Connection has no member userVersion
I just upgraded to the branch of SQLite.swift for xCode 7 and Swift 2. Now along with a million other errors I am trying to correct I can't figure out what is the equivalent to the previous Database.userVersion? I know Database type has been…
Wayne Fulcher
- 741
- 1
- 11
- 21
0
votes
1 answer
can't extend NSData with Value Type
this section doesn't work with swift2 branch:
https://github.com/stephencelis/SQLite.swift/blob/swift-2/Documentation/Index.md#binary-data
I get:
Redundant conformance of 'NSData' to protocol 'Value'
and
Type 'UIImage' does not conform to protocol…
Paolo Bernardini
- 13
- 2
0
votes
0 answers
Sqlite error on different Machine with Swift
I have made an app that has to access a database frequently. The app is Programed in swift and for the database access i use the framework SQLITE.swift from stephencelis.
Everything works finde but when I install the Program on another machine with…
Silve2611
- 2,198
- 2
- 34
- 55
0
votes
1 answer
SQLite.swift with swift 2.0 in Xcode 7.0
I recently updated to Xcode 7.0 and am trying to build my project which uses the SQLite.swift library. After converting to the latest swift syntax (Edit->Convert->To Latest Swift Syntax...) I get so many errors and I don't know where to begin fixing…
maddob
- 989
- 1
- 12
- 29
0
votes
0 answers
SQLite.swift (Swift 2.0) Joins Not showing all fields
I am having an issue creating joins with SQLite.swift while migrating application to swift2.
In this case what worked perfect in 1.2 is not working in 2.0. Might be a bug or maybe just a problem with updated syntax, but can't figure it out.
I am…
zzpaf
- 73
- 7
0
votes
0 answers
SQLite.swift Alias in swift 2.0
I am having an issue with Xcode (Prerelease 7.0 (7A218)) where alias function does not seem to work as expected (Or I am doing something wrong...)
This was working fine previously:
let preUsers = Table("PreUsers")
let eqowners =…
zzpaf
- 73
- 7
0
votes
1 answer
SQLite.Swift: Cannot invoke 'insert' with an argument list of type '(Setter, Setter, Setter)'
Okay, after some trial and error, I managed to eliminate some of my other errors, although I still have an issue with one command returning the above error. The line is:
PCharacter.PCharacters.insert(PCharacter.charName <- "\(newCharName)",
…
Eric LaRue
- 25
- 3
0
votes
1 answer
Export sqlite DB as csv - Sqlite.swift
I am using sqlite in my iOS application. I would like to export this db and put it in a centralized db. How to export sqlite db? I am using sqlite.swift. Thanks!
0
votes
2 answers
Not able to use more than one Match functions
I am not able to use more than one match functions in filter() of Query
where single match() working fine but when i start to use more than two match() it gives error like
assertion failed: unable to use function MATCH in the requested
context:…
Jasmin
- 794
- 7
- 18
0
votes
1 answer
Error: Expression is not convertible to String
My code is:
func getTimeStamps( tablename : String) -> String {
let time_stamps = db["time_stamps"]
let t_tabelle = Expression["tabelle"]
let t_time_stamp = Expression["TIME_StAMP"]
let query =…
Hauke Schrills
- 1
- 1
0
votes
0 answers
SQLite.swift joins missing information
I am trying to join a few tables in swift using the SQLite.swift library and I am having a few problems. The below code shows the issue:
I first join the tables:
let ext_tasks = tasks.join(tasktypes, on: tasktypes[tty_id] == tasks[task_type])
…
zzpaf
- 73
- 7
0
votes
1 answer
How to execute a complex sql statement and get the results in an array?
I would like to execute a fairly complex SQL statement using SQLite.swift and get the result preferably in an array to use as a data source for a tableview. The statement looks like this:
SELECT defindex, AVG(price) FROM prices WHERE quality = 5 AND…
Longi
- 3,913
- 2
- 28
- 38