public class org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils extends java.lang.Object
{
private static final org.slf4j.Logger logger;
private static final int SAMPLE_SIZE;
private static final com.google.api.client.json.JsonFactory JSON_FACTORY;
private static final java.lang.String UNKNOWN_HEADER;
private static final java.lang.String APPLICATION_NAME;
public void <init>()
{
org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils v;
v := @this: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils;
specialinvoke v.<java.lang.Object: void <init>()>();
return;
}
public static com.google.api.client.auth.oauth.Credential authorize(org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig, com.google.api.client.util.store.DataStore, java.lang.String) throws java.io.IOException, java.security.GeneralSecurityException
{
java.lang.Object[] v, v;
org.apache.drill.common.exceptions.UserException$Builder v, v, v, v;
com.google.api.client.googleapis.auth.oauth.GoogleClientSecrets v;
org.apache.drill.common.exceptions.UserException v, v;
com.google.api.client.auth.oauth.Credential v;
java.lang.String v;
com.google.api.client.util.store.DataStoreFactory v, v;
com.google.api.client.http.javanet.NetHttpTransport v;
org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig v;
com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder v, v, v;
org.slf4j.Logger v, v, v, v;
com.google.api.client.util.store.DataStore v;
java.util.List v;
com.google.api.client.json.JsonFactory v;
com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow v;
v := @parameter: org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig;
v := @parameter: com.google.api.client.util.store.DataStore;
v := @parameter: java.lang.String;
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig: com.google.api.client.googleapis.auth.oauth.GoogleClientSecrets getSecrets()>();
v = staticinvoke <java.util.Collections: java.util.List singletonList(java.lang.Object)>("https://www.googleapis.com/auth/spreadsheets");
if v != null goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
interfaceinvoke v.<org.slf4j.Logger: void debug(java.lang.String)>("Datastore is null");
v = staticinvoke <org.apache.drill.common.exceptions.UserException: org.apache.drill.common.exceptions.UserException$Builder connectionError()>();
v = newarray (java.lang.Object)[0];
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException$Builder message(java.lang.String,java.lang.Object[])>("The DrillDataStore is null.  This should not happen.", v);
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException build(org.slf4j.Logger)>(v);
throw v;
label:
v = interfaceinvoke v.<com.google.api.client.util.store.DataStore: com.google.api.client.util.store.DataStoreFactory getDataStoreFactory()>();
if v != null goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
interfaceinvoke v.<org.slf4j.Logger: void debug(java.lang.String)>("Datastore factory is null");
v = staticinvoke <org.apache.drill.common.exceptions.UserException: org.apache.drill.common.exceptions.UserException$Builder connectionError()>();
v = newarray (java.lang.Object)[0];
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException$Builder message(java.lang.String,java.lang.Object[])>("The DrillDataStoreFactory is null.  This should not happen.", v);
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException build(org.slf4j.Logger)>(v);
throw v;
label:
v = new com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder;
v = staticinvoke <com.google.api.client.googleapis.javanet.GoogleNetHttpTransport: com.google.api.client.http.javanet.NetHttpTransport newTrustedTransport()>();
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.json.JsonFactory JSON_FACTORY>;
specialinvoke v.<com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder: void <init>(com.google.api.client.http.HttpTransport,com.google.api.client.json.JsonFactory,com.google.api.client.googleapis.auth.oauth.GoogleClientSecrets,java.util.Collection)>(v, v, v, v);
v = interfaceinvoke v.<com.google.api.client.util.store.DataStore: com.google.api.client.util.store.DataStoreFactory getDataStoreFactory()>();
v = virtualinvoke v.<com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder: com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder setDataStoreFactory(com.google.api.client.util.store.DataStoreFactory)>(v);
v = virtualinvoke v.<com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder: com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder setAccessType(java.lang.String)>("offline");
v = virtualinvoke v.<com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow$Builder: com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow build()>();
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.auth.oauth.Credential loadCredential(java.lang.String,com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow,com.google.api.client.util.store.DataStore)>(v, v, v);
return v;
}
public static com.google.api.client.auth.oauth.Credential loadCredential(java.lang.String, com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow, com.google.api.client.util.store.DataStore)
{
com.google.api.client.util.store.DataStore v;
com.google.api.client.auth.oauth.StoredCredential v;
java.lang.Long v;
com.google.api.client.auth.oauth.Credential v;
java.lang.String v, v, v;
com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow v;
boolean v;
v := @parameter: java.lang.String;
v := @parameter: com.google.api.client.googleapis.auth.oauth.GoogleAuthorizationCodeFlow;
v := @parameter: com.google.api.client.util.store.DataStore;
v = staticinvoke <com.google.api.client.util.Strings: boolean isNullOrEmpty(java.lang.String)>(v);
if v == 0 goto label;
return null;
label:
if v != null goto label;
return null;
label:
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.auth.oauth.Credential newCredential(java.lang.String,com.google.api.client.auth.oauth.AuthorizationCodeFlow,com.google.api.client.util.store.DataStore)>(v, v, v);
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.DrillDataStore: com.google.api.client.auth.oauth.StoredCredential getStoredCredential()>();
if v != null goto label;
return null;
label:
v = virtualinvoke v.<com.google.api.client.auth.oauth.StoredCredential: java.lang.String getAccessToken()>();
virtualinvoke v.<com.google.api.client.auth.oauth.Credential: com.google.api.client.auth.oauth.Credential setAccessToken(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.StoredCredential: java.lang.String getRefreshToken()>();
virtualinvoke v.<com.google.api.client.auth.oauth.Credential: com.google.api.client.auth.oauth.Credential setRefreshToken(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.StoredCredential: java.lang.Long getExpirationTimeMilliseconds()>();
virtualinvoke v.<com.google.api.client.auth.oauth.Credential: com.google.api.client.auth.oauth.Credential setExpirationTimeMilliseconds(java.lang.Long)>(v);
return v;
}
private static com.google.api.client.auth.oauth.Credential newCredential(java.lang.String, com.google.api.client.auth.oauth.AuthorizationCodeFlow, com.google.api.client.util.store.DataStore)
{
com.google.api.client.util.Clock v;
com.google.api.client.auth.oauth.Credential$AccessMethod v;
com.google.api.client.auth.oauth.DataStoreCredentialRefreshListener v;
com.google.api.client.http.HttpRequestInitializer v;
com.google.api.client.auth.oauth.AuthorizationCodeFlow v;
com.google.api.client.auth.oauth.Credential v;
java.lang.String v, v;
com.google.api.client.http.HttpExecuteInterceptor v;
java.util.Collection v, v;
com.google.api.client.http.HttpTransport v;
com.google.api.client.auth.oauth.Credential$Builder v, v, v, v, v, v, v;
com.google.api.client.util.store.DataStore v;
com.google.api.client.json.JsonFactory v;
v := @parameter: java.lang.String;
v := @parameter: com.google.api.client.auth.oauth.AuthorizationCodeFlow;
v := @parameter: com.google.api.client.util.store.DataStore;
v = new com.google.api.client.auth.oauth.Credential$Builder;
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.auth.oauth.Credential$AccessMethod getMethod()>();
specialinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: void <init>(com.google.api.client.auth.oauth.Credential$AccessMethod)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.http.HttpTransport getTransport()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setTransport(com.google.api.client.http.HttpTransport)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.json.JsonFactory getJsonFactory()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setJsonFactory(com.google.api.client.json.JsonFactory)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: java.lang.String getTokenServerEncodedUrl()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setTokenServerEncodedUrl(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.http.HttpExecuteInterceptor getClientAuthentication()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setClientAuthentication(com.google.api.client.http.HttpExecuteInterceptor)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.http.HttpRequestInitializer getRequestInitializer()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setRequestInitializer(com.google.api.client.http.HttpRequestInitializer)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: com.google.api.client.util.Clock getClock()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder setClock(com.google.api.client.util.Clock)>(v);
if v == null goto label;
v = new com.google.api.client.auth.oauth.DataStoreCredentialRefreshListener;
specialinvoke v.<com.google.api.client.auth.oauth.DataStoreCredentialRefreshListener: void <init>(java.lang.String,com.google.api.client.util.store.DataStore)>(v, v);
virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential$Builder addRefreshListener(com.google.api.client.auth.oauth.CredentialRefreshListener)>(v);
label:
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: java.util.Collection getRefreshListeners()>();
v = virtualinvoke v.<com.google.api.client.auth.oauth.AuthorizationCodeFlow: java.util.Collection getRefreshListeners()>();
interfaceinvoke v.<java.util.Collection: boolean addAll(java.util.Collection)>(v);
v = virtualinvoke v.<com.google.api.client.auth.oauth.Credential$Builder: com.google.api.client.auth.oauth.Credential build()>();
return v;
}
public static com.google.api.services.sheets.v.Sheets getSheetsService(org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig, com.google.api.client.util.store.DataStore, java.lang.String) throws java.io.IOException, java.security.GeneralSecurityException
{
com.google.api.client.http.javanet.NetHttpTransport v;
org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig v;
com.google.api.client.json.gson.GsonFactory v;
com.google.api.client.util.store.DataStore v;
com.google.api.services.sheets.v.Sheets v;
com.google.api.services.sheets.v.Sheets$Builder v, v;
com.google.api.client.auth.oauth.Credential v;
java.lang.String v;
v := @parameter: org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig;
v := @parameter: com.google.api.client.util.store.DataStore;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.auth.oauth.Credential authorize(org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig,com.google.api.client.util.store.DataStore,java.lang.String)>(v, v, v);
v = new com.google.api.services.sheets.v.Sheets$Builder;
v = staticinvoke <com.google.api.client.googleapis.javanet.GoogleNetHttpTransport: com.google.api.client.http.javanet.NetHttpTransport newTrustedTransport()>();
v = staticinvoke <com.google.api.client.json.gson.GsonFactory: com.google.api.client.json.gson.GsonFactory getDefaultInstance()>();
specialinvoke v.<com.google.api.services.sheets.v.Sheets$Builder: void <init>(com.google.api.client.http.HttpTransport,com.google.api.client.json.JsonFactory,com.google.api.client.http.HttpRequestInitializer)>(v, v, v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Builder: com.google.api.services.sheets.v.Sheets$Builder setApplicationName(java.lang.String)>("Drill");
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Builder: com.google.api.services.sheets.v.Sheets build()>();
return v;
}
public static com.google.api.services.drive.Drive getDriveService(org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig, com.google.api.client.util.store.DataStore, java.lang.String) throws java.io.IOException, java.security.GeneralSecurityException
{
com.google.api.client.http.javanet.NetHttpTransport v;
org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig v;
com.google.api.client.json.gson.GsonFactory v;
com.google.api.services.drive.Drive v;
com.google.api.client.util.store.DataStore v;
com.google.api.client.auth.oauth.Credential v;
com.google.api.services.drive.Drive$Builder v, v;
java.lang.String v;
v := @parameter: org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig;
v := @parameter: com.google.api.client.util.store.DataStore;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.auth.oauth.Credential authorize(org.apache.drill.exec.store.googlesheets.GoogleSheetsStoragePluginConfig,com.google.api.client.util.store.DataStore,java.lang.String)>(v, v, v);
v = new com.google.api.services.drive.Drive$Builder;
v = staticinvoke <com.google.api.client.googleapis.javanet.GoogleNetHttpTransport: com.google.api.client.http.javanet.NetHttpTransport newTrustedTransport()>();
v = staticinvoke <com.google.api.client.json.gson.GsonFactory: com.google.api.client.json.gson.GsonFactory getDefaultInstance()>();
specialinvoke v.<com.google.api.services.drive.Drive$Builder: void <init>(com.google.api.client.http.HttpTransport,com.google.api.client.json.JsonFactory,com.google.api.client.http.HttpRequestInitializer)>(v, v, v);
v = virtualinvoke v.<com.google.api.services.drive.Drive$Builder: com.google.api.services.drive.Drive$Builder setApplicationName(java.lang.String)>("Drill");
v = virtualinvoke v.<com.google.api.services.drive.Drive$Builder: com.google.api.services.drive.Drive build()>();
return v;
}
public static java.util.Map getTokenToNameMap(com.google.api.services.drive.Drive) throws java.io.IOException
{
java.util.Iterator v;
com.google.api.services.drive.Drive v;
com.google.api.services.drive.Drive$Files v;
com.google.api.services.drive.Drive$Files$List v, v, v, v;
java.util.HashMap v;
java.util.List v;
java.lang.Object v, v;
java.lang.String v, v, v;
boolean v;
v := @parameter: com.google.api.services.drive.Drive;
v = new java.util.HashMap;
specialinvoke v.<java.util.HashMap: void <init>()>();
v = null;
label:
v = virtualinvoke v.<com.google.api.services.drive.Drive: com.google.api.services.drive.Drive$Files files()>();
v = virtualinvoke v.<com.google.api.services.drive.Drive$Files: com.google.api.services.drive.Drive$Files$List list()>();
v = virtualinvoke v.<com.google.api.services.drive.Drive$Files$List: com.google.api.services.drive.Drive$Files$List setQ(java.lang.String)>("mimeType=\'application/vnd.google-apps.spreadsheet\'");
v = virtualinvoke v.<com.google.api.services.drive.Drive$Files$List: com.google.api.services.drive.Drive$Files$List setSpaces(java.lang.String)>("drive");
v = virtualinvoke v.<com.google.api.services.drive.Drive$Files$List: com.google.api.services.drive.Drive$Files$List setPageToken(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.services.drive.Drive$Files$List: java.lang.Object execute()>();
v = virtualinvoke v.<com.google.api.services.drive.model.FileList: java.util.List getFiles()>();
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<com.google.api.services.drive.model.File: java.lang.String getId()>();
v = virtualinvoke v.<com.google.api.services.drive.model.File: java.lang.String getName()>();
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
goto label;
label:
v = virtualinvoke v.<com.google.api.services.drive.model.FileList: java.lang.String getNextPageToken()>();
if v != null goto label;
return v;
}
public static boolean isProbableFileToken(java.lang.String)
{
java.util.regex.Matcher v;
org.slf4j.Logger v;
int v;
java.lang.String v;
java.util.regex.Pattern v;
boolean v, v;
v := @parameter: java.lang.String;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
interfaceinvoke v.<org.slf4j.Logger: void debug(java.lang.String,java.lang.Object)>("Checking token {}", v);
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v == 0 goto label;
return 0;
label:
v = virtualinvoke v.<java.lang.String: int length()>();
if v == 44 goto label;
return 0;
label:
v = staticinvoke <java.util.regex.Pattern: java.util.regex.Pattern compile(java.lang.String)>("[0-9][a-zA-Z0-9_-]{43}");
v = virtualinvoke v.<java.util.regex.Pattern: java.util.regex.Matcher matcher(java.lang.CharSequence)>(v);
v = virtualinvoke v.<java.util.regex.Matcher: boolean find()>();
return v;
}
public static java.util.List getTabList(com.google.api.services.sheets.v.Sheets, java.lang.String) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets v;
java.util.List v;
org.slf4j.Logger v;
java.lang.Object v;
java.lang.String v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Get v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
interfaceinvoke v.<org.slf4j.Logger: void debug(java.lang.String,java.lang.Object)>("Getting tabs for: {}", v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Get get(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Get: java.lang.Object execute()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.Spreadsheet: java.util.List getSheets()>();
return v;
}
public static java.lang.String columnToLetter(int)
{
int v, v, v, v, v, v;
java.lang.StringBuilder v;
java.lang.String v;
v := @parameter: int;
if v > 0 goto label;
return null;
label:
v = new java.lang.StringBuilder;
specialinvoke v.<java.lang.StringBuilder: void <init>()>();
label:
if v <= 0 goto label;
v = v - 1;
v = v % 26;
v = v + 65;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder insert(int,char)>(0, v);
v = v - v;
v = v - 1;
v = v / 26;
goto label;
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.String toString()>();
return v;
}
public static int letterToColumnIndex(java.lang.String)
{
int v, v, v, v, v, v, v, v;
java.lang.String v, v;
double v;
v := @parameter: java.lang.String;
v = virtualinvoke v.<java.lang.String: java.lang.String toUpperCase()>();
v = 0;
v = virtualinvoke v.<java.lang.String: int length()>();
v = 0;
label:
if v >= v goto label;
v = staticinvoke <java.lang.Character: int codePointAt(java.lang.CharSequence,int)>(v, v);
v = v - 64;
v = v - v;
v = v - 1;
v = staticinvoke <java.lang.Math: double pow(double,double)>(26.0, v);
v = v * v;
v = v + v;
v = v + 1;
goto label;
label:
return v;
}
public static java.util.List getFirstRows(com.google.api.services.sheets.v.Sheets, java.lang.String, java.lang.String) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get v;
com.google.api.services.sheets.v.Sheets v;
java.util.List v;
java.lang.Object v;
java.lang.String v, v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String)>(v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("\u0001!1:5");
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values values()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get get(java.lang.String,java.lang.String)>(v, v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get: java.lang.Object execute()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: java.util.List getValues()>();
return v;
}
public static java.util.List getDataFromRange(com.google.api.services.sheets.v.Sheets, java.lang.String, java.lang.String) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get v;
com.google.api.services.sheets.v.Sheets v;
java.util.List v;
java.lang.Object v;
java.lang.String v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values values()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get get(java.lang.String,java.lang.String)>(v, v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Get: java.lang.Object execute()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: java.util.List getValues()>();
return v;
}
public static com.google.api.services.sheets.v.model.Sheet getSheetFromTabList(java.lang.String, java.util.List)
{
java.lang.Object[] v;
org.slf4j.Logger v;
java.util.Iterator v;
org.apache.drill.common.exceptions.UserException$Builder v, v;
org.apache.drill.common.exceptions.UserException v;
java.util.List v;
com.google.api.services.sheets.v.model.SheetProperties v;
java.lang.Object v;
java.lang.String v, v, v;
boolean v, v;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.Sheet: com.google.api.services.sheets.v.model.SheetProperties getProperties()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.SheetProperties: java.lang.String getTitle()>();
v = virtualinvoke v.<java.lang.String: boolean contentEquals(java.lang.CharSequence)>(v);
if v == 0 goto label;
return v;
label:
v = staticinvoke <org.apache.drill.common.exceptions.UserException: org.apache.drill.common.exceptions.UserException$Builder dataReadError()>();
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String)>(v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("Could not find sheet \u0001");
v = newarray (java.lang.Object)[0];
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException$Builder message(java.lang.String,java.lang.Object[])>(v, v);
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
v = virtualinvoke v.<org.apache.drill.common.exceptions.UserException$Builder: org.apache.drill.common.exceptions.UserException build(org.slf4j.Logger)>(v);
throw v;
}
public static java.util.List getBatchData(com.google.api.services.sheets.v.Sheets, java.lang.String, java.util.List) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values v;
java.util.ArrayList v, v;
int v, v, v, v;
java.lang.String v;
org.slf4j.Logger v;
java.lang.RuntimeException v;
com.google.api.services.sheets.v.Sheets v;
java.util.List v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$BatchGet v, v;
java.lang.Object v, v, v, v, v, v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger>;
interfaceinvoke v.<org.slf4j.Logger: void debug(java.lang.String,java.lang.Object)>("Getting ranges: {}", v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values values()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$BatchGet batchGet(java.lang.String)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$BatchGet: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$BatchGet setRanges(java.util.List)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$BatchGet: java.lang.Object execute()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.BatchGetValuesResponse: java.util.List getValueRanges()>();
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = 0;
label:
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(0);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: java.lang.Object get(java.lang.Object)>("values");
v = virtualinvoke v.<java.util.ArrayList: int size()>();
if v >= v goto label;
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = 0;
label:
v = interfaceinvoke v.<java.util.List: int size()>();
if v >= v goto label;
label:
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: java.lang.Object get(java.lang.Object)>("values");
v = virtualinvoke v.<java.util.ArrayList: java.lang.Object get(int)>(v);
v = virtualinvoke v.<java.util.ArrayList: java.lang.Object get(int)>(0);
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
label:
goto label;
label:
v := @caughtexception;
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(null);
label:
v = v + 1;
goto label;
label:
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
v = v + 1;
goto label;
label:
return v;
catch java.lang.IndexOutOfBoundsException from label to label with label;
catch java.lang.NullPointerException from label to label with label;
}
public static java.util.Map getColumnMap(java.util.List, java.util.List, boolean)
{
boolean v, v, v, v, v, v;
java.util.List v, v;
org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES v, v;
java.util.HashMap v;
java.util.ArrayList v;
java.util.LinkedHashMap v;
int v, v, v, v, v, v, v;
java.lang.String v;
org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn v;
java.util.Iterator v, v;
java.lang.Object v, v, v, v, v, v, v, v;
v := @parameter: java.util.List;
v := @parameter: java.util.List;
v := @parameter: boolean;
v = 0;
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = new java.util.HashMap;
specialinvoke v.<java.util.HashMap: void <init>()>();
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(0);
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = staticinvoke <org.apache.parquet.Strings: boolean isNullOrEmpty(java.lang.String)>(v);
if v == 0 goto label;
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (int)>(v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("field_\u0001");
v = v + 1;
label:
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES VARCHAR>;
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
goto label;
label:
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES UNKNOWN>;
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
goto label;
label:
if v != 0 goto label;
v = 1;
label:
v = interfaceinvoke v.<java.util.List: int size()>();
if v >= v goto label;
v = 0;
label:
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
v = interfaceinvoke v.<java.util.List: int size()>();
if v >= v goto label;
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
v = virtualinvoke v.<java.lang.Object: java.lang.String toString()>();
staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: void updateDataType(java.lang.String,java.util.Map,java.lang.String)>(v, v, v);
v = v + 1;
goto label;
label:
v = v + 1;
goto label;
label:
v = new java.util.LinkedHashMap;
specialinvoke v.<java.util.LinkedHashMap: void <init>()>();
v = 0;
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = staticinvoke <org.apache.drill.exec.util.Utilities: boolean isStarQuery(java.util.Collection)>(v);
if v != 0 goto label;
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: boolean isProjected(java.util.List,java.lang.String)>(v, v);
if v == 0 goto label;
label:
v = new org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn;
v = interfaceinvoke v.<java.util.Map: java.lang.Object get(java.lang.Object)>(v);
v = interfaceinvoke v.<java.util.List: int indexOf(java.lang.Object)>(v);
specialinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn: void <init>(java.lang.String,org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES,int,int)>(v, v, v, v);
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
v = v + 1;
goto label;
label:
return v;
}
public static java.util.List getProjectedRanges(java.lang.String, java.util.Map)
{
java.lang.Integer v;
java.util.ArrayList v;
java.util.Map v;
int v, v, v, v, v;
java.lang.String v;
boolean v, v;
java.util.Iterator v;
java.util.Collection v;
java.lang.Object v;
org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange v, v, v, v;
v := @parameter: java.lang.String;
v := @parameter: java.util.Map;
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = (int) -1;
v = v;
v = new org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange;
specialinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: void <init>(java.lang.String)>(v);
v = v;
v = interfaceinvoke v.<java.util.Map: java.util.Collection values()>();
v = interfaceinvoke v.<java.util.Collection: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn: boolean isMetadata()>();
if v != 0 goto label;
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn: int getColumnIndex()>();
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: java.lang.Integer getStartColIndex()>();
if v != null goto label;
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange setStartIndex(int)>(v);
label:
v = v + 1;
if v == v goto label;
v = (int) -1;
if v == v goto label;
virtualinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange setEndIndex(int)>(v);
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
v = new org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange;
specialinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: void <init>(java.lang.String)>(v);
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange setStartIndex(int)>(v);
label:
v = v;
goto label;
label:
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange: org.apache.drill.exec.store.googlesheets.columns.GoogleSheetsColumnRange setEndIndex(int)>(v);
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
return v;
}
public static boolean isProjected(java.util.List, java.lang.String)
{
org.apache.drill.exec.proto.UserBitShared$NamePart v;
java.util.Iterator v;
java.util.List v;
java.lang.Object v;
java.lang.String v, v;
boolean v, v, v;
v := @parameter: java.util.List;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.drill.exec.util.Utilities: boolean isStarQuery(java.util.Collection)>(v);
if v == 0 goto label;
return 1;
label:
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<org.apache.drill.common.expression.SchemaPath: org.apache.drill.exec.proto.UserBitShared$NamePart getAsNamePart()>();
v = virtualinvoke v.<org.apache.drill.exec.proto.UserBitShared$NamePart: java.lang.String getName()>();
v = virtualinvoke v.<java.lang.String: boolean contains(java.lang.CharSequence)>(v);
if v == 0 goto label;
return 1;
label:
return 0;
}
public static org.apache.drill.exec.record.metadata.TupleMetadata buildSchema(java.util.Map)
{
java.util.Iterator v;
java.util.Collection v;
org.apache.drill.exec.record.metadata.SchemaBuilder v;
org.apache.drill.exec.record.metadata.TupleMetadata v;
org.apache.drill.common.types.TypeProtos$MinorType v;
java.util.Map v;
java.lang.Object v;
java.lang.String v;
boolean v;
v := @parameter: java.util.Map;
v = new org.apache.drill.exec.record.metadata.SchemaBuilder;
specialinvoke v.<org.apache.drill.exec.record.metadata.SchemaBuilder: void <init>()>();
v = interfaceinvoke v.<java.util.Map: java.util.Collection values()>();
v = interfaceinvoke v.<java.util.Collection: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn: java.lang.String getColumnName()>();
v = virtualinvoke v.<org.apache.drill.exec.store.googlesheets.GoogleSheetsColumn: org.apache.drill.common.types.TypeProtos$MinorType getDrillDataType()>();
virtualinvoke v.<org.apache.drill.exec.record.metadata.SchemaBuilder: org.apache.drill.exec.record.metadata.SchemaBuilder addNullable(java.lang.String,org.apache.drill.common.types.TypeProtos$MinorType)>(v, v);
goto label;
label:
v = virtualinvoke v.<org.apache.drill.exec.record.metadata.SchemaBuilder: org.apache.drill.exec.record.metadata.TupleMetadata build()>();
return v;
}
public static org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES inferDataType(java.lang.String)
{
java.util.Map$Entry v;
org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES v, v, v, v, v, v;
java.lang.Object v;
java.lang.String v, v;
boolean v, v, v, v, v;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.drill.common.Typifier: java.util.Map$Entry typify(java.lang.String)>(v);
v = interfaceinvoke v.<java.util.Map$Entry: java.lang.Object getKey()>();
v = virtualinvoke v.<java.lang.Class: java.lang.String getSimpleName()>();
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES UNKNOWN>;
return v;
label:
v = virtualinvoke v.<java.lang.String: boolean equalsIgnoreCase(java.lang.String)>("Double");
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES NUMERIC>;
return v;
label:
v = virtualinvoke v.<java.lang.String: boolean equalsIgnoreCase(java.lang.String)>("LocalDateTime");
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES TIMESTAMP>;
return v;
label:
v = virtualinvoke v.<java.lang.String: boolean equalsIgnoreCase(java.lang.String)>("LocalDate");
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES DATE>;
return v;
label:
v = virtualinvoke v.<java.lang.String: boolean equalsIgnoreCase(java.lang.String)>("LocalTime");
if v == 0 goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES TIME>;
return v;
label:
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES VARCHAR>;
return v;
}
public static void updateDataType(java.lang.String, java.util.Map, java.lang.String)
{
org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES v, v, v, v, v;
java.util.Map v;
java.lang.Object v;
java.lang.String v, v;
boolean v;
v := @parameter: java.lang.String;
v := @parameter: java.util.Map;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v == 0 goto label;
return;
label:
v = staticinvoke <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES inferDataType(java.lang.String)>(v);
v = interfaceinvoke v.<java.util.Map: java.lang.Object get(java.lang.Object)>(v);
if v != v goto label;
return;
label:
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES UNKNOWN>;
if v != v goto label;
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
goto label;
label:
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES NUMERIC>;
if v != v goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES VARCHAR>;
if v != v goto label;
v = <org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES: org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils$DATA_TYPES VARCHAR>;
interfaceinvoke v.<java.util.Map: java.lang.Object put(java.lang.Object,java.lang.Object)>(v, v);
label:
return;
}
public static void addTabToGoogleSheet(com.google.api.services.sheets.v.Sheets, java.lang.String, java.lang.String) throws java.io.IOException
{
com.google.api.services.sheets.v.model.AddSheetRequest v, v;
com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest v, v;
java.lang.Integer v;
com.google.api.services.sheets.v.model.Request v, v;
java.util.ArrayList v;
java.lang.String v, v;
com.google.api.services.sheets.v.Sheets v;
com.google.api.services.sheets.v.model.SheetProperties v, v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = new com.google.api.services.sheets.v.model.Request;
specialinvoke v.<com.google.api.services.sheets.v.model.Request: void <init>()>();
v = new com.google.api.services.sheets.v.model.AddSheetRequest;
specialinvoke v.<com.google.api.services.sheets.v.model.AddSheetRequest: void <init>()>();
v = new com.google.api.services.sheets.v.model.SheetProperties;
specialinvoke v.<com.google.api.services.sheets.v.model.SheetProperties: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.SheetProperties: com.google.api.services.sheets.v.model.SheetProperties setTitle(java.lang.String)>(v);
v = staticinvoke <java.lang.Integer: java.lang.Integer valueOf(int)>(0);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.SheetProperties: com.google.api.services.sheets.v.model.SheetProperties setIndex(java.lang.Integer)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.AddSheetRequest: com.google.api.services.sheets.v.model.AddSheetRequest setProperties(com.google.api.services.sheets.v.model.SheetProperties)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.Request: com.google.api.services.sheets.v.model.Request setAddSheet(com.google.api.services.sheets.v.model.AddSheetRequest)>(v);
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
v = new com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest;
specialinvoke v.<com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest: com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest setRequests(java.util.List)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate batchUpdate(java.lang.String,com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest)>(v, v);
virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate: java.lang.Object execute()>();
return;
}
public static void removeTabFromGoogleSheet(com.google.api.services.sheets.v.Sheets, java.lang.String, com.google.api.services.sheets.v.model.Sheet) throws java.io.IOException
{
com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest v, v;
java.lang.Integer v;
com.google.api.services.sheets.v.model.Request v, v;
java.util.ArrayList v;
com.google.api.services.sheets.v.Sheets v;
com.google.api.services.sheets.v.model.DeleteSheetRequest v, v;
com.google.api.services.sheets.v.model.SheetProperties v;
com.google.api.services.sheets.v.model.Sheet v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate v;
java.lang.String v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: com.google.api.services.sheets.v.model.Sheet;
v = new java.util.ArrayList;
specialinvoke v.<java.util.ArrayList: void <init>()>();
v = new com.google.api.services.sheets.v.model.Request;
specialinvoke v.<com.google.api.services.sheets.v.model.Request: void <init>()>();
v = new com.google.api.services.sheets.v.model.DeleteSheetRequest;
specialinvoke v.<com.google.api.services.sheets.v.model.DeleteSheetRequest: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.Sheet: com.google.api.services.sheets.v.model.SheetProperties getProperties()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.SheetProperties: java.lang.Integer getSheetId()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.DeleteSheetRequest: com.google.api.services.sheets.v.model.DeleteSheetRequest setSheetId(java.lang.Integer)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.Request: com.google.api.services.sheets.v.model.Request setDeleteSheet(com.google.api.services.sheets.v.model.DeleteSheetRequest)>(v);
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
v = new com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest;
specialinvoke v.<com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest: com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest setRequests(java.util.List)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate batchUpdate(java.lang.String,com.google.api.services.sheets.v.model.BatchUpdateSpreadsheetRequest)>(v, v);
virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$BatchUpdate: java.lang.Object execute()>();
return;
}
public static void writeDataToGoogleSheet(com.google.api.services.sheets.v.Sheets, java.lang.String, java.lang.String, java.util.List) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values v;
com.google.api.services.sheets.v.Sheets v;
com.google.api.services.sheets.v.model.ValueRange v, v, v;
java.util.List v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Update v, v;
java.lang.String v, v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String)>(v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("\u0001!A1");
v = new com.google.api.services.sheets.v.model.ValueRange;
specialinvoke v.<com.google.api.services.sheets.v.model.ValueRange: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: com.google.api.services.sheets.v.model.ValueRange setValues(java.util.List)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: com.google.api.services.sheets.v.model.ValueRange setMajorDimension(java.lang.String)>("ROWS");
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values values()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Update update(java.lang.String,java.lang.String,com.google.api.services.sheets.v.model.ValueRange)>(v, v, v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Update: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Update setValueInputOption(java.lang.String)>("RAW");
virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Update: java.lang.Object execute()>();
return;
}
public static void appendDataToGoogleSheet(com.google.api.services.sheets.v.Sheets, java.lang.String, java.lang.String, java.util.List) throws java.io.IOException
{
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values v;
com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Append v, v;
com.google.api.services.sheets.v.Sheets v;
com.google.api.services.sheets.v.model.ValueRange v, v, v;
java.util.List v;
java.lang.String v, v, v;
com.google.api.services.sheets.v.Sheets$Spreadsheets v;
v := @parameter: com.google.api.services.sheets.v.Sheets;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String)>(v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("\u0001!A1");
v = new com.google.api.services.sheets.v.model.ValueRange;
specialinvoke v.<com.google.api.services.sheets.v.model.ValueRange: void <init>()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: com.google.api.services.sheets.v.model.ValueRange setValues(java.util.List)>(v);
v = virtualinvoke v.<com.google.api.services.sheets.v.model.ValueRange: com.google.api.services.sheets.v.model.ValueRange setMajorDimension(java.lang.String)>("ROWS");
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets: com.google.api.services.sheets.v.Sheets$Spreadsheets spreadsheets()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values values()>();
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Append append(java.lang.String,java.lang.String,com.google.api.services.sheets.v.model.ValueRange)>(v, v, v);
v = virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Append: com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Append setValueInputOption(java.lang.String)>("RAW");
virtualinvoke v.<com.google.api.services.sheets.v.Sheets$Spreadsheets$Values$Append: java.lang.Object execute()>();
return;
}
static void <clinit>()
{
org.slf4j.Logger v;
com.google.api.client.json.gson.GsonFactory v;
v = staticinvoke <org.slf4j.LoggerFactory: org.slf4j.Logger getLogger(java.lang.Class)>(class "Lorg/apache/drill/exec/store/googlesheets/utils/GoogleSheetsUtils;");
<org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: org.slf4j.Logger logger> = v;
v = staticinvoke <com.google.api.client.json.gson.GsonFactory: com.google.api.client.json.gson.GsonFactory getDefaultInstance()>();
<org.apache.drill.exec.store.googlesheets.utils.GoogleSheetsUtils: com.google.api.client.json.JsonFactory JSON_FACTORY> = v;
return;
}
}