Sugar.Data: Handling SQLiteConnection, SQLiteQueryResult, SQLiteException in Swift/Silver

Elements Silver
15

I confirm that now the ResultSet works fine. To traverse the array the sample code to insert test tuples and query them

                  do {
				
				let rndIndex=(Sugar.Random()).NextInt();
				let key="USER_"+Sugar.Convert.ToString(rndIndex);
				
				let INSERT = "INSERT OR REPLACE INTO CACHE (cache_key, cache_value, timestamp) VALUES (?,?,?);";
				conn.Execute(INSERT,[key,"PIPPO","20150101"]);
				
				let SELECT = "SELECT * from CACHE"
				let result:SQLiteQueryResult=conn.ExecuteQuery(SELECT);
				writeLn( result );
				
				while result.MoveNext() {
					writeLn(  result.GetString( 0 ) ); // col1
					writeLn( result.GetString( 1 ) ); // col2
					writeLn( result.GetString( 2 ) ); // col3
				}
			
			} catch let error as SQLiteException {
				logError("sql error",error:error);
			}

that logs called several times:

<SQLiteQueryResult: 0x14d55c870>
1
USER_765609548
PIPPO
2
USER_-1994321905
PIPPO
3
USER_-105582610
PIPPO

The complete working example (iOS and Android): https://github.com/loretoparisi/swift-promise-example

Note: An issue on Android ( see: Shared Project: Android app and iOS app sample apps )prevents this work at this time, I’m on it right now.