Hi Harenda,

I'll repeat what Hans has said - depending on what you're doing, this
could cause issues.  Depending on what you're doing, you may want to
look at our user template functionality, if you're storing extra data
about users.

If it's best to use an extra column on the user table, you should be
able to access that column by getting a user object in the interface and
accessing the column as an attribute on the object:

  user = sa_session.query( galaxy.model.User ).get( <user id> )
  user.new_column = value
  sa_session.add( user )
  sa_session.flush()

--nate

Hans-Rudolf Hotz wrote:
> Hi Harendra
> 
> Be very careful when you 'mess' with the database! And I would
> definitively refrain from changing the database schema, as this
> might very well cause problems in the future when you need to
> upgrade the schema as part of a Galaxy code update.
> 
> If you really need a changed 'galaxy_user' table, I suggest to set
> up a second database with a copy of this table and change it there.
> And when ever you need to access the extra column, connect to the
> other database.
> 
> 
> Anyway, your actual question was "how to add or modify data in a table?"
> 
> I am confused: you know the syntax for changing the schema of a
> table, but you don't know the syntax for manipulating the data of a
> table?
> 
> 
> You don't say, whether you are using PostgreSQL or MySQL, in case of
> MySQL, I recommend to read:
> 
> http://dev.mysql.com/doc/refman/5.1/en/update.html
> http://dev.mysql.com/doc/refman/5.1/en/insert.html
> 
> 
> Regards, Hans
> 
> 
> 
> On 05/20/2011 08:18 AM, Harendra chawla wrote:
> >Hi everyone,
> >
> >I have a specific requirement in which I have changed the schema of one
> >table in the database but I am not able find out the way to add the data
> >into the table.
> >Can anyone suggest where and how can i add or modify the data in the table.
> >For example there is a table named galaxy_user, if I will add an extra
> >column into that table then how and where can i add the data for that
> >column??
> >
> >Regards
> >Harendra
> >
> >
> >
> >
> >___________________________________________________________
> >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:
> >
> >   http://lists.bx.psu.edu/
> ___________________________________________________________
> 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:
> 
>  http://lists.bx.psu.edu/
___________________________________________________________
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:

  http://lists.bx.psu.edu/

Reply via email to