Where can I find a list of the Flask SQLAlchemy Column types and options?
Documentation is directly perceived through the senses, but if you still wanna see it in commandline, try some IDE, or just type this:
(normally our db
is just SQLALCHEMY()
)
>>> print dir(sqlalchemy.types)
["ARRAY","BIGINT","BINARY","BLOB","BOOLEAN","BigInteger","Binary","Boolean","CHAR","CLOB","Concatenable","DATE","DATETIME","DECIMAL","Date","DateTime","Enum","FLOAT","Float","INT","INTEGER","Indexable","Integer","Interval","JSON","LargeBinary","MatchType","NCHAR","NULLTYPE","NUMERIC","NVARCHAR","NullType","Numeric","PickleType","REAL","SMALLINT","STRINGTYPE","SchemaType","SmallInteger","String","TEXT","TIME","TIMESTAMP","Text","Time","TypeDecorator","TypeEngine","Unicode","UnicodeText","UserDefinedType","VARBINARY","VARCHAR","Variant"]
I think you're looking for the Column and Data Types page in the documentation. A little HTML parsing gives:
- ARRAY
- BIGINT
- BINARY
- BLOB
- BOOLEAN
- BigInteger
- Boolean
- CHAR
- CLOB
- Concatenable
- DATE
- DATETIME
- DECIMAL
- Date
- DateTime
- Enum
- FLOAT
- Float
- INT
- INTEGER
- Integer
- Interval
- LargeBinary
- MatchType
- NCHAR
- NVARCHAR
- Numeric
- PickleType
- REAL
- SMALLINT
- SchemaType
- SmallInteger
- String
- TEXT
- TIME
- TIMESTAMP
- Text
- Time
- TypeDecorator
- TypeEnginBases
- TypeEngine
- Unicode
- VARBINARY
- VARCHAR