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), ...
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...
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...
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! ...
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? ...
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...
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...
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...
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 =...
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...
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. ...
... vs declarative sqlalchemy ? ...
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 ...
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 ...
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...