Add spaces to the negated character group:

    @search_query = @search_query.gsub(/[^0-9a-z ]/i, &#39;&#39;)

In this case I would use the bang method (gsub! instead of gsub) in order to clean the input permanently. 

    #permanently filter all non-alphanumeric characters, except _
    @search_query.gsub!(/\W/,&#39;&#39;)

This avoids a situation where @seach_query is used elsewhere in the code without cleaning it.

I would have used the inclusion approach. Rather than exclude all but numbers, I would only included numbers. E.g.

    @search_query.scan(/[\da-z\s]/i).join

Maybe this will work for such case:

    # do not replace any word characters and spaces
    @search_query = @search_query.gsub(/[^\w ]/g, &#39;&#39;)

A better answer (at least in ruby) is:

    @search_query.gsub!(/^(\w|\s*)/,&#39;&#39;)



I am trying to do a mysql dump of a few rows in my database. I can then use the dump to upload those few rows into another database. The code I have is working, but it dumps everything. How can I get mysqldump to only dump certain rows of a table?

Here is my code:

&lt;pre&gt;&lt;code&gt;
mysqldump --opt --user=username --password=password lmhprogram myResumes  --where=date_pulled=&#39;2011-05-23&#39; &gt; test.sql

&lt;/code&gt;&lt;/pre&gt;



MYSQL Dump only certain rows

This is not a full/correct MySQL query only pseudo-code:
   

    Select *
     from Notifications as n
     where n.date &gt; (CurrentDate-10 days)
     limit by 1
     FOR UPDATE

http://dev.mysql.com/doc/refman/5.0/en/select.html states:
If you use FOR UPDATE with a storage engine that uses page or row locks, rows examined by the query are write-locked until the end of the current transaction

Is here only the one record returned locked by MySQL or all records it has to scan to find the single record?


When using MySQL&#39;s FOR UPDATE locking, what is exactly locked?

I want to create a regex that removes all non-alphanumber characters but keeps spaces. This is to clean search input before it hits the db. Here&#39;s what I have so far:

    @search_query = @search_query.gsub(/[^0-9a-z]/i, &#39;&#39;)

Problem here is it removes all the spaces. Solutions on how to retain spaces?

How do I strip non alphanumeric characters from a string and keep spaces?

I want to create a regex that removes all non-alphanumber characters but keeps spaces. This is to clean search input before it hits the db. Here's what I have so far:
<pre><code class="hljs language-less">@search_query = @search_query.gsub(/[^0-9a-z]/i, '')
</code></pre>
Problem here is it removes all the spaces. Solutions on how to retain spaces?

I have the following file:

    /spec/controllers/groups_controller_spec.rb

What command in terminal do I use to run just that spec and in what directory do I run the command?

My gem file:

    # Test ENVIRONMENT GEMS
    group :development, :test do
    	gem &quot;autotest&quot;
    	gem &quot;rspec-rails&quot;, &quot;~&gt; 2.4&quot;
    	gem &quot;cucumber-rails&quot;, &quot;&gt;=0.3.2&quot;
    	gem &quot;webrat&quot;, &quot;&gt;=0.7.2&quot;
    	gem &#39;factory_girl_rails&#39;
    	gem &#39;email_spec&#39;
    end

**Spec file:**

    require &#39;spec_helper&#39;
    
    describe GroupsController do
      include Devise::TestHelpers
    
      describe &quot;GET yourgroups&quot; do
        it &quot;should be successful and return 3 items&quot; do
          
          Rails.logger.info &#39;HAIL MARRY&#39;
          
          get :yourgroups, :format =&gt; :json
          response.should be_success
          body = JSON.parse(response.body)
          body.should have(3).items # @user1 has 3 permissions to 3 groups
        end
      end
    end

How to run a single RSpec test?

I&#39;ve been reading here and there about how cool the `respond_with` method is in Rails 3. But I can&#39;t even find a reference to it in either the Rails APIs or by searching the source. Can anyone either explain to me how it works (what options you can use, etc) or point me to the place it&#39;s actually implemented so I can peruse the code on my own?

Rails respond_with: how does it work?

In my `application.rb` I came across the following comment

    # Set Time.zone default to the specified zone and make Active Record auto-convert to this zone.
    # Run &quot;rake -D time&quot; for a list of tasks for finding time zone names. Default is UTC.
     config.time_zone = &#39;Eastern Time (US &amp; Canada)&#39;

As you see from above, I&#39;ve made `config.time_zone` to EST time.  However, still when records are created in the DB, it looks like `datetime` is being stored in UTC format.

In the above comment, they say 

&gt; ...and make Active Record auto-convert to this zone...

How can I do that, and where?

Also, I&#39;ll be deploying this on heroku as well and i&#39;d like the setting to carry over

How to change default timezone for Active Record in Rails?

At ShowNearby we have been doing a very big migration to RoR 3.1 from PHP and we are facing several problems that may be some of you have solved before. 

We have big amounts of data and we decided to segregate our DB into several DBs that we can handle separately. For example, our accounts, places, logs and others are split into several databases

We need to get migrations, fixtures, models, to play nicely, and so far it has been quite messy. Some of our requirements for a solution to be acceptable:

- one model should relate to one tables in one of the databases.
- rake db:drop - should drop all the database env we specify in database.yml
- rake db:create - should create all the database env we specify in database.yml
- rake db:migrate - should run migrations to the various databases
- rake db:test - should grab fixtures and drop them into the various databases and test unit/function/etc

We are considering setting separate rails projects per each database and connecting them with ActiveResource, but we feel this is not very efficient. Have any of you deal with a similar problem before?

Connecting Rails 3.1 with Multiple Databases

I&#39;m using the default JSON serialization for a model that has a number of decimal and integer attributes. An example result is:

    { &quot;user&quot;: { &quot;id&quot;: 1234, &quot;rating&quot;: &quot;98.7&quot; } }

Notice the addition of quotes around the value of &quot;rating&quot;. This causes the deserialization library I&#39;m using to incorrectly treat these as strings (instead of decimals). Can Rails be set to not use the quotes for all decimals?

**Edit:**

I&#39;m on Rails 3.0.7 and Ruby 1.9.2 if that makes a difference.

**Edit:**

Terminal:

    rails g model user rating:decimal
    rake db:migrate

Console:

    user = User.create(rating: 98.7)
    user.to_json


Rails JSON Serialization of Decimal adds Quotes


Otherwise, it needs to be

    h = {:a =&gt; 1, :b =&gt; 2.2}
    h.each_with_index do |pair, i|
      k = pair[0]; v = pair[1]
      p k, v, i
    end

and setting the `k` and `v` this way seems a bit clumsy.  Can it be simpler or something like

    h.each_with_index do |[k,v], i|
    
?

In Ruby, is there a way to use something like hash.each_with_index do |[k,v], i|?

I am starting out with Ruby on Rails. I am currently going through a tutorial where it says that I have to run a .rb file from IRB and that that will create a .xml file in my current directory.

My question is how do I run a .rb file  in IRB?  
And do I have to be in the directory where this .rb file lives when I run it in IRB?

I tried the following: just typing `irb` on the command line in the directory of the file. That starts an IRB session as far as I understand.  
Then I typed `irb &quot;filename.rb&quot;` which went through but didn&#39;t create anything in the current directory but at least it didn&#39;t give any errors.

I also tried a whole bunch of other stuff that plain gave me errors. So I don&#39;t think I can solve this myself and googling the matter didn&#39;t help at all.

I am running Leopard.

How to run a .rb file from IRB?

Example:
&quot;This is just\na simple sentence&quot;.

I want to match every character between &quot;This is&quot; and &quot;sentence&quot;. Line breaks should be ignored. I can&#39;t figure out the correct syntax.


Regex Match all characters between two strings

In Perl `\S` matches any non-whitespace character.

How can I match any non-whitespace character except a backslash `\`?


How to match any non white space character except a particular one?

I&#39;d like to know how to replace a capture group with its uppercase in JavaScript. Here&#39;s a simplified version of what I&#39;ve tried so far that&#39;s not working:

    &gt; a=&quot;foobar&quot;
    &#39;foobar&#39;
    &gt; a.replace( /(f)/, &quot;$1&quot;.toUpperCase() )
    &#39;foobar&#39;
    &gt; a.replace( /(f)/, String.prototype.toUpperCase.apply(&quot;$1&quot;) )
    &#39;foobar&#39;

Would you explain what&#39;s wrong with this code?

Replace a Regex capture group with uppercase in Javascript

I&#39;m trying to use the following regex in a `sed` script but it doesn&#39;t work:

    sed -n &#39;/$www\.$\?teste/p&#39;

The regex above doesn&#39;t seem to work. `sed` doesn&#39;t seem to apply the `?` to the grouped `www\.`.

It works if you use the `-E` parameter that switches `sed` to use the Extended Regex, so the syntax becomes:

    sed -En &#39;/(www\.)?teste/p&#39;

This works fine but I want to run this script on a machine that doesn&#39;t support the `-E` operator. I&#39;m  pretty sure that this is possible and I&#39;m doing something very stupid. 


Sed expression doesn&#39;t allow optional grouped string

I&#39;m having a tough time getting this to work. I have a string like:

    something/([0-9])/([a-z])

And I need regex or a method of getting each match between the parentheses and return an array of matches like:

    [
      [0-9],
      [a-z]
    ]

The regex I&#39;m using is `/$(.+)$/` which does seem to match the right thing **if** there is only **one** set of parenthesis.

How can I get an array like above using any RegExp method in JavaScript? I need to return just that array because the _returned_ items in the array will be looped through to create a URL routing scheme.

RegEx to match stuff between parentheses

I&#39;m building an application which I&#39;m also testing in Heroku. I ran into some problem today and had to rollback one commit in my local git repo, but Heroku now won&#39;t recognize my changes saying that &quot;everything is up to date&quot;.

So, running

    git push heroku master

heroku responds with 

    Everything up-to-date

which isn&#39;t true.

UPDATE: Things I&#39;ve tried

    git push -f heroku master
    git push --force heroku master
    git push heroku +master
    git push --force heroku +master

Did some changes in the source code and then

    git add.
    git commit -a -m &quot;Message&quot; #(Then this commit shows in my git explorer)
    git push heroku master #Everything up-to-date

How to reset Heroku app and re-commit everything?

Can someone help me understand the differences between a Rails Engine and a Mountable app?  In Rails 3.1, you can create either one with the &quot;rails new plugin _________&quot; command.

    rails plugin new forum --full        # Engine
    rails plugin new forum --mountable   # Mountable App

When would you want to use one versus the other?  I know you can package an Engine as a gem, for one.  Is that not the case for Mountable Apps?  What other differences are there?

Rails 3.1: Engine vs. Mountable App

I&#39;m using [rails_admin](https://github.com/sferik/rails_admin), and since it is in (very) active development, bugs turn up every now and then.

There are no versions for the gem as far as I can tell, for the gem in github, so I can&#39;t use the `:version` key for the gem declaration in the Gemfile .

Is there a way I can &quot;tie&quot; a specific commit(that I know is working fine for me) to the Gemfile ?

I currently have in my Gemfile:

    gem &#39;rails_admin&#39;, 
      :git =&gt; &#39;git://github.com/sferik/rails_admin.git&#39;

I&#39;d like to be able to do something like this (example &quot;commit_id&quot;):

    gem &#39;rails_admin&#39;, 
      :git =&gt; &#39;git://github.com/sferik/rails_admin.git&#39;,
      :commit_id =&gt; &quot;4e7d53e3c5c4c3c5c43c3&quot;

Is this possible to do with github?


Content Type	Original Author	Original Content on Stackoverflow
Question	TheExit	View Question on Stackoverflow
Solution 1 - Ruby on-Rails	jwueller	View Answer on Stackoverflow
Solution 2 - Ruby on-Rails	nvugteveen	View Answer on Stackoverflow
Solution 3 - Ruby on-Rails	Vadym Tyemirov	View Answer on Stackoverflow
Solution 4 - Ruby on-Rails	piton4eg	View Answer on Stackoverflow
Solution 5 - Ruby on-Rails	John Doe	View Answer on Stackoverflow

How do I strip non alphanumeric characters from a string and keep spaces?

Ruby on-Rails Problem Overview

Ruby on-Rails Solutions

Solution 1 - Ruby on-Rails

Solution 2 - Ruby on-Rails

Solution 3 - Ruby on-Rails

Solution 4 - Ruby on-Rails

Solution 5 - Ruby on-Rails

When using MySQL's FOR UPDATE locking, what is exactly locked?

MYSQL Dump only certain rows

Attributions