Skip to content

Pwic.wiki 1.2 - Stable release

Latest
Compare
Choose a tag to compare
@gitbra gitbra released this 24 Jun 21:15
· 4 commits to master since this release

Pwic.wiki is a flexible and compact wiki server to support the documentation of your projects. It is based on Python, SQLite and Markdown. It is also integrated well with OpenDocument Text (ODT).

In comparison with the previous release 1.1, this version includes many technical features related to the performances, security and BI integration.

The future of Pwic.wiki will depend on your requests and contributions. Feel free to raise your needs in the tracker.

Upgrade

Adjusting your custom code will be required: some names and formats have changed. A simple check with flake8 and mypy can identify the required changes.

From the previous release 1.1, you must convert your database as follows:

UPDATE projects SET date = '1970-01-01' WHERE date = '';
UPDATE users SET password_date = '1970-01-01' WHERE password_date = '';
UPDATE users SET password_time = '00:00:00' WHERE password_time = '';
PRAGMA foreign_keys=OFF;
ALTER TABLE users RENAME TO tmp_users;
CREATE TABLE users ("user" TEXT NOT NULL, "password" TEXT NOT NULL, "initial" TEXT NOT NULL CHECK("initial" IN ('', 'X')), "totp" TEXT NOT NULL, "password_date" TEXT NOT NULL, "password_time" TEXT NOT NULL, PRIMARY KEY("user"));
INSERT INTO users (user, password, initial, totp, password_date, password_time) SELECT user, password, initial, '', password_date, password_time FROM tmp_users;
DROP TABLE tmp_users;
ALTER TABLE users RENAME TO tmp_users;
ALTER TABLE tmp_users RENAME TO users;
PRAGMA foreign_keys=ON;

It is recommend to clear the cache to benefit from the updated Markdown parser:

./pa clear-cache

Reference links

You can test the new release online at https://pwic.wiki !

Use our bug tracker if you have any question, idea or issue.