ETL

'm reading it.
Why did you set target to 17?
...
Why did you implement the entire history in the ETL
Why not use the syncadapter?
Quint • 8:05 AM
Wenying Zhu
I couldn't build with target 19.
When sync ended in syncadapter,
I saved the sync result.
I was trying to have a process for SQLite processing, in only ETL.
Wenying • 8:09 AM
Quint Stoffers
The point is that it shouldn't be in the ETL
It's not a measurement, and it doesn't need to be converted to a QuantimodoMeasurement, so why have it there?
Why did you just use a SqliteOpenHelper to write to the database?
Quint • 8:10 AM
Wenying Zhu
I didn't use SqliteOpenHelper.
I used SQLiteDatabase
Wenying • 8:12 AM
Quint Stoffers
That's not my point.
You modified the cross platform ETL to get your history database.
Quint • 8:13 AM
Wenying Zhu
During getting the project,
I understood ETL has a sqlite connection.
Wenying • 8:15 AM
Quint Stoffers
Yes, for reading.
Do you know what ETL stands for?
http://nl.wikipedia.org/wiki/Extraction,_Transformation_and_Load
Did you document the CREATE statement for the history table?
Quint • 8:18 AM
Wenying Zhu
I didn't yet.
Wenying • 8:20 AM
Quint Stoffers
Please do that asap.
Quint • 8:20 AM
Wenying Zhu
can you send the issue list?
Wenying • 8:21 AM
Quint Stoffers
I'll clean it up myself.
Quint • 8:22 AM
Wenying Zhu
I hope to complete by mine.
I tried to take a clear code.
Wenying • 8:22 AM
Quint Stoffers
The code is clear, the structure isn't
Quint • 8:23 AM
Wenying Zhu
what part of structure has missing?
I think converter need for history.
Wenying • 8:23 AM
Quint Stoffers
You don't need a converter
You should've used a SqliteOpenHelper and a ContentProvider to write and read from the database.
http://developer.android.com/training/basics/data-storage/databases.html
Quint • 8:25 AM
Wenying Zhu
I know for sqliteOpenHelper.
Wenying • 8:25 AM
Quint Stoffers
An ETL is for extracting data from other sources. The history is no such thing
Quint • 8:25 AM
Wenying Zhu
but, I tried to add code on based current project.
In project, the access is providing with SQLiteConnection, SQLiteReader.
So, I added SQLiteWriter on based this.
Wenying • 8:26 AM
Quint Stoffers
Again, that's for the ETL.
Quint • 8:26 AM
Quint Stoffers
Your listadapter loops through the applications arraylist for each row. That's not very efficient.
https://github.com/mikepsinn/QuantiModo-Sync/issues/19
Quint • 8:36 AM
Wenying Zhu
Hi, Mr. Quint
I am sorry, 
can you teach again for issue19?
Wenying • 9:15 AM
Quint Stoffers
The SQL statement to create the table structure.
(or just document that structure)