From bf567438a9720c18f7e0045f4b198cf143fa7053 Mon Sep 17 00:00:00 2001
From: zlg <zlg@zlg.space>
Date: Tue, 9 Oct 2018 23:30:29 -0700
Subject: update_game: ensure notes are also saved

---
 src/vgstash/__init__.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src')

diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py
index ee07c78..e3ede03 100755
--- a/src/vgstash/__init__.py
+++ b/src/vgstash/__init__.py
@@ -308,9 +308,9 @@ class DB(object):
             c = self.conn.cursor()
             # TODO: do this better
             c.execute("UPDATE games\
-                    SET title=?, system=?, ownership=?, progress=?\
+                    SET title=?, system=?, ownership=?, progress=?, notes=?\
                     WHERE title=? AND system=?",
-                    (source.title, source.system, source.ownership, source.progress, target.title, target.system))
+                    (source.title, source.system, source.ownership, source.progress, source.notes, target.title, target.system))
             self.conn.commit()
             return (c.rowcount > 0)
         else:
-- 
cgit v1.2.3-54-g00ecf

lass='tabs'><tr><td>
<a href='/knr/about/'>about</a><a href='/knr/'>summary</a><a href='/knr/refs/?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767'>refs</a><a class='active' href='/knr/log/ch1/1-07_eof-value.c?follow=1'>log</a><a href='/knr/tree/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767'>tree</a><a href='/knr/commit/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;follow=1'>commit</a><a href='/knr/diff/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;follow=1'>diff</a></td><td class='form'><form class='right' method='get' action='/knr/log/ch1/1-07_eof-value.c'>
<input type='hidden' name='id' value='41d86a29051af9e3b5fe7e37bd4c0c0a18993767'/><select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/knr/log/?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;follow=1'>root</a>/<a href='/knr/log/ch1?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;follow=1'>ch1</a>/<a href='/knr/log/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;follow=1'>1-07_eof-value.c</a> (<a href='/knr/log/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767'>unfollow</a>)</div><div class='content'><table class='list nowrap'><tr class='nohover'><th class='left'>Age</th><th class='left'>Commit message (<a href='/knr/log/ch1/1-07_eof-value.c?id=41d86a29051af9e3b5fe7e37bd4c0c0a18993767&amp;showmsg=1&amp;follow=1'>Expand</a>)</th><th class='left'>Author</th><th class='left'>Files</th><th class='left'>Lines</th></tr>
<tr><td><span title='2022-01-09 16:41:26 -0800'>2022-01-09</span></td><td><a href='/knr/commit/ch8/syscalls.h?id=2b68c3d06fb2961ae3797d1ef461cff655f328b2&amp;follow=1'>Refactor syscalls.h for ch8 exercises</a></td><td>zlg</td><td>3</td><td><span class='deletions'>-117</span>/<span class='insertions'>+234</span></td></tr>
<tr><td><span title='2018-12-22 01:23:35 -0800'>2018-12-22</span></td><td><a href='/knr/commit/ch8/8-02_syscalls.h?id=4ad4e6c7f6d2fb414d22dd3e55801c85b02c1af7&amp;follow=1'>Solve Exercise 8-2: fopen and fillbuf</a></td><td>zlg</td><td>3</td><td><span class='deletions'>-0</span>/<span class='insertions'>+181</span></td></tr>
<tr><td><span title='2018-08-22 20:07:12 -0700'>2018-08-22</span></td><td><a href='/knr/commit/AUTHORS?id=963091b93c3330bd562df204fdd1a063efebc7c6&amp;follow=1'>AUTHORS: update contact info</a></td><td>zlg</td><td>1</td><td><span class='deletions'>-1</span>/<span class='insertions'>+1</span></td></tr>
<tr><td><span title='2017-05-20 22:48:50 -0700'>2017-05-20</span></td><td><a href='/knr/commit/ch8/8-01_cat-remastered.c?id=f3e194ceb2405d2063501bd46b270d988931d36b&amp;follow=1'>perfeeerrrrrm</a></td><td>zlg</td><td>1</td><td><span class='deletions'>-1</span>/<span class='insertions'>+1</span></td></tr>
<tr><td><span title='2017-05-20 01:21:01 -0700'>2017-05-20</span></td><td><a href='/knr/commit/ch8/8-01_cat-remastered.c?id=3a80ead1cbe94d23205a490c8bf469feb5960f95&amp;follow=1'>8-1: Correct superfluous increment, comment</a></td><td>zlg</td><td>1</td><td><span class='deletions'>-2</span>/<span class='insertions'>+1</span></td></tr>