I generated my sqlite db above using flaminsarge's version straight off his Github page. The only change I had to do in tf2db.py was to add a null check for the item name at line 183 before the execute:
Code:
if i.get('item_name') is None:
continue
dbc.execute('INSERT INTO new_tf2idb_item ' # ...
Alternatively, you can remove NOT NULL from the table definition on line 78:
Code:
dbc.execute('CREATE TABLE "new_tf2idb_item" ('
'"id" INTEGER PRIMARY KEY NOT NULL,'
'"name" TEXT NOT NULL,'
'"item_name" TEXT,' # <--- Right here
'"class" TEXT NOT NULL,'
'"slot" TEXT,'
'"quality" TEXT NOT NULL,'
'"tool_type" TEXT,'
'"min_ilevel" INTEGER,'
'"max_ilevel" INTEGER,'
'"baseitem" INTEGER,'
'"holiday_restriction" TEXT,'
'"has_string_attribute" INTEGER,'
'"propername" INTEGER'
')'
)
__________________