Lumen | How to use Transactions with multiple connections

lumen-transactions-multiple-connections.md

        $cn = DB::connection('pgsql-private');
        $cn->beginTransaction();

        try {
            $create = $this->create([
                'fk_user_id' => $user_id,
            ]);

            if (! $create) {
                throw new \Exception('PaymentProof does not recorded');
            }

            $sync1 = $create->attachments()->sync(array_column($attachments, 'id'));
            if (! $sync1) {
                throw new \Exception('Attachment does not recorded');
            }

            $sync2 = $paymentProof->balances()->sync(array_column($balances, 'id'));
            if (! $sync2) {
                throw new \Exception('Balance does not recorded');
            }

            $cn->commit();

            return [
                'message' => 'Success',
                'error' => false,
            ];
        } catch (\Exception $e) {
            $cn->rollBack();

            return [
                'message' => 'Caught exception:'.$e->getMessage(),
                'error' => true,
            ];
        }

https://laracasts.com/discuss/channels/eloquent/transaction-rollback-not-working