Re: [galaxy-dev] Modifying Values in the Database
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 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 > 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/ > ___ 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/
Re: [galaxy-dev] Modifying Values in the Database
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 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/ ___ 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/
[galaxy-dev] Modifying Values in the Database
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/
