Journal of my recent activities

LibreOffice transpose rows to columns

  1. Copy to clipboard the cell range that you want to transpose.
  2. Paste Special, in the dialog, mark Paste all and Transpose.

Rotating Tables (Transposing) - LibreOffice Help

#libreoffice

Automatic change of linux configuration files

sed -i 's/#Port 22/Port 123/' /etc/ssh/sshd_config

#linux

Dictionary of values with choices for select.


from enum import Enum


class ResourceType(Enum):
    HTML = 0
    VIDEO = 1
    AUDIO = 2
    IMAGE = 3
    PDF = 4
    HTTP = 5
    EPUB = 6


def get_choices():
    return [(r.value, r.name) for r in ResourceType]

Creating unit tests for Flask.

import unittest

from app import create_app, db
from config_tests import Config


class MmTestCase(unittest.TestCase):
    def setUp(self):
        self.app = create_app(Config)
        self.appctx = self.app.app_context()
        self.appctx.push()
        db.create_all()
        self.client = self.app.test_client()

    def tearDown(self):
        db.drop_all()
        self.appctx.pop()
        self.app = None
        self.appctx = None
        self.client = None

How to Write Unit Tests in Python, Part 3: Web Applications

Downloading backups from remote hosts

rsync -av --delete -e 'ssh -p 223' user@host:/dir1 local_dir

#soft #linux

Symetric ant anti-symetric wave function

http://hyperphysics.phy-astr.gsu.edu/hbase/molecule/hmol.html

Google Sheets: Bulk delete

Tools > Script ediotr Set a breakpoint at console log sheet name and Debug.

function DeleteAllSheets() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  console.log("Doc: " + ss.getName());
  var sheets = ss.getSheets();
  for (i = 0; i < sheets.length; i++) {
    switch(sheets[i].getSheetName()) {
      case "21-01":  
        break;
      default:
        console.log("Delete: " + sheets[i].getSheetName());
        ss.deleteSheet(sheets[i]);
    }
  }
}

https://spreadsheetpoint.com/delete-multiple-sheets-google-sheets/

#soft

Convert ssh2 public key to openssh format

If the pub key is in the format

---- BEGIN SSH2 PUBLIC KEY ----

then you can convert it with

ssh-keygen -i -f klucz.pub >> ~/.ssh/authorized_keys

#soft #linux