Skip to content

Instantly share code, notes, and snippets.

View graffic's full-sized avatar

Javier Gonel graffic

View GitHub Profile
@graffic
graffic / AutofacModule.cs
Created May 24, 2019 10:38
Failed attempt to register all DBSets
public class AutofacModule:Module
{
private static readonly object[] NoParameters = new object[] { };
protected override void Load(ContainerBuilder builder)
{
var dbsetType = typeof(DbSet<>);
var registerMethod = new Func<ContainerBuilder, Func<IComponentContext, object>, IRegistrationBuilder<object, SimpleActivatorData, SingleRegistrationStyle>>(Af.RegistrationExtensions.Register<object>)
.Method.GetGenericMethodDefinition();
foreach (var property in typeof(ApplicationDbContext).GetProperties())
@graffic
graffic / mssql_slow_monitor.py
Last active August 19, 2019 12:04
El-cheapo mssql slow query monitor
#!/usr/bin/env python
from datetime import datetime
from functools import wraps
from hashlib import sha1
from time import sleep
import os
import pymssql
import click
from sty import fg, rs
@graffic
graffic / stats.js
Last active October 7, 2021 08:38
Cookie clicker stats
// Calculates the price per click per second taking into account synergies.
function potato() {
const result = {}
for (const me of Object.values(Game.Objects).sort((a,b) => a.id - b.id)) {
let synergyBoost = 0
if (me.name=='Grandma')
{
for (var i in Game.GrandmaSynergies)
{
use std::rc::Rc;
use rusqlite::{params, Connection, Statement};
use owning_ref::OwningHandle;
struct MyStatements<'a> {
select_all: Statement<'a>,
select_one: Statement<'a>
}
type MyStatementsOwned = OwningHandle<Rc<Connection>, Box<MyStatements<'static>>>;