[ArmedXpert] One method for running an arbitrary SQL SELECT query using the ArmedXpert plugin editor.

ArmedXpertRunArbitrarySQL.py

editor.ClearLog()

import clr
clr.AddReference('System.Data.SQLite')

from nichevision.forensics.armedxpert.dnada.datalayer import Database
from System.Data.SQLite import SQLiteCommand

cmd = SQLiteCommand("select * from AlleleCombination", Database.SharedDatasource.Connection)
reader = cmd.ExecuteReader()
try:
    while reader.Read():
        v = list(reader.GetValues())
        output = ','.join(['%s = %s%s' % (
            name, 
            str(reader[name])[:50], 
            '...' if len(str(reader[name])) > 50 else '') 
            for name in v])
        print output
finally:
    reader.Close()