adililhan

#!/bin/bash

ip netns del one
ip netns del two
ip netns del three

ip link del name virtual-bridge type bridge

iptables -F POSTROUTING -t nat

adililhan

PostgreSQL Note

Commands

https://www.postgresql.org/docs/9.5/static/reference-client.html

Show work memory

SHOW work_mem;

adililhan

Exploitation

Database information

Schema settings

SELECT r.rolname, d.datname, rs.setconfig
FROM   pg_db_role_setting rs
LEFT   JOIN pg_roles      r ON r.oid = rs.setrole
LEFT   JOIN pg_database   d ON d.oid = rs.setdatabase

adililhan

--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

------------
-- Basics --
------------

-- Get indexes of tables

adililhan

import functools


class Computer:
    @functools.singledispatchmethod
    def __init__(self, *parts):
        self.parts = " *** ".join(parts)

    @__init__.register
    def _(self, parts: dict):

adililhan

import functools


class Computer:
    @functools.singledispatchmethod
    def __init__(self, *parts):
        self.parts = " *** ".join(parts)

    def get_parts(self):
        return self.parts

adililhan

import functools


class Computer:
    @functools.singledispatchmethod
    def __init__(self, *parts):
        self.parts = " *** ".join(parts)

    def get_parts(self):
        return self.parts

adililhan

  @patch.object(
      UserController, "__init__", Mock(return_value=None)
  )
  def test_get_first_picture(self):
      user = UserController()
      user.picture = MagicMock()

      self.assertEqual("Test 1", user.get_first_picture())

adililhan

  @patch.object(
      UserController, "__init__", Mock(return_value=None)
  )
  def test_get_first_picture(self):
      mock_app = MagicMock()
      mock_app.dbal.all.return_value = ["Test 1", "Test 2"]

      user = UserController()
      user.picture = mock_app

adililhan

  @patch.object(
      UserController, "__init__", Mock(return_value=None)
  )
  def test_get_second_picture(self):
      mock_app = MagicMock()
      mock_app.dbal.all.return_value = ["Test 1", "Test 2"]

      user = UserController()
      user.picture = mock_app