SQLite interface by @macwinnie

This is the documentation overview for SQLite interface by @macwinnie.

To install this package, please run:

        pip install macwinnie_sqlite3
    

Usage could then e.g. be – with some yoyo-migrations within the directory db_migrations:

        from macwinnie_sqlite3 import SQLite

        db_file = "{}/{}".format(
            os.getcwd(),
            "database.sqlite"
        )
        db_migrations_path = "{}/{}".format(
            os.getcwd(),
            "db_migrations"
        )

        db = SQLite.database(db_file, db_migrations_path)
        # # or you can also do it like this in two steps:
        # db = SQLite.database(db_file)
        # db.migrate(db_migrations_path)

        sql = "SELECT name FROM pragma_table_info( 'TableCreatedByYoyo' ) ORDER BY cid;"
        db.startAction()
        db execute(sql)
        colNames = [n[0] for n in db.fetchall()]
        db.close()
    

This short example retrieves all table attributes within the table TableCreatedByYoyo which has to be created first by a yoyo migration.

The Sourcecode of the package can be found on GitHub, the documentation you currently are reading can be found at GitHub Pages and was last updated on Thu Oct 6 12:22:12 UTC 2022.

Feel free to inspect the specific module documentations:

• SQLite.html