Gossamer Forum: Products: Gossamer Links: Discussions: How do I add a MYSQL query to the nightly cron?

Jul 14, 2004, 10:40 PM

dwh

User (108 posts)

Jul 14, 2004, 10:40 PM

Post #1 of 8

Shortcut

How do I add a MYSQL query to the nightly cron?

My cron looks like this:

30 23 * * * /home3/ling/www/l/admin/nph-verify.cgi --check_all
15 20 * * * /home3/ling/www/l/admin/nph-build.cgi --changed

I'd like to precede the nph-verify.cgi processing with a MYSQL Query. How do I modify the script to do my query? Or how do I create a new script with my query and put it into a new cron?

Jul 14, 2004, 10:44 PM

ryel01

Veteran (1264 posts)

Jul 14, 2004, 10:44 PM

Post #2 of 8

Shortcut

Re: [dwh] How do I add a MYSQL query to the nightly cron? In reply to

In Reply To:

Or how do I create a new script with my query and put it into a new cron?

you would need to make a new script and run that through your cron.

how to do the script? you could copy one of the existing scripts and hack the code to do what you want...

r

Jul 14, 2004, 10:48 PM

dwh

User (108 posts)

Jul 14, 2004, 10:48 PM

Post #3 of 8

Shortcut

Re: [ryel01] How do I add a MYSQL query to the nightly cron? In reply to

I'd love to but these Perl modules confuse the hell out of me. I don't see a single place with a straightforward MYSQL query that I can copy.

I never "got" Object Oriented Programming and it reads like Chinese to me.

Jul 15, 2004, 1:57 AM

Andy

Veteran / Moderator (18441 posts)

Jul 15, 2004, 1:57 AM

Post #4 of 8

Shortcut

Re: [dwh] How do I add a MYSQL query to the nightly cron? In reply to

What are you trying to do exactly? May be quite simple to code :)

I guess your best bet, as ryel suggested. Add in some code to do what you want, so that the commands are run just before the nph-verify script does anything.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 15, 2004, 2:39 AM

dwh

User (108 posts)

Jul 15, 2004, 2:39 AM

Post #5 of 8

Shortcut

Re: [Andy] How do I add a MYSQL query to the nightly cron? In reply to

I just want this SQL

Code:
 UPDATE Links SET URL=TRIM(TRAILING '/' FROM URL)

to be run right before nph-verify.cgi --check_all

Jul 15, 2004, 2:47 AM

Andy

Veteran / Moderator (18441 posts)

Jul 15, 2004, 2:47 AM

Post #6 of 8

Shortcut

Re: [dwh] How do I add a MYSQL query to the nightly cron? In reply to

In that case, you should be able to get away with adding this just before the main subroutine call in nph-verify.cgi;

Code:
$DB->table('Links')->update({ URL => \"TRIM(TRAILING '/' FROM URL)"  }) || die $GT::SQL::error;

Please be sure to do a backup of your tables though, just in case it doesn't have the desired effect.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 15, 2004, 3:06 AM

dwh

User (108 posts)

Jul 15, 2004, 3:06 AM

Post #7 of 8

Shortcut

Re: [Andy] How do I add a MYSQL query to the nightly cron? In reply to

Thank you. It worked like a charm :)

You might want to click on Check Duplicates from the table menu, then from SQL Monitor try this query and then Check Duplicates again. I found a lot of hidden dupes because of that trailing slash.

Jul 15, 2004, 3:07 AM

Andy

Veteran / Moderator (18441 posts)

Jul 15, 2004, 3:07 AM

Post #8 of 8

Shortcut

Re: [dwh] How do I add a MYSQL query to the nightly cron? In reply to

Glad to hear it :)

Cheers

Andy (mod)
andy@ultranerds.co.uk