<stdin>

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

    ensuring table forum_topics is valid
  coldefs is: OrderedDict([('id', 'id integer primary key autoincrement'), ('postnum', 'postnum integer unique not null'), ('topicnum', 'topicnum integer not null')])
  colkeys is: ['id', 'postnum', 'topicnum']
  colstr is:  id integer primary key autoincrement, postnum integer unique not null, topicnum integer not null
    table forum_topics found
  colDict is: {'topicnum': 'integer not null', 'postnum': 'integer unique not null', 'id': 'integer primary key autoincrement'}
  finding "id" in table... found
  finding "postnum" in table... found
  finding "topicnum" in table... found

  addPost: insert into forum_posts (author, topic, content) values (?, ?, ?)
added post at index: 16
  registerPost: select postnum from forum_topics where postnum = ?
  registerPost: found []
  registerPost: insert into forum_topics (postnum, topicnum) values (?, ?)
registered post 16 to topic 1: 13
  getTopic: select postnum from forum_topics where topicnum = ?
checked topic 1: [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16]
post 4: (4, 'DICKS IN A BLENDER 499', '', '', None, None)
post 5: (5, 'DICKS IN A BLENDER 485', '', '', None, None)
post 6: (6, 'DICKS IN A BLENDER 764', '', '', None, None)
post 7: (7, 'DICKS IN A BLENDER 86', '', '', None, None)
post 8: (8, 'DICKS IN A BLENDER 499', '', '', None, None)
post 9: (9, 'DICKS IN A BLENDER 824', '', '', None, None)
post 10: (10, 'DICKS IN A BLENDER 709', '', '', None, None)
post 11: (11, 'DICKS IN A BLENDER 540', '', '', None, None)
post 12: (12, 'DICKS IN A BLENDER 288', '', '', None, None)
post 13: (13, 'DICKS IN A BLENDER 904', '', '', None, None)
post 14: (14, 'DICKS IN A BLENDER 580', '', '', None, None)
post 15: (15, 'DICKS IN A BLENDER 973', '', '', None, None)
post 16: (16, 'DICKS IN A BLENDER 440', '', '', None, None)
well this works.