Skip to content

Instantly share code, notes, and snippets.

View marcelolebre's full-sized avatar

Marcelo Lebre marcelolebre

  • Remote.com
  • Lisbon, Portugal
View GitHub Profile
@marcelolebre
marcelolebre / psql_terminate_connections
Created January 7, 2015 14:52
Terminating Connections on PSQL
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB'
AND pid <> pg_backend_pid();
@marcelolebre
marcelolebre / center-and-crop-image.css
Created November 19, 2015 18:21
Center and crop image with full cover
background: url("<img>");
background-size: cover;
background-position: center center;
background-repeat: no-repeat;
@marcelolebre
marcelolebre / docker cheat sheet
Last active November 19, 2018 07:29
docker cheat sheet
# Connect to machine
eval $(docker-machine env machine-name)
# Clean docker images
docker rm $(docker images -q)
# Clean all docker images
docker rmi $(docker images -q)
# Clean docker containers /all
@marcelolebre
marcelolebre / drop postgres sessions
Created September 17, 2016 15:38
drop postgres sessions
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB'
AND pid <> pg_backend_pid();
@marcelolebre
marcelolebre / letsencrypt
Last active November 22, 2016 14:32
create certonly certs
sudo certbot certonly --standalone -d website.com -d www.website.com
sudo letsencrypt certonly --standalone --standalone-supported-challenges http-01 --http-01-port 63443 --text --expand --agree-tos -d api.dopplr2.com
class AppHandler(object):
@classmethod
def create(cls, name, description):
return CreateAppService(name, description).call()
@classmethod
def update(cls, app_id, name, description):
app = AppFinder.get_from_id(app_id)
return UpdateAppService(app, name, description).call()
@bp.route('/create/', methods=['POST'], endpoint='create')
def create():
form = AppForm(request.form)
name = form.name.data
description = form.description.data
app = AppHandler.create(name, description)
return redirect(url_for('app.show', app_id=app.id), code=301)
class CreateAppService(object):
def __init__(self, name, description):
self._name = name
self._description = description
def call(self):
app = App.create(name=self._name, description=self._description)
return app
class RoleFinder(object):
@classmethod
def get_from_id(cls, role_id):
return Role.query.get(role_id)
@classmethod
def get_from_app(cls, app_id):
return Role.query.filter_by(app_id=app_id).first()
class UserValue(ValueComposite):
def __init__(self, username, email, first_name, last_name):
super(UserValue, self).initialize({})
self.serialize_with(username=username)
self.serialize_with(email=email)
self.serialize_with(first_name=first_name)
self.serialize_with(last_name=last_name)