<stdin>

ijontichy@powernoob ~http/forum $ ./index.py
  coldefs is: OrderedDict([('id', 'id integer primary key autoincrement'), ('author', 'author text'), ('topic', 'topic text'), ('content', 'content text not null'), ('image', 'image blob')])
  colkeys is: ['id', 'author', 'topic', 'content', 'image']
  colstr is:  id integer primary key autoincrement, author text, topic text, content text not null, image blob
    table forum_posts found
  colDict is: {'topic': 'text', 'id': 'integer primary key autoincrement', 'image': 'blob', 'author': 'text', 'content': 'text not null'}
  finding "id" in table... found, "integer primary key autoincrement" (expected) vs "integer primary key autoincrement" (actual)
  finding "author" in table... found, "text" (expected) vs "text" (actual)
  finding "topic" in table... found, "text" (expected) vs "text" (actual)
  finding "content" in table... found, "text not null" (expected) vs "text not null" (actual)
  finding "image" in table... found, "blob" (expected) vs "blob" (actual)

  coldefs is: OrderedDict([('id', 'id integer primary key autoincrement'), ('postnum', 'postnum integer')])
  colkeys is: ['id', 'postnum']
  colstr is:  id integer primary key autoincrement, postnum integer
    table forum_topics found
  colDict is: {'postnum': 'integer', 'id': 'integer primary key autoincrement'}
  finding "id" in table... found, "integer primary key autoincrement" (expected) vs "integer primary key autoincrement" (actual)
  finding "postnum" in table... found, "integer" (expected) vs "integer" (actual)

insert into forum_posts (author, topic, content) values (?, ?, ?)
30
[(1, 'DICKS IN A BLENDER 21', '', '', None), (2, 'DICKS IN A BLENDER 627', '', '', None), (3, 'DICKS IN A BLENDER 504', '', '', None), (4, 'DICKS IN A BLENDER 104', '', '', None), (5, 'DICKS IN A BLENDER 961', '', '', None), (6, 'DICKS IN A BLENDER 85', '', '', None), (7, 'DICKS IN A BLENDER 333', '', '', None), (8, 'DICKS IN A BLENDER 371', '', '', None), (9, 'DICKS IN A BLENDER 240', '', '', None), (10, 'DICKS IN A BLENDER 183', '', '', None), (11, 'DICKS IN A BLENDER 884', '', '', None), (12, 'DICKS IN A BLENDER 381', '', '', None), (13, 'DICKS IN A BLENDER 849', '', '', None), (14, 'DICKS IN A BLENDER 887', '', '', None), (15, 'DICKS IN A BLENDER 248', '', '', None), (16, 'DICKS IN A BLENDER 305', '', '', None), (17, 'DICKS IN A BLENDER 253', '', '', None), (18, 'DICKS IN A BLENDER 255', '', '', None), (19, 'DICKS IN A BLENDER 999', '', '', None), (20, 'DICKS IN A BLENDER 477', '', '', None), (21, 'DICKS IN A BLENDER 818', '', '', None), (22, 'DICKS IN A BLENDER 322', '', '', None), (23, 'DICKS IN A BLENDER 410', '', '', None), (24, 'DICKS IN A BLENDER 666', '', '', None), (25, 'DICKS IN A BLENDER 656', '', '', None), (26, 'DICKS IN A BLENDER 245', '', '', None), (27, 'DICKS IN A BLENDER 216', '', '', None), (28, 'DICKS IN A BLENDER 974', '', '', None), (29, 'DICKS IN A BLENDER 963', '', '', None), (30, 'DICKS IN A BLENDER 972', '', '', None)]
[(2, 'DICKS IN A BLENDER 627', '', '', None)]