Extracting SQL statements from the rails development log

[Gurdipe Dosanjh]

Hi 

I need to extract all the sql statements from the the rails development log.

Is there a quick way to do this using a regular expression or another method?

Kind Regards

Gurdipe

[Robert Walker]

Gurdipe Dosanjh wrote in post #1065210:

> I need to extract all the sql statements from the the rails development
> log.
>
> Is there a quick way to do this using a regular expression or another
> method?

This makes it sound unlikely:

http://stackoverflow.com/questions/139926/regular-expression-to-match-common-sql-syntax

BTW, is your Google broken? This is was the second link in my Google.

--
Posted via http://www.ruby-forum.com/.

[Matt Jones]

On Tuesday, 19 June 2012 15:46:12 UTC-4, Gurdipe Dosanjh wrote:

Hi 

I need to extract all the sql statements from the the rails development log.

Is there a quick way to do this using a regular expression or another method?

If you're looking to grab all the queries, check out the Notification system:

http://asciicasts.com/episodes/249-notifications-in-rails-3

the 'sql.active_record' notification will be fired every time there's a query.

--Matt Jones