EasyDB.pm

Gaby Vanhegan - 2/5/2001

About
-----

This is the EasyDB suite of modules.  It is the final year project of
Gaby Vanhegan for a BSc Information Systems.

What is EasyDB?
---------------

EasyDB allows people with no knowledge of SQL to use a database.  The user
only needs to know:

	- A username/password that they can connect to the database with
	- The name of the machine that the database is stored on
	- The name of the database they are connecting to

It is also helpful to know:

	- The name of the table you want to work with
	- How that table is structured

In order to be able to use EasyDB you must have the DBI and DBD::mysql
Perl modules installed.  These can be found at:

http://search.cpan.org

What Can I Do With EasyDB?
--------------------------

There are four things you can do in this release:

1. Find data in a table

This is done using the find function:

	$db->find->criteria( [search criteria] );
	my @array	= @{ $db->find->as_array() };
	my %hash	= %{ $db->find->as_hash() };

2. Add new data to a table

This is done using the add function:

	$db->add->data(	Name => 'Barry',
			Age  => '21' );

3. Change data in the table

This is achieved using the change function

	$db->change->criteria( Age => '21' );
	$db->change->to( Age => '22' );

4. Delete data from the table

Using the delete function

	$db->delete->criteria( Age => '<= 15' );
	$db->delete->now();

There are a number of utility functions that these functions have but
you should read the man page to find out more.

In this release only MySQL databases are supported but other systems
will be supported in later releases.