Author Archives: mahdi

Python Logging Config Sample with Multiple Sinks

Multiple sinks for default logger’s levels

[loggers]
keys=root

[handlers]
keys=consoleHandler, fileHandler

[formatters]
keys=simpleFormatter

[logger_root]
level=DEBUG
handlers=consoleHandler, fileHandler

[handler_consoleHandler]
class=StreamHandler
level=DEBUG
formatter=simpleFormatter
args=(sys.stdout,)

[handler_fileHandler]
class=FileHandler
level=INFO
formatter=simpleFormatter
args=("%(log_path)s/%(log_filename)s", "a", "utf-8", False)

[formatter_simpleFormatter]
format=[%(levelname)-8s] - %(asctime)s (%(threadName)-10s) %(message)s

Test like this:

import logging
import logging.config
from logging import debug, log
from os import path


def main():
    debug("Hello %s", 1)


if __name__ == "__main__":
    logging.config.fileConfig(
        r"C:\Workspace\Python\VS Code\Logging\default.conf",
        {
            'log_path': path.dirname(path.realpath(__file__)),
            'log_filename': "%s.log" % path.basename(__file__)[:-3]
        }
    )

    log(logging.INFO, "Started")
    main()
    log(logging.INFO, "Finished")

Device OS Versions – Iran

Device OS - Iran

Finding ancestors in a SQL-Server’s HierarchyId tree

Imagine this table, filled with more than a million records containing a 7-levels tree:

CREATE TABLE HierTest (
	Id		BIGINT PRIMARY KEY IDENTITY(1,1),
	Path	HIERARCHYID NOT NULL UNIQUE,
	Name	NVARCHAR(100) NOT NULL
)

Now imagine there’s a node with Id=1839861 and you want to get all of its ancestors. I know of two ways to do this (sources: Simon Ince’s blog post and StackOverflow):

DECLARE @Hiernode HIERARCHYID;
SELECT @Hiernode=[ht].[Path] FROM [TestSchema].[HierTest] AS [ht] WHERE [ht].[Id]=1839861;
SELECT
	*--,
	--[ht].[Path].ToString() AS PathString
FROM [TestSchema].[HierTest] AS [ht]
WHERE @Hiernode.[IsDescendantOf]([ht].[Path])=1
ORDER BY [ht].[Path];

and

WITH Tree(Id, Name, Path, AncestorPath) AS(
	SELECT
		[ht].[Id],
		[ht].[Name],
		[ht].[Path],
		[ht].[Path].GetAncestor(1) AS 'AncestorPath'
	FROM [TestSchema].[HierTest] AS [ht]
	WHERE [ht].[Id]=1839861

	UNION ALL

	SELECT
		[ht].[Id],
		[ht].[Name],
		[ht].[Path],
		[ht].[Path].GetAncestor(1) AS 'AncestorPath'
	FROM [TestSchema].[HierTest] AS [ht]
	INNER JOIN [Tree] t ON [ht].[Path] = [t].[AncestorPath]
)
SELECT
	[t].[Id],
	[t].[Name],
	[t].[Path]
FROM [Tree] t
ORDER BY [t].[Path]

Measuring the execution time shows the “Take II” to be more than 100 times faster than “Take I”!!

I’ll update this post with what I’ll learn in the future.


Download the scripts from: Hierarchy Test.

Windows TCP 49154 – What is it!!?

Just had a tough struggle with my “MUTE” friend – Windows Server – trying to understand what’s running behind tcp/49154 on my server, accepting connection.

There are many ALLOW ALL PROFILES WITH ANY PORTS listed on windows’ firewall by default and thinking of them as being secure is not right.

File Server Remote Management (WMI-In) was listening on that port! Disabled the rule and now I’m in peace again! 😀

 

Use Powershell 5 to start automatic services not running

There are times when windows doesn’t start some automatic services. In situations like this, the best way would be a clean fresh windows installation; but what if you can’t re-install the OS?

This script will be very handy when you can’t re-install the Windows. It runs those nasty services 🙂

clear
$svcs=Get-Service | Where-Object {$_.Status -eq 'stopped' -and $_.StartType -like "*Automatic*"}
foreach ($svc in $svcs){
    Write-Host Starting $svc.Name
    Start-Service $svc
}

Linux – Find last 10 modified folders.

This post will be updated, but for the mean time this should work:

find . -maxdepth 2 -type d -exec stat -c "%y %n" {} \; | sort | tail -n 20

Update 1:

This is much faster:

find . -maxdepth 2 -type d -printf "%TY-%Tm-%Td %TH:%TM:%TS %TZ %p\n" | sort | tail -n 20

🙂

%Path% variable analyzer

Use this in Powershell:

 $env:Path.Split(";".ToCharArray()) | Select-Object @{Name="Path";Expression={$_}},@{Name="Exists";Expression={[System.IO.Directory]::Exists($_)}}

کیبورد فارسی برای همه ویندوز ها

قبلاً در مورد کیبورد فارسی یک پست نوشته بودم. اون کیبورد فارسی یک ایراد کوچک داشت که توی این نسخه جدید برطرف شده. ایراد این بود که اگر کیبورد در حالت فارسی باشد و Caps Lock هم روشن باشد، نمیتوان با استفاده از Shift، کاراکترهایی مانند % ( )  و اینها را تایپ کرد؛ که خوب حالا می شود!!

تغییر دیگری که ایجاد شده، استفاده از Zero-Width Space به جای Zero-Width Non-Joiner در Shift+Space است که کاربردش دقیقاً طراحی شده برای عبارتهایی مثل این: “در سده‌ی گذشته” کاراکتری که بدون اینکه فاصله ایجاد کند، باعث شود حروف به هم نچسبند.

حالا این کیبورد جدید رو از اینجا دانلود کنید: Farsi Keyboard Layout Patch

اطلاعات شهرهای ایران

فایل پیوست شامل فهرست نام و مشخصات تقسیمات کشوری در ایران، مشخصاً شهر ها، از دید پورتال وزارت کشور است.

Iran Cities (2015-SEP-01).xlsx

Make windows files/folders permissions right

There are times on windows when you migrate your files to a new system and you will face the corrupted permission-sets on your files or folders. These 4 cmd commands will help you gain your control over your files again 🙂

<Drive>:
CD \
TAKEOWN /F * /A /R 1 > NUL
ICACLS * /reset /T /Q

Just remember to create a batch file containing those lines above. 🙂