Hi John, I ended up reading about using sqlalchemy, thanks for getting back to me though! On Fri, Sep 30, 2016 at 8:57 AM, John Chilton <jmchilton@gmail.com> wrote:
Is this something inside the application or external to it? If it is external to the application - I'd probably just target the database directly (Postgres or MySQL). The internals of Galaxy use sqlalchemy for the most part (http://www.sqlalchemy.org/). I've done a lot with the database but I've never really read a tutorial on sqlalchemy - I just find something close in the code and hack on that pattern.
The are a lot of examples in the code of using sqlalchemy - if you want an example of like using postgres directly - here is one:
https://github.com/galaxyproject/galaxy/blob/dev/scripts/cleanup_datasets/ pgcleanup.py
-John
On Tue, Sep 6, 2016 at 9:13 AM, Katherine Beaulieu <katherine.beaulieu014@gmail.com> wrote:
Hello Everyone, I am trying to create a query to modify a value from a table in the galaxy database, but don't quite know what this language is that is being used to modify the database. The only command I know of are sa_session.add and sa_session.flush. Any help would be really appreciated! Katherine
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/