Multiple foreign keys to same table using Elixir

Posted by Suvir on Stack Overflow See other posts from Stack Overflow or by Suvir
Published on 2010-04-09T07:11:22Z Indexed on 2010/04/09 7:13 UTC
Read the original article Hit count: 362

Filed under:

elixir

|

orm

|

sqlalchemy

Hello,

I am new to ORMs in general. I have a table (lets call it Entity) with columns --

ID
expression
type ( can be 'long_word', 'short_word' or 'sentence' )

Often, the first two types occur in a 'sentence', so, I want to maintain another table which maps 'Sentences' to 'long_word' or 'short_word' using the 'ID' field.

All i need is another table with 2 'Integer fields' referring to 'ID' as a foreign key.

But, how do i do this in Elixir?

Thanks a lot...

© Stack Overflow or respective owner

Related posts about elixir

Multiple foreign keys to same table using Elixir

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am new to ORMs in general. I have a table (lets call it Entity) with columns -- ID expression type ( can be 'long_word', 'short_word' or 'sentence' ) Often, the first two types occur in a 'sentence', so, I want to maintain another table which maps 'Sentences' to 'long_word' or 'short_word'… >>> More
Sqlalchemy+elixir: How query with a ManyToMany relationship?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, 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 = Table('customer_lists_customers', metadata, Column('id'… >>> More
How do I create self-relationships in polymorphic inheritance in Elixir and Pylons?

as seen on Stack Overflow - Search for 'Stack Overflow'
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 schema and have continued from there. In the wiki there is a requirement for a Navigation table which… >>> More
In Elixir or SQLAlchemy, is there a way to also store a comment for a/each field in my entities?

as seen on Stack Overflow - Search for 'Stack Overflow'
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 to know what data fields are available (i.e. what's been mapped from the database). But, it's pointless… >>> More
strange SqlAlchemy update behaviour

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm new to SqlAlchemy and Elixir, so I've started from tutorial and tried to create table, insert a record, and then update it as follows: #'elixir_test.py' from elixir import * metadata.bind = "postgresql://myuser:mypwd@localhost:5432/dbname" metadata.bind.echo = True class Movie(Entity): … >>> More

Related posts about orm

Optimizations employed by ORM's

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm teaching JEE, especially JPA, Spring and Spring MVC. As I have not so much experience in large projects, it is difficult to know what to present to students about optimisation of ORM. At the present time, I present some classic optimisation tricks: prepared statements (most of ORM implicitely… >>> More
Which ORM to use with SQL Azure?

as seen on Stack Overflow - Search for 'Stack Overflow'
Just wondering what everyones thoughts on what ORM to use for SQL Azure? I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future… >>> More
PHP Doctrine ORM NestedSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, although I read through the manual here: http://www.doctrine-project.org/documentation/manual/1_2/hu/hierarchical-data I couldn't find a way to move a node from a Leaf to become a Root node. Any clues? The question is trivial for inserting a new node...but what about updating a node? >>> More
PHP PSR-0 + several namespaces in one file and autoload

as seen on Programmers - Search for 'Programmers'
I've been thinking for a while about defining several namespaces in one php file and so, having several classes inside this file. Suppose, I want to implement something like Doctrine\ORM\Query\Expr: Expr.php Expr |-- Andx.php |-- Base.php |-- Comparison.php |-- Composite.php |-- From.php |-- Func… >>> More
FOSUserBundle override mapping to remove need for username

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to remove the need for a username in the FOSUserBundle. My users will login using an email address only and I've added real name fields as part of the user entity. I realised that I needed to redo the entire mapping as described here. I think I've done it correctly but when I try to submit… >>> More