Examples of SpreadsheetEntry


Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

  @Test
  public void updateWorksheetTwiceForRetryTest() throws Exception {

    String[] kinds = new String[] { "TestKind1" };
    List<GbProperty> propList = TestDataUtil.entities2();
    final SpreadsheetEntry spreadsheet = createSpreadsheet(kinds);
    try {

      goboService.prepareWorksheet(spreadsheet.getKey(), kinds[0], propList);
      goboService.prepareWorksheet(spreadsheet.getKey(), kinds[0], propList);

    } finally {
      deleteSpreadsheet(spreadsheet);
    }
  }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

      kindList.add("TestKind" + i);
    }
    String[] kinds = kindList.toArray(new String[0]);

    List<GbProperty> propList = TestDataUtil.entities2();
    final SpreadsheetEntry spreadsheet = createSpreadsheet(kinds);
    String ssKey = spreadsheet.getKey();
    try {
      for (int i = 0; i < kinds.length; i++) {
        String tableId = goboService.prepareWorksheet(ssKey, kinds[i], propList);
        assertThat(tableId, is(String.valueOf(i)));
      }
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

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

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

    ControllerTester tester = new ControllerTester();
    HttpSession session = tester.request.getSession(true);
    session.setAttribute("token", authSubToken);

    String[] kinds = new String[] { "TestKind1" };
    final SpreadsheetEntry spreadsheet = SpreadsheetUtil.createSpreadsheet(authSubToken, kinds);
    try {
      String run = tester.start("/restore/index");
      assertNotNull(run);
      List<Map<String, Object>> list = (List) tester.request.getAttribute("list");
      assertThat(list.size(), not(0));
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

  @SuppressWarnings("unchecked")
  @Test
  public void runAuthWithDataTest() throws Exception {

    String[] kinds = new String[] { "TestKind1" };
    final SpreadsheetEntry spreadsheet = SpreadsheetUtil.createSpreadsheet(authSubToken, kinds);
    try {
      ControllerTester tester = new ControllerTester();
      HttpSession session = tester.request.getSession(true);
      session.setAttribute("token", authSubToken);
     
      tester.request.setParameter("ssKey", spreadsheet.getKey());
      String run = tester.start("/restore/sheet");
      assertNotNull(run);
      List<Map<String, Object>> list = (List) tester.request.getAttribute("list");
      assertThat(list.size(), not(0));
    } finally {
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

  @Test
  public void runWithoutDataTest() throws Exception {

    String[] kinds = { "TestKind1" };
    SpreadsheetEntry ssEntry = SpreadsheetUtil.createSpreadsheet(authSubToken, kinds);
    try {
      Key controlKey =
        TaskQueueUtil.prepareRestoreControlKey("TestKind1", ssEntry.getKey(), authSubToken);

      ControllerTester tester = new ControllerTester();
      tester.request.setParameter("controlKey", KeyFactory.keyToString(controlKey));
      String run = tester.start("/tasks/restore");
      assertNull(run);
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

  @Test
  public void runWithDataTest() throws Exception {

    String[] kinds = { "TestKind1" };
    SpreadsheetEntry ssEntry = SpreadsheetUtil.createAndDumpSpreadsheet(authSubToken, kinds);
    try {
      Key controlKey =
        TaskQueueUtil.prepareRestoreControlKey("TestKind1", ssEntry.getKey(), authSubToken);

      ControllerTester tester = new ControllerTester();
      tester.request.setParameter("controlKey", KeyFactory.keyToString(controlKey));
      String run = tester.start("/tasks/restore");
      assertNull(run);
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

        ServiceException, URISyntaxException {
        SpreadsheetService service = new SpreadsheetService("MySpreadsheetIntegration-foo");
        URL url = new URL("https://spreadsheets.google.com/feeds/spreadsheets/private/full?title=GSS-Dev-Schedule");
        SpreadsheetFeed feed = service.getFeed(url, SpreadsheetFeed.class);
        List<SpreadsheetEntry> spreadsheets = feed.getEntries();
        SpreadsheetEntry spreadsheet = spreadsheets.get(0);
        WorksheetFeed worksheetFeed = service.getFeed(spreadsheet.getWorksheetFeedUrl(), WorksheetFeed.class);
        List<WorksheetEntry> worksheets = worksheetFeed.getEntries();
        WorksheetEntry worksheet = worksheets.get(0);
        // fetch A1 only
        URL cellFeedUrl = new URI(worksheet.getCellFeedUrl().toString() + "?min-row=1&max-row=1&min-col=1&max-col=1")
            .toURL();
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

  public String getExportLink(DocumentListEntry entry, String format){
    return ((MediaContent) entry.getContent()).getUri() + "&exportFormat=" + format;
  }
  public void createReprtWorksheets(String title) {
    try {
      SpreadsheetEntry spEntry = findSpreadsheetEntry(title);
      for (WorksheetEntry wsEntry : spEntry.getWorksheets()) {
        if (wsEntry.getTitle().getPlainText().equals("Sheet 1") || wsEntry.getTitle().getPlainText().equals("Sheet1")) {
          wsEntry.setTitle(new PlainTextConstruct(ChartTypes.TOTAL));
          wsEntry.setRowCount(20);
          wsEntry.setColCount(2);
          wsEntry.update();
          break;
        }
      }
      URL wsFeedUrl = spEntry.getWorksheetFeedUrl();
      WorksheetEntry wsEntry = null;
      if (spEntry != null) {
        if (findWorksheetEntry(ChartTypes.DAY, spEntry) == null) {
          wsEntry = new WorksheetEntry();
          wsEntry.setRowCount(365);
View Full Code Here

Examples of com.google.gdata.data.spreadsheet.SpreadsheetEntry

    return null;
  }

  public void initStatSpreadSheet(String title) {
    try {
      SpreadsheetEntry spEntry = findSpreadsheetEntry(title);
      if (spEntry != null) {
        WorksheetEntry wsEntry = findWorksheetEntry(ChartTypes.DAY, spEntry);
        if (wsEntry != null) {
          initStatWorksheet(wsEntry, ChartTypes.DAY);
        }
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.