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/