- galaxy-dev - lists.galaxyproject.org

Re: [galaxy-dev] Database locked errors
by Nate Coraor 20 Aug '09

20 Aug '09

SHAUN WEBB wrote: > Yes we are using SQLite. I will look in to switching to MySQL. I know a > few people have been discussing this lately, is there a wiki page > devoted to this? There are a few pages that contain most of the information, but I'm trying to consolidate all of this right now. > I found a few errors in the log from todays activity. I've attached a > few examples in a text file. The final error relates to the job that I > stopped in the admin section. As described, some of these "queued" > datasets are not associated with job ids. > > I am concerned that if I transfer all the information as is to a mySQL > database that I will still have the same problem. The locking issues will go away with a real database server, and thus these uncaught exceptions will go away. The ultimate result is that Galaxy won't lose track of jobs because of this. --nate

1 0

Database locked errors
by SHAUN WEBB 20 Aug '09

20 Aug '09

Hi, I'm having the following problems with our Galaxy server: This morning one of our users complained that Galaxy was crashing a lot, either: -The main page was coming up as an operational error page: Database Locked -The output history item returned an error "database is locked" -The output history item would appear to be waiting to run (grey box) but never complete This error is intermittent. I took a look at the manage jobs section on the admin page and found that all the jobs had a "new" status except one which had not been updated for over an hour and had a status of queued. I stopped this job from the admin page and after this the remaining jobs completed. However this doesn't seem to have solved the problem. I've taken a look at the database and as of today only, there are 11 datasets in the dataset table with a "queued" status. Some of these are associated with histories (and marked as deleted in hda table) and jobs (with an error status). The remaining 6 are associated with a history but not marked as deleted and there is no entry in the job_to_output_dataset table to associate these datasets with a job. I wonder if these datasets are causing the problem and galaxy is continually trying to resolve their queued status resulting in the "locked database" error. I'd be grateful if anyone can help with this or even shed some light on how the problem might have occurred and the processes galaxy uses to initiate jobs. Thanks Shaun Webb -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.

2 1

SGE Cluster suggestion
by Assaf Gordon 17 Aug '09

17 Aug '09

Hello, I'm trying to move our Galaxy to the our SGE cluster, and I need couple of fine-tuning tweaks. 1. set a project name (in addition to the queue) - globally, and per tool. 2. set extra QSUB options per tool 3. Specify the actual user who submitted the job - in the "email" field and as the job name. Details: The project name is needed for accounting (requested by our SGE admins). To specify a project name, add a fourth slash to the sge URL in universe_wsgi.ini, as so: --- ## Global SGE project name , for all tools default_cluster_job_runner = sge:////GalaxyProject/ ## Tool specific project name Cut1 = sge:////OtherGalaxyProject/ ---- The extra QSUB options per tool allow requesting nodes with more memory or request more cores (=threads) per job. To specify extra options, add a fifth slash to the sge tool runner URL in univer_wsge.ini, as so: ---- ## Tool specific parameters - ## run 'cut' on a node with at least 7GB of ram Cut1 = sge:////GalaxyProject/-l virtual_free=7G/ ## run 'select first lines' on a node with 4 cores, and reserve all the cores for the tool ## allowing multi-threaded 'select lines' operation ;) Show beginning1 = sge:////GalaxyProject/-R y -pe threads 4/ ---- Note: specifying extra parameters ALWAYS overrides the project name (but the project name can be an empty string). The actual user is needed to quickly see (with qstat) who runs what (currently, the job names are "galaxy_NNNN.sh"). Comments are welcomed, -gordon.

2 4

Re: [galaxy-dev] galaxy-dev Digest, Vol 44, Issue 22
by Ross 15 Aug '09

15 Aug '09

On Fri, Aug 14, 2009 at 1:14 PM, <galaxy-dev-request(a)bx.psu.edu> wrote: This is excellent - it seems very natural - another extremely compelling feature. Congratulations everyone! > Message: 4 > Date: Fri, 14 Aug 2009 13:14:02 -0400 > From: Greg Von Kuster <greg(a)bx.psu.edu> > Subject: [galaxy-dev] [hg] galaxy 2558: Integrate 'rerun' support from > Assaf Gordan. N... > To: galaxy-dev(a)bx.psu.edu > Message-ID: > <hg.52ad5635f01a.1250270042.-331200333(a)scofield.bx.psu.edu> > > details: http://www.bx.psu.edu/hg/galaxy/rev/52ad5635f01a > changeset: 2558:52ad5635f01a > user: James Taylor <james(a)jamestaylor.org> > date: Thu Aug 13 11:27:45 2009 -0400 > description: > Integrate 'rerun' support from Assaf Gordan. Not supported for all tools, but checking whether the link should be displayed is expensive currently, this can be improved ghopefully. > > 2 file(s) affected in this change: > > lib/galaxy/web/controllers/tool_runner.py > templates/root/history_common.mako > > diffs (118 lines): > > diff -r ad5232a4dbc5 -r 52ad5635f01a lib/galaxy/web/controllers/tool_runner.py > --- a/lib/galaxy/web/controllers/tool_runner.py Thu Aug 13 11:00:00 2009 -0400 > +++ b/lib/galaxy/web/controllers/tool_runner.py Thu Aug 13 11:27:45 2009 -0400 > @@ -5,6 +5,7 @@ > from galaxy.web.base.controller import * > from galaxy.util.bunch import Bunch > from galaxy.tools import DefaultToolState > +from galaxy.tools.parameters.basic import UnvalidatedValue > > import logging > log = logging.getLogger( __name__ ) > @@ -52,6 +53,80 @@ > add_frame.wiki_url = trans.app.config.wiki_url > add_frame.from_noframe = True > return trans.fill_template( template, history=history, toolbox=toolbox, tool=tool, util=util, add_frame=add_frame, **vars ) > + > + @web.expose > + def rerun( self, trans, id=None, from_noframe=None, **kwd ): > + """ > + Given a HistoryDatasetAssociation id, find the job and that created > + the dataset, extract the parameters, and display the appropriate tool > + form with parameters already filled in. > + """ > + if not id: > + error( "'id' parameter is required" ); > + try: > + id = int( id ) > + except: > + error( "Invalid value for 'id' parameter" ) > + # Get the dataset object > + data = trans.app.model.HistoryDatasetAssociation.get( id ) > + # Get the associated job, if any. If this hda was copied from another, > + # we need to find the job that created the origial hda > + job_hda = data > + while job_hda.copied_from_history_dataset_association: > + job_hda = job_hda.copied_from_history_dataset_association > + if not job_hda.creating_job_associations: > + error( "Could not find the job for this dataset" ) > + # Get the job object > + job = None > + for assoc in job_hda.creating_job_associations: > + job = assoc.job > + break > + if not job: > + raise Exception("Failed to get job information for dataset hid %d" % hid) > + # Get the tool object > + tool_id = job.tool_id > + try: > + # Load the tool > + toolbox = self.get_toolbox() > + tool = toolbox.tools_by_id.get( tool_id, None ) > + except: > + #this is expected, so not an exception > + error( "This dataset was created by an obsolete tool (%s). Can't re-run." % tool_id ) > + # Can't rerun upload, external data sources, et cetera. Workflow > + # compatible will proxy this for now > + if not tool.is_workflow_compatible: > + error( "The '%s' tool does not currently support rerunning." % tool.name ) > + # Get the job's parameters > + try: > + params_objects = job.get_param_values( trans.app ) > + except: > + raise Exception( "Failed to get paramemeters for dataset id %d " % hid ) > + # Unpack unvalidated values to strings, they'll be validated when the > + # form is submitted (this happens when re-running a job that was > + # initially run by a workflow) > + validated_params = {} > + for name, value in params_objects.items(): > + if isinstance( value, UnvalidatedValue ): > + validated_params [ str(name) ] = str(value) > + else: > + validated_params [ str(name) ] = value > + params_objects = validated_params > + # Create a fake tool_state for the tool, with the parameters values > + state = tool.new_state( trans ) > + state.inputs = params_objects > + tool_state_string = util.object_to_string(state.encode(tool, trans.app)) > + # Setup context for template > + history = trans.get_history() > + template = "tool_form.mako" > + vars = dict( tool_state=state, errors = {} ) > + # Is the "add frame" stuff neccesary here? > + add_frame = AddFrameData() > + add_frame.debug = trans.debug > + if from_noframe is not None: > + add_frame.wiki_url = trans.app.config.wiki_url > + add_frame.from_noframe = True > + return trans.fill_template( template, history=history, toolbox=toolbox, tool=tool, util=util, add_frame=add_frame, **vars ) > + > > @web.expose > def redirect( self, trans, redirect_url=None, **kwd ): > diff -r ad5232a4dbc5 -r 52ad5635f01a templates/root/history_common.mako > --- a/templates/root/history_common.mako Thu Aug 13 11:00:00 2009 -0400 > +++ b/templates/root/history_common.mako Thu Aug 13 11:27:45 2009 -0400 > @@ -51,9 +51,12 @@ > <div>${_('Job is currently running')}</div> > %elif data_state == "error": > <div> > - An error occurred running this job: <i>${data.display_info().strip()}</i>, > - <a href="${h.url_for( controller='dataset', action='errors', id=data.id )}" target="galaxy_main">report this error</a> > + An error occurred running this job: <i>${data.display_info().strip()}</i> > </div> > + <div> > + <a href="${h.url_for( controller='dataset', action='errors', id=data.id )}" target="galaxy_main">report this error</a> > + | <a href="${h.url_for( controller='tool_runner', action='rerun', id=data.id )}" target="galaxy_main">rerun</a> > + </div> > %elif data_state == "discarded": > <div> > The job creating this dataset was cancelled before completion. > @@ -77,6 +80,7 @@ > <div> > %if data.has_data: > <a href="${h.url_for( action='display', id=data.id, tofile='yes', toext=data.ext )}" target="_blank">save</a> > + | <a href="${h.url_for( controller='tool_runner', action='rerun', id=data.id )}" target="galaxy_main">rerun</a> > %for display_app in data.datatype.get_display_types(): > <% display_links = data.datatype.get_display_links( data, display_app, app, request.base ) %> > %if len( display_links ) > 0: > > > ------------------------------ > > _______________________________________________ > galaxy-dev mailing list > galaxy-dev(a)bx.psu.edu > http://mail.bx.psu.edu/cgi-bin/mailman/listinfo/galaxy-dev > > > End of galaxy-dev Digest, Vol 44, Issue 22 > ****************************************** > -- Ross Lazarus, Associate Professor, Department of Population Medicine, Harvard Medical School; Director of Bioinformatics, Channing Laboratory, BWH 181 Longwood Ave., Boston MA 02115, USA.

1 0

Possible Bug in SGE Runner when recovering jobs
by Assaf Gordon 15 Aug '09

15 Aug '09

Hi, Not sure if this is a bug or my configuration problem, but: 1. universe_wsgi.ini has: track_jobs_in_database = True enable_job_recovery = True 2. A tool (which uses the SGE runner) is in 'queued' state: psql# select id,tool_id,state from job where state = 'queued'; id | tool_id | state ----+-----------------+-------- 39 | Show beginning1 | queued (1 row) 3. Starting galaxy with "sh run.sh" gives: Traceback (most recent call last): File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/web/buildapp.py", line 61, in app_factory app = UniverseApplication( global_conf = global_conf, **kwargs ) File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/app.py", line 64, in __init__ self.job_manager = jobs.JobManager( self ) File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/jobs/__init__.py", line 35, in __init__ self.job_queue = JobQueue( app, self.dispatcher ) File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/jobs/__init__.py", line 112, in __init__ self.__check_jobs_at_startup() File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/jobs/__init__.py", line 137, in __check_jobs_at_startup self.dispatcher.recover( job, job_wrapper ) File "/bh/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/jobs/__init__.py", line 661, in recover self.job_runners[runner_name].recover( job, job_wrapper ) File "/data/hannon/gordon/galaxy/galaxy_bh_dev/lib/galaxy/jobs/runners/sge.py", line 358, in recover sge_job_state.old_state = DRMAA.Session.QUEUED AttributeError: type object 'Session' has no attribute 'QUEUED' ------------- The immediate cause is that the DRMAA Session class does not have a "QUEUED" state. The closest thing is "QUEUED_ACTIVE" state, as evident from both sge.py lines 18-28, and from DRMAA.py line 363. On a related note, I'm not quite sure how job recovery works with SGE: Let's say a job is queued with QSUB, then galaxy is stopped. The database still says "queued", but in the meantime, the SGE cluster might run the job, and even complete it - So the job can in fact be 'running' or 'ok' or 'error', but Galaxy thinks it is queued. What will happen when Galaxy is restarted ? Is the job automatically restarted, or is the new state queried from the SGE ? Thanks, Gordon.

1 0

[hg] galaxy 2564: Fix for library expand buttons in IE (even tho...
by Greg Von Kuster 15 Aug '09

15 Aug '09

details: http://www.bx.psu.edu/hg/galaxy/rev/eb1244477b90 changeset: 2564:eb1244477b90 user: James Taylor <james(a)jamestaylor.org> date: Fri Aug 14 12:17:45 2009 -0400 description: Fix for library expand buttons in IE (even though the old way used to work, should work, and was tested). 1 file(s) affected in this change: templates/library/browse_library.mako diffs (26 lines): diff -r bfd2ee7bff9d -r eb1244477b90 templates/library/browse_library.mako --- a/templates/library/browse_library.mako Fri Aug 14 10:03:15 2009 -0400 +++ b/templates/library/browse_library.mako Fri Aug 14 12:17:45 2009 -0400 @@ -38,14 +38,21 @@ descendents = descendents.add( child_descendents ); }); // Set up expand / hide link + // HACK: assume descendents are invisible. The caller actually + // ensures this for the root node. However, if we start + // remembering folder states, we'll need something + // more sophisticated here. + var visible = false; $(q).find( "span.expandLink").click( function() { - if ( children.is( ":visible" ) ) { + if ( visible ) { descendents.hide(); descendents.removeClass( "expanded" ); q.removeClass( "expanded" ); + visible = false; } else { children.show(); q.addClass( "expanded" ); + visible = true; } }); // Check/uncheck boxes in subfolders.

1 0

[hg] galaxy 2563: Functional test fixes for my last commit.
by Greg Von Kuster 15 Aug '09

15 Aug '09

details: http://www.bx.psu.edu/hg/galaxy/rev/bfd2ee7bff9d changeset: 2563:bfd2ee7bff9d user: Greg Von Kuster <greg(a)bx.psu.edu> date: Fri Aug 14 10:03:15 2009 -0400 description: Functional test fixes for my last commit. 2 file(s) affected in this change: templates/admin/library/browse_libraries.mako test/base/twilltestcase.py diffs (24 lines): diff -r d2ad22e73b81 -r bfd2ee7bff9d templates/admin/library/browse_libraries.mako --- a/templates/admin/library/browse_libraries.mako Fri Aug 14 09:22:31 2009 -0400 +++ b/templates/admin/library/browse_libraries.mako Fri Aug 14 10:03:15 2009 -0400 @@ -13,7 +13,7 @@ <ul class="manage-table-actions"> %if not deleted: <li> - <a class="action-button" href="${h.url_for( controller='admin', action='library', new=True )}"><span>Create a new library</span></a> + <a class="action-button" href="${h.url_for( controller='admin', action='library', new=True )}"><span>Create a new data library</span></a> </li> <li> <a class="action-button" href="${h.url_for( controller='admin', action='deleted_libraries' )}"><span>Manage deleted libraries</span></a> diff -r d2ad22e73b81 -r bfd2ee7bff9d test/base/twilltestcase.py --- a/test/base/twilltestcase.py Fri Aug 14 09:22:31 2009 -0400 +++ b/test/base/twilltestcase.py Fri Aug 14 10:03:15 2009 -0400 @@ -1003,7 +1003,7 @@ """Create a new library""" self.home() self.visit_url( "%s/admin/library?new=True" % self.url ) - self.check_page_for_string( 'Create a new library' ) + self.check_page_for_string( 'Create a new data library' ) tc.fv( "1", "1", name ) # form field 1 is the field named name... tc.fv( "1", "2", description ) # form field 1 is the field named name... tc.submit( "create_library_button" )

1 0

[hg] galaxy 2559: Fixing masthead centering again
by Greg Von Kuster 15 Aug '09

15 Aug '09

details: http://www.bx.psu.edu/hg/galaxy/rev/50a38a294296 changeset: 2559:50a38a294296 user: James Taylor <james(a)jamestaylor.org> date: Thu Aug 13 11:43:46 2009 -0400 description: Fixing masthead centering again 1 file(s) affected in this change: templates/base_panels.mako diffs (51 lines): diff -r 52ad5635f01a -r 50a38a294296 templates/base_panels.mako --- a/templates/base_panels.mako Thu Aug 13 11:27:45 2009 -0400 +++ b/templates/base_panels.mako Thu Aug 13 11:43:46 2009 -0400 @@ -115,18 +115,9 @@ ## Masthead <%def name="masthead()"> - <div style="position: absolute; left: 0px; width: 100%; text-align: center"> + ## Tab area, fills entire width + <div style="position: absolute; top: 0; left: 0; width: 100%; text-align: center"> - <div class="title" style="float: left;"> - <a href="/"> - <img border="0" src="${h.url_for('/static/images/galaxyIcon_noText.png')}" style="width: 26px; vertical-align: top;"> - Galaxy - %if app.config.brand: - <span class='brand'>/${app.config.brand}</span> - %endif - </a> - </div> - <table class="tab-group" border="0" cellspacing="0" style="margin: auto;"> <tr> @@ -231,6 +222,17 @@ </div> + ## Logo, layered over tabs to be clickable + <div class="title" style="position: absolute; top: 0; left: 0;"> + <a href="/"> + <img border="0" src="${h.url_for('/static/images/galaxyIcon_noText.png')}" style="width: 26px; vertical-align: top;"> + Galaxy + %if app.config.brand: + <span class='brand'>/${app.config.brand}</span> + %endif + </a> + </div> + </%def> <%def name="overlay( title='', content='' )"> @@ -283,7 +285,7 @@ </head> <body scroll="no" class="${self.body_class}"> - <div id="everything" style="position: absolute; width: 100%; height: 100%; min-width: 960px; min-height: 400px;"> + <div id="everything" style="position: absolute; top: 0; left: 0; width: 100%; height: 100%; min-width: 960px;"> ## Background displays first <div id="background"></div> ## Layer iframes over backgrounds

1 0

[hg] galaxy 2560: Resolve issue #129, 'library view jumps to top...
by Greg Von Kuster 15 Aug '09

15 Aug '09

details: http://www.bx.psu.edu/hg/galaxy/rev/ff4b7ca79092 changeset: 2560:ff4b7ca79092 user: James Taylor <james(a)jamestaylor.org> date: Thu Aug 13 12:03:25 2009 -0400 description: Resolve issue #129, 'library view jumps to top upon node expansion' 1 file(s) affected in this change: templates/library/browse_library.mako diffs (21 lines): diff -r 50a38a294296 -r ff4b7ca79092 templates/library/browse_library.mako --- a/templates/library/browse_library.mako Thu Aug 13 11:43:46 2009 -0400 +++ b/templates/library/browse_library.mako Thu Aug 13 12:03:25 2009 -0400 @@ -38,16 +38,14 @@ descendents = descendents.add( child_descendents ); }); // Set up expand / hide link - $(q).find( "span.expandLink").wrap( "<a href='#' class='expandLink'></a>" ).click( function() { + $(q).find( "span.expandLink").click( function() { if ( children.is( ":visible" ) ) { descendents.hide(); descendents.removeClass( "expanded" ); q.removeClass( "expanded" ); - // expanded = false; } else { children.show(); q.addClass( "expanded" ); - // expanded = true; } }); // Check/uncheck boxes in subfolders.

1 0

[hg] galaxy 2561: Restoring history/grid.mako
by Greg Von Kuster 15 Aug '09

15 Aug '09

details: http://www.bx.psu.edu/hg/galaxy/rev/172548982c18 changeset: 2561:172548982c18 user: James Taylor <james(a)jamestaylor.org> date: Thu Aug 13 12:19:00 2009 -0400 description: Restoring history/grid.mako 1 file(s) affected in this change: templates/history/grid.mako diffs (200 lines): diff -r ff4b7ca79092 -r 172548982c18 templates/history/grid.mako --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/templates/history/grid.mako Thu Aug 13 12:19:00 2009 -0400 @@ -0,0 +1,196 @@ +<%inherit file="/base.mako"/> +<%def name="title()">${grid.title}</%def> + +%if message: + <p> + <div class="${message_type}message transient-message">${message}</div> + <div style="clear: both"></div> + </p> +%endif + +<%def name="javascripts()"> + ${parent.javascripts()} + <script type="text/javascript"> + ## TODO: generalize and move into galaxy.base.js + $(document).ready(function() { + $(".grid").each( function() { + var grid = this; + var checkboxes = $(this).find("input.grid-row-select-checkbox"); + var update = $(this).find( "span.grid-selected-count" ); + $(checkboxes).each( function() { + $(this).change( function() { + var n = $(checkboxes).filter("[checked]").size(); + update.text( n ); + }); + }) + }); + }); + ## Can this be moved into base.mako? + %if refresh_frames: + %if 'masthead' in refresh_frames: + ## Refresh masthead == user changes (backward compatibility) + if ( parent.user_changed ) { + %if trans.user: + parent.user_changed( "${trans.user.email}", ${int( app.config.is_admin_user( trans.user ) )} ); + %else: + parent.user_changed( null, false ); + %endif + } + %endif + %if 'history' in refresh_frames: + if ( parent.frames && parent.frames.galaxy_history ) { + parent.frames.galaxy_history.location.href="${h.url_for( controller='root', action='history')}"; + if ( parent.force_right_panel ) { + parent.force_right_panel( 'show' ); + } + } + %endif + %if 'tools' in refresh_frames: + if ( parent.frames && parent.frames.galaxy_tools ) { + parent.frames.galaxy_tools.location.href="${h.url_for( controller='root', action='tool_menu')}"; + if ( parent.force_left_panel ) { + parent.force_left_panel( 'show' ); + } + } + %endif + %endif + </script> +</%def> + +<%def name="stylesheets()"> + <link href="${h.url_for('/static/style/base.css')}" rel="stylesheet" type="text/css" /> + <style> + ## Not generic to all grids -- move to base? + .count-box { + min-width: 1.1em; + padding: 5px; + border-width: 1px; + border-style: solid; + text-align: center; + display: inline-block; + } + </style> +</%def> + +%if grid.standard_filters: + <div class="grid-header"> + <h2>${grid.title}</h2> + <span class="title">Filter:</span> + %for i, filter in enumerate( grid.standard_filters ): + %if i > 0: + <span>|</span> + %endif + <span class="filter"><a href="${url( filter.get_url_args() )}">${filter.label}</a></span> + %endfor + </div> +%endif + +<form name="history_actions" action="${url()}" method="post" > + <table class="grid"> + <thead> + <tr> + <th></th> + %for column in grid.columns: + %if column.visible: + <% + href = "" + extra = "" + if column.sortable: + if sort_key == column.key: + if sort_order == "asc": + href = url( sort=( "-" + column.key ) ) + extra = "↓" + else: + href = url( sort=( column.key ) ) + extra = "↑" + else: + href = url( sort=column.key ) + %> + <th\ + %if column.ncells > 1: + colspan="${column.ncells}" + %endif + > + %if href: + <a href="${href}">${column.label}</a> + %else: + ${column.label} + %endif + <span>${extra}</span> + </th> + %endif + %endfor + <th></th> + </tr> + </thead> + <tbody> + %for i, item in enumerate( query ): + <tr \ + %if current_item == item: + class="current" \ + %endif + > + ## Item selection column + <td style="width: 1.5em;"> + <input type="checkbox" name="id" value=${trans.security.encode_id( item.id )} class="grid-row-select-checkbox" /> + </td> + ## Data columns + %for column in grid.columns: + %if column.visible: + <% + # Link + link = column.get_link( trans, grid, item ) + if link: + href = url( **link ) + else: + href = None + # Value (coerced to list so we can loop) + value = column.get_value( trans, grid, item ) + if column.ncells == 1: + value = [ value ] + %> + %for cellnum, v in enumerate( value ): + <% + # Attach popup menu? + if column.attach_popup and cellnum == 0: + extra = '<a id="grid-%d-popup" class="popup-arrow" style="display: none;">▼</a>' % i + else: + extra = "" + %> + %if href: + <td><a href="${href}">${v}</a> ${extra}</td> + %else: + <td >${v}${extra}</td> + %endif + </td> + %endfor + %endif + %endfor + ## Actions column + <td> + <div popupmenu="grid-${i}-popup"> + %for operation in grid.operations: + %if operation.allowed( item ): + <a class="action-button" href="${url( operation=operation.label, id=item.id )}">${operation.label}</a> + %endif + %endfor + </div> + </td> + </tr> + %endfor + </tbody> + <tfoot> + <tr> + <td></td> + <td colspan="100"> + For <span class="grid-selected-count"></span> selected histories: + %for operation in grid.operations: + %if operation.allow_multiple: + <input type="submit" name="operation" value="${operation.label}" class="action-button"> + %endif + %endfor + </td> + </tr> + </tfoot> + </table> +</form>

1 0