Hash and multiline items

[Yannick Turgeon]

Hello,

I'm a newbie and I wanted to get a hash with items having multilines string.
Something like this (air coded) :

SQL = {
"Company" => <<-END_SQL
SELECT Name
FROM Company
WHERE Active = 1
END_SQL
,
"Employee" => <<-END_SQL
SELECT Name, Title
FROM Employee
WHERE Active = 1
END_SQL
}

But it doesn't work. I get an error. I suppose I have to use the "\" line
continuation? I prefer this synthaxe though.

Is there a way to use the "labeled" multiline way in a hash? Any other style
suggestion?

Yannick

 

[Charles Steinman]

Hello,

I'm a newbie and I wanted to get a hash with items having multilines string.
Something like this (air coded) :

SQL = {
"Company" => <<-END_SQL
SELECT Name
FROM Company
WHERE Active = 1
END_SQL
,
"Employee" => <<-END_SQL
SELECT Name, Title
FROM Employee
WHERE Active = 1
END_SQL
}

But it doesn't work. I get an error. I suppose I have to use the "\" line
continuation? I prefer this synthaxe though.

Is there a way to use the "labeled" multiline way in a hash? Any other style
suggestion?

It looks like heredoc statements don't play well with Hashes. How does
this strike your fancy?

SQL = {
"Company" => %q{
SELECT Name
FROM Company
WHERE Active = 1
},

"Employee" => %q{
SELECT Name, Title
FROM Employee
WHERE Active = 1
}
}

 

[James Edward Gray II]

Hello,

I'm a newbie and I wanted to get a hash with items having
multilines string.
Something like this (air coded) :

SQL = {
"Company" => <<-END_SQL
SELECT Name
FROM Company
WHERE Active = 1
END_SQL
,
"Employee" => <<-END_SQL
SELECT Name, Title
FROM Employee
WHERE Active = 1
END_SQL
}

You just need to move the commas, they go after the heredoc
declaration, not after the end of the heredoc.

SQL = {
"Company" => <<-END_SQL,
SELECT Name
FROM Company
WHERE Active = 1
END_SQL
"Employee" => <<-END_SQL,
SELECT Name, Title
FROM Employee
WHERE Active = 1
END_SQL
}

You can even add calls to gsub() if you want to strip the leading
whitespace:

SQL = {
"Company" => <<-END_SQL.gsub(/^\s+/, "").tr("\n", " "),
SELECT Name
FROM Company
WHERE Active = 1
END_SQL
"Employee" => <<-END_SQL.gsub(/^\s+/, "").tr("\n", " "),
SELECT Name, Title
FROM Employee
WHERE Active = 1
END_SQL
}

Hope that helps.

James Edward Gray II

 

[Yannick Turgeon]

Pretty nice! ) I actually used %Q because I had a couple of #{} in my
queries to include today's date. I didn't know %q and %Q. Thanks for you
help.

Yannick

 

[Yannick Turgeon]

Thanks for those informations, especially to strip the leading spaces and
ending nl. In this case it's not necessary but I'll try it anyway. ;o) This
comma after the initial heredoc label is not intuitive at all!

Yannick