Skip to content

Instantly share code, notes, and snippets.

@jpzwarte
Created December 8, 2010 13:01
Show Gist options
  • Save jpzwarte/733254 to your computer and use it in GitHub Desktop.
Save jpzwarte/733254 to your computer and use it in GitHub Desktop.
ruby-1.9.2-p0 > s = Site.first
EXECUTE (0.6ms) USE [mpp_admin_dev]
Site Load (0.4ms) SELECT TOP (1) [sites].* FROM [sites]
=> #<Site id: 1, domain_id: nil, content_id: nil, name: "realtime", course_name: nil, ga_code: nil, webshop_url: nil, created_at: "2010-12-08 12:12:41", updated_at: "2010-12-08 12:38:08", published_at: nil, deleted_at: nil>
ruby-1.9.2-p0 > s.name = 'realtime2'
=> "realtime2"
ruby-1.9.2-p0 > s.save
EXECUTE (0.5ms) BEGIN TRANSACTION
EXECUTE (1.0ms) UPDATE [sites] SET [name] = N'realtime2', [updated_at] = '2010-12-08 12:57:50.514' WHERE ([sites].[id] = 1)
{"content_id"=>nil, "course_name"=>nil, "created_at"=>2010-12-08 12:12:41 UTC, "domain_id"=>nil, "ga_code"=>nil, "name"=>"realtime2", "updated_at"=>2010-12-08 12:57:50 UTC, "webshop_url"=>nil}
Connecting to the staging database
EXECUTE (0.5ms) USE [mpp_admin_staging]
EXECUTE (0.7ms) BEGIN TRANSACTION
EXECUTE (1.9ms) INSERT INTO [sites] ([content_id], [course_name], [created_at], [domain_id], [ga_code], [name], [updated_at], [webshop_url]) VALUES (NULL, NULL, '2010-12-08 12:12:41.370', NULL, NULL, N'realtime2', '2010-12-08 12:57:50.514', NULL)
EXECUTE (0.5ms) COMMIT TRANSACTION
Updated/created record in staging database
EXECUTE (0.3ms) USE [mpp_admin_dev]
Switched back to development database; updating published_at column
EXECUTE (3.3ms) UPDATE [sites] SET [published_at] = '2010-12-08 12:57:50.592' WHERE ([sites].[id] = 1)
Done!
=> true
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment