Creating a table presents a DatsetException about dataset HOT 4 CLOSED

Sorry, this is really poorly documented. The reference to Text is to the SQLAlchemy object of that name, not the string literal. You can import it from sqlalchemy.types. I'll leave this open to improve the docs.

from dataset.

Considering that in the code at https://github.com/pudo/dataset/blob/master/dataset/persistence/database.py#L124

  if primary_type is 'Integer':
    auto_flag = False
    if primary_id is 'id':
      auto_flag = True
      col = Column(primary_id, Integer, primary_key=True, autoincrement=auto_flag)
  elif primary_type is 'Text':
    col = Column(primary_id, Text, primary_key=True)
  else:
    raise DatasetException(
      "The primary_type has to be either 'Integer' or 'Text'.")

you're comparing to strings, changing is to == would make the code function as specified in the documentation. And the alternative (If you want to use sqlalchemy.types) would be

primary_type is sqlalchemy.types.Integer

from dataset.

I'm sorry - I hadn't seen these type checks and only glanced over your ticket. Thanks for your thorough description and thanks @3onyc for the PR. Got to love open source :)

from dataset.

Thanks guys, that did the trick. 👍

from dataset.