Skip to content

Instantly share code, notes, and snippets.

View lucasteles's full-sized avatar
:shipit:
Ship it!

Lucas Teles lucasteles

:shipit:
Ship it!
View GitHub Profile
SELECT
fk.name 'FK Name',
tp.name 'Parent table',
cp.name, cp.column_id,
tr.name 'Refrenced table',
cr.name, cr.column_id
FROM
sys.foreign_keys fk
INNER JOIN
sys.tables tp ON fk.parent_object_id = tp.object_id
DECLARE tabelas CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
OPEN tabelas
DECLARE @tablename sysname
FETCH NEXT FROM tabelas INTO @tablename
WHILE (@@FETCH_STATUS <> -1) BEGIN
IF (@@FETCH_STATUS <> -2) BEGIN
IF LEFT(@tablename,3)<>'TS_' BEGIN
SELECT @tablename = RTRIM(@tablename)
------------------------------------------------------------------------------------------
- CRIANDO TABELA DE TESTES
------------------------------------------------------------------------------------------
CREATE TABLE TB_CADUNICO (
@lucasteles
lucasteles / table2model.sql
Created February 14, 2017 17:38
Generate Model class from database
DECLARE @TableName VARCHAR(MAX) = 'NewsItem' -- Replace 'NewsItem' with your table name
DECLARE @TableSchema VARCHAR(MAX) = 'Markets' -- Replace 'Markets' with your schema name
DECLARE @result varchar(max) = ''
SET @result = @result + 'using System;' + CHAR(13) + CHAR(13)
IF (@TableSchema IS NOT NULL)
BEGIN
SET @result = @result + 'namespace ' + @TableSchema + CHAR(13) + '{' + CHAR(13)
END
@lucasteles
lucasteles / AllTables2Models.sql
Created February 14, 2017 17:56
Generate model class based on database tables
DECLARE @TableSchema VARCHAR(MAX) = 'Models'
DECLARE tables_cursor CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
OPEN tables_cursor
DECLARE @TableName VARCHAR(MAX) = ''
@lucasteles
lucasteles / Email.cs
Created February 24, 2017 19:07 — forked from AlbertoMonteiro/Email.cs
Mapeando tipos complex no EF sem problemas
namespace EfAndCpf
{
public class Email
{
public string EmailValue { get; private set; }
private Email()
{
}
@lucasteles
lucasteles / AllowCrossSiteJsonAttribute.cs
Created March 2, 2017 20:47
Simple CORS enable attribute for MVC
public class AllowCrossSiteJsonAttribute : ActionFilterAttribute
{
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
filterContext.RequestContext.HttpContext.Response.AddHeader("Access-Control-Allow-Origin", "*");
base.OnActionExecuting(filterContext);
}
}
@lucasteles
lucasteles / quake.fsx
Created March 23, 2017 00:38 — forked from lucascebertin/quake.fsx
F# - Quake log parser
open System
open System.Data
open System.IO
open System.Text.RegularExpressions
type DeathTypes =
| MOD_UNKNOWN=1 | MOD_SHOTGUN=2 | MOD_GAUNTLET=3 | MOD_MACHINEGUN=4
| MOD_GRENADE_SPLASH=5 | MOD_ROCKET=6 | MOD_ROCKET_SPLASH=7 | MOD_PLASMA=8
| MOD_PLASMA_SPLASH=9 | MOD_RAILGUN=10 | MOD_LIGHTNING=11 | MOD_BFG=12
| MOD_BFG_SPLASH=13 | MOD_WATER=14 | MOD_SLIME=15 | MOD_LAVA=16
@lucasteles
lucasteles / jokenPo.js
Last active April 12, 2017 23:51
Js JokenPo
class Jogada {
constructor(_tipo, jogador){
if (!(jogador instanceof Jogador))
throw {type:"jp_argument", message:"argumento de tipo invalido"};
this.tipo = _tipo;
this.jogador = jogador;
@lucasteles
lucasteles / paper_scissors_rock_lizard_spock.js
Last active April 12, 2017 23:57
[JavaScript ]paper scissors rock lizard spock
class Jogada {
constructor(_tipo, jogador){
if (!(jogador instanceof Jogador))
throw {type:"jp_argument", message:"argumento de tipo invalido"};
this.tipo = _tipo;
this.jogador = jogador;
this.ganhaDe = [];