CVS log for loncom/interface/lonmysql.pm

Up to [LON-CAPA] / loncom / interface

Request diff between arbitrary revisions

Keyword substitution: kv
Default branch: MAIN

- Bug 6825

- Ensure course's "temporary" MySQL tables for student information are
  current when Chart or Statistics web GUI is used.

- 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.

Show-Tables Cache: Buffering the result for later use in tables_in_db function (much faster)

- log spew

- need to clean usernames and domains of nonword characters to use them as table names

A better fix for the last commit.  No longer rely on hard-coded column names.

Removed/commented out debugging code.

Fixed MySQL 4 bug where &update_table_status returned bogus data.  This is
only a temporary fix as it still has the bug of hard-coding the data fields.

Debugging code.

- I'm an idiot

- wrap_symb ddoes the checking so no need to check it before calling it

- ENV -> env

&fix_table_name MySQL barfs on 1234E5678 as well as 1234e5678.

Added ability to specify the database to connect to in
&set_mysql_user_and_password() to make it possible to test lonmysql.

lonmysql.pm: Added &fix_table_name, which takes care of some of
MySQLs stupidity by prepending a '_' to table names which would
be interpreted as numbers.
Modified lontrackstudent.pm to use lonmysql and call fix_table_name

lonmysql:Added &table_information, which returns the metadata mysql keeps
    about the tables.
    Modified &update_table_info to turn the MySQL dates (creation,
    update, and check times) into unix times.
parse_activity_log.pl: Use LONCAPA::Configuration to set configuration
    options instead of the removed subroutine &initialize_configuration
    Modified backup handling code - if a table is missing and any of the
    current tables has been modified since the backup file was written,
    back up the current tables (even though one or more is missing) to
    a filename what will not be overwritten automatically, just to
    be sure no data is being lost.
    &load_backup_tables: Now actually use the filename we pass in instead of
    hard coding a file which may not actually exist.

Removed redundant code in create_table which caused searching to fail.

Added &bulk_store_rows, to take advantage of MySQLs ability to store multiple
rows at a time.  Currently untested.

Remove ummmm debuging code.

Remove dependence on Apache::lonnet.
Added: package variables $mysqluser and $mysqlpassword.
Added: &set_mysql_user_and_password to set or look up via lonnet
  the user and password for MySQL
Modified &connect_to_db and &verify_sql_connection to call
&set_mysql_user_and_password if neccessary and to use $mysqluser and
$mysqlpassword.

&create_table: now report the error (with $dbh->errstr()) instead of
acting like we did and there was no error.

For some reason we occasionally need to execute the 'SHOW TABLES' call
twice in &tables_in_db().

Update metadata entry on re-publication

column in DELETE cannot have quotes.

Was trying to store UNIX timestamps into MySQL DATE field

Update to drop_table to make it clear out the internal bookkeeping for
the tables it drops.

Added &drop_table($tableid) to drop tables when we need to clean up.

Added &Apache::lonmysql::verify_sql_connection() to test the daemons ability
to talk to the database.
Modified &Apache::lonstatistics::handler to call verify_sql_connection and
give an error message to the user.

Added setting of $debugstring in &remove_from_table.

Updated lonmysql.pm to allow more than one 'KEY', 'INDEX', etc. entry.

Added &get_dbh() to allow the user direct access to the dbh.

lonmysql:
   Added &replace_row, which is analogus to &store_row but it does a
'REPLACE' instead of 'STORE'.
   Changed somewhat the table definition.  PRIMARY KEY, KEY, INDEX,
UNIQUE [INDEX], and FULLTEXT [INDEX] are now able to be specified.
Previously only FULLTEXT was allowed.

lonsearchcat.pm:
   Updated to use new mechanism for specifying FULLTEXT indexing.

Modified data structure expected by lonmysql::create_table.
$table->{'columns'} is now an array ref instead of a hash ref.

Cleaned up POD in lonmysql.pm

lonsearchcat.pm has been tested and does work.

Deal cleanly with $dbh not being defined at all.  I have no idea how this
happens, but appearantly it does.

No need to escape and unescape values.  This was preventing dates from
being stored properly.

General cleanups.
Added new function &remove_from_table to remove a row from a table.

Handle empty @fulltext list.

Many changes to documentation and many code cleanups.  In particular, the
package variable %Tables was redefined.
&get_table_info was renamed &update_table_info and completely rewritten.
&create_table now has a new calling structure.
More error checking has been introduced to many functions.

Replaced unimplemented &query_table with (implemented) &number_of_rows.
Changed &get_rows to use WHERE instead of HAVING in SQL query.

LON-CAPA interface to MySQLs loncapa database.  perldoc lonmysql.pm for more
information and interface description.  Not yet complete, but reasonably close.