Files
CTFd/migrations/versions/a03403986a32_add_theme_code_injections_to_configs.py
Kevin Chung 22c132358e 2.3.0 (#1248)
2.3.0 / 2020-02-17
==================

**General**
* During setup, admins can register their email address with the CTFd LLC newsletter for news and updates
* Fix editting hints from the admin panel
* Allow admins to insert HTML code directly into the header and footer (end of body tag) of pages. This replaces and supercedes the custom CSS feature.
    * The `views.custom_css` route has been removed.
* Admins can now customize the content of outgoing emails and inject certain variables into email content.
* The `manage.py` script can now manipulate the CTFd Configs table via the `get_config` and `set_config` commands. (e.g. `python manage.py get_config ctf_theme` and `python manage.py set_config ctf_theme core`)

**Themes**
* Themes should now reference the `theme_header` and `theme_footer` configs instead of the `views.custom_css` endpoint to allow for user customizations. See the `base.html` file of the core theme.

**Plugins**
* Make `ezq` functions available to `CTFd.js` under `CTFd.ui.ezq`

**Miscellaneous**
* Python imports sorted with `isort` and import order enforced
* Black formatter running on a majority of Python code
2020-02-17 02:17:25 -05:00

47 lines
1.1 KiB
Python

"""add theme code injections to configs
Revision ID: a03403986a32
Revises: 080d29b15cd3
Create Date: 2020-02-13 01:10:16.430424
"""
from alembic import op
from sqlalchemy.sql import column, table
from CTFd.models import db
# revision identifiers, used by Alembic.
revision = "a03403986a32"
down_revision = "080d29b15cd3"
branch_labels = None
depends_on = None
configs_table = table(
"config", column("id", db.Integer), column("key", db.Text), column("value", db.Text)
)
def upgrade():
connection = op.get_bind()
css = connection.execute(
configs_table.select().where(configs_table.c.key == "css").limit(1)
).fetchone()
if css and css.value:
new_css = "<style>\n" + css.value + "\n</style>"
config = connection.execute(
configs_table.select().where(configs_table.c.key == "theme_header").limit(1)
).fetchone()
if config:
# Do not overwrite existing theme_header value
pass
else:
connection.execute(
configs_table.insert().values(key="theme_header", value=new_css)
)
def downgrade():
pass