gabidavila

use blog;

-- Count posts id
SELECT COUNT(DISTINCT id) FROM posts;
-- => 7

-- count posts id
SELECT COUNT(DISTINCT post_id) from comments;
-- => 3

gabidavila

if settings.has_key?('services')
    settings['services'].each do |service|
        service['enabled'].each do |enable_service|
            config.vm.provision "shell", inline: "sudo systemctl enable #{enable_service}"
        end if service.include?('enabled')

        service['disabled'].each do |disable_service|
            config.vm.provision "shell", inline: "sudo systemctl disable #{disable_service}"
        end if service.include?('disabled')
    end

gabidavila

# Snippet
# Enable Services
if settings.has_key?('services')
  settings['services'].each do |service|
    if service.include?('enabled')
      enable = service['enabled']
      enable.each do |enable_service|
        config.vm.provision "shell", inline: "sudo systemctl enable #{enable_service}"
      end
    end

gabidavila

All about database

Because you know I am all about database
database, database, but no trigger (4x)

I am about database, base, base

Yeah it ain't clear
This font is size 2

gabidavila

FROM composer:latest as composer

COPY src /var/www/html
WORKDIR /var/www/html

ENV COMPOSER_ALLOW_SUPERUSER 1

RUN composer install && composer dump-autoload
RUN composer require google/cloud-language

gabidavila

Connection string for JDBC driver on DataGrip

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={project:param};OAuthType=0;OAuthServiceAcctEmail={email:param};OAuthPvtKeyPath={secret:param}

gabidavila

WITH RECURSIVE fizz_buzz (sequence, modulo_3, modulo_5) AS (
  SELECT 1, CAST('' AS CHAR(4)), CAST('' AS CHAR(5))
  UNION ALL
  SELECT sequence + 1,
         IF(MOD(sequence + 1, 3) = 0, 'Fizz', ''),
         IF(MOD(sequence + 1, 5) = 0, 'Buzz', '')
  FROM fizz_buzz
  WHERE sequence < 100
)

gabidavila

WITH RECURSIVE traversed (id, name, path, `left`, `right`) AS (
  SELECT id,
         name,
         CAST(JSON_ARRAY(id) AS JSON),
         `left`,
         `right`
  FROM binary_tree
  WHERE id = 1
  UNION
  SELECT b.id,

gabidavila

gabidavila

/**
 * Responds to any HTTP request that can provide a "message" field in the body.
 *
 * @param {!Object} req Cloud Function request context.
 * @param {!Object} res Cloud Function response context.
 */
const options = {
  host: "your ip address",
  port: 33060,
  password: "your password",