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
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
use blog; | |
-- Count posts id | |
SELECT COUNT(DISTINCT id) FROM posts; | |
-- => 7 | |
-- count posts id | |
SELECT COUNT(DISTINCT post_id) from comments; | |
-- => 3 |
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
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 |
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
# 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 |
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
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 |
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
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 | |
) |
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
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, |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
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
/** | |
* 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", |
NewerOlder