Python Freelancers

I have issues with my code, trying to setup SQLAlchemy database in flask using python. Code: Thanks… Read more Sqlalchemy Adds Significant Overload. Sqlalchemy Object Has No Attribute 'datetime

I'm tyring to recreate this query in SQL Alchamey but I've been unable to nest the filters:… Read more How To Nest Conjunctions Or_ And And_ In Sqlalchamey

My Flask app(postgresql db) is working fine in local. I pushed my code to server and there I tried … Read more Sqlalchemy.exc.operationalerror: (psycopg2.operationalerror)

I have a model Region and each Region can have sub-regions. Each sub-region has a field parent_id w… Read more Unable To Create Self Referencing Foreign Key In Flask-sqlalchemy

So here's my problem: I created a heroku app that is working as expected, although when the app… Read more Added Database Records Are Deleted After Restarting App (heroku/sqlalchemy)

The SQLAlchemy provides the Connection.execution_options.schema_translate_map for change the schema… Read more Flask-sqlalchemy How To Use Create_all With Schema_translate_map

I'm getting this error sometime (sometime is ok, sometime is wrong): sqlalchemy.exc.Operational… Read more Mysql Connection Not Available When Use Sqlalchemy(mysql) And Flask

I am using sqlalchemy and flask-sqlalchemy, one of my db model comes with a state column class Item… Read more How Can Sqlalchemy Work With Custom Class As The Attributes

I have the following class for a table in SQLalchemy class STDcodes(db.Model): id = db.Column(db.In… Read more Getting Errors With Passing Parameters With Fliter_by Function In Sqlalchemy

I have been using django's ORM and sqlalchemy has me beat a.t.m. I have this: recipie_voters = … Read more Sqlalchemy Count Related

I have two tables( location and country ) that am trying to query; which are represented by the mod… Read more Filtering After A Join In Flask-sqlalchemy

I have read quite a bit of documentation and I can't see what is wrong with these lines update_… Read more Update State With Flask Sqlalchemy With Postgres Will Not Commit To Database

Am doing a project with Flask, Gevent and web socket using flask development server environment. I … Read more Flask-login - How To Get Session Id

The PostgreSQL ON CONFLICT clause in INSERT statements provides 'upsert' functionality (i.e… Read more How To Use Postgresql's "insert...on Conflict" (upsert) Feature With Flask_sqlalchemy?

So I am building a query based on user input in flask with this code: if empty_indic_form.valid… Read more Typeerror: 'dict' Object Does Not Support Indexing Thrown On Second Instance Of This Query

I have a set of dynamic database tables (Postgres 9.3 with PostGIS) that I am mapping using a pytho… Read more Sqlalchemy Reflection Using Metaclass With Column Override

I am writing a Flask app and I am using elasticsearch. Here is search.py: from flask import current… Read more How Do I Tell An Elasticsearch Multi-match Query That I Want Numeric Fields, Stored As Strings, To Return Matches With Numeric Strings?

I need to create a table called friends, it should looks like: friends: user_id friend_id I was t… Read more How To Create Relationship Many To Many In Sqlalchemy (python, Flask) For Model User To Itself

I'm trying out Flask but I'm having the error sqlalchemy.exc.InterfaceError: while submitt… Read more Sqlalchemy.exc.interfaceerror:

I'm trying to do a where clause in reverse order with SQLAlchemy ORM. So instead of Table.query… Read more How Do I Express "where 'value' Like Column" In Sqlalchemy?