CVS log for loncom/metadata_database/LONCAPA/lonmetadata.pm

[BACK] Up to [LON-CAPA] / loncom / metadata_database / LONCAPA

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.38: download - view: text, markup, annotated - select for diffs
Thu Mar 15 23:01:59 2012 UTC (12 years, 9 months ago) by www
Branches: MAIN
CVS tags: version_2_12_X, version_2_11_X, version_2_11_5_msu, version_2_11_5, version_2_11_4_uiuc, version_2_11_4_msu, version_2_11_4, version_2_11_3_uiuc, version_2_11_3_msu, version_2_11_3, version_2_11_2_uiuc, version_2_11_2_msu, version_2_11_2_educog, version_2_11_2, version_2_11_1, version_2_11_0_RC3, version_2_11_0_RC2, version_2_11_0_RC1, version_2_11_0, HEAD
Diff to previous 1.37: preferred, unified
Changes since revision 1.37: +7 -7 lines
Work on Bug #6576

Revision 1.37: download - view: text, markup, annotated - select for diffs
Thu Mar 15 21:54:58 2012 UTC (12 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.36: preferred, unified
Changes since revision 1.36: +5 -4 lines
Properly deal with "___" in dynamic metadata keys

Revision 1.36: download - view: text, markup, annotated - select for diffs
Thu Mar 15 20:53:27 2012 UTC (12 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.35: preferred, unified
Changes since revision 1.35: +8 -8 lines
Part of Bug #6576: store part and instance info for statistics

Revision 1.35: download - view: text, markup, annotated - select for diffs
Wed Mar 14 20:53:56 2012 UTC (12 years, 9 months ago) by www
Branches: MAIN
Diff to previous 1.34: preferred, unified
Changes since revision 1.34: +5 -1 lines
Some comments

Revision 1.34: download - view: text, markup, annotated - select for diffs
Tue Mar 6 21:48:28 2012 UTC (12 years, 9 months ago) by droeschl
Branches: MAIN
Diff to previous 1.33: preferred, unified
Changes since revision 1.33: +3 -2 lines
Bug 6566: convert unix timestamp to sql time before insert into database if the field is of type datetime.

Revision 1.33: download - view: text, markup, annotated - select for diffs
Tue May 31 14:45:53 2011 UTC (13 years, 6 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_10_X, version_2_10_1, version_2_10_0, loncapaMITrelate_1, language_hyphenation_merge, language_hyphenation, BZ4492-merge, BZ4492-feature_horizontal_radioresponse
Diff to previous 1.32: preferred, unified
Changes since revision 1.32: +2 -2 lines
- TYPE=MYISAM was replaced with ENGINE=MYISAM in MySQL 4.
- TYPE was deprecated in 4 and 5.0/5.1.  It is no longer supported in 5.5.

Revision 1.32: download - view: text, markup, annotated - select for diffs
Tue May 31 02:40:05 2011 UTC (13 years, 6 months ago) by raeburn
Branches: MAIN
Diff to previous 1.31: preferred, unified
Changes since revision 1.31: +2 -2 lines
- TYPE=MYISAM was replaced with ENGINE=MYISAM in MySQL 4.
- TYPE was deprecated in 4 and 5.0/5.1.  It is no longer supported in 5.5.

Revision 1.31: download - view: text, markup, annotated - select for diffs
Sun May 29 19:10:10 2011 UTC (13 years, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.30: preferred, unified
Changes since revision 1.30: +2 -2 lines
- Correct scalar.

Revision 1.30: download - view: text, markup, annotated - select for diffs
Sun May 29 18:11:45 2011 UTC (13 years, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.29: preferred, unified
Changes since revision 1.29: +4 -4 lines
- username is only column for which charset is explicitly set for allusers
  in MySQL table.
  - case sensitive searches for username
  - case insensitive for other fields

Revision 1.29: download - view: text, markup, annotated - select for diffs
Mon Jan 3 04:47:45 2011 UTC (13 years, 11 months ago) by raeburn
Branches: MAIN
Diff to previous 1.28: preferred, unified
Changes since revision 1.28: +4 -1 lines
- explicitly set charset for allusers MySQL table to latin1.
  (current default for all Linux distros except SuSE 11.3).

Revision 1.28: download - view: text, markup, annotated - select for diffs
Sun Jan 31 03:12:03 2010 UTC (14 years, 10 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_99_1, version_2_10_0_RC2, version_2_10_0_RC1, bz6209-base, bz6209, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE
Diff to previous 1.27: preferred, unified
Changes since revision 1.27: +21 -11 lines
- Logging when &sqltime() is unable to convert time.
  - Replace direct call to &log() originally used for this
    from time when &sqltime() was in lonsearchcat.pm;
    (moved to lonmetadata.pm in rev 1.15).

Revision 1.27: download - view: text, markup, annotated - select for diffs
Wed Apr 29 15:21:00 2009 UTC (15 years, 8 months ago) by bisitz
Branches: MAIN
CVS tags: version_2_8_99_0, bz5969, bz2851, GCI_3, GCI_2, BZ5971-printing-apage, BZ5434-fox
Diff to previous 1.26: preferred, unified
Changes since revision 1.26: +2 -2 lines
Optimized handling of evaluation comments for metadata:
Only create metadata field, if actual content exisits

Revision 1.26: download - view: text, markup, annotated - select for diffs
Tue Apr 21 15:38:05 2009 UTC (15 years, 8 months ago) by bisitz
Branches: MAIN
Diff to previous 1.25: preferred, unified
Changes since revision 1.25: +8 -4 lines
Corrected and optimized dynamical metadata "Evaluation Comments":
- Only wrap comments output in div, if actual comment data is available
- Added white space between username and comment

Revision 1.25: download - view: text, markup, annotated - select for diffs
Fri Dec 7 22:31:08 2007 UTC (17 years ago) by raeburn
Branches: MAIN
CVS tags: version_2_8_X, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_99_1, GCI_1
Diff to previous 1.24: preferred, unified
Changes since revision 1.24: +3 -3 lines
Fix bug 5457
- make delete actions in the MySQL allusers table case sensitive, so changes to a user with username userX do not eliminate the record for user with username userx.

Revision 1.24: download - view: text, markup, annotated - select for diffs
Sat Aug 18 00:32:05 2007 UTC (17 years, 4 months ago) by albertel
Branches: MAIN
CVS tags: version_2_5_99_0
Diff to previous 1.23: preferred, unified
Changes since revision 1.23: +2 -2 lines
- add in missing test

Revision 1.23: download - view: text, markup, annotated - select for diffs
Wed Jul 25 23:17:49 2007 UTC (17 years, 5 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_5_X, version_2_5_2, version_2_5_1, version_2_5_0, version_2_4_99_0
Diff to previous 1.22: preferred, unified
Changes since revision 1.22: +114 -23 lines
searchcat.pl
- Additional MySQL table to build: allusers
- &descend_tree() arguments changed. $dom added as first arg, and reference to %allusers hash added as last arg.
- %allusers keys are usernames for all users in the domain which are not courses.
- user information put into allusers MySQL table.

LONCAPA/lonmetadata.pm
- description of allusers table
- &update_metadata(), &lookup_metadata() and &delete_metadata() modified to allow more flexibility in the WHERE condition in the SQL query (no longer forced to be url = ).
- &process_allusers_data() added to add/modify the contents of the allusers table.

Revision 1.22: download - view: text, markup, annotated - select for diffs
Fri Jun 15 23:02:09 2007 UTC (17 years, 6 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_X, version_2_4_2
Diff to previous 1.21: preferred, unified
Changes since revision 1.21: +5 -1 lines
- include the domain in the port metadata

Revision 1.21: download - view: text, markup, annotated - select for diffs
Sat May 12 23:24:56 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_1, version_2_4_0, version_2_3_99_0
Diff to previous 1.20: preferred, unified
Changes since revision 1.20: +17 -12 lines
- BUG#5248, correct student counting in the avg calculations, also throw out any saved NaN items

Revision 1.20: download - view: text, markup, annotated - select for diffs
Sat May 12 23:03:30 2007 UTC (17 years, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.19: preferred, unified
Changes since revision 1.19: +11 -7 lines
- BUG#5248, stop double counting course accesses

Revision 1.19: download - view: text, markup, annotated - select for diffs
Fri Jan 19 14:23:46 2007 UTC (17 years, 11 months ago) by raeburn
Branches: MAIN
Diff to previous 1.18: preferred, unified
Changes since revision 1.18: +1 -17 lines
Prefer a null value as the option value in a select box when the user chooses "Not specified" - searching in MySQL for IS NULL seems better.

In cases where there are multiple ways to enter metadata for a single field, eliminate storage of comma(s) when the user has not specified anything
for the field.

Advanced search for portfolio files can now include the name(s) of added (course-specified) field(s) with/without the value(s).

addedfieldnames and addedfieldvalues eliminated from the portfolio_metadata table in MySQL - searches do a join on the portfolio_addedfields table instead.

Revision 1.18: download - view: text, markup, annotated - select for diffs
Fri Jan 19 06:09:08 2007 UTC (17 years, 11 months ago) by albertel
Branches: MAIN
Diff to previous 1.17: preferred, unified
Changes since revision 1.17: +1 -3 lines
- removing comment

Revision 1.17: download - view: text, markup, annotated - select for diffs
Fri Jan 12 21:30:58 2007 UTC (17 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_3_X, version_2_3_2, version_2_3_1
Diff to previous 1.16: preferred, unified
Changes since revision 1.16: +2 -2 lines
- eliminating a dependency

Revision 1.16: download - view: text, markup, annotated - select for diffs
Tue Jan 2 12:53:27 2007 UTC (17 years, 11 months ago) by raeburn
Branches: MAIN
Diff to previous 1.15: preferred, unified
Changes since revision 1.15: +231 -3 lines
portfolio_metadata, portfolio_addedfields and portfolio_access tables in MySQL updated when portfolio access controls are modified or when portfolio metadata is updated.

Some routines in searchcat.pl moved to LONCAPA::lonmetadata.pm so they are available to lonsql when performing MySQL table updates on the library server which houses the portfolio files.

metadata updates and access control updates from lonmeta and lonnet::modify_access_controls are routed through lonnet::update_portfolio_table() which in turn does a querysend to dispatch a query to lonsql (via lond).

Only access control settings for public and passphrase-protected controls are stored in the portfolio_access MySQL table.

Revision 1.15: download - view: text, markup, annotated - select for diffs
Fri Dec 29 19:15:28 2006 UTC (18 years ago) by raeburn
Branches: MAIN
Diff to previous 1.14: preferred, unified
Changes since revision 1.14: +36 -1 lines
Moving &sqltime() from searchcat.pl to lonmetadata.pm so it can accessed elsewhere when usin Apache::lonmetadata().

Revision 1.14: download - view: text, markup, annotated - select for diffs
Tue Sep 26 15:15:31 2006 UTC (18 years, 3 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_3_0, version_2_2_99_1, version_2_2_99_0
Diff to previous 1.13: preferred, unified
Changes since revision 1.13: +172 -33 lines
Support for searching for portfolio files using metadata associated with a file. Three new MySQL tables added - portfolio_access, portfolio_metadata and portfolio_addedfields.  Both personal portfolio and course group portfolio files with currently active access controls are included.

Revision 1.13: download - view: text, markup, annotated - select for diffs
Tue Nov 29 19:56:42 2005 UTC (19 years, 1 month ago) by www
Branches: MAIN
CVS tags: version_2_2_X, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_X, version_2_1_99_3, version_2_1_99_2, version_2_1_99_1, version_2_1_99_0, version_2_1_3, version_2_1_2, version_2_1_1, version_2_1_0, version_2_0_99_1
Diff to previous 1.12: preferred, unified
Changes since revision 1.12: +10 -1 lines
Bug #4486: set fields to appropriate "empty" values if nothing is set

Revision 1.12: download - view: text, markup, annotated - select for diffs
Fri Mar 11 03:25:18 2005 UTC (19 years, 9 months ago) by matthew
Branches: MAIN
CVS tags: version_2_0_X, version_2_0_2, version_2_0_1, version_2_0_0, version_1_99_3, version_1_99_2, version_1_99_1_tmcc, version_1_99_1, version_1_99_0_tmcc, version_1_99_0
Diff to previous 1.11: preferred, unified
Changes since revision 1.11: +6 -1 lines
searchcat.pl:Bug 3961 - metadata only processed for default domain on
    multi-domain servers.  Now takes command line option -multi_domain.
    This causes a hostname lookup and the hosts.tab file to be parsed for
    matches of the hostname.  Added 'domain' to the dynamic metadata.
lonmetadata.pm:Added 'domain' to the metadata table and to the dynamic
    metadata;

Revision 1.11: download - view: text, markup, annotated - select for diffs
Thu Jun 17 20:33:21 2004 UTC (20 years, 6 months ago) by www
Branches: MAIN
CVS tags: version_1_3_X, version_1_3_3, version_1_3_2, version_1_3_1, version_1_3_0, version_1_2_X, version_1_2_99_1, version_1_2_99_0, version_1_2_1, version_1_2_0, version_1_1_99_5, version_1_1_99_4, version_1_1_99_3, version_1_1_99_2, version_1_1_99_1
Diff to previous 1.10: preferred, unified
Changes since revision 1.10: +3 -2 lines
Ignored "correct" evaluation data

Revision 1.10: download - view: text, markup, annotated - select for diffs
Fri Jun 11 19:52:12 2004 UTC (20 years, 6 months ago) by matthew
Branches: MAIN
Diff to previous 1.9: preferred, unified
Changes since revision 1.9: +89 -14 lines
lonmetadata:
  Minor changes to &store_metadata, should be a little more readable now.
  &lookup_metadata: added $tablename input parameter, defaults to 'metadata'.
  Implemented &delete_metadata
  Added &update_metadata
lonmetadata_test.pl:
  Added tests for &lookup_metadata, &delete_metadata, and &update_metadata
  Added utility routines &metadata_do_not_match, &metadata_mismatch_error,
  &testrecords, &build_test_table.

Revision 1.9: download - view: text, markup, annotated - select for diffs
Fri Apr 23 20:30:07 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_99_0
Diff to previous 1.8: preferred, unified
Changes since revision 1.8: +3 -1 lines
Added degree of discrimination to metadata storage.

Revision 1.8: download - view: text, markup, annotated - select for diffs
Fri Apr 16 21:43:56 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.7: preferred, unified
Changes since revision 1.7: +123 -10 lines
lonmeta.pm: Added degree of discrimination output.
Added 'detailed assessment statistical data' output, a table of classes,
sections, and various statistics which make up the 'overall assessment
statistical data'.
lonmetadata.pm: Documented data storage in nohist_resevaldata.db
&process_dynmaic_metadata now uses a weighted average for statistics, and
reports the sum of the maximum number of students per class as 'stdno',
since there may be multiple entries per class.
Added &dynamic_metadata_storage which prepares statistical data for
storage in nohist_resevaldata.db.
lonproblemstatistics.pm: Use lonmetadata::dynamic_metadata_storage to prepare
storage of dynamic metadata.

Revision 1.7: download - view: text, markup, annotated - select for diffs
Wed Apr 14 20:35:29 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.6: preferred, unified
Changes since revision 1.6: +7 -4 lines
&process_dynamic_metadata:
Reworked html around evaluation comments.
Actually put the comments into the returned data structure now, instead of
just letting perl garbage collection throw it away.

Revision 1.6: download - view: text, markup, annotated - select for diffs
Wed Apr 14 18:29:31 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.5: preferred, unified
Changes since revision 1.5: +26 -2 lines
Added &LONCAPA::lonmetadata::metadata_col_to_hash.
Modified lonpublisher.pm and lonsearchcat.pm to use it instead of the
version in lonmeta.pm.

Revision 1.5: download - view: text, markup, annotated - select for diffs
Mon Apr 12 21:11:45 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.4: preferred, unified
Changes since revision 1.4: +203 -2 lines
Moved nohist_reseval parsing functionality from searchcat.pl to lonmetadata.pm.
searchcat.pl: stop dying on insert errors.
lonmetadata.pm: &store_metadata now translates 'nan' to 'NULL' because MySQL
won't take 'nan' in a numeric field.
Added &process_reseval_data and &process_dynamic_metadata routines.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Thu Apr 8 14:50:44 2004 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
Diff to previous 1.3: preferred, unified
Changes since revision 1.3: +14 -7 lines
Modified &store_metadata to take a table name as a parameter.

Revision 1.3: download - view: text, markup, annotated - select for diffs
Mon Jan 12 21:48:38 2004 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.2: preferred, unified
Changes since revision 1.2: +5 -4 lines
Modified lonmetadata::create_metadata_storage to take an optional parameter
for the table name to make life a little easier in searchcat.pl.
Added test for it to lonmetadata_test.pl

Revision 1.2: download - view: text, markup, annotated - select for diffs
Mon Jan 12 21:32:20 2004 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.1: preferred, unified
Changes since revision 1.1: +86 -5 lines
Implement store_metadata.  lookup_metadata is not tested in the least.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Mon Jan 12 15:07:08 2004 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
First swipe at consolidating the metadata table creation routines.  Designed
to be used in scripts as well as the httpd.  Table creation and table
description are implemented.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>