Query Truxton - Revision history

Sam: /* Number of File Types */

2024-09-11T20:54:35Z

Number of File Types

2023-08-17T23:56:33Z

Number of File Types

2023-07-02T21:12:39Z

2022-09-17T12:25:52Z

2022-09-16T21:10:41Z

Number of File Types

2022-07-27T20:39:27Z

2022-07-27T20:28:03Z

@@ Line 29: / Line 29: @@
 if __name__ == "__main__":
-   main()
+   sys.exit(main())
 </source>

@@ Line 2: / Line 2: @@
 To install the PostgreSQL library for Python:
-<pre>pip install psycopg</pre>
+<pre>pip install "psycopg[binary,pool]"</pre>
 =Number of File Types=

@@ Line 22: / Line 22: @@
    print( "There are " + str(len(database_rows)) + " file types in Truxton" )
    return None
 if __name__ == "__main__":
    main()
 </source>

@@ Line 22: / Line 22: @@
    print( "There are " + str(len(database_rows)) + " file types in Truxton" )
-   return
+   return None
 if __name__ == "__main__":

← Older revision		Revision as of 20:28, 27 July 2022
Line 1:		Line 1:
	Here's an example of how to query the Truxton database using Python.		Here's an example of how to query the Truxton database using Python.
		+
		+	To install the PostgreSQL library for Python:
		+	<pre>pip install psycopg2</pre>

	=Number of File Types=		=Number of File Types=

@@ Line 13: / Line 13: @@
 import psycopg
-def main():
+def main() -> None:
    t = truxton.create()

@@ Line 2: / Line 2: @@
 To install the PostgreSQL library for Python:
-<pre>pip install psycopg2</pre>
+<pre>pip install psycopg</pre>
 =Number of File Types=
@@ Line 11: / Line 11: @@
 sys.path.append('C:/Program Files/Truxton/SDK')
 import truxton
-import psycopg2
+import psycopg
 def main():
    t = truxton.create()
-   connection = psycopg2.connect(t.connectionstring)
+   connection = psycopg.connect(t.connectionstring)
-   database_cursor = connection.cursor(cursor_factory=psycopg2.extras.DictCursor)
+   database_cursor = connection.cursor()
    database_cursor.execute("SELECT * FROM \"FileType\";")
    database_rows = database_cursor.fetchall()