Skip to content

Instantly share code, notes, and snippets.

View NP-komplett's full-sized avatar

Niklas Paulsson NP-komplett

  • Kentor
View GitHub Profile
hemnet=> select objekt_id,deleted_at from gamlaobjekts order by deleted_at desc limit 10;
objekt_id | deleted_at
-----------+--------------------
3165056 | 15-FEB-12 01:00:12
3225335 | 15-FEB-12 01:00:12
3182157 | 15-FEB-12 01:00:12
3232035 | 15-FEB-12 01:00:12
3250619 | 15-FEB-12 01:00:12
3210356 | 15-FEB-12 01:00:12
3197475 | 15-FEB-12 01:00:12
msg = {}
msg[:download] = {}
msg[:download][:from] = logo_write_path
msg[:download][:to] = "#{APP_CONFIG[:inspiration_logos_url]}/#{res[:logo_filename]}"
msg[:download][:version] = version.to_i
Rails.logger.info "Sending msg = " + msg.inspect
if DELETING or (UPDATING and :NEW.AKTIV<>1) then
delete from sokobjekts where MAKLARFIRMA_id = :OLD.ID;
delete from kommersiellasokobjekts where MAKLARFIRMA_id = :OLD.ID;
elsif UPDATING and :NEW.AKTIV_KOMMERSIELLA<>1 then
delete from kommersiellasokobjekts where MAKLARFIRMA_id = :OLD.ID;
elsif UPDATING and :NEW.AKTIV_HEMNET<>1 then
delete from sokobjekts where MAKLARFIRMA_id = :OLD.ID;
end if;
-- Trigger: maklarfirmas_upd_sokobjekts on hn_dev.maklarfirmas
-- DROP TRIGGER maklarfirmas_upd_sokobjekts ON hn_dev.maklarfirmas;
CREATE OR REPLACE TRIGGER maklarfirmas_upd_sokobjekts
BEFORE UPDATE OR DELETE
ON hn_dev.maklarfirmas
FOR EACH ROW
BEGIN
if UPDATING then
{
:download=> {
:from => "scp://rbenv@htest01.hn.local/files/rubyapp/bcms/uploads/2012/02/20/a610af1704d6d5b92fd10b346e3a1ec6fe4981cc",
:to=>"/cms/2012/02/20/a610af1704d6d5b92fd10b346e3a1ec6fe4981cc",
:version=>1
},
:alias => {
:source=>"/cms/2012/02/20/a610af1704d6d5b92fd10b346e3a1ec6fe4981cc",
:destination=>"/cms/Bellagio1.jpg",
:version=>1
polygon,58.9834527242788,17.3801638277901,58.9837281960803,17.3811418396048,58.985236422166,17.3848638785344,58.9858936455485,17.3861986847216,58.9853861761528,17.3887849675579,58.9843236216015,17.393433246421,58.9844778101244,17.3969717651728,58.98264571541,17.3984529854142,58.9827307322215,17.4024926274875,58.9832677074876,17.4077361381035,58.983436935113,17.4107534471014,58.9836020765028,17.4133704962815,58.9834842207757,17.4178009454154,58.982427905248,17.4211437469602,58.9821051055941,17.425425260768,58.9820772926024,17.4276505320954,58.9817917419786,17.428941753191,58.9810020076704,17.4332011333797,58.9811551102568,17.4367394699633,58.9816996708149,17.4419836683196,58.9825471477035,17.4438503181732,58.9840766586312,17.445749431038,58.9858101837306,17.4471364993249,58.9875469964724,17.4482628912229,58.9891509413341,17.4492438821961,58.9906879349067,17.449838995644,58.9922453623245,17.449530316413,58.9954292576364,17.447715425249,58.9932660143306,17.4540161098843,58.9911716824301,17.4647388936484,58.98990
--DROP FUNCTION hn_dev.as_apegroup(geometry);
CREATE OR REPLACE FUNCTION hn_dev.as_apegroup(the_geom hn_dev.geometry)
RETURNS text AS
$BODY$
DECLARE
retval text;
as_text text;
coords text array[2];
su git -c ". /usr/local/rvm/scripts/rvm ; rvm use 1.8.7-p302@bygga_nytt ; export RAILS_ENV=acceptance_test ; passenger start -d -p 8288 --max-pool-size 20 --min-instances 2 --spawn-method conservative --user git --log-file /files/rubyapp/passenger_logfiles/bygganytt_passenger.log --pid-file /files/rubyapp/passenger_logfiles/bygganytt_passenger.pid /files/rubyapp/bygganytt_8288"
+ def force_utf8_cookie(cookie)
+ traverse = lambda do |object, block|
+ if object.kind_of?(Hash)
+ object.each_value { |o| traverse.call(o, block) }
+ elsif object.kind_of?(Array)
+ object.each { |o| traverse.call(o, block) }
+ else
+ block.call(object)
+ end
+ object
ActionView::TemplateError (undefined method `strftime' for "05-MAR-12 00:00:00":String) on line #12 of /files/rubyapp/hemnet/shared/bundle/ruby/1.9.1/gems/bcms_news-hemnet-1.0.1.22/app/view
s/news_articles/index.rss.builder:
9: xml.item do
10: xml.title(article.name)
11: xml.description(article.summary) unless article.summary.blank?
12: xml.pubDate(article.release_date.strftime("%a, %d %b %Y %H:%M:%S %z")) unless article.release_date.blank?
13: xml.link(news_article_url(article.route_params))
14: xml.guid(news_article_url(article.route_params))
15: end