marcelodeandrade

$query = Model::findAll();
echo $query->createCommand()->sql;
echo $query->createCommand()->getRawSql();

marcelodeandrade

# Backup
docker exec -i DOCKER_CONTAINER_ID /usr/bin/mysql --user=root --password=root -h 127.0.0.1 DATABASE > backup.sql

# Restore
docker exec -i DOCKER_CONTAINER_ID /usr/bin/mysql --user=root --password=root -h 127.0.0.1 < backup.sql
docker exec -i $(docker ps -qf "name=superlogica-mysql") /usr/bin/mysql --user=root --password=root -h 127.0.0.1 < backup.sql

marcelodeandrade

public function typeValue(value)
        select case TypeName(value)
            case "Byte":            typeValue = cBool(value)
            case "Integer":         typeValue = cInt(value)
            case "Long":            typeValue = cLng(value)
            case "Single":          typeValue = cDbl(value)
            case "Double":          typeValue = cDbl(value)
            case "Currency":        typeValue = cDbl(value)
            case "Decimal":         typeValue = cDbl(value)
            case "Date":            typeValue = cDate(value)

marcelodeandrade

<%

class teste

    private abc
    private def

    private sub class_initialize
    end sub

marcelodeandrade

<?php

header('Content-Type: application/json');

header('HTTP/1.1 401 Unauthorized');

$data = [
    'status' => 401,
    'message' => '401 Unauthorized'
];

marcelodeandrade

SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%search%'

marcelodeandrade

# Credits to @marcelmfs in https://github.com/moby/moby/issues/23371#issuecomment-224927009

# Containers
docker rm -f $(docker ps -a -q)

# Images
docker rmi -f $(docker images -a -q)

# Volumes
docker volume rm $(docker volume ls -q)

marcelodeandrade

DELETE FROM database.dbo.table
DBCC CHECKIDENT ('database.dbo.table', RESEED, 0)

marcelodeandrade

Generate a GitHub Personal Access Token for Private Composer Packages

If you're trying to load a private repository with Composer/Laravel, we'll need to generate a GitHub Personal Access Token (similar to OAuth token) to access the repository during a composer install without entering credentials.

If you have used other Github packages from {my-org} before, you may be able to skip this step.

1. Visit https://github.com/settings/tokens.

2. Click Generate new token.

marcelodeandrade

# see https://git-scm.com/docs/git-config#git-config-pushdefault
git config --global push.default current