Simple filtering using predicate

Hi ppl,

Today morning my friend asked me to create a piechart with rotates while doing single finger rotation. I made it for her assuming lables are added separately. I have uploaded the project here . Feel free to use it.

It is more of a discussion post rather than tips/tutorial post. Comments are welcomed.

Hey ppl,
I have been asked to work with something which i am not part of. Initially i hesistated and even resisted.But I have been forced to work. But it turned to be interesting.

Let me explain the problem briefly,

There are certain items in a database. When ever there is a change in any item it has to be cloned and added newly with the modification. Technically, there is no updation ,only insertion.  The server side didn finish the task. They just did updation and sent the modified row to the ipad as a part of delta sync.

In the ipad side the modified row should reflect the change. Ipad should insert data and not update as it is the real scenario . Insertion, as you have rightly guessed, would violate the primary key constrain. So we decided to delete the row and insert anew.

Don't worry if you do not understand the backgroud, Its just written to give wholly to the story.

Given  : An insert query which would violate primary key constrain.
Task   : Insert row after deleteing the row in question.
approach :

1.Extract tablename from the query.
I have parsed the query string to obtain the table name.  [[query componentsseperatedByString:@" "] objectAtIndex:2].

2. Extract Primary key from table given table name.
PRAGMA table_info(table-name);This pragma returns one row for each column in the named table. Columns in the result set include the column name, data type, whether or not the column can be NULL, and the default value for the column.

From this result(Run the query to understand better.) the primary key extracted by iterating over the resultset.

3. Delete the Row using the primary key extracted.
Value for the primary key is extracted from the query.

4.Run the new insert query.

Eventhough the work is not going to be used, I was happy to have done this work.

I had to write a STUB  in objective-c for webservice consumption.Let me share my findings. First I would like to explain what a STUB is.

From my understanding STUB is a proxy code generated from the WSDL information to intereact with the associated webservice.In other words, STUB consists of the bolierplate code that is needed for the webservice interaction.

In IOS there is no built-in API to create STUB from WSDL. However there are few open source tools that can help you making it. For example , you can look into WSDL2OBJC or