This does not work – the update has no effect: Switching the statements performs the update and select successfully: Why does the first not work? It works in Pgadmin. I enabled autocommit with Flask-Sqlalchemy. I am doing a workshop on SQL injection, so please dont rewrite the solution! Answer The way SQLAlch…
Tag: sqlalchemy
sqlalchemy.exc.DataError: (psycopg2.DataError) value too long for type character varying
I Try to save a hashed Password in postgresql database using SQL Alchemy. table script is: and this is the mapping: when i try to insert data, this exception raised : but as you see data is exactly fit too field and there is no error when i execute this query inside pgadmin! I think problem is in my mapping.
generating drop down list of users in database using wtforms and sqlalchemy
I am trying to generate a drop down list of all the users in my database so I can assign admins later that can edit their information. I keep getting the following error from my template: views.py forms.py models.py mobility_add_users.html More of the error readback I’m still new to this so please go ea…
why UniqueConstraint doesn’t work in flask_sqlalchemy
I want an alternative of Django’s unique_together in flask, seems UniqueConstraint is what I’m looking for, but doesn’t work for me. here is the example: Test it: I also tried with: not work either, what’s wrong with it? Answer An instance of UniqueConstraint is iterable and in this ca…
Create a Full Text Search index with SQLAlchemy on PostgreSQL
I need to create a PostgreSQL Full Text Search index in Python with SQLAlchemy. Here’s what I want in SQL: Now how do I do the second part with SQLAlchemy when using the ORM: Answer You could create index using Index in __table_args__. Also I use a function to create ts_vector to make it more tidy and r…
sqlalchemy dynamic filtering
I’m trying to implement dynamic filtering using SQLAlchemy ORM. I was looking through StackOverflow and found very similar question:SQLALchemy dynamic filter_by It’s useful for me, but not enough. So, here is some example of code, I’m trying to write: then I’m trying to reuse it with s…
has no attribute validate_on_submit: How to use wtforms-alchemy’s ModelForm in a flask handler / view
I’m trying to switch from wtforms.ext.sqlalchemy.orm import model_form to using wtforms_alchemy ModelForm: I’m failing miserably… and I’ve been unsuccessful searching for a working example of that uses wtforms_alchemy which shows both the handler and the model. Using model_form works f…
pandas to_sql all columns as nvarchar
I have a pandas dataframe that is dynamically created with columns names that vary. I’m trying to push them to sql, but don’t want them to go to mssqlserver as the default datatype “text” (can anyone explain why this is the default? Wouldn’t it make sense to use a more common dat…
Write Large Pandas DataFrames to SQL Server database
I have 74 relatively large Pandas DataFrames (About 34,600 rows and 8 columns) that I am trying to insert into a SQL Server database as quickly as possible. After doing some research, I learned that the good ole pandas.to_sql function is not good for such large inserts into a SQL Server database, which was th…
flask-admin form: Constrain Value of Field 2 depending on Value of Field 1
One feature I have been struggling to implement in flask-admin is when the user edits a form, to constrain the value of Field 2 once Field 1 has been set. Let me give a simplified example in words (the actual use case is more convoluted). Then I will show a full gist that implements that example, minus the &#…