DelayedJob stores a database record for each enqueued job so you can retrieve them directly through the rails console (assuming you are using ActiveRecord or similar).

Open the rails console:

    $ rails c

and then query the enqueued jobs:

    $ Delayed::Job.all

or

    $ Delayed::Job.last

Check out the [documentation][1].


  [1]: https://github.com/collectiveidea/delayed_job#gory-details

If you installed delayed_job with another database like Redis you may want to go and check in there the queued jobs.

You should see jobs in the delayed_jobs table, yes. But when delayed jobs are run successfully they&#39;re deleted. So it may just be a fleeting thing. (Delayed Job checks the table for new jobs to run every 5 seconds, so the record may only last a few seconds on average given a short-running job.) I usually make sure the delayed job daemon is turned off if I want to inspect the payload objects in the delayed_jobs table.

Is there a way for me to subset data based on column names starting with a particular string? I have some columns which are like `ABC_1 ABC_2 ABC_3` and some like `XYZ_1, XYZ_2,XYZ_3` let&#39;s say.

How can I subset my `df` based only on columns containing the above portions of text (lets say, `ABC` or `XYZ`)? I can use indices, but the columns are too scattered in data and it becomes too much of hard coding.

Also, I want to only include rows from each of these columns where any of their value is `&gt;0` so if either of the `6` columns above has a `1` in the row, it makes a cut into my final data frame.

Subset data to contain only columns whose names match a condition

I have this legacy code :
  
     private void conecta()
     {  
         if (conexao.State == ConnectionState.Closed)
             conexao.Open();
     }

     public List&lt;string[]&gt; get_dados_historico_verificacao_email_WEB(string email)
     {
         List&lt;string[]&gt; historicos = new List&lt;string[]&gt;();
         conecta();
        
         sql = 
             @&quot;SELECT * 
             FROM historico_verificacao_email 
             WHERE nm_email = &#39;&quot; + email + @&quot;&#39; 
             ORDER BY dt_verificacao_email DESC, hr_verificacao_email DESC&quot;;
 
         com = new SqlCommand(sql, conexao);
         SqlDataReader dr = com.ExecuteReader();
         
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 string[] dados_historico = new string[6];
                 dados_historico[0] = dr[&quot;nm_email&quot;].ToString();
                 dados_historico[1] = dr[&quot;dt_verificacao_email&quot;].ToString();
                 dados_historico[1] = dados_historico[1].Substring(0, 10);
                 dados_historico[2] = dr[&quot;hr_verificacao_email&quot;].ToString();
                 dados_historico[3] = dr[&quot;ds_tipo_verificacao&quot;].ToString();

                 sql = 
                     @&quot;SELECT COUNT(e.cd_historico_verificacao_email) QT 
                     FROM emails_lidos e 
                     WHERE e.cd_historico_verificacao_email = 
                         &#39;&quot; + dr[&quot;cd_historico_verificacao_email&quot;].ToString() + &quot;&#39;&quot;;
                 
                 tipo_sql = &quot;sele&#231;&#227;o&quot;;
                 conecta();
                 com2 = new SqlCommand(sql, conexao);

                 SqlDataReader dr3 = com2.ExecuteReader();
                 while (dr3.Read())
                 {
                     //quantidade de emails lidos naquela verifica&#231;&#227;o
                     dados_historico[4] = dr3[&quot;QT&quot;].ToString(); 
                 }
                 dr3.Close();
                 conexao.Close();
                 
                 //login
                 dados_historico[5] = dr[&quot;cd_login_usuario&quot;].ToString();
                 historicos.Add(dados_historico);
             }
             dr.Close();
         }
         else
         { 
             dr.Close();
         }
         
         conexao.Close();
         return historicos;
     }

&lt;br/&gt;
I have created two separates commands to correct the issue, but it still continues: &quot;There is already an open DataReader associated with this Command which must be closed first&quot;.

An additional info: the same code is working in another app.

Error &quot;There is already an open DataReader associated with this Command which must be closed first&quot; when using 2 distinct commands

I wonder if I succeeded to get [Delayed::Job](https://github.com/collectiveidea/delayed_job) working.
Can&#39;t see jobs in the `delayed_jobs` table.

- Is that normal?
- Is there any other ways too see job queue?

How can I see the delayed job queue?

<p>I wonder if I succeeded to get <a href="https://github.com/collectiveidea/delayed_job" target="_blank" rel="noopener noreferrer">Delayed::Job</a> working.
Can't see jobs in the <code>delayed_jobs</code> table.</p>
<ul>
<li>Is that normal?</li>
<li>Is there any other ways too see job queue?</li>
</ul>


I&#39;m building a simple api with [Rails API][1], and want to make sure I&#39;m on the right track here. I&#39;m using devise to handle logins, and decided to go with Devise&#39;s `token_authenticatable` option, which generates an API key that you need to send with each request.

I&#39;m pairing the API with a backbone/marionette front end and am generally wondering how I should handle sessions. My first thought was to just store the api key in local storage or a cookie, and retrieve it on page load, but something about storing the api key that way bothered me from a security standpoint. Wouldn&#39;t be be easy to grab the api key either by looking in local storage/the cookie or sniffing any request that goes through, and use it to impersonate that user indefinitely? I currently am resetting the api key each login, but even that seems frequent - any time you log in on any device, that means you&#39;d be logged out on every other one, which is kind of a pain. If I could drop this reset I feel like it would improve from a usability standpoint.

I may be totally wrong here (and hope I am), can anyone explain whether authenticating this way is reliably secure, and if not what a good alternative would be? Overall, I&#39;m looking for a way I can securely keep users &#39;signed in&#39; to API access without frequently forcing re-auth.


  [1]: https://github.com/rails-api/rails-api

Is devise&#39;s token_authenticatable secure?

I&#39;m getting the error:

    FATAL: Peer authentication failed for user &quot;postgres&quot;

when I try to make postgres work with Rails. 

Here&#39;s my [`pg_hba.conf`][1], my [`database.yml`][2], and a [dump of the full trace][3].

I changed authentication to md5 in pg_hba and tried different things, but none seem to work. 

I also tried creating a new user and database as per https://stackoverflow.com/questions/9987171/rails-3-2-fatal-peer-authentication-failed-for-user-pgerror

But they don&#39;t show up on pgadmin or even when I run `sudo -u postgres psql -l`.

Any idea where I&#39;m going wrong?


  [1]: http://pastebin.com/4V1sMS01
  [2]: http://pastebin.com/mS0G6Srp
  [3]: http://pastebin.com/bXg1Pkr5

Getting error: Peer authentication failed for user &quot;postgres&quot;, when trying to get pgsql working with rails

I&#39;m trying to put my app into production and image and css asset paths aren&#39;t working.

Here&#39;s what I&#39;m currently doing:

 - Image assets live in /app/assets/images/image.jpg 
 - Stylesheets live in /app/assets/stylesheets/style.css
 - In my layout, I reference the css file like this: `&lt;%= stylesheet_link_tag    &quot;styles&quot;, media: &quot;all&quot;, &quot;data-turbolinks-track&quot; =&gt; true %&gt;`
 - Before restarting unicorn, I run `RAILS_ENV=production bundle exec rake assets:precompile` and it succeeds and I see the fingerprinted files in the `public/assets` directory.

When I browse to my site, I get a 404 not found error for `mysite.com/stylesheets/styles.css`. 

What am I doing wrong?


**Update:**
In my layout, it looks like this:

	&lt;%= stylesheet_link_tag    &quot;bootstrap.min&quot;, media: &quot;all&quot;, &quot;data-turbolinks-track&quot; =&gt; true %&gt;
	&lt;%= stylesheet_link_tag    &quot;styles&quot;, media: &quot;all&quot;, &quot;data-turbolinks-track&quot; =&gt; true %&gt;
	&lt;%= javascript_include_tag &quot;application&quot;, &quot;data-turbolinks-track&quot; =&gt; true %&gt;

The generate source is this:

    &lt;link data-turbolinks-track=&quot;true&quot; href=&quot;/stylesheets/bootstrap.min.css&quot; media=&quot;all&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;link data-turbolinks-track=&quot;true&quot; href=&quot;/stylesheets/styles.css&quot; media=&quot;all&quot; rel=&quot;stylesheet&quot; /&gt;
    &lt;script data-turbolinks-track=&quot;true&quot; src=&quot;/assets/application-0c647c942c6eff10ad92f1f2b0c64efe.js&quot;&gt;&lt;/script&gt;

Looks like Rails is not properly looking for the compiled css files. But it&#39;s very confusing *why* it&#39;s working correctly for javascripts (notice the `/assets/****.js` path).

  [1]: http://edgeguides.rubyonrails.org/asset_pipeline.html


Rails 4: assets not loading in production

What is rake and how it is used in Ruby on Rails?

What is rake and how it is used in rails?

I have a class called `CachedObject` that stores generic serialized objects indexed by a key. I want this class to implement a `create_or_update` method. If an object is found it will update it, otherwise it will create a new one.

Is there a way to do this in Rails or do I have to write my own method?

Rails create or update magic?

trying to upgrade to Rails 4.2, using delayed_job_active_record. I&#39;ve not set the delayed_job backend for test environment as thought that way jobs would execute straight away. 

I&#39;m trying to test the new &#39;deliver_later&#39; method with RSpec, but I&#39;m not sure how.

Old controller code:

    ServiceMailer.delay.new_user(@user)

New controller code:

    ServiceMailer.new_user(@user).deliver_later

I USED to test it like so:

    expect(ServiceMailer).to receive(:new_user).with(@user).and_return(double(&quot;mailer&quot;, :deliver =&gt; true))

Now I get errors using that. (Double &quot;mailer&quot; received unexpected message :deliver_later with (no args))

Just

    expect(ServiceMailer).to receive(:new_user)

fails too with &#39;undefined method `deliver_later&#39; for nil:NilClass&#39;

I&#39;ve tried some examples that allow you to see if jobs are enqueued using test_helper in ActiveJob but I haven&#39;t managed to test that the correct job is queued.

    expect(enqueued_jobs.size).to eq(1)

This passes if the test_helper is included, but it doesn&#39;t allow me to check it is the correct email that is being sent.

What I want to do is:

 - test that the correct email is queued (or executed straight away in test env)
 - with the correct parameters (@user)

Any ideas??
thanks

Content Type	Original Author	Original Content on Stackoverflow
Question	knotito	View Question on Stackoverflow
Solution 1 - Ruby on-Rails	Nicolas Garnil	View Answer on Stackoverflow
Solution 2 - Ruby on-Rails	pdobb	View Answer on Stackoverflow

How can I see the delayed job queue?

Ruby on-Rails Problem Overview

Ruby on-Rails Solutions

Solution 1 - Ruby on-Rails

Solution 2 - Ruby on-Rails

Error "There is already an open DataReader associated with this Command which must be closed first" when using 2 distinct commands

Subset data to contain only columns whose names match a condition

Attributions