/[scire]/trunk/scire/.lib/DB_functions.php
Gentoo

Log of /trunk/scire/.lib/DB_functions.php

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (download) (annotate)

Revision 307 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jan 2 01:10:57 2008 UTC (6 years, 10 months ago) by codeman
File length: 14935 byte(s)
Diff to previous 248
set deploy_time to now for non-scheduled jobs.


Revision 248 - (view) (download) (annotate) - [select for diffs]
Modified Sun Dec 23 04:50:01 2007 UTC (6 years, 10 months ago) by agaffney
File length: 14860 byte(s)
Diff to previous 247
move everything to new trunk directory

Revision 247 - (view) (download) (annotate) - [select for diffs]
Modified Tue Aug 7 01:36:04 2007 UTC (7 years, 2 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 14860 byte(s)
Diff to previous 238
This is a very large commit from Rodrigo Lazo (rlazo) for Google SoC
This is the latest patch on the job execution series. As far as I
could test it, now scire should be able to create, distribute, execute
and gather the output of a job with the new models.

Also the jobs register their status on the database (pending,
downloaded, running, failed, finished or cancelled). So now all the
backend code needed to "watch" a job is on its place.

Right now a job gets executed but dies on the post processing stage
(at least that is what I understand from the error message)

Just move the GACL_functions.py from server/ to server/modules and
apply this patch and you'll how myltiple entries are created for each
member of the group in jobs_clients and on job_history.

I've take some precautions regarding concurrency adding some locks,
I'm not sure they are enough so please comment on that




Revision 238 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 22 22:01:41 2007 UTC (7 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 13407 byte(s)
Diff to previous 233
in DB.php:
  added get_next_id to grab the next id from a sequence
  added now to insert the timestamp in whatever DB format.
in functions:
  added get_client_statuses() for clients pages
  modified add_client and add_job to use $db->now()
  fixed add_job to use the sequence. made the code simpler.
  fixed clients and clientgroups addition.
  heavily modified the script addition. uses sequence
  also adds tags passed to it now.


Revision 233 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 21 02:09:06 2007 UTC (7 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 13109 byte(s)
Diff to previous 228
adding changes from Rodrigo Lazo (rlazo) for Google SoC:
modified add_job.php to make use of the new scheduling logic, plus other minor changes


Revision 228 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 19 01:12:21 2007 UTC (7 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 12787 byte(s)
Diff to previous 220
adding a change from Rodrigo Lazo (rlazo) for Google SoC.
these are basic changes to accomodate job fetching and editing.


Revision 220 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jun 16 17:44:09 2007 UTC (7 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 11387 byte(s)
Diff to previous 190
some excellent updates from Rodrigo Lazo:
UI DB functions have been modified to work with the new job_status model.



Revision 190 - (view) (download) (annotate) - [select for diffs]
Modified Mon Mar 26 01:43:07 2007 UTC (7 years, 7 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 10814 byte(s)
Diff to previous 172
some larger structural changes here.
userid, clientid, and permid are no-longer auto_increment values
they instead will take their IDs from the gacl ids assigned.
this makes linking between the tables much easier since the ids
will always be the same. (no more lookups)
also adding a bare_scire.sql file with a minimal setup
this combines scire.sql and scire2.sql


Revision 172 - (view) (download) (annotate) - [select for diffs]
Modified Mon Dec 11 00:50:28 2006 UTC (7 years, 10 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 10718 byte(s)
Diff to previous 164
updating DB.php with a $db->query() function
which takes a straight up SQL query.
updated a bunch of DB functions for jobs and scripts
fixed the job insertion.
added description to jobs fields in functions


Revision 164 - (view) (download) (annotate) - [select for diffs]
Modified Sat Dec 2 20:02:55 2006 UTC (7 years, 10 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 9193 byte(s)
Diff to previous 154
updating the code for adding a job. finally works in MySQL.


Revision 154 - (view) (download) (annotate) - [select for diffs]
Modified Sun Oct 8 20:34:17 2006 UTC (8 years ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 8936 byte(s)
Diff to previous 138
adding a bunch of functions i wrote a long time ago and forgot about.


Revision 138 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 23 21:13:00 2006 UTC (8 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 6768 byte(s)
Diff to previous 128
adding client status field filtering.  defaults to Active
removed old query


Revision 128 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 15 05:21:58 2006 UTC (8 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 6847 byte(s)
Diff to previous 123
various updates regarding permissions
added categories to the code, so that permissions
can be grouped.  A special group will consist of
Scire UI permissions.


Revision 123 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 5 04:04:38 2006 UTC (8 years, 3 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 6622 byte(s)
Diff to previous 108
massive updates to the permissions code on users and clients.
they now share a common permissions.tpl template.  viewing of
user/client permissions works, remove button doesn't.
link to add works.


Revision 108 - (view) (download) (annotate) - [select for diffs]
Modified Mon Jun 19 03:12:52 2006 UTC (8 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 6627 byte(s)
Diff to previous 105
adding a scire_add_setting function


Revision 105 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jun 18 20:41:50 2006 UTC (8 years, 4 months ago) by agaffney
Original Path: scire/.lib/DB_functions.php
File length: 6368 byte(s)
Diff to previous 103
less stupid settings :P

Revision 103 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jun 18 20:37:48 2006 UTC (8 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 6244 byte(s)
Diff to previous 99
adding settings stuff.  needs to be made into a hash


Revision 99 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jun 14 01:52:27 2006 UTC (8 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 5767 byte(s)
Diff to previous 95
 various updates around the board.  mainly focusing on client and user
 pages.  some DB updates and asthetic changes.
 preparing for user sessions



Revision 95 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jun 11 03:24:22 2006 UTC (8 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 5112 byte(s)
Diff to previous 91
adding adodb path link, tho not used yet
changing db functions for new tables.
added function for leftbar entries to save code.


Revision 91 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jun 4 04:37:02 2006 UTC (8 years, 4 months ago) by codeman
Original Path: scire/.lib/DB_functions.php
File length: 4015 byte(s)
Diff to previous 79
updated some scire database interface files
fixed some queries
fixed the exporter pages (as useless as they are now).


Revision 79 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 22 02:46:20 2006 UTC (8 years, 5 months ago) by blackace
Original Path: scire/.lib/DB_functions.php
File length: 4007 byte(s)
Copied from: scire/DBInterface.php revision 77
Diff to previous 77
move DBInterface.php to .lib/DB_functions.php

Revision 77 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 22 02:44:28 2006 UTC (8 years, 5 months ago) by blackace
Original Path: scire/DBInterface.php
File length: 4007 byte(s)
Diff to previous 47
convert to using DB.php methods

Revision 47 - (view) (download) (annotate) - [select for diffs]
Modified Sun Apr 23 02:59:12 2006 UTC (8 years, 6 months ago) by codeman
Original Path: scire/DBInterface.php
File length: 4825 byte(s)
Diff to previous 46
adding the rest of the converted admin pages.
conversion should be complete.


Revision 46 - (view) (download) (annotate) - [select for diffs]
Modified Sun Apr 23 02:24:31 2006 UTC (8 years, 6 months ago) by codeman
Original Path: scire/DBInterface.php
File length: 4740 byte(s)
Diff to previous 43
Lots more general updates.  Getting things converted over and simplified.


Revision 43 - (view) (download) (annotate) - [select for diffs]
Modified Sat Apr 22 19:29:31 2006 UTC (8 years, 6 months ago) by agaffney
Original Path: scire/DBInterface.php
File length: 4529 byte(s)
Diff to previous 41
add get_scire_user() function

Revision 41 - (view) (download) (annotate) - [select for diffs]
Added Sat Apr 22 16:07:51 2006 UTC (8 years, 6 months ago) by codeman
Original Path: scire/DBInterface.php
File length: 4300 byte(s)
initial scire files and directory added.  more will come soon


This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

Sticky Revision:

  ViewVC Help
Powered by ViewVC 1.1.20