Tag: metaprogramming

How can I use an SQL query’s result for the WHERE clause of another query?

Okay, basically I have a table that contains statements like: I would like to use the contents from this table to generate other tables that fulfill the conditions expressed in this one. So I would need to make it something like But the last part of the where has to come from the first table. Right now what I’m trying

Why am I able to call the class method as if it were an instance method here?

metaprogramming ruby sql

I was looking through this example: class SQLObject def self.columns return @columns if @columns columns = DBConnection.execute2(<<-SQL).first SELECT "#{table_name}".* ...