Felipe Bernardo bergfelipe

Full Stack web Developer

bergfelipe / gist:fa9cb9662fc49cb1ad7e63317a6e970e

Created November 24, 2025 21:18

docker reanitialize

bergfelipe / gist:7ab2eb6f47faf2e18af9e216361313e9

Last active January 15, 2025 04:15

sqls Wordpress

	## atualiza cash ##
	DELETE FROM wp_options WHERE option_name LIKE '_transient_%';

	UPDATE wp_term_taxonomy SET count = (
	SELECT COUNT(1)
	FROM wp_term_relationships
	WHERE wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
	);

	## acha categorias ##

bergfelipe / drop banco

Created October 11, 2023 12:58 — forked from lucasslemos/drop banco

dropfull.sql

	begin
	for deleta in (select table_name, 'DROP TABLE '\|\|table_name\|\|' cascade constraints' AS dropar from user_tables) loop
	BEGIN
	EXECUTE IMMEDIATE deleta.dropar;
	dbms_output.put_line('DROP TABLE '\|\|deleta.table_name\|\|' cascade constraints;');
	EXCEPTION WHEN OTHERS THEN
	dbms_output.put_line('Erro ao tentar dropar a tabela:'\|\|deleta.table_name);
	END;
	end loop;
	end;

bergfelipe / gist:486f1d1695e4a048eb6c7b5de87d7ff6

Created December 13, 2022 01:42

nokogiri

	#! /usr/bin/env ruby

	require 'nokogiri'
	require 'open-uri'

	# Fetch and parse HTML document
	doc = Nokogiri::HTML(URI.open('https://www.imdb.com/chart/top/?ref_=nv_mv_250'))


	table = doc.css('table.chart').css('tbody.lister-list')

bergfelipe / SWEET ALERT 2 IN RUBY ON RAILS 7

Last active October 24, 2022 14:39

USE SWEET ALERT 2 WITH A DESTROY AND UPDATE BUTTON IN RUBY ON RAILS 7

	INPORT

	import Swal from "sweetalert2"
	import * as sweetalert2 from "sweetalert2"

	IN BUTTON

	<%= button_to "Destroy this post", @post, method: :delete, form_class: 'delete-post' %>

	IN JS

bergfelipe / consultas.rb

Created October 13, 2022 13:50 — forked from lucasslemos/consultas.rb

Active Record

	###########################################
	where pt 1
	###########################################

	Transfer.where(amount_cents: 1500)

	O Active Records cria cláusulas IN na consulta SQL quando passamos um array de valores

	Transfer.where(amount_cents: [1000, 1500, 2000]) #SELECT "products".* FROM transfers WHERE "transfer.amount_cents" IN (100, 150, 200)

bergfelipe / rbenv-ruby-rails-install.sh

Created October 4, 2022 12:30 — forked from alexishida/rbenv-ruby-rails-install.sh

Script to install rbenv, Ruby, nodejs and yarn

	#!/bin/bash
	#---------------------------------------------------------------------------------------
	# Script to install rbenv, Ruby, nodejs and yarn
	# Source: https://gist.github.com/alexishida/655fb139c759393ae5fe47dacd163f99
	#
	# Author: Alex Ishida <alexishida@gmail.com>
	# Version: 1.5.6 - 28/06/2022
	#---------------------------------------------------------------------------------------
	#
	# HOW TO INSTALL A SCRIPT

bergfelipe / Rails DB

Created September 5, 2022 15:14 — forked from lucasslemos/Rails DB

Rails DB

	rails db:migrate VERSION=20211006171023
	rails db:migrate:up VERSION=20211006171023
	rails db:migrate:down VERSION=20211006171023
	rails db:rollback STEP=1

bergfelipe / Instalando o PostgreSQL

Created June 7, 2022 02:52 — forked from lucasslemos/Instalando o PostgreSQL

Instalando o PostgreSQL

	# Ubuntu 21.10 Impish Indri
	sudo apt update
	sudo apt install postgresql postgresql-contrib
	sudo -i -u postgres
	psql
	CREATE USER lucas WITH PASSWORD '12345678' CREATEDB;
	ALTER USER postgres PASSWORD postgres;

bergfelipe / ssh key add

Created June 3, 2022 15:17 — forked from Thalescantai/ssh key add

add ssh key

	git config --global color.ui true
	git config --global user.name "Thalescantai"
	git config --global user.email "tcantai54@gmail.com"
	ssh-keygen -t rsa -b 4096 -C "tcantai54@gmail.com"
	cat ~/.ssh/id_rsa.pub