*.sql scripts to
<package>/sql. You can run these scripts from any callback with
name is a directory, each script it contains will be executed.
Both types of scripts are executed without being wrapped with SQL transactions. It's generally a good idea to avoid touching table data in scripts;
SQL scripts are ignored if SQLite is used as a database backend.
By default, an empty
sql/<hook_name> directory is generated for every hook in config during init. Comment out
execute_sql in hook code to avoid executing them.
sql/on_restart directory are executed each time you run DipDup. Those scripts may contain
CREATE OR REPLACE VIEW or similar non-destructive operations.
sql/on_reindex directory are executed after the database schema is created based on the
models.py module but before_ indexing starts. It may be useful to change the database schema in the ways that are not supported by the Tortoise ORM, e.g., to create a composite primary key;