View of /trunk/webwork2/conf/sql.conf.dist

    1 #!perl
    2 ################################################################################
    3 # WeBWorK mod_perl (c) 1995-2002 WeBWorK Team, Univeristy of Rochester
    4 # $Id: sql.conf.dist,v 1.1 2003-06-10 19:58:27 sh002i Exp $
    5 ################################################################################
    6 
    7 =head1 NAME
    8 
    9 sql.conf - defines database layout for use with an SQL server.
   10 
   11 =head1 SYNOPSIS
   12 
   13 In global.conf (or course.conf):
   14 
   15  include "conf/sql.conf";
   16 
   17 =head1 DESCRIPTION
   18 
   19 The SQL database layout uses an SQL database server to store the tables of the
   20 WeBWorK database. The SQL driver uses two SQL accounts, a read only and a
   21 read-write account. The read-only account must have C<SELECT> access, and the
   22 read-write account needs C<SELECT>, C<INSERT>, C<UPDATE>, and C<DELETE> access.
   23 The names and passwords of these accounts are given as parameters to each table
   24 in the layout.
   25 
   26  usernameRO     the name of the read-only account
   27  usernameRW     the name of the read-write account
   28  passwordRO     the password for the read-only account
   29  passwordRW     the password for the read-write account
   30 
   31 Don't confuse these accounts with the accounts of the users of a course. These
   32 are system-wide accounts which allow WeBWorK to talk to the database server.
   33 
   34 FIXME: the way the SQL account information is handled should be changed. It
   35 shouldn't be in the course environment. (We should do the same thing that we
   36 did with the "SECRET" in WeBWorK::Constants.
   37 
   38 =cut
   39 
   40 my %sqlParams = (
   41   usernameRO => "webworkRead",
   42   passwordRO => "zaqwsxcderfv",
   43   usernameRW => "webworkWrite",
   44   passwordRW => "qwerfdsazxcv",
   45   debug => 0,
   46 );
   47 
   48 %dbLayout = (
   49   password => {
   50     record => "WeBWorK::DB::Record::Password",
   51     schema => "WeBWorK::DB::Schema::SQL",
   52     driver => "WeBWorK::DB::Driver::SQL",
   53     source => "dbi:mysql:webwork_$courseName",
   54     params => { %sqlParams },
   55   },
   56   permission => {
   57     record => "WeBWorK::DB::Record::PermissionLevel",
   58     schema => "WeBWorK::DB::Schema::SQL",
   59     driver => "WeBWorK::DB::Driver::SQL",
   60     source => "dbi:mysql:webwork_$courseName",
   61     params => { %sqlParams },
   62   },
   63   key => {
   64     record => "WeBWorK::DB::Record::Key",
   65     schema => "WeBWorK::DB::Schema::SQL",
   66     driver => "WeBWorK::DB::Driver::SQL",
   67     source => "dbi:mysql:webwork_$courseName",
   68     params => {
   69       %sqlParams,
   70       tableOverride => "key_not_a_keyword",
   71       fieldOverride => { key => "key_not_a_keyword" },
   72     },
   73   },
   74   user => {
   75     record => "WeBWorK::DB::Record::User",
   76     schema => "WeBWorK::DB::Schema::SQL",
   77     driver => "WeBWorK::DB::Driver::SQL",
   78     source => "dbi:mysql:webwork_$courseName",
   79     params => { %sqlParams },
   80   },
   81   set => {
   82     record => "WeBWorK::DB::Record::Set",
   83     schema => "WeBWorK::DB::Schema::SQL",
   84     driver => "WeBWorK::DB::Driver::SQL",
   85     source => "dbi:mysql:webwork_$courseName",
   86     params => { %sqlParams, tableOverride => "set_not_a_keyword" },
   87   },
   88   set_user => {
   89     record => "WeBWorK::DB::Record::UserSet",
   90     schema => "WeBWorK::DB::Schema::SQL",
   91     driver => "WeBWorK::DB::Driver::SQL",
   92     source => "dbi:mysql:webwork_$courseName",
   93     params => { %sqlParams },
   94   },
   95   problem => {
   96     record => "WeBWorK::DB::Record::Problem",
   97     schema => "WeBWorK::DB::Schema::SQL",
   98     driver => "WeBWorK::DB::Driver::SQL",
   99     source => "dbi:mysql:webwork_$courseName",
  100     params => { %sqlParams },
  101   },
  102   problem_user => {
  103     record => "WeBWorK::DB::Record::UserProblem",
  104     schema => "WeBWorK::DB::Schema::SQL",
  105     driver => "WeBWorK::DB::Driver::SQL",
  106     source => "dbi:mysql:webwork_$courseName",
  107     params => { %sqlParams },
  108   },
  109 );