Digital-Old-School-Journey digital-old-school-journey
digital-old-school-journey
/ docker-compose.yml
Created
July 13, 2019 06:58
This file contains hidden or 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
| version: '3' | |
| services: | |
| elasticsearch: | |
| image: docker.elastic.co/elasticsearch/elasticsearch:7.0.0 | |
| container_name: elasticsearch | |
| ports: | |
| - "9200:9200" | |
| - "9300:9300" | |
| volumes: | |
| - ./es/config/elasticsearch.yml:/usr/share/elasticsearch/config/elasticsearch.yml:ro |
digital-old-school-journey
/ .gitlab-ci.yml
Created
April 12, 2019 15:18
This file contains hidden or 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
| before_script: | |
| - apt-get update -qq && apt-get install -y -qq sshpass | |
| deploy_production: | |
| stage: deploy | |
| only: | |
| - master | |
| script: | |
| - ls | |
| - sshpass -V |
digital-old-school-journey
/ restore.sql
Created
February 17, 2019 07:11
SQL Command to RESTORE AdventureWorks2012 ON Linux container
This file contains hidden or 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
| RESTORE DATABASE AdventureWorks2012 | |
| FROM DISK= '/var/opt/mssql/AdventureWorks2012.bak' | |
| WITH MOVE 'AdventureWorks2012' TO '/var/opt/mssql/data/AdventureWorks2012.mdf', | |
| MOVE 'AdventureWorks2012_Log' TO '/var/opt/mssql/data/AdventureWorks2012.ldf' |
digital-old-school-journey
/ docker-compose.yml
Created
February 17, 2019 06:16
Docker compose file for Microsoft SQL Server for linux
This file contains hidden or 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
| version: '3' | |
| services: | |
| mssql: | |
| image: mcr.microsoft.com/mssql/server:2017-latest-ubuntu | |
| container_name: "mssql" | |
| networks: | |
| - local-network | |
| ports: | |
| - "1433:1433" | |
| restart: always |
digital-old-school-journey
/ vrsteel.sql
Last active
January 24, 2019 09:07
This file contains hidden or 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 | |
| t1.`id`, | |
| t1.`uid`, | |
| t1.`proticketid`, | |
| t1.`subject`, | |
| t1.`created`, | |
| t1.`lastreply`, | |
| t1.`status`, | |
| t1.`ticketnoti`, | |
| t1.`topic` |
digital-old-school-journey
/ avg.sql
Last active
January 23, 2019 08:20
This file contains hidden or 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 AVG(CASE WHEN num = 0 THEN NULL ELSE num END) | |
| FROM( | |
| SELECT 2.0 as num | |
| UNION ALL | |
| SELECT 0 | |
| UNION ALL | |
| SELECT NULL | |
| UNION ALL | |
| SELECT 1 | |
| ) AS t |
digital-old-school-journey
/ png.php
Created
January 6, 2019 14:38
This file contains hidden or 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
| <?php | |
| require_once("vendor/autoload.php"); | |
| $op = $_REQUEST['op']; | |
| if ($op == "create") { | |
| png(); | |
| } else if($op == "download") { | |
| word(); |
digital-old-school-journey
/ graph.php
Created
January 6, 2019 14:36
This file contains hidden or 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
| <html> | |
| <head> | |
| <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> | |
| <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> | |
| <script type="text/javascript"> | |
| google.charts.load('current', {'packages':['corechart']}); | |
| google.charts.setOnLoadCallback(drawChart); | |
| function drawChart() { |
digital-old-school-journey
/ mongodb-template-06-query-02.js
Last active
November 5, 2018 16:12
Mongodb-Query-Template6-Rev02
This file contains hidden or 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
| db.search_logs.aggregate([ | |
| { | |
| $match: { 'keyword': 'Super car' } | |
| }, | |
| { | |
| "$group": { | |
| "_id": { | |
| 'keyword': '$keyword', | |
| 'username': '$username', | |
| 'created': { $dateToString: { format: "%Y-%m-%d", date: "$created_at" } } |
digital-old-school-journey
/ mongodb-template-06-query.js
Last active
November 4, 2018 00:33
MongoDB - Query
This file contains hidden or 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
| db.search_logs.aggregate( | |
| [ | |
| { | |
| $group : { | |
| _id : { | |
| keyword: "$keyword" | |
| , created: { $dateToString: { format: "%Y-%m-%d", date: "$created_at" } } | |
| } | |
| , users: { | |
| $push: { |