Objectify your SQL scripts. Take blocks of SQL from an .sql script and turn them into class methods on your models/classes.
include Threequel::Commandant
Run a series of co-dependant .sql scripts to perform tasks.
A Hash subclass that maps to Commandant SQL class methods. Keys are the SQL class method names and Values are SQL::Command objects.
A class that can execute a series of SQL blocks on a specified connection.
sql = <<-"SQL"
CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);
GO
DROP TABLE dbo.foo;
GO
SQL
connection = ActiveRecord::Base.connection
cmd = Threequel::SQL::Command.new(sql, "My Command")
cmd.execute_on connection
# SQL (23.6ms) CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);
# SQL (37.1ms) DROP TABLE dbo.foo;
# => {:message=>"Command executed successfully", :status=>:success}
# or
Threequel::SQL::Command.new(sql, "My Command") do |cmd|
cmd.execute_on connection
end
# SQL (23.6ms) CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);
# SQL (37.1ms) DROP TABLE dbo.foo;
# => {:message=>"Command executed successfully", :status=>:success} Adds logging to any instance method.
sql = <<-"SQL"
CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);
GO
DROP TABLE dbo.foo;
GO
SQL
connection = ActiveRecord::Base.connection
Threequel::SQL::Command.new(sql, "My Command") do |cmd|
cmd.extend Threequel::Logging
cmd.add_logging_to :execute_on, :console
cmd.execute_on connection
end
# -- Starting execution of My Command at 2012-07-25 17:13:43 -0400
# SQL (23.6ms) CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);
# SQL (37.1ms) DROP TABLE dbo.foo;
# -- Finishing execution of My Command at 2012-07-25 17:13:43 -0400 in 0.006583 seconds
# => [#<Threequel::ConsoleLogger:0x007ffc47f95240 @attributes={:sql=>"CREATE TABLE dbo.foo (bar varchar(20) NOT NULL);\nGO\n\nDROP TABLE dbo.foo;\nGO\n", :command=>"My Command", :statement=>nil, :name=>"My Command", :started_at=>2012-07-25 17:13:43 -0400, :finished_at=>2012-07-25 17:13:43 -0400, :duration=>0.006583, :stage=>:finished, :message=>"Command executed successfully", :status=>:success}>]Wrap code in a Timer.clock block and get timing information about your code block.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent