    timing = Benchmark.measure { Post.all }
    
The various attributes of the object returned (Benchmark::Tms) are provided [here][1].

  [1]: https://ruby-doc.org/stdlib-2.0/libdoc/benchmark/rdoc/Benchmark/Tms.html

With [benchmark-ips][2] gem:

    2.3.0 :001 &gt; require &#39;benchmark/ips&#39;
    =&gt; true 
    2.3.0 :002 &gt; Benchmark.ips do |x|
    2.3.0 :003 &gt;       x.report(&quot;add: &quot;) { 1+2 }
    2.3.0 :004?&gt;       x.report(&quot;div: &quot;) { 1/2 }
    2.3.0 :005?&gt;       x.report(&quot;iis: &quot;) { 1/2.0 }
    2.3.0 :006?&gt;   end
    Warming up --------------------------------------
               add:    280.299k i/100ms
               div:    278.189k i/100ms
               iis:    266.526k i/100ms
    Calculating -------------------------------------
               add:      11.381M (&#177; 4.5%) i/s -     56.901M in   5.010669s
               div:       9.879M (&#177; 4.6%) i/s -     49.518M in   5.024084s
               iis:       9.289M (&#177; 4.2%) i/s -     46.376M in   5.001639s

  [2]: https://github.com/evanphx/benchmark-ips

Here is my version of how to measure performance automatically in rails console using gem: https://github.com/igorkasyanchuk/execution_time

It&#39;s showing similar information which you already see during requests.

Sample:

`[METRICS]  Completed in 908.3ms | Allocations: 2894 | ActiveRecord: 0.9ms (queries: 13)`

I want to compare a date from a database that is between 2 given dates.
The column from the database is DATETIME, and I want to compare it only to the date format, not the datetime format.

    SELECT * FROM `players` WHERE CONVERT(CHAR(10),us_reg_date,120) &gt;= &#39;2000-07-05&#39; AND CONVERT(CHAR(10),us_reg_date,120) &lt;= &#39;2011-11-10&#39;

I get this error when I execute the SQL above:

&gt; You have an error in your SQL syntax;
&gt; check the manual that corresponds to
&gt; your MySQL server version for the
&gt; right syntax to use near
&gt; &#39;us_reg_date,120) &gt;= &#39;2000-07-05&#39; AND
&gt; CONVERT(CHAR(10),us_reg_date,120) &lt;=
&gt; &#39;2011-&#39; at line 1

How can this problem be fixed?



Compare dates in MySQL

I&#39;m new to Clojure and have been using Compojure to write a basic web application.  I&#39;m hitting a wall with Compojure&#39;s `defroutes` syntax, though, and I think I need to understand both the &quot;how&quot; and the &quot;why&quot; behind it all.

It seems like a Ring-style application begins with an HTTP request map, then just passes the request through a series of middleware functions until it gets transformed into a response map, which gets sent back to the browser.  This style seems too &quot;low level&quot; for developers, thus the need for a tool like Compojure.  I can see this need for more abstractions in other software ecosystems as well, most notably with Python&#39;s WSGI.

The problem is that I don&#39;t understand Compojure&#39;s approach.  Let&#39;s take the following `defroutes` S-expression:

    (defroutes main-routes
      (GET &quot;/&quot;  [] (workbench))
      (POST &quot;/save&quot; {form-params :form-params} (str form-params))
      (GET &quot;/test&quot; [&amp; more] (str &quot;&lt;pre&gt;&quot; more &quot;&lt;/pre&gt;&quot;))
      (GET [&quot;/:filename&quot; :filename #&quot;.*&quot;] [filename]
        (response/file-response filename {:root &quot;./static&quot;}))
      (ANY &quot;*&quot;  [] &quot;&lt;h1&gt;Page not found.&lt;/h1&gt;&quot;))

I know that the key to understanding all of this lies within some macro voodoo, but I don&#39;t totally understand macros (yet).  I&#39;ve stared at the `defroutes` source for a long time, but just don&#39;t get it!  What&#39;s going on here?  Understanding the &quot;big idea&quot; will probably help me answer these specific questions:

1. How do I access the Ring environment from within a routed function (e.g. the `workbench` function)?  For example, say I wanted to access the HTTP_ACCEPT headers or some other part of the request/middleware?
2. What&#39;s the deal with the destructuring (`{form-params :form-params}`)?  What keywords are available for me when destructuring?

I really like Clojure but I am so stumped!

What&#39;s the &quot;big idea&quot; behind compojure routes?

I want compare time of execution `Post.all` and `SELECT * FROM posts` (or some other statements) How can i get execution time of `Post.all` ?

How to get execution time in rails console?

<p>I want compare time of execution <code>Post.all</code> and <code>SELECT * FROM posts</code> (or some other statements) How can i get execution time of <code>Post.all</code> ?</p>


I want something like

    DECLARE myVariable nvarchar[MAX] = &quot;hello world&quot;.

Bonus points if you show me how to encode a quote in the string.

E.g.:

I want the string to read

    John said to Emily &quot;Hey there Emily&quot;

my attempt would be

    DECLARE myVariable nvarchar[MAX] = &quot;John said to Emily \&quot;Hey there Emily\&quot;&quot;


How do I declare and assign a variable on a single line in SQL

I want to use order by with union in mysql query.
I am fetching different types of record based on different criteria from a table based on distance for a search on my site.
The first select query returns data related to the exact place search .
The 2nd select query returns data related to distance within 5 kms from the place searched.
The 3rd select query returns data related to distance within 5-15 kms from the place searched.

Then i m using union to merge all results and show on a page with paging. Under appropriate heading as **&#39;Exact search results&#39;**, **&#39;Results within 5 kms&#39;** etc

Now i want to sort results based on id or add_date. But when i add order by clause at the end of my query ( query1 union query 2 union query 3 order by add_date). It sorts all results. But what i want is it should sort under each heading.

Using union and order by clause in mysql

I am getting `NULL` values in the results of an operation in MySQL.   

Is there a way to convert the `NULL` values into the value 0?

Replace null with 0 in MySQL

I have a table with 2 columns, date and score. It has at most 30 entries, for each of the last 30 days one. 

    date      score
    -----------------
    1.8.2010  19
    2.8.2010  21
    4.8.2010  14
    7.8.2010  10
    10.8.2010 14

My problem is that some dates are missing - I want to see:

    date      score
    -----------------
    1.8.2010  19
    2.8.2010  21
    3.8.2010  0
    4.8.2010  14
    5.8.2010  0
    6.8.2010  0
    7.8.2010  10
    ...

What I need from the single query is to get: 19,21,9,14,0,0,10,0,0,14... That means that the missing dates are filled with 0.

I know how to get all the values and in server side language iterating through dates and missing the blanks. But is this possible to do in mysql, so that I sort the result by date and get the missing pieces.

EDIT: In this table there is another column named UserID, so I have 30.000 users and some of them have the score in this table. I delete the dates every day if date &lt; 30 days ago because I need last 30 days score for each user. The reason is I am making a graph of the user activity over the last 30 days and to plot a chart I need the 30 values separated by comma. So I can say in query get me the USERID=10203 activity and the query would get me the 30 scores, one for each of the last 30 days. I hope I am more clear now.

MySQL how to fill missing dates in range?

If I use something like

    [ntext2] &lt;&gt; &#39;1,032.5&#39;,

I get this error:

&gt; The data types ntext and varchar are incompatible in the not equal to operator.

The best possible solution would be if comparison is implemented in the same way for any column type. (&lt;&gt; operator is applicable for both NVARCHAR and INT).


What&#39;s the right way to compare an NTEXT column with a constant value?

I need to know the name of a programmers application from within a Rails 3 engine.

How do I access the name of the Rails 3 application object?

I have added a field to the sign-up form that is based on a different model, see [How do I use nested attributes with the devise model](https://stackoverflow.com/questions/3544265/how-do-i-use-nested-attributes-with-the-devise-model) for the gory details. This part is working fine.

The problem now is when I save, it is failing in the create action of the registrations controller that is supplied by devise with an `Activerecord::UnknownAttributeError` on this field (company).

I am assuming I need to override the registrations controller, or is there a better/easier way I should be approaching this?

Override devise registrations controller

When I render a partial which does not exists, I get an Exception. I&#39;d like to check if a partial exists before rendering it and in case it doesn&#39;t exist, I&#39;ll render something else. I did the following code in my .erb file, but I think there should be a better way to do this:

        &lt;% begin %&gt;
          &lt;%= render :partial =&gt; &quot;#{dynamic_partial}&quot; %&gt;
        &lt;% rescue ActionView::MissingTemplate %&gt;
          Can&#39;t show this data!
        &lt;% end %&gt;

Is there any Rails function to check if a partial exists?

I&#39;m using Rails&#39; accepts_nested_attributes_for method with great success, but how can I have it *not* create new records if a record already exists?

By way of example:

Say I&#39;ve got three models, Team, Membership, and Player, and each team has_many players through memberships, and players can belong to many teams.  The Team model might then accept nested attributes for players, but that means that each player submitted through the combined team+player(s) form will be created as a new player record.

How should I go about doing things if I want to only create a new player record this way if there isn&#39;t already a player with the same name?  If there *is* a player with the same name, no new player records should be created, but instead the correct player should be found and associated with the new team record.

accepts_nested_attributes_for with find_or_create?

I have a Rails 3 application using [Devise][1] for authentication. Now I need to allow someone to log in using their Facebook account. I think this is called Facebook Connect, but I&#39;ve also heard the term Facebook Graph API, so I&#39;m not sure which one I&#39;m asking for.

What do I need to do in order to integrate Facebook Connect with Devise?

## Solution:

This question is pretty old now. A year ago, Devise v1.2 introduced [OmniAuth][2] support. Now Devise is at v2.1 (as of this writing) and using OmniAuth is even easier. Here is a great tutorial from the Devise wiki on [using the `omniauth-facebook` gem with Devise to allow sign-in using Facebook][3].

Also check out this great tutorial on [registering your application and working with the Facebook Graph API][4].


  [1]: http://github.com/plataformatec/devise
  [2]: https://github.com/intridea/omniauth
  [3]: https://github.com/plataformatec/devise/wiki/OmniAuth:-Overview
  [4]: http://devcenter.heroku.com/articles/facebook

Rails 3 using Devise: How to allow someone to log in using their Facebook account?

1. My output is in the format of 290.52262423327 seconds. How can i change this to 00:04:51?

2. The same output i want to show in seconds and in HH:MM:SS format, so if it is seconds, i want to show only 290.52 seconds.(only two integers after decimal point)? how can i do this?

I am working in php and the output is present in `$time` variable. want to change this `$time` into `$newtime` with HH:MM:SS and `$newsec` as 290.52.

Thanks :)

Output is in seconds. convert to hh:mm:ss format in php

Given today&#39;s time e.g. 2:24PM, how do I get it to round to 2:30PM?

Similarly if the time was 2:17PM, how do I get it to round to 2:15PM?

How to round time to the nearest quarter hour in java?

I want to find out for how long (approximately) some block of code executes. Something like this:

    startStopwatch();
    // do some calculations
    stopStopwatch();
    printf(&quot;%lf&quot;, timeMesuredInSeconds);

How?

 

How do I measure time in C?

With the Time module in python is it possible to measure elapsed time? If so, how do I do that? 

I need to do this so that if the cursor has been in a widget for a certain duration an event happens.  

Measuring elapsed time with the Time module

`time()` is in seconds - is there one in milliseconds?

How to get current time in milliseconds in PHP?

I googled around for information on how to hide one’s own console window. Amazingly, the only solutions I could find were hacky solutions that involved `FindWindow()` to find the console window *by its title*. I dug a bit deeper into the Windows API and found that there is a much better and easier way, so I wanted to post it here for others to find.

**How do you hide (and show) the console window associated with my own C# console application?**


Show/Hide the console window of a C# console application

&gt; **Possible Duplicate:**  
&gt; [How to search through all commits in the repository?](https://stackoverflow.com/questions/746684/how-to-search-through-all-commits-in-the-repository)  

&lt;!-- End of automatically inserted text --&gt;

Is there a way to search through commit headers using the command line?

How to search in commit messages using command line?

In node.js you can use `console.log` or `sys.puts` to print out to the screen.

What is the preferred method and what is the difference between these?

Difference between console.log and sys.puts in node.js?

I would like to see test results ( system.out/err, log messages from components being tested ) _as they run_ in the same console I run:

    gradle test

And not wait until tests are done to look at the test reports ( that are only generated when tests are completed, so I can&#39;t &quot;tail -f&quot; anything while tests are running )

Gradle: How to Display Test Results in the Console in Real Time?

I was trying to create a simple console application to try out Qt&#39;s XML parser. I started a project in VS2008 and got this template:

    int main(int argc, char *argv[])
    {
        QCoreApplication a(argc, argv);

        return a.exec();
    }

Since I don&#39;t need event processing, I was wondering whether I may get into trouble if I neglect to create a QCoreApplication and running the event loop. The docs state that it&#39;s recommended in most cases.

For the sake of curiosity however, I am wondering how could I make some generic task execute on the event loop and then terminate the application. I was unable to google a relevant example.

Content Type	Original Author	Original Content on Stackoverflow
Question	Bohdan	View Question on Stackoverflow
Solution 1 - Sql	Shadwell	View Answer on Stackoverflow
Solution 2 - Sql	Bohdan	View Answer on Stackoverflow
Solution 3 - Sql	Igor Kasyanchuk	View Answer on Stackoverflow

How to get execution time in rails console?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

What's the "big idea" behind compojure routes?

Compare dates in MySQL

Attributions