Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sorted! </p> <p>Added token and secret to the authentications table described in <a href="http://railscasts.com/episodes/236-omniauth-part-2">http://railscasts.com/episodes/236-omniauth-part-2</a> but changed the authentication.build line to take two more parameters:</p> <pre><code>authentications.build( :provider =&gt; omniauth['provider'], :uid =&gt; omniauth['uid'], :token =&gt; omniauth['credentials']['token'], :secret =&gt; omniauth['credentials']['secret'] ) </code></pre> <p>then used the code example from <a href="http://dev.twitter.com/pages/oauth_single_token#ruby">http://dev.twitter.com/pages/oauth_single_token#ruby</a></p> <pre><code>class CronController &lt; ApplicationController def recent_tweets # Exchange your oauth_token and oauth_token_secret for an AccessToken instance. def prepare_access_token(oauth_token, oauth_token_secret) consumer = OAuth::Consumer.new("APIKey", "APISecret" { :site =&gt; "http://api.twitter.com" }) # now create the access token object from passed values token_hash = { :oauth_token =&gt; oauth_token, :oauth_token_secret =&gt; oauth_token_secret } access_token = OAuth::AccessToken.from_hash(consumer, token_hash ) return access_token end auth = current_user.authentications.find(:first, :conditions =&gt; { :provider =&gt; 'twitter' }) # Exchange our oauth_token and oauth_token secret for the AccessToken instance. access_token = prepare_access_token(auth['token'], auth['secret']) # use the access token as an agent to get the home timeline response = access_token.request(:get, "http://api.twitter.com/1/statuses/home_timeline.json") render :json =&gt; response.body end end </code></pre> <p>By pulling the content from current_user.authentications (im finding the first as they should only have one) I can grab the token and security and its alllll good.</p> <p>Now I can tweak this, get stuff saved, faff with the JSON and take what I need. I'm sure Facebook will be pretty similar.</p>
    singulars
    1. This table or related slice is empty.
    1. POOmniAuth + Pulling Tweets, FB Places, etc
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USPhil Sturgeon
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POOmniAuth + Pulling Tweets, FB Places, etc
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    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. COSweet man! I know exactly what you mean after number 2 it's like now how do I get data. It was there the whole time and you just pointed me in the right direction +1!
      singulars
      1. PO
      1. USthenengah
 

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