pyp_db contains a set of procedures for ...
createPedigreeDatabase() creates a new database in SQLite.
createPedigreeDatabase() creates a new pedigree table in a SQLite database.
databaseQuery() executes an SQLite query. This is a wrapper function used by the reporting functions that need to fetch data from SQLite. I wrote it so that any changes that need to be made in the way PyPedal talks to SQLite will only need to be changed in one place.
getCursor() creates a database connection and returns a cursor on success or a 0 on failure. It isvery useful for non-trivial queries because it creates SQLite aggrefates before returning the cursor. The reporting routines in pyp_reports make heavy use of getCursor().
loadPedigreeDatabase() takes a PyPedal pedigree object and loads the animal records in that pedigree into an SQLite table.
PypMean is a user-defined aggregate for SQLite for returning means from queries.
For more information about this class, see The PypMean Class.
PypSSD is a user-defined aggregate for SQLite for returning sample standard deviations from queries.
For more information about this class, see The PypSSD Class.
PypSum is a user-defined aggregate for SQLite for returning sums from queries.
For more information about this class, see The PypSum Class.
PypSVar is a user-defined aggregate for SQLite for returning sample variances from queries.
For more information about this class, see The PypSVar Class.
tableCountRows() returns the number of rows in a table.
tableDropRows() drops all of the data from an existing table.
tableDropTable() drops a table from the database.
tableExists() queries the sqlite_master view in an SQLite database to determine whether or not a table exists.
PypMean is a user-defined aggregate for SQLite for returning means from queries.
PypSSD is a user-defined aggregate for SQLite for returning sample standard deviations from queries.
PypSum is a user-defined aggregate for SQLite for returning sums from queries.
PypSVar is a user-defined aggregate for SQLite for returning sample variances from queries.