Skip to content

Instantly share code, notes, and snippets.

View plcosta's full-sized avatar

Pedro Costa plcosta

  • Brazil
  • 02:35 (UTC -03:00)
View GitHub Profile
public function index()
{
DB::connection('openbase')->enableQueryLog();
$internados = Bed::where('c02codclin', '002')->get();
dd( $internados );
}
<?php
namespace LaravelDoctrine\ORM\Configuration\Connections;
use Illuminate\Support\Str;
class OpensqlConnection extends Connection
{
/**
* @param array $settings
@plcosta
plcosta / PG::Error: ERROR: new encoding (UTF8) is incompatible
Created October 5, 2015 14:01 — forked from amolkhanorkar/PG::Error: ERROR: new encoding (UTF8) is incompatible
Postgres PG::Error: ERROR: new encoding (UTF8) is incompatible
======= Prolbem =================================================================================================================
I have installed : ruby-2.0.0,postgres-9.2 , now in rails app when I execute:
rake db:create , command I get:
PG::InvalidParameterValue: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0 as template.
: CREATE DATABASE "my_db_name" ENCODING = 'unicode'.......
bin/rake:16:in `load'
@plcosta
plcosta / gist:f496c4b12b242a6cee04
Created December 20, 2014 20:11
Linux Derrubar conexões ociosas
#!/bin/bash
###################################################
# #
# Script para matar conexoes ociosas #
# #
# Nome: LIMPANDO_CONEXAO Versao 0.2 #
# by Guilherme Moura de Souza #
# Colaboradores: Tulio.Hoffimann #
# stack_of #
@plcosta
plcosta / backup openbase hospub
Last active August 29, 2015 14:08
Backup OpenBase HOSPUB
#!/bin/bash
#
# Nao esquecer de colocar na cron do root as linhas abaixo:
# #!/bin/bash
# TERM=linux
##### Area das variaveis ################################################
# Declaro a varialvel EXEC com o nome dos executaveis
EXEC="SIADM SIADT SIALM SICEC SIFAR SIFIN SIGAE SIGHO SIGUE SIINF SIMAT SINAT SINUT SISRH SSAME HOSPUB ATIVA"
# -*- mode: ruby -*-
# vi: set ft=ruby :
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
VAGRANTFILE_API_VERSION = "2"
Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
# hospub - debian 7
config.vm.define "hospub" do |hospub|
'use strict';
module.exports = function(grunt) {
grunt.initConfig({
pkg: grunt.file.readJSON('package.json'),
watch: {
options: {
livereload: true
},
var http = require("http"),
url = require("url"),
path = require("path"),
fs = require("fs")
port = process.argv[2] || 8888;
http.createServer(function(request, response) {
var uri = url.parse(request.url).pathname
, filename = path.join(process.cwd(), uri);
apt-get install -y ppa-purge
add-apt-repository -y ppa:ondrej/php5-oldstable
apt-get update
ppa-purge ppa:ondrej/php5
apt-get update && apt-get upgrade -y && apt-get autoremove -y && apt-get autoclean -y
@plcosta
plcosta / Preferences.sublime-settings
Created January 23, 2014 19:52
Sublime Text 3 Settings
{
"bold_folder_labels": true,
"caret_style": "phase",
"color_scheme": "Packages/Color Scheme - Default/Monokai Bright.tmTheme",
"font_face": "Monaco",
"font_size": 14.0,
"highlight_line": true,
"ignored_packages":
[
"Vintage"