gcw07’s gists

lorisleiva / toSqlWithBindings.php

Last active November 12, 2024 12:14

A little macro to get the SQL from a query builder without the annoying "?".

	<?php

	use Illuminate\Database\Eloquent\Builder;

	Builder::macro('toSqlWithBindings', function () {
	$bindings = array_map(
	fn ($value) => is_numeric($value) ? $value : "'{$value}'",
	$this->getBindings()
	);

calebporzio / RouteDirectives.php

Created January 4, 2020 10:33

Blade Route Directives

	<?php

	// Register these inside a service provider:

	Blade::directive('route', function ($expression) {
	return "<?php echo route({$expression}) ?>";
	});

	Blade::directive('routeIs', function ($expression) {
	return "<?php if (request()->routeIs({$expression})) : ?>";

jasonmccreary / test-controllers.sh

Last active July 23, 2019 07:10

One-line shell script to generate HTTP Tests for your application's controllers.

	# Run `artisan make:test` for all Controllers under `your app/Http/Controllers` folder.
	# Created tests mirror their path under the `app` folder and are suffixed with "Test".

	find app/Http/Controllers -type f -name '*Controller.php' -exec sh -c 'php artisan make:test $(dirname "${1:4}")/$(basename "$1" .php)Test' sh {} \;

troatie / CreatesWithLock.php

Last active September 12, 2023 13:51

Guard against race conditions in Laravel's firstOrCreate and updateOrCreate

	trait CreatesWithLock
	{
	public static function updateOrCreate(array $attributes, array $values = [])
	{
	return static::advisoryLock(function () use ($attributes, $values) {
	// emulate the code found in Illuminate\Database\Eloquent\Builder
	return (new static)->newQuery()->updateOrCreate($attributes, $values);
	});
	}

jarektkaczyk / laravel-multiformat-response.php

Last active June 24, 2018 07:42

laravel multiformat response

	<?php

	Response::macro('multiFormat', function ($data, $html = '') {
	if (request('format') == 'json') {
	return $this->json($data);
	}

	if (request('format') == 'xml') {
	if (!is_array($data) && !$data instanceof Arrayable) { /* 400 Bad Request*/ }

adamwathan / 1-add-macros.php

Last active June 11, 2022 19:55

Multiformat Endpoints in Laravel

	<?php

	namespace App\Providers;

	use Illuminate\Http\Request;
	use Illuminate\Routing\Route;
	use Illuminate\Support\ServiceProvider;
	use App\Http\Middleware\CaptureRequestExtension;

	class AppServiceProvider extends ServiceProvider

calebporzio / PreviewOfUpcomingPackage.php

Last active December 2, 2024 12:10

A model trait that allows child models to use parent table names and relationship keys.

	<?php

	namespace App\Abilities;

	use Illuminate\Support\Str;
	use ReflectionClass;

	/**
	* Note: This is a preview of an upcoming package from Tighten.
	**/

adamwathan / promise-take-at-least.js

Last active February 26, 2023 14:25

Promise.takeAtLeast

	// Creates a new promise that automatically resolves after some timeout:
	Promise.delay = function (time) {
	return new Promise((resolve, reject) => {
	setTimeout(resolve, time)
	})
	}

	// Throttle this promise to resolve no faster than the specified time:
	Promise.prototype.takeAtLeast = function (time) {
	return new Promise((resolve, reject) => {

nickdenardis / deploy.php

Last active February 13, 2024 16:39

Zero downtime local build Laravel 5 deploys with Deployer

	<?php
	namespace Deployer;

	require 'recipe/laravel.php';
	require 'vendor/deployer/recipes/local.php';
	require 'vendor/deployer/recipes/rsync.php';
	require 'vendor/deployer/recipes/npm.php';

	// Configuration
	set('ssh_type', 'native');

tbreuss / dnsbl.php

Last active October 30, 2024 12:26

IP Blacklist Check Script - This is a simple PHP script to lookup for blacklisted IP against multiple DNSBLs at once.

	<?php // Simple PHP script to lookup for blacklisted IP against multiple DNSBLs at once. ?>
	<html>
	<head>
	<title>DNSBL Lookup Tool - IP Blacklist Check Script</title>
	</head>
	<body>
	<h2>IP Blacklist Check Script</h2>
	<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
	<input type="text" value="" name="ip"/>
	<input type="submit" value="LOOKUP"/>

Grant Williams gcw07