From edbad479285e84b28d431d1f8714f8660070bfd5 Mon Sep 17 00:00:00 2001 From: Bernd Schlapsi Date: Tue, 24 Aug 2010 18:03:05 +0200 Subject: [PATCH] Add "not null" and "default" to upgrade function (bug 1127) --- src/gpodder/dbsqlite.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/src/gpodder/dbsqlite.py b/src/gpodder/dbsqlite.py index d9d48f88..0ed221c0 100644 --- a/src/gpodder/dbsqlite.py +++ b/src/gpodder/dbsqlite.py @@ -662,10 +662,13 @@ class Database(object): else: existing = set(column[NAME] for column in available) - for field_name, field_type, field_null, field_default in fields: + for field_name, field_type, field_required, field_default in fields: if field_name not in existing: log('Adding column: %s.%s (%s)', table_name, field_name, field_type, sender=self) - cur.execute("ALTER TABLE %s ADD COLUMN %s %s" % (table_name, field_name, field_type)) + sql = "ALTER TABLE %s ADD COLUMN %s %s" % (table_name, field_name, field_type) + if field_required: + sql += " NOT NULL DEFAULT %s" % (field_default) + cur.execute(sql) for column, typ in index_list: cur.execute('CREATE %s IF NOT EXISTS idx_%s ON %s (%s)' % (typ, column, table_name, column)) -- 2.11.4.GIT