Posts in 2020
-
PostgreSQL mini cookbook: basic query tricks
Last Update: in PostgreSQL
PostgreSQL mini cookbook: PostgreSQL basic query tricks, those tricks back to 2001 and still works today. 😉
Case insensitive searches You want to check equality or do a regular expression search but ignoring case Solution Either use lower() on the field and the value being compared or use the ILIKE or ˜˜* regular expression operators. Discussion If you …
-
Python unicode string lowercase and caseless match
in Python
str.lower()andstr.casefold()str.lower() and str.casefold() Starting with Python 3.0, strings are stored as Unicode. Python defined to two functions str.lower() and str.casefold() can be used to convert string to lowercase: str.lower() Return a copy of the string with all the …
-
psql 101
Last Update: in PostgreSQL
psqlis a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file.psql shell command List exist databases $ psql --list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ------------------------+-------+----------+-------------+-------------+------------------- dvdrental | dbch | UTF8 …
-
Azure function Did not find any initialized language workers
Last Update: in Azure
Azure function app random response
500 Internal errorto client. log indicate Azure function: Did not find any initialized language workers.Symptom We deployed a very simple Azure function with nodejs runtime, on an Linux container. However after deployment, the service is not stable stable, it goes up and down, server random response 500 Internal error to client. From Azure’s log, …
-
Add git commit date as last update date in hugo page
Last Update: in Hugo
Hugo page template: Use
.GitInfoor.Page.Lastmodas last update date in hugo pageUse .GitInfo or .Page.Lastmod Hugo have build-in support to get the last Git revision information for every content file through Page.Lastmod or .GitInfo variable. Page.Lastmod is fetched from .GitInfo.AuthorDate. To enable Hugo get git commit info, …
-
Add git commit to docker image tag in Azure pipeline
Last Update: in Azure
Add git commit to docker image tag in Azure pipeline
Problem I have Azure devops pipeline to build docker image from source. I want the docker image have the source code revision info like git commit hash. I tried to use Build.SourceVersion as a docker image tag, Build.SourceVersion : The latest …
-
Pass var in Azure pipeline
Last Update: in Azure
Use variable to pass data in Azure devops pipelines
I have an Azure devops pipeline and want to pass some data between different tasks. One way to do is use environment var. Variables give you a convenient way to get key bits of data into various parts of the pipeline. As the name suggests, the value …
-
Azure WALinuxAgent Backdoor
Last Update: in Azure
WALinuxAgent is is Microsoft Azure Linux Agent with root access (backdoor?). Remove it if you do not use it.
WALinuxAgent is Microsoft Azure Linux Agent with root access (backdoor?). It is pretty powerful to manage Linux on Azure. The source code is host at github Azure/WALinuxAgent . The Microsoft Azure Linux Agent (waagent) manages Linux provisioning and …
-
python-cas Flask Example
Last Update: in CAS
An example project to demo how to integrate python-cas into a Flask app.
python-cas is Python CAS (Central Authentication Server) client library support CAS 1.0/2.0/3.0. It was initially split from django-cas-ng to support any Python app to easily implement a CAS client. This post is an example project to demo how to …
-
django-cas-ng Example
Last Update: in CAS
An example project to demo how easy to integrate with django-cas-ng
django-cas-ng is Django CAS (Central Authentication Service) 1.0/2.0/3.0 client library to support SSO (Single Sign On) and SLO (Single Logout)! To demo how easy to integrate with django-cas-ng, here is an example project to show how to use …