CVS log for loncom/metadata_database/LONCAPA/lonmetadata.pm
Up to [LON-CAPA] / loncom / metadata_database / LONCAPA
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Current tag: MAIN
Revision 1.38: download - view: text, markup, annotated - select for diffs
Thu Mar 15 23:01:59 2012 UTC (12 years, 5 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, colored
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, 5 months ago) by www
Branches: MAIN
Diff to previous 1.36: preferred, colored
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, 5 months ago) by www
Branches: MAIN
Diff to previous 1.35: preferred, colored
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, 5 months ago) by www
Branches: MAIN
Diff to previous 1.34: preferred, colored
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, 5 months ago) by droeschl
Branches: MAIN
Diff to previous 1.33: preferred, colored
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, 3 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, colored
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, 3 months ago) by raeburn
Branches: MAIN
Diff to previous 1.31: preferred, colored
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, 3 months ago) by raeburn
Branches: MAIN
Diff to previous 1.30: preferred, colored
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, 3 months ago) by raeburn
Branches: MAIN
Diff to previous 1.29: preferred, colored
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, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.28: preferred, colored
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, 7 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, colored
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, 4 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, colored
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, 4 months ago) by bisitz
Branches: MAIN
Diff to previous 1.25: preferred, colored
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 (16 years, 8 months 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, colored
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 ago) by albertel
Branches: MAIN
CVS tags: version_2_5_99_0
Diff to previous 1.23: preferred, colored
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, 1 month 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, colored
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, 2 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_X,
version_2_4_2
Diff to previous 1.21: preferred, colored
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, 3 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, colored
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, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.19: preferred, colored
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, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.18: preferred, colored
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, 7 months ago) by albertel
Branches: MAIN
Diff to previous 1.17: preferred, colored
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, 7 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, colored
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, 7 months ago) by raeburn
Branches: MAIN
Diff to previous 1.15: preferred, colored
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 (17 years, 8 months ago) by raeburn
Branches: MAIN
Diff to previous 1.14: preferred, colored
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 (17 years, 11 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, colored
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 (18 years, 9 months 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, colored
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, 5 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, colored
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, 2 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, colored
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, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.9: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
CVS tags: version_1_1_99_0
Diff to previous 1.8: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
Diff to previous 1.7: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
Diff to previous 1.6: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
Diff to previous 1.5: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
Diff to previous 1.4: preferred, colored
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, 4 months ago) by matthew
Branches: MAIN
Diff to previous 1.3: preferred, colored
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, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.2: preferred, colored
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, 7 months ago) by matthew
Branches: MAIN
Diff to previous 1.1: preferred, colored
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, 7 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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>