def test_create_and_fetch(): conn = connect() store = NoteStore(conn) note = Note(None, "title", "content") store.create(note) assert note.note_id is not None assert note.title == "title" assert note.content == "content" from_db = store.fetch(note.note_id) assert from_db.note_id == note.note_id assert from_db.title == note.title assert from_db.content == note.content
def test_delete(): conn = connect() store = NoteStore(conn) note = Note(None, "title", "content") store.create(note) assert store.fetch(note.note_id) is not None store.delete(note.note_id) assert store.fetch(note.note_id) is None
def test_update(): conn = connect() store = NoteStore(conn) note = Note(None, 'title', 'content') store.create(note) note.title = "Better Title" note.content = "Better Content" store.update(note) from_db = store.fetch(note.note_id) assert from_db.title == "Better Title" assert from_db.content == "Better Content"
def test_fetch_all(): conn = connect() store = NoteStore(conn) first = Note(None, "a", "ac") store.create(first) second = Note(None, "b", "bc") store.create(second) all_notes = store.fetch_all() assert len(all_notes) == 2 assert all_notes[0].note_id == first.note_id assert all_notes[0].title == first.title assert all_notes[0].content == first.content assert all_notes[1].note_id == second.note_id assert all_notes[1].title == second.title assert all_notes[1].content == second.content
def test_returns_none_when_no_note_was_found(): conn = connect() store = NoteStore(conn) assert store.fetch(555) is None