elixir

Sqlalchemy+elixir: How query with a ManyToMany relationship?

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', Integer, primary_key=True), ...

dump csv from sqlalchemy

For some reason, I want to dump a table from a database (sqlite3) in the form of a csv file. I'm using a python script with elixir (based on sqlalchemy) to modify the database. I was wondering if there is any way to dump the table I use to csv. I've seen sqlalchemy serializer but it doesn't seem to be what I want. Am I doing it wrong? S...

SQLAlchemy & Complex Queries

I have to implement ACL for an existing application. So I added the a user, group and groupmembers table to the database. I defined a ManyToMany relationship between user and group via the association table groupmembers. In order to protect some ressources of the app (i..e item) I added a additional association table auth_items which s...

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 relationship is self-referential and I can't figure out where to get the insert() object from. Can anyone help? Thanks! ...

SQLAlchemy and Elixir?

I have been using django ORM, it's nice and very easy, but this time I'm doing a desktop app and I found SQLAlchemy, but I'm not sure to use it with Elixir. What do you think? is it really useful? ...

Elixir/SQLAlchemy equivalent to SQL "LIKE" statement?

I'm using the MySQLicious type schema described here for a simple tagging system. I've read some alternative implementations of tagging schema in 4 different SO threads, and this suits my needs best. A collection of entries have the tags "apple banana orange" and "strawberry banana lemon", and I'm trying to find the Elixir/SQLAlchemy eq...

Flex IBM ILOG (Elixir 3.0) Interactive map

I develop interactive map: user can zoom some area and place labels by mouse click. I am creating customSkin: <ibm:Scroller top="0" left="0" width="100%" height="100%" id="scroller" doubleClickEnabled="true" skinClass="com.ibm.ilog.elixir.skins.spark.ScrollerSkin"> <ibm:MapGroup id="mapGroup"> <ibm:MapFeatureGroup id="featureGroup" feat...

Is elixir out-dated?

My sqlalchemy is 0.6.3, and elixir is 0.7.1 I created a model class which extends Entity: from elixir import * class User(Entity): pass And save the a user as: user = User() user.save() It reports Session has no attribute 'save' I looked into the code of elixir, found it invokes sqlalchemy.org.session.Session#save(), but ther...

Elixir - deleting rows in a ManyToMany intermediate table

Hi, 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 inside the automatically created intermediary table. To clarify the problem, here is a small code: from elixir import * metadata.bind =...

Sharing model between Camelot and non-Camelot apps

I would like to share my data model between different Elixir/SQLAlchemy applications, one of which would be a Camelot UI and the others stuff like web interfaces and so on. They would all connect to the same underlying database. As far as I know, to build a Camelot app my model would do from camelot import blah and that would prevent it...

how to add new column on elixir

i use elixir as orm for mysql database,now i want to add new column to my schema,how could i keep orginal data in the mysql and update the schema automatically,the concept called migrate on ruby on rails,it seems i didn't found relevent infomation & code in sqlalchemy & elixir,any advice is welcome. ...

What are the benefits of using Elixir...

... vs declarative sqlalchemy ? ...

how to write udpate sql in python elixir

i'm using elixir as my orm for mysql database, and it's hard for me to write a update sql under elixir "update products set price=NULL where id>100" class Product(Entity): using_options(tablename='model_product') name = Field(Unicode(200)) en_name = Field(Unicode(200)) price ...

Loading Elixir/SQLAlchemy models in .NET?

A new requirement has come down from the top: implement 'proprietary business tech' with the awesome, resilient Elixir database I have set up. I've tried a lot of different things, such as creating an implib from the provided interop DLL (which apparently doesn't work like COM dlls) which didn't work at all. CPython doesn't like the MFC ...

Feedback for Camelot

Hello, My needs : I need to develop an GUI application that is cross platform the chosen solution must be the fastest to implement it should be easy to extend The application is just a database front-end, mainly for CRUD operations, listing, filtering, exporting, charts and graphs etc. After reading about some solutions (Python Car...