Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I solved this exact issue for my app Push Actions - <a href="http://www.pushactions.com" rel="nofollow">http://www.pushactions.com</a>. For my solution, I did end up using GAE, but only to authenticate the token. The actual Push Actions app is hosted on Heroku. Here's my flow:</p> <ol> <li>Android app generates GAE token then posts the token &amp; the account's email address to Push Actions running on Heroku</li> <li>Push Actions posts the token to my service running on GAE</li> <li>The GAE service takes the token, determines if it is valid, and returns the email address it is valid for</li> <li>Push Actions compares the email address returned by GAE with the email address from the android app, if they match, the token is valid for that email address. This means the token can be safely associated with the google user's openid email address.</li> </ol> <p>As far as I know, this is the ONLY way to verify if a token generated by AccountManager is valid. True, it does require the use of GAE, but only for one small piece of your overall app. My GAE service ended up being like 1 class and a few lines of code, so it isn't much. You can think of the GAE piece as a service provided by google for authenticating tokens.</p> <p>Here is the code for my GAE service:</p> <pre><code>package com.pushactions; import java.io.IOException; import java.util.logging.Logger; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.google.appengine.api.users.User; import com.google.appengine.api.users.UserService; import com.google.appengine.api.users.UserServiceFactory; @SuppressWarnings("serial") public class PushActionsAuthServlet extends HttpServlet { private static final Logger log = Logger.getLogger(HttpServlet.class.getName()); public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException { UserService userService = UserServiceFactory.getUserService(); User user = userService.getCurrentUser(); if (user != null) { req.setAttribute("user", user); try { req.getRequestDispatcher("/logged_in.jsp").forward(req, resp); } catch (ServletException e) { log.severe("Couldn't redirect to logged_in.jsp"); } } else { try { req.getRequestDispatcher("/logged_out.jsp").forward(req, resp); } catch (ServletException e) { log.severe("Couldn't redirect to logged_out.jsp"); } } } } </code></pre> <p>logged_in.jsp:</p> <pre><code>&lt;%@ page import="com.google.appengine.api.users.User" %&gt; &lt;% User user = (User)request.getAttribute("user"); %&gt; &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;result&gt; &lt;status&gt;ok&lt;/status&gt; &lt;user_name&gt;&lt;%= user.getEmail() %&gt;&lt;/user_name&gt; &lt;/result&gt; </code></pre> <p>logged_out.jsp:</p> <pre><code>&lt;%@ page import="com.google.appengine.api.users.User" %&gt; &lt;% User user = (User)request.getAttribute("user"); %&gt; &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;result&gt; &lt;status&gt;error&lt;/status&gt; &lt;message&gt;not logged in&lt;/message&gt; &lt;/result&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to make AccountManager (authtoken) and OpenID work together (without AppEngine)?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgotosleep
    1. USgotosleep
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI'm telling you guys, this is the answer :) Imagine if google provided a service that authenticated tokens. All you had to do was post the token generated by Android to the service and Google would respond with whether or not the token was valid. Does that sound suitable? Well that is exactly what my answer provides.
      singulars
      1. PO
      1. USgotosleep
    2. COawesome that looks like just what i need. can you tell me how you pass the token and email to GAE (to your PushActionsAuthServlet). i can't tell from your code. thanks so much!
      singulars
      1. PO
      1. USdweebo
    3. COHey dweebo, I just do an http get to "https://MYAPP.appspot.com/_ah/login?auth=GAE_TOKEN&continue=https://MYAPP.appspot.com" http post might work as well, haven't tested
      singulars
      1. PO
      1. USgotosleep
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload