xirukitepe

EXPLAIN for: SELECT  `jobs`.* FROM `jobs` INNER JOIN `bids` ON `bids`.`job_id` = `jobs`.`id` INNER JOIN `suburbs` ON `suburbs`.`id` = `jobs`.`suburb_id` WHERE (jobs.status NOT IN ('drafted','rejected') AND (jobs.status = 'stopped' OR bidding_closes_on < DATE(CURRENT_TIMESTAMP + INTERVAL 10 HOUR))) AND (DATE(jobs.created_at) >= '2020-06-09') AND (suburbs.region IN ('Sydney','Melbourne','Brisbane')) GROUP BY bids.job_id HAVING (count(bids.job_id) >= 1) ORDER BY jobs.id desc

xirukitepe

curl -XGET http://localhost:9200/store_development_products/_search -d '
{
  "aggs": {
    "category_ids": {
      "terms": { 
        "field": "root_category_ids", 
        "size": 1000 
      },
      "aggs" : {
        "by_product_type": {

xirukitepe

Friendly URLs

By default, Rails applications build URLs based on the primary key -- the id column from the database. Imagine we have a Person model and associated controller. We have a person record for Bob Martin that has id number 6. The URL for his show page would be:

/people/6

But, for aesthetic or SEO purposes, we want Bob's name in the URL. The last segment, the 6 here, is called the "slug". Let's look at a few ways to implement better slugs.

xirukitepe

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')

xirukitepe

Prereq:

apt-get install zsh
apt-get install git-core

Getting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh

wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh

xirukitepe

Ensemblist::Application.configure do
  # Settings specified here will take precedence over those in config/application.rb

  # Code is not reloaded between requests
  config.cache_classes = true

  # Full error reports are disabled and caching is turned on
  config.consider_all_requests_local       = false
  config.action_controller.perform_caching = true

xirukitepe

<Directory "/Users/xiruki/Sites/">
  Options Indexes MultiViews
  AllowOverride None
  Order allow,deny
  Allow from all
</Directory>

xirukitepe

 config.action_mailer.default_url_options = { :host => 'localhost:3000' }

  config.action_mailer.delivery_method = :smtp

  config.action_mailer.smtp_settings = {
    address: "smtp.gmail.com",
    port: 587,
    domain: 'gmail.com',
    authentication: "plain",
    enable_starttls_auto: true,

xirukitepe

# MySQL.  Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
#   gem install mysql2
#
# And be sure to use new-style password hashing:
#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
  adapter: mysql2
  encoding: utf8

xirukitepe

Security is Hard

Massive Assignment

• watch for ActiveRecord Relation, like has_many, has_many :through
• watch for user_roles, `group_users
• UPDATE action

Admin