The Inserter Sample

This sample lets the user insert a DB_BOOK object in your database using EiffelStore insertion facilities.

Compiling

To compile the example:

• Launch EiffelStudio.
• Select Use existing Ace (control file) and click OK.
• Browse to Eiffel52\examples\store\select\.
• Choose the file that fits your platform and the DBMS you want to use:
  • Ace.odbc.windows.ace on Windows platforms for ODBC DBMS drivers
  • Ace.oracle.windows.ace on Window platforms for Oracle DBMS
  • Ace.oracle.unix.ace on Unix platforms for Oracle DBMS
• Choose the directory where the project will be compiled, by default the same directory containing the Ace file.
• Click OK.

Running

This sample lets you interact with your database through a console.

First you have to enter the database connection information:

• For ODBC:

Database user authentication:
Data Source Name: handson
Name: smith
Password: mypass

Note: Name and Password are no required with ODBC. If you don't need Name and Password, you can simply hit Return when prompted.

• For Oracle:

Database user authentication:
Name: smith@HANDSON
Password: mypass

Note: you have to specify the Oracle User Name and Net Service Name with the syntax <user>@<service> where <user> stands for the User Name and <service> stands for the Net Service Name.

Then you can insert a book in the database, for instance:

What new book should I create?
Author? John Smith
Title? My book
Quantity? 1
Price? 50
Year? 2001
Double value? 12.675
Object inserted

Note: if your database does not contain a DB_BOOK table, this example will create it.

Under the Hood

This sample showcases the use of the DB_STORE class to perform database insertions where the SQL language is totally abstracted. 

The whole sample code is contained in the root class:

• INSERTER for Oracle.
• INSERTER_ODBC for ODBC.