Gustavo Alexandre gassantos

## SqlAlchemyGet.py
from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.orm import mapper
from sqlalchemy.sql import select


class MyTable(object):
    pass


# Trusted Connection

## gist:62edd42305d3cf2e647a4052e2746cbb
# Starter pipeline
# Start with a minimal pipeline that you can customize to build and deploy your code.
# Add steps that build, run tests, deploy, and more:
# https://aka.ms/yaml

trigger:
- master

pool:
  vmImage: 'windows-latest'

## GitCommitEmoji.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                gassantos
                / GitCommitEmoji.md
            
            
              Created
              August 14, 2021 04:45
                — forked from HelioCampos/GitCommitEmoji.md
            
              
                Git Commit message Emoji
              
          
    Inspired by dannyfritz/commit-message-emoji
See also gitmoji.


Commit type
Emoji


Initial commit
🎉 :tada:


Version tag
🔖 :bookmark:


New feature
✨ :sparkles:


Bugfix
🐛 :bug:


## gitflow.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                gassantos
                / gitflow.md
            
            
              Created
              August 14, 2021 04:43
                — forked from HelioCampos/gitflow.md
            
              
                Manual de git flow
              
          
    GIT FLOW

Instalando

MAC OS X:


brew install git-flow

UBUNTU/LINUX:


sudo apt-get install git-flow

Inicializando


## SQLAlchemyMSSQL.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""Exemplo de CRUD com SQLAlchemy e MS SQL Server.

Em caso de problemas na instalação com ``pip install pyodbc``
pode-se utilizar: `pyodbc <https://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc>`_

Além do conector é necessária a instalação do driver do SQL Server:

- `Windows <https://docs.microsoft.com/pt-br/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-2017#installing-microsoft-odbc-driver-for-sql-server>`_.

## README.md

      
              3 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                gassantos
                / README.md
            
            
              Created
              March 5, 2021 14:55
                — forked from rduplain/README.md
            
              
                Connect to MSSQL using FreeTDS / ODBC in Python.
              
          
    Goal: Connect to MSSQL using FreeTDS / ODBC in Python.
Host: Ubuntu 11.10 x86_64
Install:
sudo apt-get install freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc sqlalchemy

In /etc/odbcinst.ini:

  
## query_finder.sql
SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
FROM information_schema.processlist
WHERE command <> 'Sleep'
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;

## edm2.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                gassantos
                / edm2.ipynb
            
            
              Created
              August 29, 2018 23:06
                — forked from ruizendaalr-zz/edm2.ipynb
            
              
                EDM_student_grade_prediction
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## oracle.pl
#!/usr/bin/perl
use strict;
use warnings;
use DBD::Oracle qw(:ora_session_modes);

### Variaveis e conexao ao Oracle.
my $oracle_hostname = $ARGV[0];
my $oracle_database = $ARGV[1];
my $oracle_port = $ARGV[2];
my $oracle_username = 'SYS';
	from sqlalchemy import create_engine, MetaData, Table
	from sqlalchemy.orm import mapper
	from sqlalchemy.sql import select


	class MyTable(object):
	pass


	# Trusted Connection
	# Starter pipeline
	# Start with a minimal pipeline that you can customize to build and deploy your code.
	# Add steps that build, run tests, deploy, and more:
	# https://aka.ms/yaml

	trigger:
	- master

	pool:
	vmImage: 'windows-latest'
Commit type	Emoji
Initial commit	🎉 `:tada:`
Version tag	🔖 `:bookmark:`
New feature	✨ `:sparkles:`
Bugfix	🐛 `:bug:`
	#!/usr/bin/env python3
	# -- coding: utf-8 --
	"""Exemplo de CRUD com SQLAlchemy e MS SQL Server.

	Em caso de problemas na instalação com ``pip install pyodbc``
	pode-se utilizar: `pyodbc <https://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc>`_

	Além do conector é necessária a instalação do driver do SQL Server:

	- `Windows <https://docs.microsoft.com/pt-br/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-2017#installing-microsoft-odbc-driver-for-sql-server>`_.
	SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
	FROM information_schema.processlist
	WHERE command <> 'Sleep'
	AND info NOT LIKE '%PROCESSLIST%'
	ORDER BY time DESC LIMIT 50;
	#!/usr/bin/perl
	use strict;
	use warnings;
	use DBD::Oracle qw(:ora_session_modes);

	### Variaveis e conexao ao Oracle.
	my $oracle_hostname = $ARGV[0];
	my $oracle_database = $ARGV[1];
	my $oracle_port = $ARGV[2];
	my $oracle_username = 'SYS';