RicterZ / BGmi

BGmi is a cli tool for subscribed bangumi.
https://bgmi.ricterz.me
387 stars 72 forks source link

bug fix for losing colomn in script.scripts #93

Closed trim21 closed 6 years ago

trim21 commented 7 years ago
  File "bgmi\controllers.py", line 211, in cal
    website.bangumi_calendar(force_update=ret.force_update, today=ret.today, save=not ret.no_save)
  File "bgmi\website\base.py", line 130, in bangumi_calendar
    patch_list = runner.get_models_dict()
  File "bgmi\script.py", line 48, in get_models_dict
    return [dict(script.Model()) for script in self.scripts if script.bangumi_name is not None]
  File "bgmi\script.py", line 113, in __init__
    s.save()
  File "bgmi\models.py", line 352, in save
    self.cursor.execute(sql, _v)
sqlite3.OperationalError: table scripts has no column named updated_time

应该是sql.py

CREATE_TABLE_SCRIPT = '''CREATE TABLE IF NOT EXISTS scripts (
          id INTEGER PRIMARY KEY  AUTOINCREMENT,
          bangumi_name TEXT UNIQUE NOT NULL,
          episode INTEGER DEFAULT 0,
          status INTEGER DEFAULT 1
        )'''

漏掉了updated_time INTEGER DEFAULT 0 (居然不是直接复制的CREATE_TABLE_FOLLOWED,难道这是个feature?)