I’m reading about sqlalchemy and I saw following code:
employees_table = Table(’employees’, metadata,
Column(’employee_id’, Integer, primary_key=True),
Column(‘name’, String(50)),
Column(‘manager_data’, String(50)),
Column(‘engineer_info’, String(50)),
Column(‘type’, String(20), nullable=False)
)
employee_mapper = mapper(Emplo….
A tags column has values like “apple banana orange” and “strawberry banana lemon”. I want to find the SQLAlchemy equivalent statement to
SELECT * FROM table WHERE tags LIKE “%banana%”;
What should I pass to Class.query.filter() to do this?
….
According to the documentation and the comments in the sqlalchemy.Column class, we should use the class sqlalchemy.schema.Index to specify an index that contains multiple columns.
However, the example shows how to do it by directly using the Table object like this:
meta = MetaData()
mytable = Table(‘mytable’, meta,
# an indexed column, with in….
I’ve been trying to figure out how to iterate over the list of columns defined in a SQLAlchemy model. I want it for writing some serialization and copy methods to a couple of models. I can’t just iterate over the obj.__dict__ since it contains a lot of SA specific items.
Anyone know of a way to just get the id and desc names from the following?
c….
When I try SQLAlchemy Relation Example following this guide: Basic Relationship Patterns
I have this code
#!/usr/bin/env python
# encoding: utf-8
from sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, ForeignKey
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy.ext.declarative import declarative_bas….
I have an ORM class called Person, which wraps around a person table:
After setting up the connection to the db etc, I run the statement:
people = session.query(Person).all()
The person table does not contain any data (as yet), so when I print the variable people, I get an empty list.
I renamed the table referred to in my ORM class People, to peo….
How do I delete all rows in a single table using Flask-SQLAlchemy?
Looking for something like this:
>>> users = models.User.query.all()
>>> models.db.session.delete(users)
# but it errs out: UnmappedInstanceError: Class ‘__builtin__.list’ is not mapped
….
I don’t have much experience with SQLAlchemy and I have a problem, which I can’t solve. I tried searching and I tried a lot of code.
This is my Class (reduced to the most significant code):
class Patient(Base):
__tablename__ = ‘patients’
id = Column(Integer, primary_key=True, nullable=False)
mother_id = Column(Integer, ForeignKey(‘pati….
I’m using Flask-SQLAlchemy to query from a database of users; however, while
user = models.User.query.filter_by(username=”ganye”).first()
will return
doing
user = models.User.query.filter_by(username=”GANYE”).first()
returns
None
I’m wondering if there’s a way to query the database in a case insensitive way, so that the second ….
Just a quick question: SQLAlchemy talks about calling sessionmaker() once but calling the resulting Session() class each time you need to talk to your DB. For me that means the second I would do my first session.add(x) or something similar, I would first do
from project import Session
session = Session()
What I did until now was to make the call ….