Compare text

Find the difference between two text files

Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools
Diffchecker Desktop icon
Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

1.4 vs 2.0 error

Created Diff never expires
56 removals
Lines
Total
Removed
Words
Total
Removed
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
73 lines
60 additions
Lines
Total
Added
Words
Total
Added
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
77 lines
tests/test_blog.py INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO:sqlalchemy.engine.Engine:PRAGMA main.table_info("user")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA main.table_info("user")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA temp.table_info("user")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA temp.table_info("user")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA main.table_info("post")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA main.table_info("post")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA temp.table_info("post")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA temp.table_info("post")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:COMMIT
INFO sqlalchemy.engine.Engine:base.py:2691 COMMIT
INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO:sqlalchemy.engine.Engine:PRAGMA main.table_info("user")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA main.table_info("user")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA temp.table_info("user")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA temp.table_info("user")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA main.table_info("post")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA main.table_info("post")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:PRAGMA temp.table_info("post")
INFO sqlalchemy.engine.Engine:base.py:1844 PRAGMA temp.table_info("post")
INFO:sqlalchemy.engine.Engine:[raw sql] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [raw sql] ()
INFO:sqlalchemy.engine.Engine:
INFO sqlalchemy.engine.Engine:base.py:1844
CREATE TABLE user (
CREATE TABLE user (
id INTEGER NOT NULL,
id INTEGER NOT NULL,
username VARCHAR NOT NULL,
username VARCHAR NOT NULL,
password_hash VARCHAR NOT NULL,
password_hash VARCHAR NOT NULL,
PRIMARY KEY (id),
PRIMARY KEY (id),
UNIQUE (username)
UNIQUE (username)
)
)




INFO:sqlalchemy.engine.Engine:[no key 0.00006s] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [no key 0.00005s] ()
INFO:sqlalchemy.engine.Engine:
INFO sqlalchemy.engine.Engine:base.py:1844
CREATE TABLE post (
CREATE TABLE post (
id INTEGER NOT NULL,
id INTEGER NOT NULL,
author_id INTEGER NOT NULL,
author_id INTEGER NOT NULL,
created DATETIME NOT NULL,
created DATETIME NOT NULL,
title VARCHAR NOT NULL,
title VARCHAR NOT NULL,
body VARCHAR NOT NULL,
body VARCHAR NOT NULL,
PRIMARY KEY (id),
PRIMARY KEY (id),
FOREIGN KEY(author_id) REFERENCES user (id)
FOREIGN KEY(author_id) REFERENCES user (id)
)
)




INFO:sqlalchemy.engine.Engine:[no key 0.00005s] ()
INFO sqlalchemy.engine.Engine:base.py:1844 [no key 0.00010s] ()
INFO:sqlalchemy.engine.Engine:COMMIT
INFO sqlalchemy.engine.Engine:base.py:2691 COMMIT
INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO:sqlalchemy.engine.Engine:INSERT INTO user (username, password_hash) VALUES (?, ?) RETURNING id
INFO sqlalchemy.engine.Engine:base.py:1839 INSERT INTO user (username, password_hash) VALUES (?, ?) RETURNING id
INFO:sqlalchemy.engine.Engine:[generated in 0.00006s (insertmanyvalues) 1/2 (ordered; batch not supported)] ('test', 'pbkdf2:sha256:600000$BQjxnuHHXBOVUbPK$b9e6048a968efd9d00c08df40a7d160bc48ef72c9cf326020a21c54a939011a9')
INFO sqlalchemy.engine.Engine:base.py:1839 [generated in 0.00007s (insertmanyvalues) 1/2 (ordered; batch not supported)] ('test', 'pbkdf2:sha256:600000$kog02usFd9rbOZo5$c1ad0d33d4f00300d0031573d55c4d36f1f879cba84b91e992afe9af0ab3c7ad')
INFO:sqlalchemy.engine.Engine:INSERT INTO user (username, password_hash) VALUES (?, ?) RETURNING id
INFO sqlalchemy.engine.Engine:base.py:1839 INSERT INTO user (username, password_hash) VALUES (?, ?) RETURNING id
INFO:sqlalchemy.engine.Engine:[insertmanyvalues 2/2 (ordered; batch not supported)] ('other', 'pbkdf2:sha256:600000$tJy08p6HKHRWLlHg$2426c099a011cfe4ed559aaf22590a47bdc8dfa8a1e99afd9bd8e4fbb2f044ac')
INFO sqlalchemy.engine.Engine:base.py:1839 [insertmanyvalues 2/2 (ordered; batch not supported)] ('other', 'pbkdf2:sha256:600000$4ZMc1NZVxKOQwTgL$7a69d16990643d95ca59eaafcc4bdeca34a1cd673c697bca91eedd4850af1242')
INFO:sqlalchemy.engine.Engine:INSERT INTO post (author_id, created, title, body) VALUES (?, ?, ?, ?)
INFO sqlalchemy.engine.Engine:base.py:1844 INSERT INTO post (author_id, created, title, body) VALUES (?, ?, ?, ?)
INFO:sqlalchemy.engine.Engine:[generated in 0.00009s] (1, '2018-01-01 00:00:00.000000', 'test title', 'test\nbody')
INFO sqlalchemy.engine.Engine:base.py:1844 [generated in 0.00010s] (1, '2018-01-01 00:00:00.000000', 'test title', 'test\nbody')
INFO:sqlalchemy.engine.Engine:COMMIT
INFO sqlalchemy.engine.Engine:base.py:2691 COMMIT
INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
-------------------------------------------------- Captured log call ---------------------------------------------------
INFO:sqlalchemy.engine.Engine:SELECT user.id, user.username, user.password_hash
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:1844 SELECT user.id, user.username, user.password_hash
FROM user
FROM user
WHERE user.username = ?
WHERE user.username = ?
INFO:sqlalchemy.engine.Engine:[generated in 0.00009s] ('test',)
INFO sqlalchemy.engine.Engine:base.py:1844 [generated in 0.00016s] ('test',)
INFO:sqlalchemy.engine.Engine:ROLLBACK
INFO sqlalchemy.engine.Engine:base.py:2688 ROLLBACK
INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO:sqlalchemy.engine.Engine:SELECT user.id AS user_id, user.username AS user_username, user.password_hash AS user_password_hash
INFO sqlalchemy.engine.Engine:base.py:1844 SELECT user.id AS user_id, user.username AS user_username, user.password_hash AS user_password_hash
FROM user
FROM user
WHERE user.id = ?
WHERE user.id = ?
INFO:sqlalchemy.engine.Engine:[generated in 0.00009s] (1,)
INFO sqlalchemy.engine.Engine:base.py:1844 [generated in 0.00010s] (1,)
INFO:sqlalchemy.engine.Engine:ROLLBACK
INFO sqlalchemy.engine.Engine:base.py:2688 ROLLBACK
INFO:sqlalchemy.engine.Engine:BEGIN (implicit)
INFO sqlalchemy.engine.Engine:base.py:2685 BEGIN (implicit)
INFO:sqlalchemy.engine.Engine:SELECT user.id AS user_id, user.username AS user_username, user.password_hash AS user_password_hash
INFO sqlalchemy.engine.Engine:base.py:1844 SELECT user.id AS user_id, user.username AS user_username, user.password_hash AS user_password_hash
FROM user
FROM user
WHERE user.id = ?
WHERE user.id = ?
INFO:sqlalchemy.engine.Engine:[cached since 0.006167s ago] (1,)
INFO sqlalchemy.engine.Engine:base.py:1844 [cached since 0.06136s ago] (1,)
INFO:sqlalchemy.engine.Engine:INSERT INTO post (author_id, created, title, body) VALUES (?, ?, ?, ?)
INFO sqlalchemy.engine.Engine:base.py:1844 SELECT post.id AS post_id, post.author_id AS post_author_id, post.created AS post_created, post.title AS post_title, post.body AS post_body
INFO:sqlalchemy.engine.Engine:[generated in 0.00013s] (1, '2023-09-02 15:04:47.237160', 'created', '')
FROM post
INFO:sqlalchemy.engine.Engine:COMMIT
WHERE ? = post.author_id
.
INFO sqlalchemy.engine.Engine:base.py:1844 [generated in 0.00009s] (1,)
INFO sqlalchemy.engine.Engine:base.py:1844 UPDATE post SET author_id=? WHERE post.id = ?
INFO sqlalchemy.engine.Engine:base.py:1844 [generated in 0.00007s] (None, 1)
INFO sqlalchemy.engine.Engine:base.py:2688 ROLLBACK
Saved diffs