Query Truxton

Here's an example of how to query the Truxton database using Python.

To install the PostgreSQL library for Python:

pip install "psycopg[binary,pool]"

Number of File Types

This will tell you how many types of files Truxton knows about.

import sys
sys.path.append('C:/Program Files/Truxton/SDK')
import truxton
import psycopg

def main():
  t = truxton.create()

  connection = psycopg.connect(t.connectionstring)
  database_cursor = connection.cursor()
  database_cursor.execute("SELECT * FROM \"FileType\";")
  database_rows = database_cursor.fetchall()

  print( "There are " + str(len(database_rows)) + " file types in Truxton" )

  connection.commit()
  connection.close()

  return None

if __name__ == "__main__":
  sys.exit(main())