Skip to content

Instantly share code, notes, and snippets.

Avatar

JobNinja Lolobosse lolobosse

View GitHub Profile
View task_sql_alchemy.py
class Task(db.Model):
__tablename__ = 'task_tb'
id = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String(SLen.NAME))
arguments = db.Column(db.String(2000))
created_at = db.Column(db.DateTime, default=func.now())
__table_args__ = (UniqueConstraint('type', 'arguments', name='unique_task'),)
View task_db.sql
create table task_tb
(
id serial not null
constraint task_tb_pkey
primary key,
type varchar(110),
arguments varchar(2000),
created_at timestamp,
constraint unique_task
unique (type, arguments)
@lolobosse
lolobosse / gist:4dcbc39373709cbd56be0e22e138dbe7
Created Feb 4, 2019
Airline Manager Plane combination calculator
View gist:4dcbc39373709cbd56be0e22e138dbe7
import math
# from constraint import *
#
# problem = Problem()
#
# problem.addVariable("Q400 Eco", [80, 0, 0])
# problem.addVariable("Q400 Aff", [0, 44, 0])
# problem.addVariable("Q400 First", [0, 0, 19])
# problem.addVariable("ORY", [368, 107, 19, 4.25])
View gist:127b767a5ba14c5dcaea1bb09f601642
daemon off;
#Heroku dynos have at least 4 cores.
worker_processes <%= ENV['NGINX_WORKERS'] || 4 %>;
events {
use epoll;
accept_mutex on;
worker_connections 1024;
}
View Jobninja_red logo.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Jobninja logo.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Cleanup Parse Direct from Mongo
var i = 0;
db.getCollection('fs.files').find({}).forEach(function(element){
if (!db.getCollection('_User').find({profilePicture: element.filename}).toArray().length > 0){
i++;
db.getCollection('fs.files').remove({filename: element.filename})
}
})
print(i)
View gist:1dd21daf81d24fa712757a88ef7b61bd
alias ip="ifconfig | egrep -o '([[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3})[[:space:]]netmask[[:space:]]0x[[:xdigit:]]{8}[[:space:]]broadcast'|egrep -o '([[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3}\.[[:digit:]]{1,3})' | pbcopy"
@lolobosse
lolobosse / gist:6ce504ff3b53427defe0
Created Dec 24, 2015
To regroup x avis files which have been splitted
View gist:6ce504ff3b53427defe0
import re
from subprocess import call
import sys
import os
rootdir = '.'
dictOfFilms = {}
View Get sum of t411 column in Future Téléchargements
for(var total=0,i=0;i<$("tbody").children().size();i++){var string=$($("tbody").children()[i]).children()[6].innerHTML,split=string.split(" ");value=parseFloat(split[0])*("MB"==split[1]?1:1e3),total+=value}