Best code snippets using com.google.api.services.bigquery.model(Showing top 15 results out of 315)

 TableRow tr = new TableRow(this);  
TableLayout.LayoutParams tableRowParams=
 new TableLayout.LayoutParams
 (TableLayout.LayoutParams.FILL_PARENT,TableLayout.LayoutParams.WRAP_CONTENT);

int leftMargin=10;
int topMargin=2;
int rightMargin=10;
int bottomMargin=2;

tableRowParams.setMargins(leftMargin, topMargin, rightMargin, bottomMargin);

tr.setLayoutParams(tableRowParams);

public static String printRows(final GetQueryResultsResponse response) {
 StringBuilder msg = null;
 msg = new StringBuilder();
 try {
  for (TableFieldSchema schem: response.getSchema().getFields()) {
   msg.append(schem.getName());
   msg.append(TAB);
  }      
  msg.append(NEWLINE);
  for (TableRow row : response.getRows()) {
   for (TableCell field : row.getF()) {
    msg.append(field.getV().toString());
    msg.append(TAB);
   }
   msg.append(NEWLINE);
  }
  return msg.toString();
 } catch ( NullPointerException ex ) {
  throw new NullPointerException("SQL Execution returned an error!");
 }
}

public static Job pollJob(final Bigquery.Jobs.Get request, final long interval) 
  throws IOException, InterruptedException {
 Job job = request.execute();
 while (!job.getStatus().getState().equals("DONE")) {
  System.out.println("Job is " 
    + job.getStatus().getState() 
    + " waiting " + interval + " milliseconds...");
  Thread.sleep(interval);
  job = request.execute();
 }
 return job;
}

public static Iterator<GetQueryResultsResponse> run(final String queryString,
 final String projId, final long wTime, final long maxRows, boolean useLegacySql)
  throws IOException {
 try {
  logger.info("Use legacy sql: {}", useLegacySql);
  QueryResponse query;
  query = service
    .jobs()
    .query(
      projId,
      new QueryRequest().setTimeoutMs(wTime)
        .setUseLegacySql(useLegacySql).setQuery(queryString)
        .setMaxResults(maxRows)).execute();
  jobId = query.getJobReference().getJobId();
  projectId = query.getJobReference().getProjectId();
  GetQueryResults getRequest = service.jobs().getQueryResults(
    projectId,
    jobId);
  return getPages(getRequest);
 } catch (IOException ex) {
  throw ex;
 }
}

 /* Find Tablelayout defined in main.xml */
TableLayout tl = (TableLayout) findViewById(R.id.SaleOrderLines);
/* Create a new row to be added. */
TableRow tr = new TableRow(this);
tr.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.FILL_PARENT, TableRow.LayoutParams.WRAP_CONTENT));
/* Create a Button to be the row-content. */
Button b = new Button(this);
b.setText("Dynamic Button");
b.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.FILL_PARENT, TableRow.LayoutParams.WRAP_CONTENT));
/* Add Button to row. */
tr.addView(b);
/* Add row to TableLayout. */
//tr.setBackgroundResource(R.drawable.sf_gradient_03);
tl.addView(tr, new TableLayout.LayoutParams(TableLayout.LayoutParams.FILL_PARENT, TableLayout.LayoutParams.WRAP_CONTENT));

private JobStatus runJob(Job job) throws InterruptedException, IOException {
 if (job.getConfiguration().getLoad() != null) {
  return runLoadJob(job.getJobReference(), job.getConfiguration().getLoad());
 } else if (job.getConfiguration().getCopy() != null) {
  return runCopyJob(job.getConfiguration().getCopy());
 } else if (job.getConfiguration().getExtract() != null) {
  return runExtractJob(job, job.getConfiguration().getExtract());
 } else if (job.getConfiguration().getQuery() != null) {
  return runQueryJob(job.getConfiguration().getQuery());
 }
 return new JobStatus().setState("DONE");
}

public TableRowBuilder set(String fieldName, Object value) {
 row.set(fieldName, value);
 return this;
}
public TableRow build() {

static TableReference createTempTableReference(String projectId, String jobUuid) {
 String queryTempDatasetId = "temp_dataset_" + jobUuid;
 String queryTempTableId = "temp_table_" + jobUuid;
 TableReference queryTempTableRef = new TableReference()
   .setProjectId(projectId)
   .setDatasetId(queryTempDatasetId)
   .setTableId(queryTempTableId);
 return queryTempTableRef;
}

@Override
public void startQueryJob(JobReference jobRef, JobConfigurationQuery query)
  throws IOException, InterruptedException {
 synchronized (allJobs) {
  Job job = new Job();
  job.setJobReference(jobRef);
  job.setConfiguration(new JobConfiguration().setQuery(query));
  job.setKind(" bigquery#job");
  job.setStatus(new JobStatus().setState("PENDING"));
  allJobs.put(jobRef.getProjectId(), jobRef.getJobId(), new JobInfo(job));
 }
}

public TableRowBuilder() {
 row = new TableRow();
}
public TableRowBuilder set(String fieldName, Object value) {

private JobStatus runQueryJob(JobConfigurationQuery query)
  throws IOException, InterruptedException  {
 List<TableRow> rows = FakeBigQueryServices.rowsFromEncodedQuery(query.getQuery());
 datasetService.createTable(new Table().setTableReference(query.getDestinationTable()));
 datasetService.insertAll(query.getDestinationTable(), rows, null);
 return new JobStatus().setState("DONE");
}

 private QueryResponse createResponseContainingTestData() {
  TableCell field1 = new TableCell();
  field1.setV("abc");
  TableCell field2 = new TableCell();
  field2.setV("2");
  TableCell field3 = new TableCell();
  field3.setV("testing BigQuery matcher.");
  TableRow row = new TableRow();
  row.setF(Lists.newArrayList(field1, field2, field3));

  QueryResponse response = new QueryResponse();
  response.setJobComplete(true);
  response.setRows(Lists.newArrayList(row));
  response.setTotalRows(BigInteger.ONE);
  return response;
 }
}

@Override
public void startCopyJob(JobReference jobRef, JobConfigurationTableCopy copyConfig)
  throws IOException, InterruptedException {
 synchronized (allJobs) {
  verifyUniqueJobId(jobRef.getJobId());
  Job job = new Job();
  job.setJobReference(jobRef);
  job.setConfiguration(new JobConfiguration().setCopy(copyConfig));
  job.setKind(" bigquery#job");
  job.setStatus(new JobStatus().setState("PENDING"));
  allJobs.put(jobRef.getProjectId(), jobRef.getJobId(), new JobInfo(job));
 }
}

/** Sets the table reference. */
private static TableReference getTableReference(String project, String dataset, String table){
 TableReference tableRef = new TableReference();
 tableRef.setProjectId(project);
 tableRef.setDatasetId(dataset);
 tableRef.setTableId(table);
 return tableRef;
}

 /** Utility to construct an output table reference. */
 static TableReference getTable(String projectId, String datasetId, String tableName) {
  TableReference table = new TableReference();
  table.setDatasetId(datasetId);
  table.setProjectId(projectId);
  table.setTableId(tableName);
  return table;
 }
}