Roman Lehnert romanlehnert
romanlehnert
/ gist:8546582
Created
January 21, 2014 19:28
sql query for posts with multiple comment conditions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT "posts".* FROM "posts" | |
| WHERE | |
| "posts"."id" IN | |
| (SELECT post_id FROM "posts" | |
| INNER JOIN "comments" ON "comments"."post_id" = "posts"."id" | |
| WHERE "comments"."title" = 'foo') | |
| AND | |
| "posts"."id" IN | |
| (SELECT post_id FROM "posts" | |
| INNER JOIN "comments" ON "comments"."post_id" = "posts"."id" |
romanlehnert
/ truncate_rails_tables.rb
Created
September 17, 2013 15:54
Truncate all tables in rails
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ActiveRecord::Base.establish_connection | |
| ActiveRecord::Base.connection.tables.each do |table| | |
| next if table == 'schema_migrations' | |
| case ActiveRecord::Base.connection.adapter_name.downcase.to_sym | |
| when :mysql2 || :postgresql | |
| ActiveRecord::Base.connection.execute("TRUNCATE #{table}") | |
| when :sqlite | |
| ActiveRecord::Base.connection.execute("DELETE FROM #{table}") | |
| end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def current_job_speed(time = 5) | |
| start_time = Time.now | |
| start_count = Delayed::Job.count | |
| sleep time | |
| end_time = Time.now | |
| end_count = Delayed::Job.count | |
| t = end_time - start_time |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| c.save_design_doc('{ "_id": "_design/admin", "language": "javascript", "views": { "all": { "map": "function(doc){emit(doc);}" } } }') | |
| docs = Hash[c.design_docs['admin'].all(:include_docs => true).map{ |doc| doc.data }.collect{ |doc| [doc["doc"]["meta"]["id"], doc["doc"]["value"]] }] |
romanlehnert
/ gist:4529821
Last active
December 11, 2015 02:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp b/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| index e666ff7..8abcc48 100644 | |
| --- a/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| +++ b/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| @@ -100,7 +100,7 @@ int SocketStreamHandlePrivate::send(const char* data, int len) | |
| if (!m_socket || m_socket->state() != QAbstractSocket::ConnectedState) | |
| return 0; | |
| quint64 sentSize = m_socket->write(data, len); | |
| - QMetaObject::invokeMethod(this, "socketSentData", Qt::QueuedConnection); | |
| + QMetaObject::invokeMethod(this, "socketSentdata", Qt::QueuedConnection); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp b/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| index e666ff7..8abcc48 100644 | |
| --- a/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| +++ b/src/3rdparty/webkit/WebCore/platform/network/qt/SocketStreamHandleQt.cpp | |
| @@ -100,7 +100,7 @@ int SocketStreamHandlePrivate::send(const char* data, int len) | |
| if (!m_socket || m_socket->state() != QAbstractSocket::ConnectedState) | |
| return 0; | |
| quint64 sentSize = m_socket->write(data, len); | |
| - QMetaObject::invokeMethod(this, "socketSentData", Qt::QueuedConnection); | |
| + QMetaObject::invokeMethod(this, "socketSentdata", Qt::QueuedConnection); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "((void 0),(function (counter, val) {var topic = val.topic;topic.unread = topic_unread_counter(topic.uuid);scope.unread = topic.unread + scope.unread;save_topic_in_dom(topic);}))@http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js:29 (1,[object Object])@http://gobas.sharenotes.de/javascripts/run_v3.js:238 ([object Array],(function (i, scope) {scope.unread = 0;$.each(scope.subscriptions, function (counter, val) {var topic = val.topic;topic.unread = topic_unread_counter(topic.uuid);scope.unread = topic.unread + scope.unread;save_topic_in_dom(topic);});}))@http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js:30 scopes_for_template([object Array])@http://gobas.sharenotes.de/javascripts/run_v3.js:236 ([object Array],"success",[object XMLHttpRequest])@http://gobas.sharenotes.de/javascripts/app_v6.js:78 b()@http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js:124 ()@http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js:129 ([object Object])@http://ajax.googleapis.com/ajax/ |
NewerOlder