1 package com.prasanta.sample;
\r
3 import java.util.ArrayList;
\r
4 import java.util.HashMap;
\r
7 import com.pras.SpreadSheet;
\r
8 import com.pras.SpreadSheetFactory;
\r
9 import com.pras.WorkSheet;
\r
10 import com.pras.conn.HttpConHandler;
\r
11 import com.pras.table.Record;
\r
14 * Demonstrates how to handle Data/Records using this Lib.
\r
15 * Conditional Data Retrieval and Record Add/Edit/Delete
\r
16 * @author Prasanta Paul
\r
19 public class ConditionalDataRetrieve {
\r
21 public static void main(String[] args){
\r
22 String TAG = "ConditionalDataRetrieve";
\r
23 // Enable/Disable Log
\r
26 // Create SpreadSheet Factory instance
\r
27 SpreadSheetFactory spf = SpreadSheetFactory.getInstance(args[0], args[1]);
\r
29 // Get all SpreadSheets
\r
30 ArrayList<SpreadSheet> spreadSheets = spf.getAllSpreadSheets();
\r
32 if(spreadSheets == null && spreadSheets.size() == 0){
\r
33 Log.p(TAG, "No SpreadSheet Exists");
\r
37 SpreadSheet s = spreadSheets.get(0);
\r
39 System.out.println("SpreadSheet: "+ s.getTitle());
\r
42 s.addWorkSheet("tab_work_sample", new String[]{"Name", "Age", "Exp", "Country"});
\r
44 // Get List of All WorkSheets
\r
45 ArrayList<WorkSheet> wks = s.getAllWorkSheets();
\r
46 WorkSheet wk = wks.get(0);
\r
49 HashMap<String, String> record = new HashMap<String, String>();
\r
51 record.put("Name", "Santosh");
\r
52 record.put("Age", "25");
\r
53 record.put("Exp", "10");
\r
54 record.put("Country", "India");
\r
56 wk.addRecord(s.getKey(), record);
\r
58 // Conditional Data Read
\r
59 // Read Data from WorkSheet, where Age < 30 and Order by "Name" column
\r
60 // Please follow- http://code.google.com/apis/spreadsheets/data/3.0/reference.html#RecordParameters
\r
61 ArrayList<Record> records = wk.getRecords(s.getKey(), false, HttpConHandler.encode("\"Age\"") + "<" + HttpConHandler.encode("30"), "column:Name");
\r
63 if(records == null || records.size() == 0){
\r
64 System.out.println("No matching data");
\r
69 for(int i=0; i<records.size(); i++){
\r
70 Record r = records.get(i);
\r
71 HashMap<String, String> data = r.getData();
\r
72 System.out.println("Data: "+ data);
\r
75 //wk.deleteRecord(r);
\r
79 s.deleteWorkSheet(wk);
\r