Simon Hamp simonhamp

This script is designed to help reset all sequences in a PostgreSQL database to their correct values based on existing data in the tables.

Purpose

In PostgreSQL, sequences are used to auto-increment integer columns in tables. These sequences need to have their "last value" accurately set to avoid conflicts when inserting new rows into the table. This can become an issue, for example, when data is imported into the database and the sequences are not updated accordingly, leading to unique constraint

How it Works

The script works by iterating over each table in the current schema of the PostgreSQL database. For each table, it dynamically looks up the associated sequence and the column that the sequence is used for. It then finds the maximum value in that column and sets the "last value" of the sequence to this maximum value.

	<?php

	class VersionMatcher
	{
	protected $specificity = 'major';
	protected $originals = [];
	protected $current;
	protected $target;

	protected static $padDigits;

	<?php

	namespace App\Providers;

	use Illuminate\Support\Str;

	class AppServiceProvider extends ServiceProvider
	{

	public function boot()

	<?php

	//Don't forget to change the namespace!
	namespace App\Traits;

	use Cron\CronExpression;
	use Illuminate\Support\Carbon;
	use Illuminate\Console\Scheduling\ManagesFrequencies;

	trait Schedulable{

	const echoPostRequest = {
	url: 'https://<my url>.auth0.com/oauth/token',
	method: 'POST',
	header: 'Content-Type:application/json',
	body: {
	mode: 'application/json',
	raw: JSON.stringify(
	{
	client_id:'<your client ID>',
	client_secret:'<your client secret>',

	#!/bin/bash

	PLATFORM=iPhoneOS # iPhoneSimulator # iPhoneOS
	HOST=arm-apple-darwin # i386-apple-darwin10 # arm-apple-darwin10
	ARCH=arm64 # i386 # armv7s #armv7
	SDK_VERSION=13.0

	XCODE_ROOT=`xcode-select -print-path`
	PLATFORM_PATH=$XCODE_ROOT/Platforms/$PLATFORM.platform/Developer
	SDK_PATH=$PLATFORM_PATH/SDKs/$PLATFORM$SDK_VERSION.sdk