Python: view line numbers in standard editor

python-logo

By default IDLE (the standard Python IDE) does not show line numbers 😦

You can install the extension IdleX to do this.  This is only one of IdleX’s features. See http://idlex.sourceforge.net/features.html for an overview of all features.

You can download IdleX here.  After decompressing the ZIP file you only need to run idlex.py to use this extension (and show/hide line numbers).

Python: creating executables

python-logo

Out of the box Python is an interpreted programming language.

One way to create an exe file from the standard Python py files is using PyInstaller.  (note: I am working with Python 3.5.  PyInstaller supports Python 3.  Py2exe – which also allows to make exe files – currently only supports Python 2.7)

Preparation:

  1. Download PyInstaller (http://www.pyinstaller.org/ – documentation can also be found here)
  2. Install PyInstaller with the pip command:
    • Start Cmd
      Go to the folder containing PyInstaller-3.0.zip (using CD FOLDERNAME)
    • Execute the pip command:
    • > pip install pyinstaller

Now package your py file with the command PyInstaller xxx.py; for example:

> PyInstaller Testapp.py

The exe file will now be created under the dist folder.  You need all files in the dist folder containing the exe file.

Other examples:

> PyInstaller -F Testapp.py

Now Testapp.exe will also be created in the subfolder caller “dist” in a one-file bundled exe file.

> PyInstaller -F -w Testapp.py

This also creates a one-file bundled exe file, but does not show a console window; this is probably what you need when you create a GUI application.

Changing colors in SciTE

autoit

When attaching an external monitor I was not able to see a code selection on this screen in the AutoIt editor SciTE.

I found out that changing the colors involved modifying the “c:\Program Files (x86)\AutoIt3\SciTE\SciTEGlobal.properties” file.

More specifically changing the selection.fore, alpha and back solved the issue.

AutoIt-colors

As the alpha.selection settings apparently can behave differenty on a laptop display and an external monitor, it makes sense to disable this setting …

AutoIt Colors 2

Tips:

  1. When you modify the colors in SciTE, you can immediately see the result after saving the file.
  2. Put # in front of the original line to keep a backup of the original setting.
  3. See for example this page on w3schools.com for an overview of hex values colors
  4. Modify indicators.alpha, for example to “indicators.alpha=150” to improve visibility when highlighting a word (see below)

AutoIt_Highlight

SQL queries on WSUS database

LoginToWID

Sometimes you need to query the WSUS database using T-SQL statements.

The WSUS database can be installed using the Windows Internal Database (shipping with WSUS 3.0) or a standard SQL database.

When a Windows Internal Database is used, you can use SQL Management Studio Express to connect to.  Use the following string to connect to this database: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
For more info, see http://blogs.technet.com/b/gborger/archive/2009/02/27/exploring-the-wsus-windows-internal-database.aspx.
Continue reading SQL queries on WSUS database

IT to the point