rana01645

#https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-18-04


#install necessary libs
sudo apt update
sudo apt install python3-pip python3-dev libpq-dev nginx curl

#install mysql
sudo apt install mysql-server
sudo apt-get install libmysqlclient-dev

rana01645

composer dump-autoload
php artisan cache:clear
php artisan config:clear
php artisan view:clear

rana01645

sudo find /home/forge/default/user/ -mindepth 1 -type f -mtime +7 | xargs rm

rana01645

Remove all block comments and line comments:
(/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+/|[ \t]*//.*)

Remove block comments:
(/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+/)

Remove line comments:
([ \t]*//.*)

rana01645

# checkout to old_named branch
git checkout <old_name>

# create new named branch
git branch -m <new_name>

# push new named branch to remote
git push origin -u <new_name>

# delete old named branch

rana01645

DB_HOST=1.2.3.4
DB_PORT=3306
DB_DATABASE=db_name
DB_PASSWORD='password'
DB_USERNAME=username
pv -f db.sql | mysql -f -h ${DB_HOST} --port=${DB_PORT} -u${DB_USERNAME} -p${DB_PASSWORD} ${DB_DATABASE}

rana01645

#!/usr/bin/env python3

import subprocess
import json
import os
from pathlib import Path

import requests
from requests.compat import urljoin

rana01645

use Illuminate\Support\Collection;
function csvToArray($filename = '', $delimiter = ',')
{
    if (!file_exists($filename) || !is_readable($filename))
        return false;

    $header = null;
    $data = array();
    if (($handle = fopen($filename, 'r')) !== false)
    {

rana01645

sudo mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
service mysql restart

rana01645

$action = AutomationAction::where('type','upload')->whereNull('started_at')->whereHasMorph(                                                                                                                        'performer',['App\Video'],                                                                                                                                                                                         function ( $query) {                                                                                                                                                                                                   $query->whereNotNull('uploaded_at');                                                                                                                                                                           })->update(['status'=>'success','started_at'=>now(),'finished_at'=>now()]);