1.1.5.6. gnr.sql.gnrsqlutils – Utilities

Last page update: November 23, 2011

Classes:

• ModelExtractor
• SqlModelChecker

Complete reference:

• gnr.sql.gnrsqlutils - The complete reference list

1.1.5.6.1. ModelExtractor

• buildColumns()
• buildIndexes()
• buildRelations()
• buildSchemata()
• buildTables()
• buildViews()
• extractModelSrc()

1.1.5.6.2. SqlModelChecker

• checkDb()

1.1.5.6.3. gnr.sql.gnrsqlutils - The complete reference list

class gnr.sql.gnrsqlutils.ModelExtractor(dbroot)

TODO

buildColumns(tbl, pkg_name, tbl_name)

TODO

Parameters:

• tbl – the table object
• pkg_name – the name of the package. For more information, check the packages documentation page
• tbl_name – the name of the database table

buildIndexes(tbl, pkg_name, tbl_name)

TODO

Parameters:

• tbl – the table object
• pkg_name – the name of the package. For more information, check the packages documentation page
• tbl_name – the name of the database table

buildRelations(root)

TODO

Parameters:root – the root of the page. For more information, check the main documentation section.

buildSchemata(root)

TODO

Parameters:root – the root of the page. For more information, check the main documentation section.

buildTables(pkg, pkg_name)

TODO

Parameters:

• pkg – the package object
• pkg_name – the:ref:package <packages> name

buildViews()

TODO

extractModelSrc(root)

Call the buildSchemata() and buildRelations() methods. Return the root

Parameters:root – the root of the page. For more information, check the main documentation section.

class gnr.sql.gnrsqlutils.SqlModelChecker(db)

Keep a database aligned with its logical structure in the GnrSqlDb. If there is any change in the modelobj, database is automatically updated.

checkDb()

Return a list of instructions for the database building