Skip to content

Instantly share code, notes, and snippets.

View raphaeldealmeida's full-sized avatar

Raphael de Almeida raphaeldealmeida

109 followers · 124 following
View GitHub Profile
@raphaeldealmeida
raphaeldealmeida / MyComponent.tsx
Created July 15, 2023 13:00
Generic mithril js component snippet
import m from "mithril"
type TProps = {}
const MyComponent: m.ClosureComponent<TProps> = () => {
return {
view: () =>
{
return <>
@raphaeldealmeida
raphaeldealmeida / wp-install.sh
Created June 14, 2021 18:21
Step-by-step wp install using wp-cli
mkdir blog
cd blog
wp core download
wp config create --dbname=wordpress_plugin --dbuser=root --dbpass=root
wp db create
wp core install --url=example.com --title=Example --admin_user=supervisor --admin_password=password --admin_email=info@example.com
wp server --port=8001
@raphaeldealmeida
raphaeldealmeida / interactive_maps.html
Created April 26, 2021 15:49
This file has been truncated, but you can view the full file.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<style>
@raphaeldealmeida
raphaeldealmeida / previsao.sql
Created August 19, 2019 23:13
select avg(valor) previsao_valor from (
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
where (EMPRESA_ID = 1)
and (VALOR > 0)
and (DAY_WEEK = 1)
UNION
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
@raphaeldealmeida
raphaeldealmeida / previsao.sql
Created August 19, 2019 23:13
select avg(valor) previsao_valor from (
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
where (EMPRESA_ID = 1)
and (VALOR > 0)
and (DAY_WEEK = 1)
UNION
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
@raphaeldealmeida
raphaeldealmeida / testconn.php
Last active May 13, 2019 18:12
<?php
$host = "";
$db = 'onboard';
$user = 'inffel';
$pass = "";
$conn = new PDO("sqlsrv:server=$host,1433;Database=$db", $user, $pass);
$tsql = "select * from usuarios";
@raphaeldealmeida
raphaeldealmeida / docker_sqlsrv.sh
Last active April 3, 2019 23:31
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 --name sql1 -d -v /home/raphael/projects/freelas/OnBoard/Backup:/home/backup mcr.microsoft.com/mssql/server:2017-latest
sudo docker start sql1
sudo docker exec -it sql1 "bash"
## on container, it request pass
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE central FROM DISK = '/home/backup/Central.bak' WITH MOVE 'central' TO '/var/opt/mssql/data/central.mdf', MOVE 'central_log' TO '/var/opt/mssql/data/central.ldf'"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE onboard FROM DISK = '/home/backup/Onboard.bak' WITH MOVE 'onboard' TO '/var/opt/mssql/data/onboard.mdf', MOVE 'onboard_log' TO '/var/opt/mssql/data/onboard.ldf'"
@raphaeldealmeida
raphaeldealmeida / link_gravatar
Created March 11, 2019 22:35
link para gravatar
@raphaeldealmeida
raphaeldealmeida / pdf_merge.sh
Created March 11, 2019 17:26
pdf merge
gs -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/default -dNOPAUSE -dQUIET -dBATCH -dDetectDuplicateImages -dCompressFonts=true -r150 -sOutputFile=output.pdf input.pdf
@raphaeldealmeida
raphaeldealmeida / import.log
Created February 13, 2019 09:03
1 ls /home/backup/Onboard.bak
2 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATUS = 5"
3 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"
4 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
5 ls /home/backup/Onboard.bak
6 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [central] FROM DISK = N'/home/backup/Central.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5"
7 /opt/mssql-tools/bin/sqlcmd
8 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA
9 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE [onboard] FROM DISK = N'/home/backup/Onboard.bak' WITH FILE = 1, NOUNLOAD, REPLACE,