com.google.appinventor.components.runtime

Class FusiontablesControl

java.lang.Object

com.google.appinventor.components.runtime.AndroidNonvisibleComponent

com.google.appinventor.components.runtime.FusiontablesControl

All Implemented Interfaces:

Component

public class FusiontablesControl
extends AndroidNonvisibleComponent
implements Component

Appinventor fusiontables control. This version has been migrated from the Fusiontables SQL API to the Fusiontables V1.0 API. See https://developers.google.com/fusiontables/ See https://developers.google.com/fusiontables/ The main change occurs in the way API requests are authorized. This version uses OAuth 2.0 and makes use of OAuth2Helper. The helper uses the Google AccountManager to acquire an access token that must be attached as the OAuth header in all Fusiontable Http requests. Before a Fusiontable request can be made, the app must acquire an OAuth token. This may involve the user logging in to their Gmail account (or not if they are already logged in) and then being prompted to give the app permission to access the user's fusion tables. Permission takes the form of an access token (called authToken), which must be transmitted to the Fusiontables service as part of all Http requests.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	APP_NAME
static java.lang.String	AUTH_TOKEN_TYPE_FUSIONTABLES
static java.lang.String	AUTHORIZATION_HEADER_PREFIX
static java.lang.String	FUSIONTABLES_POST
static java.lang.String	FUSIONTABLES_URL

Fields inherited from class com.google.appinventor.components.runtime.AndroidNonvisibleComponent

form

Fields inherited from interface com.google.appinventor.components.runtime.Component

ACCELEROMETER_SENSITIVITY_MODERATE, ACCELEROMETER_SENSITIVITY_STRONG, ACCELEROMETER_SENSITIVITY_WEAK, ALIGNMENT_CENTER, ALIGNMENT_NORMAL, ALIGNMENT_OPPOSITE, ASSET_DIRECTORY, BUTTON_SHAPE_DEFAULT, BUTTON_SHAPE_OVAL, BUTTON_SHAPE_RECT, BUTTON_SHAPE_ROUNDED, COLOR_BLACK, COLOR_BLUE, COLOR_CYAN, COLOR_DEFAULT, COLOR_DKGRAY, COLOR_GRAY, COLOR_GREEN, COLOR_LTGRAY, COLOR_MAGENTA, COLOR_NONE, COLOR_ORANGE, COLOR_PINK, COLOR_RED, COLOR_WHITE, COLOR_YELLOW, DEFAULT_VALUE_COLOR_BLACK, DEFAULT_VALUE_COLOR_BLUE, DEFAULT_VALUE_COLOR_CYAN, DEFAULT_VALUE_COLOR_DEFAULT, DEFAULT_VALUE_COLOR_DKGRAY, DEFAULT_VALUE_COLOR_GRAY, DEFAULT_VALUE_COLOR_GREEN, DEFAULT_VALUE_COLOR_LTGRAY, DEFAULT_VALUE_COLOR_MAGENTA, DEFAULT_VALUE_COLOR_NONE, DEFAULT_VALUE_COLOR_ORANGE, DEFAULT_VALUE_COLOR_PINK, DEFAULT_VALUE_COLOR_RED, DEFAULT_VALUE_COLOR_WHITE, DEFAULT_VALUE_COLOR_YELLOW, DIRECTION_EAST, DIRECTION_MAX, DIRECTION_MIN, DIRECTION_NONE, DIRECTION_NORTH, DIRECTION_NORTHEAST, DIRECTION_NORTHWEST, DIRECTION_SOUTH, DIRECTION_SOUTHEAST, DIRECTION_SOUTHWEST, DIRECTION_WEST, FONT_DEFAULT_SIZE, LAYOUT_ORIENTATION_HORIZONTAL, LAYOUT_ORIENTATION_VERTICAL, LENGTH_FILL_PARENT, LENGTH_PREFERRED, LENGTH_UNKNOWN, SLIDER_MAX_VALUE, SLIDER_MIN_VALUE, SLIDER_THUMB_VALUE, TOAST_LENGTH_LONG, TOAST_LENGTH_SHORT, TYPEFACE_DEFAULT, TYPEFACE_MONOSPACE, TYPEFACE_SANSSERIF, TYPEFACE_SERIF

Constructor Summary

Constructors

Constructor and Description
FusiontablesControl(ComponentContainer componentContainer)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	ApiKey() Getter for the API key.
void	ApiKey(java.lang.String apiKey) Setter for the app developer's API key.
void	DoQuery()
void	ForgetLogin()
void	GetRows(java.lang.String tableId, java.lang.String columns)
void	GetRowsWithConditions(java.lang.String tableId, java.lang.String columns, java.lang.String conditions)
void	GotResult(java.lang.String result)
void	handleOAuthError(java.lang.String msg) Callback used for error reporting.
static java.lang.String	httpApacheResponseToString(org.apache.http.HttpResponse response) Handles Apache Http Response.
static java.lang.String	httpResponseToString(com.google.api.client.http.HttpResponse response) Static utility method to prettify the HttpResponse.
void	InsertRow(java.lang.String tableId, java.lang.String columns, java.lang.String values)
java.lang.String	KeyFile()
void	KeyFile(java.lang.String path)
static java.lang.String	parseResponse(java.io.InputStream input) Parses the input stream returned from Http query
java.lang.String	Query()
void	Query(java.lang.String query)
void	SendQuery() Calls QueryProcessor to execute the API request asynchronously, if the user has already authenticated with the Fusiontables service.
com.google.api.client.http.HttpResponse	sendQuery(java.lang.String query, java.lang.String authToken) Executes a Fusiontable query with an OAuth 2.0 authenticated request.
java.lang.String	ServiceAccountEmail() Property for the service account email to use when using service authentication.
void	ServiceAccountEmail(java.lang.String email)
boolean	UseServiceAuthentication() Property to determine whether to use service authentication or user authentication.
void	UseServiceAuthentication(boolean bool)

Methods inherited from class com.google.appinventor.components.runtime.AndroidNonvisibleComponent

getDispatchDelegate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.google.appinventor.components.runtime.Component

getDispatchDelegate

Field Detail

FUSIONTABLES_POST

public static final java.lang.String FUSIONTABLES_POST

See Also:

Constant Field Values

AUTHORIZATION_HEADER_PREFIX

public static final java.lang.String AUTHORIZATION_HEADER_PREFIX

See Also:

Constant Field Values

FUSIONTABLES_URL

public static final java.lang.String FUSIONTABLES_URL

See Also:

Constant Field Values

AUTH_TOKEN_TYPE_FUSIONTABLES

public static final java.lang.String AUTH_TOKEN_TYPE_FUSIONTABLES

See Also:

Constant Field Values

APP_NAME

public static final java.lang.String APP_NAME

See Also:

Constant Field Values

Constructor Detail

FusiontablesControl

public FusiontablesControl(ComponentContainer componentContainer)

Method Detail

UseServiceAuthentication

public boolean UseServiceAuthentication()

Property to determine whether to use service authentication or user authentication. When this is checked, service authentication is used.

UseServiceAuthentication

public void UseServiceAuthentication(boolean bool)

ServiceAccountEmail

public java.lang.String ServiceAccountEmail()

Property for the service account email to use when using service authentication.

ServiceAccountEmail

public void ServiceAccountEmail(java.lang.String email)

ApiKey

public void ApiKey(java.lang.String apiKey)

Setter for the app developer's API key.

ApiKey

public java.lang.String ApiKey()

Getter for the API key.

Returns:

apiKey the apiKey

Query

public void Query(java.lang.String query)

Query

public java.lang.String Query()

KeyFile

public void KeyFile(java.lang.String path)

KeyFile

public java.lang.String KeyFile()

SendQuery

public void SendQuery()

Calls QueryProcessor to execute the API request asynchronously, if the user has already authenticated with the Fusiontables service.

DoQuery

public void DoQuery()

GotResult

public void GotResult(java.lang.String result)

ForgetLogin

public void ForgetLogin()

InsertRow

public void InsertRow(java.lang.String tableId,
             java.lang.String columns,
             java.lang.String values)

GetRows

public void GetRows(java.lang.String tableId,
           java.lang.String columns)

GetRowsWithConditions

public void GetRowsWithConditions(java.lang.String tableId,
                         java.lang.String columns,
                         java.lang.String conditions)

sendQuery

public com.google.api.client.http.HttpResponse sendQuery(java.lang.String query,
                                                java.lang.String authToken)

Executes a Fusiontable query with an OAuth 2.0 authenticated request. Requests are authenticated by attaching an Authentication header to the Http request. The header takes the form 'Authentication Oauth '. Requests take the form of SQL strings, using an Sql object from the Google API Client library. Apparently the Sql object handles the decision of whether the request should be a GET or a POST. Queries such as 'show tables' and 'select' are supposed to be GETs and queries such as 'insert' are supposed to be POSTS. See https://developers.google.com/fusiontables/docs/v1/using

Parameters:

query - the raw SQL string used by App Inventor

authToken - the OAuth 2.0 access token

Returns:

the HttpResponse if the request succeeded, or null

httpResponseToString

public static java.lang.String httpResponseToString(com.google.api.client.http.HttpResponse response)

Static utility method to prettify the HttpResponse. This version uses Google API HttpResponse object, which is different than Apache's

Parameters:

response -

Returns:

resultString

httpApacheResponseToString

public static java.lang.String httpApacheResponseToString(org.apache.http.HttpResponse response)

Handles Apache Http Response. Uses Apache's HttpResponse object, which is different from Google's.

Parameters:

response -

Returns:

The result string

parseResponse

public static java.lang.String parseResponse(java.io.InputStream input)

Parses the input stream returned from Http query

Parameters:

input -

Returns:

The Result String

handleOAuthError

public void handleOAuthError(java.lang.String msg)

Callback used for error reporting.

Parameters:

msg -