Examples of GbSpreadsheetService

Examples of gobo.service.GbSpreadsheetService

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    ds.put(orgData);

    final String[] kinds = { KIND_NAME };

    // Create Spreadsheet
    GbSpreadsheetService gss = new GbSpreadsheetService(authSubToken);
    SpreadsheetEntry spreadsheet = gss.createSpreadsheet(Arrays.asList(kinds));
    try {

      // Get Data from Datastore.
      final List<GbEntity> srcData = GbDatastoreService.getData(null, KIND_NAME, COUNT);

      // Dump Data to Spreadsheet.
      List<GbProperty> properties = GbDatastoreService.getProperties(KIND_NAME);
      final String tableId = gss.prepareWorksheet(spreadsheet.getKey(), KIND_NAME, properties);
      gss.dumpData(spreadsheet.getKey(), KIND_NAME, tableId, srcData, false);

      // (Retry) Dump Data to Spreadsheet.
      gss.dumpData(spreadsheet.getKey(), KIND_NAME, tableId, srcData, true);

      // Get Data from Spreadsheet
      final List<GbEntity> midData =
        gss.getDataOrNull(spreadsheet.getKey(), KIND_NAME, 3, COUNT);

      // Compare
      for (int i = 0; i < srcData.size(); i++) {
        final GbEntity src = srcData.get(i);
        for (int j = 0; j < midData.size(); j++) {
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
import com.google.gdata.data.spreadsheet.SpreadsheetEntry;

public class SpreadsheetUtil {

  public static SpreadsheetEntry createSpreadsheet(String authSubToken, String[] kinds) {
    GbSpreadsheetService goboService = new GbSpreadsheetService(authSubToken);
    try {
      SpreadsheetEntry createSpreadsheet =
        goboService.createSpreadsheet(Arrays.asList(kinds));
      for (String kind : kinds) {
        List<GbProperty> testPropList1 = TestDataUtil.entities2();
        goboService.prepareWorksheet(createSpreadsheet.getKey(), kind, testPropList1);
      }
      return createSpreadsheet;
    } catch (Exception e) {
      e.printStackTrace();
    }
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    }
    return null;
  }

  public static SpreadsheetEntry createAndDumpSpreadsheet(String authSubToken, String[] kinds) {
    GbSpreadsheetService goboService = new GbSpreadsheetService(authSubToken);
    try {
      SpreadsheetEntry createSpreadsheet =
        goboService.createSpreadsheet(Arrays.asList(kinds));
      int i = 0;
      for (String kind : kinds) {
        List<GbProperty> testPropList1 = TestDataUtil.entities2();
        goboService.prepareWorksheet(createSpreadsheet.getKey(), kind, testPropList1);
        List<GbEntity> list = TestDataUtil.entities(kind);
        goboService.dumpData(createSpreadsheet.getKey(), kind, String.valueOf(i++), list, false);
      }
      return createSpreadsheet;
    } catch (Exception e) {
      e.printStackTrace();
    }
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

49
50
51
52
53
54
55
56
57
58
59
60
61
62
    }
    return null;
  }

  public static SpreadsheetEntry createBlunkSpreadsheet(String authSubToken, String[] kinds) {
    GbSpreadsheetService goboService = new GbSpreadsheetService(authSubToken);
    try {
      SpreadsheetEntry createSpreadsheet =
        goboService.createSpreadsheet(Arrays.asList(kinds));
      return createSpreadsheet;
    } catch (Exception e) {
      e.printStackTrace();
    }
    return null;
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    final String token = sessionScope("token");
    final UserService user = UserServiceFactory.getUserService();
    final User currentUser = user.getCurrentUser();

    // Craete new spreadsheet
    GbSpreadsheetService gss = new GbSpreadsheetService(token);
    SpreadsheetEntry spreadsheet;
    while (true) {
      try {
        spreadsheet = gss.createSpreadsheet(Arrays.asList(kinds));
        break;
      } catch (IOException ioe) {
        // retry when timeout.
      }
    }
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

13
14
15
16
17
18
19
20
21
22
23
  protected String runAuth() throws Exception {

    final String ssKey = asString("ssKey");
    requestScope("ssKey", ssKey);
   
    GbSpreadsheetService service = new GbSpreadsheetService((String) sessionScope("token"));
    List<Map<String, String>> list = service.getAllWorkSheets(ssKey);
    requestScope("list", list);

    return forward("/gobo/restore/sheet.jsp");
  }
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

37
38
39
40
41
42
43
44
45
46
47
48
    final String token = (String) control.getProperty(GbControl.AUTH_SUB_TOKEN);
    logger.info("Restore:kind=" + kind + ":rowNum=" + rowNum);
    Queue queue = QueueFactory.getDefaultQueue();

    // Spreadsheetからデータを取得
    GbSpreadsheetService service = new GbSpreadsheetService(token);
    List<GbEntity> data = service.getDataOrNull(ssKey, kind, rowNum + 1, RANGE);

    if (data == null) {
      // Call the final task
      queue.add(TaskOptions.Builder.url("/tasks/restoreEnd.gobo").param(
        "controlKey",
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

10
11
12
13
14
15
16
17
18
19
public class IndexController extends AuthSubBase {

  @Override
  protected String runAuth() throws Exception {

    GbSpreadsheetService service = new GbSpreadsheetService((String) sessionScope("token"));
    List<Map<String, String>> list = service.getAllSpreadSheets();
    requestScope("list", list);
    return forward("/gobo/restore/index.jsp");
  }
View Full Code Here

Examples of gobo.service.GbSpreadsheetService

36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
    final String kind = (String) control.getProperty(GbControl.KIND_NAME);
    String tableId = (String) control.getProperty(GbControl.TABLE_ID);
    final String _cursor = (String) control.getProperty(GbControl.CURSOR);
    final Long rowNum = (Long) control.getProperty(GbControl.COUNT);
    final String token = (String) control.getProperty(GbControl.AUTH_SUB_TOKEN);
    final GbSpreadsheetService gss = new GbSpreadsheetService(token);
    logger.info("Dump:kind=" + kind + ":rowNum=" + rowNum);

    // Prepare table only at first chain.
    final Cursor cursor = (_cursor == null) ? null : Cursor.fromWebSafeString(_cursor);
    if (cursor == null) {
      List<GbProperty> properties = GbDatastoreService.getProperties(kind);
      tableId = gss.prepareWorksheet(ssKey, kind, properties);
    }

    // Get data from datastore.
    GbEntityList<GbEntity> list = GbDatastoreService.getData(cursor, kind, RANGE);

    // Call the last chain.
    Queue queue = QueueFactory.getDefaultQueue();
    if ((list == null) || (list.size() == 0)) {
      queue.add(TaskOptions.Builder.url("/tasks/dumpEnd.gobo").param(
        "controlKey",
        KeyFactory.keyToString(controlKey)).method(Method.GET));
      return null;
    }

    // Add to Spreadsheet.
    gss.dumpData(ssKey, kind, tableId, list, retry);

    // Update the control table.
    control.setProperty(GbControl.CURSOR, list.getCursor().toWebSafeString());
    control.setProperty(GbControl.TABLE_ID, tableId);
    control.setProperty(GbControl.COUNT, rowNum + RANGE);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.