Copy/ export SQLite file

[aiqc]

Difficulty: ★☆☆☆☆
Related to: https://github.com/aiqc/aiqc/issues/9

Background

AIQC stores data in a SQLite file. It has methods like def get_db() def create_db() and def destroy_db() for working with this file. The location of this file is kept at aiqc.get_config()['db_path'] and the ORM uses this as the target for the database connection.

The AIQC file is intended to be a proof for a single experiment.

Problem

When a user is done with their experiment, there is no way to do a "save as" on that file to encapsulate their progress, so they would just keep adding more and more experiments into the same file. There is no way to export their work.

Potential Solution

Similar to create_db() and destroy_db() - make a method for copying the database with a user-specified name. The file extension would still be .sqlite3. By default it would live within the default appdirs directory of aiqc, unless the user provides a specific system path for it.