Tagged Questions
0
votes
1answer
26 views
sqlalchemy update not commiting changes to database. Using single connection in an app
I'm using sqlalchemy in a pyqt desktop application. When I execute and update to the database the changes are not reflected in the database, if I inspect the session object ...
0
votes
0answers
19 views
sqlalchemy and untrusted requests
I am looking for a way to provide python modules access to a SQL database through an interface (aka agent). This agent ought to garantuee, that these modules execute its requests only to a predefined ...
0
votes
0answers
20 views
Subclass of declarative_base cannot be garbage collected?
I am learning sqlalchemy and want to use it in my project. Because my project involve a tree structure and a lot of nodes, I want to free the memory after the object is persisted in the DB.
But when ...
0
votes
1answer
16 views
SQLAlchemy: Single Table Inheritance, same column in childs
Im currently mapping a class hierarchy using the single table inheritance strategy (it is not possible for me to use joined). This hierarchy might look like this:
class Parent(Base):
...
2
votes
1answer
43 views
Identical databases in Flask-SQLAlchemy
I've already asked a similar question, but I thought maybe I could rephrase it, or show what I've done further to shed some light onto what's going on here.
Currently I have 2 identical databases, ...
0
votes
2answers
50 views
SqlAlchemy: Join onto another object
My little website has a table of comments and a table of votes. Each user of the website gets to vote once on each comment.
When displaying comments to the user, I will select from the comments table ...
0
votes
1answer
15 views
SQLAlchemy Mass-Column Creation
So I have an interesting use case for declarative SQLAlchemy: I need to define about ten different sqlalchemy classes that have several hundred columns each. However, these objects will be essentially ...
0
votes
1answer
25 views
SQLalchemy hierarchical hybrid-transformation
BASED on http://docs.sqlalchemy.org/ru/latest/orm/extensions/hybrid.html#hybrid-transformers
Hello fellow sqlalchemy coders!
I have a data of the form:
from sqlalchemy import Column, Integer, ...
0
votes
1answer
257 views
How do I create self-relationships in polymorphic inheritance in Elixir and Pylons?
I am new to programming and am following the example in the Pylons documentation on creating a Wiki. The database I want to link to the wiki was created with Elixir so I rewrote the Wiki database ...
0
votes
1answer
142 views
Using Elixir, how can I get the table object of a self-referential relationship to perform inserts on?
I'm using Elixir with SQLite and I'd like to perform multiple inserts as per the docs:
http://www.sqlalchemy.org/docs/05/sqlexpression.html#executing-multiple-statements
However, my ManyToMany ...
2
votes
1answer
479 views
Deleting rows in a ManyToMany intermediate table
I have two tables with a ManyToMany relation between them. Sometimes I need to refresh the
database so I delete elements from both tables. However relations between deleted rows are still stored ...
0
votes
1answer
618 views
Elixir create_all() not creating database and tables
Hey,
I'm using Elixir 0.7.1 , Sqlalchemy 0.6beta1 , MySQLdb 1.2.2.
My Model file 'model.py' looks like this:
from elixir import *
from datetime import datetime
class Author:
first_name = ...
1
vote
1answer
139 views
In Elixir or SQLAlchemy, is there a way to also store a comment for a/each field in my entities?
Our project is basically a web interface to several systems of record. We have many tables mapped, and the names of each column aren't as well named and intuitive as we'd like... The users would like ...
1
vote
3answers
1k views
Sqlalchemy+elixir: How query with a ManyToMany relationship?
I'm using sqlalchemy with Elixir and have some troubles trying to make a query..
I have 2 entities, Customer and CustomerList, with a many to many relationship.
customer_lists_customers_table = ...
5
votes
5answers
3k views
Execute sql query with Elixir
I'm using Elixir in a project that connects to a postgres database. I want to run the following query on the database I'm connected to, but I'm not sure how to do it as I'm rather new to Elixir and ...
