Skip to content

Instantly share code, notes, and snippets.

View rafaelpadovezi's full-sized avatar

Rafael rafaelpadovezi

32 followers · 42 following
View GitHub Profile
@rafaelpadovezi
rafaelpadovezi / comissions.json
Created June 24, 2017 22:07
[{"name":"Comissão de Agricultura, Pecuária, Abastecimento e Desenvolvimento Rural","children":[{"name":"PDT","children":[{"name":"ASSIS DO COUTO"},{"name":"AFONSO MOTTA"},{"name":"MÁRIO HERINGER"},{"name":"DAGOBERTO NOGUEIRA"}]},{"name":"PSDB","children":[{"name":"IZAQUE SILVA"},{"name":"DOMINGOS SÁVIO"},{"name":"GUILHERME COELHO"},{"name":"NELSON PADOVANI"},{"name":"NILSON LEITÃO"},{"name":"RAIMUNDO GOMES DE MATOS"}]},{"name":"PP","children":[{"name":"AFONSO HAMM"},{"name":"DILCEU SPERAFICO"},{"name":"JERÔNIMO GOERGEN"},{"name":"LÁZARO BOTELHO"},{"name":"LUIS CARLOS HEINZE"},{"name":"NELSON MEURER"},{"name":"ROBERTO BALESTRA"},{"name":"BETO ROSADO"},{"name":"FAUSTO PINATO"},{"name":"LUIZ FERNANDO FARIA"},{"name":"ANDRÉ ABDON"},{"name":"JORGE BOEIRA"},{"name":"BETO SALAME"}]},{"name":"DEM","children":[{"name":"ALBERTO FRAGA"},{"name":"ONYX LORENZONI"},{"name":"CARLOS MELLES"},{"name":"HÉLIO LEITE"}]},{"name":"PMDB","children":[{"name":"ANDRÉ AMARAL"},{"name":"CELSO MALDANER"},{"name":"DULCE MIRANDA"},{"name"
@rafaelpadovezi
rafaelpadovezi / index.html
Last active March 3, 2018 17:07
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Composição partidária das Comissões da Camara Federal - Junho/2017</title>
<style>
body {
font-family: Cambria, Cochin, Georgia, Times, Times New Roman, serif
}
@rafaelpadovezi
rafaelpadovezi / orgaos-20190306.json
Last active March 6, 2019 22:42
This file has been truncated, but you can view the full file.
[
{
"id": 4,
"uri": "https://dadosabertos.camara.leg.br/api/v2/orgaos/4",
"sigla": "MESA",
"nome": "Mesa Diretora da Câmara dos Deputados",
"apelido": "Mesa Diretora",
"codTipoOrgao": 1,
"tipoOrgao": "Comissão Diretora"
},
@rafaelpadovezi
rafaelpadovezi / db-coalesce-tests.cs
Created May 21, 2020 13:12
public class Contract
{
public int Id { get; set; }
public string Url { get; set; }
}
public class ModelContext : DbContext
{
public static readonly ILoggerFactory DebugLoggerFactory
= LoggerFactory.Create(builder => { builder.AddDebug(); });
@rafaelpadovezi
rafaelpadovezi / medium-configuring-db-context.cs
Created March 12, 2021 20:34
Medium - Configuring db context
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder
.UseSqlServer(
"Data Source=localhost,1433;Initial Catalog=Timesheet;User Id=sa;Password=Password1")
.LogTo(message => Debug.WriteLine(message));
}
@rafaelpadovezi
rafaelpadovezi / medium-save-changes.cs
Created March 12, 2021 20:35
Adding entities
var employee = new Employee
{
Name = "John Doe",
Entries = new List<TimeEntry>
{
new TimeEntry
{
Start = TimeSpan.FromHours(8),
End = TimeSpan.FromHours(12)
}
@rafaelpadovezi
rafaelpadovezi / medium-begin-transaction.cs
Created March 12, 2021 20:37
Add entities - explicity transaction
var employee = new Employee
{
Name = "John Doe",
Entries = new List<TimeEntry>
{
new TimeEntry
{
Start = TimeSpan.FromHours(8),
End = TimeSpan.FromHours(12)
}
@rafaelpadovezi
rafaelpadovezi / medium-savepoint.cs
Created March 12, 2021 20:38
Creating savepoints
using var transaction = context.Database.BeginTransaction();
context.Add(new Employee { Name = "John Doe" });
context.SaveChanges();
transaction.CreateSavepoint("A");
context.Add(new Employee { Name = "Jane Doe" });
context.SaveChanges();
@rafaelpadovezi
rafaelpadovezi / starting-savechanges
Created March 16, 2021 23:29
Log - Starting SaveChanges
dbug: CoreEventId.SaveChangesStarting[10004] (Microsoft.EntityFrameworkCore.Update)
SaveChanges starting for 'TestContext'.
dbug: CoreEventId.DetectChangesStarting[10800] (Microsoft.EntityFrameworkCore.ChangeTracking)
DetectChanges starting for 'TestContext'.
dbug: CoreEventId.DetectChangesCompleted[10801] (Microsoft.EntityFrameworkCore.ChangeTracking)
DetectChanges completed for 'TestContext'.
dbug: RelationalEventId.ConnectionOpening[20000] (Microsoft.EntityFrameworkCore.Database.Connection)
Opening connection to database 'Timesheet' on server 'localhost,1433'.
dbug: RelationalEventId.ConnectionOpened[20001] (Microsoft.EntityFrameworkCore.Database.Connection)
Opened connection to database 'Timesheet' on server 'localhost,1433'.
@rafaelpadovezi
rafaelpadovezi / starting-savechanges.sql
Created March 16, 2021 23:30
Starting SaveChanges
dbug: CoreEventId.SaveChangesStarting[10004] (Microsoft.EntityFrameworkCore.Update)
SaveChanges starting for 'TestContext'.
dbug: CoreEventId.DetectChangesStarting[10800] (Microsoft.EntityFrameworkCore.ChangeTracking)
DetectChanges starting for 'TestContext'.
dbug: CoreEventId.DetectChangesCompleted[10801] (Microsoft.EntityFrameworkCore.ChangeTracking)
DetectChanges completed for 'TestContext'.
dbug: RelationalEventId.ConnectionOpening[20000] (Microsoft.EntityFrameworkCore.Database.Connection)
Opening connection to database 'Timesheet' on server 'localhost,1433'.
dbug: RelationalEventId.ConnectionOpened[20001] (Microsoft.EntityFrameworkCore.Database.Connection)
Opened connection to database 'Timesheet' on server 'localhost,1433'.