Python Column示例

示例#1

class TestFullText(Model):
  __tablename__ = 'TestFullText'
  client_id = Column(String(), primary_key=True)
  id = Column(String(), primary_key=True)
  title = Column(String(), analyze=True)
  text = Column(String(), analyze=True)
  published = Column(Bit())

示例#2

class TestFind(Model):
  __tablename__ = 'TestFind'
  client_id = Column(String(), primary_key=True)
  id = Column(String(), primary_key=True)
  first_name = Column(String())
  last_name = Column(String())
  email = Column(String())
  state = Column(String())
  locked = Column(Bit())
  created_on = Column(Date())
  updated_on = Column(Date())

示例#3

class TestDatabaseUpdate(Model):
  __tablename__ = 'TestDatabaseUpdate'
  id = Column(Integer(), primary_key=True)
  name = Column(String())

示例#4

class TestDatabaseInitializer(Model):
  __tablename__ = 'TestDatabaseInitializer'
  id = Column(Integer(), primary_key=True)
  name = Column(String())

示例#5

class TestDocumentWithDate(Model):
  __tablename__ = 'TestDocumentWithDate'
  id = Column(Integer(), autoincrement=True, primary_key=True)
  created_on = Column(Date())

示例#6

class TestDocumentWithGeneratedAttribute(Model):
  __tablename__ = 'TestDocumentWithGeneratedAttribute'
  id = Column(Integer(), generator=lambda: 1234567890, primary_key=True)

示例#7

class TestDocumentWithAutoIncrementPkey(Model):
  __tablename__ = 'TestDocumentWithAutoIncrementPkey'
  id = Column(Integer(), autoincrement=True, primary_key=True)
  name = Column(String(), nullable=False)