Difference between revisions of "Query Truxton"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
To install the PostgreSQL library for Python: | To install the PostgreSQL library for Python: | ||
| − | <pre>pip install psycopg</pre> | + | <pre>pip install "psycopg[binary,pool]"</pre> |
=Number of File Types= | =Number of File Types= | ||
| Line 13: | Line 13: | ||
import psycopg | import psycopg | ||
| − | def main(): | + | def main() -> None: |
t = truxton.create() | t = truxton.create() | ||
| Line 29: | Line 29: | ||
if __name__ == "__main__": | if __name__ == "__main__": | ||
| − | main() | + | sys.exit(main()) |
</source> | </source> | ||
Latest revision as of 16:54, 11 September 2024
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() -> None:
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())
