Query Truxton

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

To install the PostgreSQL library for Python:

pip install psycopg2

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 psycopg2
import psycopg2.extras

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

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

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

if __name__ == "__main__":
  main()