Where can I find a list of the Flask SQLAlchemy Column types and options?

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

Related Posts:

  1. How to update SQLAlchemy row entry?
  2. Flask-SQLalchemy update a row’s information
  3. SQLAlchemy ORDER BY DESCENDING?
  4. ImportError: No module named MySQLdb
  5. How to create a new database using SQLAlchemy?
  6. ValueError: setting an array element with a sequence
  7. ‘python’ is not recognized as an internal or external command [duplicate]
  8. Find the current directory and file’s directory [duplicate]
  9. Finding the index of an item in a list
  10. Python Error: AttributeError: __enter__ [duplicate]
  11. How to plot a histogram using Matplotlib in Python with a list of data?
  12. Convert pandas dataframe to NumPy array
  13. Fastest way to check if a value exists in a list
  14. TypeError: can’t multiply sequence by non-int of type ‘str’
  15. Error:cannot convert float NaN to integer in pandas
  16. What does the % sign mean in coding?
  17. Replacing column values in a pandas DataFrame
  18. How can I count the occurrences of a list item?
  19. Unable to plot Double Bar, Bar plot using pyplot for ndarray
  20. matplotlib error – no module named tkinter
  21. AttributeError: module ‘urllib3’ has no attribute ‘urlopen’ in python
  22. How to download a file over HTTP?
  23. filedialog, tkinter and opening files
  24. How do I get the row count of a Pandas DataFrame?
  25. Singular matrix issue with Numpy
  26. TypeError: ‘dict’ object is not callable
  27. What does “unsqueeze” do in Pytorch?
  28. Delete an element from a dictionary
  29. Change figure size and figure format in matplotlib
  30. How can I concatenate str and int objects?
  31. Python Calling Function from Another File
  32. error: Unable to find vcvarsall.bat
  33. Python: OverflowError: math range error
  34. Best way to replace multiple characters in a string?
  35. Convert base-2 binary number string to int
  36. setup script exited with error: command ‘x86_64-linux-gnu-gcc’ failed with exit status 1
  37. sublime text2 python error message /usr/bin/python: can’t find ‘__main__’ module in ”
  38. load csv into 2D matrix with numpy for plotting
  39. Python TypeError: cannot convert the series to when trying to do math on dataframe
  40. How do I do a case-insensitive string comparison?
  41. How to fix ‘ValueError: list.remove(x): x not in list’ error in Python
  42. How can I convert radians to degrees with Python?
  43. How to initialize a two-dimensional array in Python?
  44. How to configure logging to syslog in Python?
  45. Converting binary to decimal integer output
  46. Don’t understand this SyntaxError: illegal target for annotation
  47. No module named setuptools
  48. Using Queue in python
  49. Whats the difference between ‘for x in list:’ and ‘for x in list[:]:’
  50. Python: maximum recursion depth exceeded while calling a Python object
  51. Checking if a number is prime in Python
  52. Implementing an efficient queue in Python
  53. Modify the legend of pandas bar plot
  54. Python int to binary string?
  55. Full examples of using pySerial package
  56. Checking whether a variable is an integer or not
  57. Using headers with the Python requests library’s get method
  58. How to measure elapsed time in Python?
  59. Pandas DataFrame: replace all values in a column, based on condition
  60. How to create a trie in Python
  61. How to convert string to datetime format in pandas python?
  62. TypeError: expected a character buffer object
  63. “RuntimeError: Make sure the Graphviz executables are on your system’s path” after installing Graphviz 2.38
  64. Convert date to datetime in Python
  65. UnicodeEncodeError: ‘ascii’ codec can’t encode character u’\xa0′ in position 20: ordinal not in range(128)
  66. How to install PyQt5 on Windows?
  67. How do I get the day of week given a date?
  68. TypeError: ‘dict_keys’ object does not support indexing
  69. Add Variables to Tuple
  70. Python: Converting string into decimal number
  71. Segmentation fault: 11 in OS X
  72. Removing duplicates from a list of lists
  73. plotly: TypeError: cannot convert dictionary update sequence element #0 to a sequence
  74. Update python dictionary (add another value to existing key)
  75. scrapy run spider from script
  76. Using replace() method in python by index
  77. Python, how to handle the “ValueError: unsupported pickle protocol: 4” error?
  78. python error: TypeError: an integer is required
  79. Process finished with exit code 139 (interrupted by signal 11: SIGSEGV)
  80. Get an attribute value based on the name attribute with BeautifulSoup
  81. Plot a histogram such that the total area of the histogram equals 1
  82. pip throws TypeError: parse() got an unexpected keyword argument ‘transport_encoding’ when trying to install new packages
  83. How to change legend size with matplotlib.pyplot
  84. An equivalent function to matplotlib.mlab.bivariate_normal
  85. MovieWriter ffmpeg unavailable; trying to use class ‘matplotlib.animation.PillowWriter’ instead
  86. How can I access global variable inside class in Python
  87. Sorting arrays in NumPy by column
  88. How to open html file?
  89. In Python, is there an elegant way to print a list in a custom format without explicit looping?
  90. “Python version 2.7 required, which was not found in the registry” error when attempting to install netCDF4 on Windows 8
  91. Does tkinter have a table widget?
  92. Releasing memory in Python
  93. Text progress bar in terminal with block characters
  94. Generator expression must be parenthesized if not sole argument
  95. Get a Try statement to loop around until correct value obtained
  96. Does python have header files like C/C++?
  97. Extracting specific selected columns to new DataFrame as a copy
  98. How to read a CSV file from a URL with Python?
  99. How to print both strings in a dictionary in Python
  100. Python: OSError: [Errno 2] No such file or directory: ”

Leave a Comment