← Back to branch summary

~launchpad-results/launchpad-results/trunk

« back to all changes in this revision

Viewing changes to lib/lpresults/tracker/schema/test/__init__.py

  • Committer: Marc Tardif
  • Date: 2011-09-19 21:09:02 UTC
  • Revision ID: marc.tardif@canonical.com-20110919210902-32f23dwivc6tua56
Changed results to only return the last state which fixes bug #852007.

Show diffs side-by-side

added added

removed removed

Lines of Context:
lib/lpresults/tracker/schema/test/__init__.py
331
331
LANGUAGE plpgsql AS
332
332
$$
333
333
BEGIN
334
 
   IF NEW.distro_series IS NOT NULL THEN
335
 
       NEW.sequence = next_distroseries_sequence(NEW.distro_series);
336
 
   ELSIF NEW.project_series IS NOT NULL THEN
337
 
       NEW.sequence = next_projectseries_sequence(NEW.project_series);
338
 
   END IF;
 
334
    IF NEW.distro_series IS NOT NULL THEN
 
335
        NEW.sequence = next_distroseries_sequence(NEW.distro_series);
 
336
    ELSIF NEW.project_series IS NOT NULL THEN
 
337
        NEW.sequence = next_projectseries_sequence(NEW.project_series);
 
338
    END IF;
339
339
 
340
 
   RETURN NEW;
 
340
    RETURN NEW;
341
341
END
342
342
$$
343
343
""",
353
353
    EXECUTE PROCEDURE testrun_insert_before()
354
354
""",
355
355
"""
 
356
CREATE FUNCTION testrun_insert_after() RETURNS TRIGGER
 
357
LANGUAGE plpgsql AS
 
358
$$
 
359
BEGIN
 
360
    IF NEW.distro_series IS NOT NULL THEN
 
361
        UPDATE testresult SET date_deleted = NEW.date_created
 
362
            WHERE date_deleted = '3000-01-01'
 
363
            AND test_case IN (
 
364
                SELECT id FROM testcase
 
365
                WHERE distro_series = NEW.distro_series);
 
366
    ELSIF NEW.project_series IS NOT NULL THEN
 
367
        UPDATE testresult SET date_deleted = NEW.date_created
 
368
            WHERE date_deleted = '3000-01-01'
 
369
            AND test_case IN (
 
370
                SELECT id FROM testcase
 
371
                WHERE project_series = NEW.project_series);
 
372
    END IF;
 
373
 
 
374
    RETURN NEW;
 
375
END
 
376
$$
 
377
""",
 
378
"""
 
379
GRANT EXECUTE
 
380
    ON FUNCTION testrun_insert_after()
 
381
    TO lpresults
 
382
""",
 
383
"""
 
384
CREATE TRIGGER testrun_insert_after_trigger
 
385
    BEFORE INSERT ON testrun
 
386
    FOR EACH ROW
 
387
    EXECUTE PROCEDURE testrun_insert_after()
 
388
""",
 
389
"""
356
390
CREATE FUNCTION testresult_insert_before() RETURNS TRIGGER
357
391
LANGUAGE plpgsql AS
358
392
$$
575
609
"DROP FUNCTION testresult_delete_after()",
576
610
"DROP FUNCTION testresult_update_before()",
577
611
"DROP FUNCTION testresult_insert_before()",
 
612
"DROP FUNCTION testrun_insert_after()",
578
613
"DROP FUNCTION testrun_insert_before()",
579
614
"DROP FUNCTION next_projectseries_sequence(INTEGER)",
580
615
"DROP FUNCTION next_distroseries_sequence(INTEGER)",