I am using SQLAlchemy and PostgreSQL, and I am trying to create a case-insensitive unique constraint that works like this UniqueConstraint( 'country', 'organisation_id', func.lower(func.trim('name')), name='uq_country_orgid_lower_trim_name' ) Ensuring a unique combination of name, country and organisation id, regardless of case and…
I am trying to select a segment if: settings dict is not null Has key user_parameters in it And user_parameters (dict) has key user_id in it Code below: user_id = '100952' select([self.db.segments]).where( and_( self.db.segments.c.settings.isnot(None), cast(self.db.segments.c.settings, JSON)["user_parameters"].as_string().contains(f"'{user_id}'"), ) ) Converting JSON…
I keep getting the error: Uncaught SyntaxError: missing ) after argument list (at bestellen:60:105) this is my html: <div class="gerechten"> {% for gerecht in gerechten %} <div class="Gerechtdiv"> <img src={{gerecht.url}} class="gerechtimg"> <h3 class="GerechtTitel">{{gerecht.gerecht}}</h3> <p class ="GerechtBeschrijving">{{gerecht.beschrijving}}</p> <div class ="BottomGerechtDiv"> <p…
I have a table called Gerechten with the columns: id, gerecht, beschrijving, categorie, prijs, url and sterren. In this table i have a lot of rows, so i used a jinja loop in the html script to loop through every…
I have a query such as: select_query = [text(f) for f in fields] with engine.connect() as conn: query = select(*select_query, MyTable.id).select_from( table(MyTable.__tablename__) ... Everything works fine except when the field (inside select_query) is camelcase. Is there any function or directive…
I'm building a simple To-Do List app in Flask, and I've created a form that's supposed to add a task within a user's account. Flask Form: class AddTask(FlaskForm): title = StringField('Title', validators = [DataRequired()]) description = StringField('Description') project = SelectField('Project',…
So, I want an object that will have background image assigned from database. I have found some solutions but none of them had part that would get image from database. This is how I set regular image: <img src="{{url_for('static', filename='images/'…
I have a problem with my connection between my flask app using flask-sqlalchemy and my database container, i want to make a compose project. I'm currently using Python3 Flask and MySQL as my database, im trying to connect both containers…
I am working on a simple CRUD application and I can't return an array of objects in Flask. My db Model is like this: class QrRecord(db.Model): id = db.Column(db.String(256), primary_key=True) name = db.Column(db.String(128), nullable=False) date = db.Column(db.Date, nullable=False) qrType =…
Table structure image The column amount of table is type of Float datatype. when I'm inserting a new record with the amount value 999999999 it gets automatically converted to 1000000000.0 I'm using Python3.10.2, Flask 2.2.2, Flask-SQLAlchemy 3.0.2, Flask-Migrate 4.0.0 and…