{ GPC demo program for the Database unit

  Copyright 2000-2006 Frank Heckenbach <frank@pascal.gnu.de>

  This program is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License as
  published by the Free Software Foundation, version 2.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; see the file COPYING. If not, write to
  the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
  Boston, MA 02111-1307, USA.

  As a special exception, if you incorporate even large parts of the
  code of this demo program into another program with substantially
  different functionality, this does not cause the other program to
  be covered by the GNU General Public License. This exception does
  not however invalidate any other reasons why it might be covered
  by the GNU General Public License. }

program DatabaseDemo;

uses GPC, Database;

var
  DBRes: PDBRes;
  i, j: Integer;
  s: PString;

procedure Error (const Msg: String);
begin
  WriteLn (StdErr, 'Error: ', Msg);
  Halt (1)
end;

begin
  if not DBOpen (Error, db_MySQL, '', 'localhost', '', '', 'test') then Halt (1);
  DBCommand ('INSERT INTO adresse SET firstname=' + DBQuoteString ('''')
             + ', lastname=' + DBQuoteString ('"'));
  DBRes := DBQuery ('SELECT * FROM adresse');
  for i := 1 to DBRes^.Rows do
    begin
      for j := 1 to DBRes^.Columns do
        begin
          s := DBQueryItem (DBRes, i, j);
          if s = nil then
            Write ('NULL, ')
          else
            Write (s^, ', ')
        end;
      WriteLn
    end;
  DBCommand ('DELETE FROM adresse WHERE firstname=' + DBQuoteString (''''));
  DBQueryDone (DBRes)
end.