List of Projects rdnielsen is involved in

chkcsv

chkcsv.py is a Python library and program that checks the format of data in a CSV file. It can check whether required columns and data are present, and the type of data in each column. Pattern matching using regular expressions is suppo...

execsql

A Python program that runs a SQL script stored in a text file against a PostgreSQL, MS-Access, SQLite, MS-SQL-Server, MySQL, MariaDB, Firebird, or Oracle database, or an ODBC DSN. execsql also supports a set of special commands (metacom...

execsql-compare

Scripts for the execsql.py script processor that generate SQL to compare attribute values in a base table and a staging table of the same structure. SQL can be generated to produce several types of comparison results. The scripts int...

execsql-glossary

Scripts for the execsql.py SQL script processor that allow the user to easily create a glossary of terms to accompany a database export. A typical use is to create a glossary of all of the column names that appear in the export. The s...

execsql-upsert

Scripts for the execsql.py script processor that perform automated upsert operations (insert or update) on multiple tables simultaneously. The scripts dynamically create and execute SQL based on the database's information schema, and t...

tklayout

A Python library that simplifies the construction of Tkinter user interfaces by allowing the developer to specify the structure of the interface elements from the inside out. Whereas Tkinter requires that nested frames and other wi...

tkpane

TkPane is a Python package designed to simplify the construction of a Tkinter user interface by encapsulating one or more widgets into ‘pane’ objects that have no direct dependence on any other UI elements. Panes interact with other app...

un-xtab

A Python module and command-line program that rearranges data from a crosstabulated format to a normalized format. See https://pypi.org/project/un-xtab/

xtab

A Python module and command-line program that rearranges data from a normalized format to a crosstabulated format.