ryanermita

# Running raw SQL in Ruby on Rails
sql = "SELECT * FROM table_name"
result = ActiveRecord::Base.connection.execute(sql)

ryanermita

Very useful when you need to update database transaction locking timeout dyanamically.

SET SESSION innodb_lock_wait_timeout = 1; will set the innodb_lock_wait_timeout

SELECT @@innodb_lock_wait_timeout; will output the updated innodb_lock_wait_timeout

ryanermita

%Q

• Alternative way in ruby to enclose strings in double quotes.

• Useful when you have more quote characters in a string.You can use this instead of putting backslashes in front of them.

• Can use in escaping HTML and multiline SQL statements.

Usage

ryanermita

dict_object = {"firstname": "John", "lastname": "Doe"}
type(dict_object)  # dict

# cache dict_object as redis hash
app.redis_connection.hmset("your_unique_key", dict_object)

# fetch cached data (hash) from redis 
cached_data = app.redis_connection.hgetall("your_unique_key")
type(cached_data)  # dict

ryanermita

dict_object = {
	"name": "John Doe",
	"social_media_accounts": ["facebook", "twitter", "Instagram"],
	"language_proficiency": {
		"Python": "9/10", 
		"Javascript": "7/10",
		"Ruby": "8/10"
	}
}

ryanermita

dict_object = {
	"name": "John Doe",
	"social_media_accounts": ["facebook", "twitter", "Instagram"],
	"language_proficiency": {
		"Python": "9/10", 
		"Javascript": "7/10",
		"Ruby": "8/10"
	}
}

ryanermita

    __lt__: NotImplemented
    __gt__: NotImplemented
    __le__: NotImplemented
    __ge__: NotImplemented
    __int__: 1
    __contains__: False
    __len__: 0
    __iter__: iter([])
    __exit__: False
    __complex__: 1j

ryanermita

import unittest
from unittest.mock import patch


class MyDummyClass:

    def __init__(self):
        self.my_dummy_attribute = "yey!"

    def test_dummy_function(self):

ryanermita

import unittest
from unittest.mock import patch


class MyDummyClass:

    def test_dummy_function(self):
        return "hello"

ryanermita

import pika
import time

connection = pika.BlockingConnection(pika.ConnectionParameters('localhost'))
channel = connection.channel()

channel.exchange_declare(exchange='direct_exchange', exchange_type='direct')
channel.queue_declare(queue='direct_queue', durable=True)
channel.queue_bind(exchange='direct_exchange', queue="direct_queue", routing_key="direct.routing.key")