On postgres, three databases are normally present by default. If you are able to connect as a superuser (eg, the postgres role), then you can connect to the postgres or template1 databases. The default pg_hba.conf permits only the unix user named postgres to use the postgres role, so the simplest thing is to just become that user. At any rate, create an engine as usual … Read more
Retrieve an object using the tutorial shown in the Flask-SQLAlchemy documentation. Once you have the entity that you want to change, change the entity itself. Then, db.session.commit(). For example: Flask-SQLAlchemy is based on SQLAlchemy, so be sure to check out the SQLAlchemy Docs as well.
If you’re having issues compiling the binary extension, or on a platform where you cant, you can try using the pure python PyMySQL bindings. Simply pip install pymysql and switch your SQLAlchemy URI to start like this: There are some other drivers you could also try.
Usage from @jpmc26
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 … Read more