Ricardo Augusto ricardoaugusto

## mysqlworkbench.sh
ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysql /usr/local/bin/mysql
ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump /usr/local/bin/mysqldump

## html_scrapper.py
from urllib.request import urlopen

link = 'https://example.net'

f = urlopen(link)
output = f.read()
print(output)

## belongsToMany.php
class Current extends Model
{
    public function final()
    {
        $this->belongsToMany(
            'pivot_model',
            'pivot_table',
            'current_id',
            'final_ID'
        );

## restore_migration.php
public function down()
{
    (new AnotherMigration)->up();
}

## docker-mysqldump.sh
# To run the MySQL container:
docker-compose exec [container] bash

# Export
# Inside the container:
mysqldump -u [username] -p [database] | gzip -c > [filename].sql.gz
exit

# Local Terminal:
docker cp [container]:/[filename].sql.gz [filename].sql.gz

## mysqldump-10rows.sql
mysqldump --opt --where="1 limit 10" [DATABASE] > dump.sql

## gist:74c3f841a3c263593cecc5c063a89ebb
git branch -m old_branch new_branch         # Rename branch locally
git push origin :old_branch                 # Delete the old branch
git push --set-upstream origin new_branch   # Push the new branch, set local branch to track the new remote

## trait-with-anonymous-class.php
<?php

trait TraitA {
  public function show() {
    return 123;
  }
}

trait TraitB {
  public function show() {

## table-sizes.sql
SELECT
  TABLE_NAME AS `Table`,
  ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024),2) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "database_name"
#AND
#  TABLE_NAME = "table_name"
ORDER BY

## row-count.sql
SELECT TABLE_NAME,SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database_name'
GROUP BY TABLE_NAME;
	ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysql /usr/local/bin/mysql
	ln -s /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump /usr/local/bin/mysqldump
	from urllib.request import urlopen

	link = 'https://example.net'

	f = urlopen(link)
	output = f.read()
	print(output)
	class Current extends Model
	{
	public function final()
	{
	$this->belongsToMany(
	'pivot_model',
	'pivot_table',
	'current_id',
	'final_ID'
	);
	# To run the MySQL container:
	docker-compose exec [container] bash

	# Export
	# Inside the container:
	mysqldump -u [username] -p [database] \| gzip -c > [filename].sql.gz
	exit

	# Local Terminal:
	docker cp [container]:/[filename].sql.gz [filename].sql.gz
	git branch -m old_branch new_branch # Rename branch locally
	git push origin :old_branch # Delete the old branch
	git push --set-upstream origin new_branch # Push the new branch, set local branch to track the new remote
	<?php

	trait TraitA {
	public function show() {
	return 123;
	}
	}

	trait TraitB {
	public function show() {
	SELECT
	TABLE_NAME AS `Table`,
	ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024),2) AS `Size (MB)`
	FROM
	information_schema.TABLES
	WHERE
	TABLE_SCHEMA = "database_name"
	#AND
	# TABLE_NAME = "table_name"
	ORDER BY
	SELECT TABLE_NAME,SUM(TABLE_ROWS)
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_SCHEMA = 'database_name'
	GROUP BY TABLE_NAME;