1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
-------------------------------------------------------------------------------
-- --
-- GNADE : GNat Ada Database Environment --
-- --
-- Filename : $Source: /cvsroot/gnade/gnade/samples/mysql/testdb.gpb,v $
--| Description : Simple example how to use the mysql bindings --
-- Author : Michael Erdmann <Michael.Erdmann@snafu.de> --
-- Created On : 22-Dec-2000 --
-- Last Modified By: $Author: merdmann $
-- Last Modified On: $Date: 2004/05/29 13:29:19 $ --
-- Status : $State: Exp $ --
-- --
-- Copyright (C) 2000-2003 Michael Erdmann --
-- --
-- GNADE is free software; you can redistribute it and/or modify it under --
-- terms of the GNU General Public License as published by the Free Soft- --
-- ware Foundation; either version 2, or (at your option) any later ver- --
-- sion. GNAT is distributed in the hope that it will be useful, but WITH- --
-- OUT 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 distributed with GNAT; see file COPYING. If not, write --
-- to the Free Software Foundation, 59 Temple Place - Suite 330, Boston, --
-- MA 02111-1307, USA. --
-- --
-- As a special exception, if other files instantiate generics from this --
-- unit, or you link this unit with other files to produce an executable, --
-- this unit does not by itself cause the resulting executable to be --
-- covered by the GNU General Public License. This exception does not --
-- however invalidate any other reasons why the executable file might be --
-- covered by the GNU Public License. --
-- --
-- GNADE is implemented to work with GNAT, the GNU Ada compiler. --
-- --
-- Functional Description --
-- ====================== --
-- This program prints out the result of the following query: --
-- select * from test where id='otto' --
-- --
-- Restrictions --
-- ============ --
-- --
-- References --
-- ========== --
-- --
-------------------------------------------------------------------------------
with System; use System;
with Ada.Unchecked_Conversion;
with Ada.Exceptions; use Ada.Exceptions;
with Ada.Text_IO; use Ada.Text_IO;
with Ada.Strings.Unbounded; use Ada.Strings.Unbounded;
with Ada.Calendar; use Ada.Calendar;
with GNU.DB.MySQL; use GNU.DB.MySQL;
use GNU.DB ;
procedure TestDB is
Version : constant String := "$Id: testdb.gpb,v 1.9 2004/05/29 13:29:19 merdmann Exp $";
pragma Unreferenced (Version);
dBase : MySQL.Object;
qId : MySQL.Query_ID;
Nbr_Tuples : Integer := 0;
function Convert2 is new Ada.Unchecked_Conversion
( Byte_Array_Access, Integer);
begin
Initialize( dBase );
User( dBase, $DBUSER );
Password( dBase, $DBPASSWD );
Connect( dBase, "localhost" );
Select_DB( dBase, $DBNAME );
------------------------------------------------------------------------
begin
qID := Query( dBase, "select * from Test where id='Otto'");
Put_Line( "Nbr of Rows:" & Integer'Image(Nbr_of_Rows(dBase, qID)) );
while true loop
declare
Insert_Time : Time;
pragma Unreferenced (Insert_Time);
Data : Byte_Array_Access;
begin
Nbr_Tuples := Nbr_Tuples + 1;
Data := Blob_Field( DBase, qID, 4 );
Put( " Field length = " & Get_Field_Length(DBase, QId, 4)'Img);
Put( " Data address = " & Convert2(Data)'img & ":");
declare
function Convert is new Ada.Unchecked_Conversion
( Byte_Array_Access, Address);
S : String(1..Get_Field_Length( DBase, QId, 4)+1);
for S'address use Convert(Data);
begin
Put_Line("""" & S & """");
end;
Free( Data );
Next( dBase, qID );
exception
when Field_Parse_Error =>
Put_Line("Field parse error");
Next( dBase, qID );
when Others =>
raise;
end;
end loop;
exception
when Field_Type_Error =>
Put_Line("Field type error");
when No_Query_Result =>
Put_Line("Query Failed");
when No_More_Rows =>
Put_Line( "End of Query Tuples:" & Integer'Image( Nbr_Tuples ) );
when The_Error : Others =>
Put_Line( "An error has occured at record " & Integer'Image( Nbr_Tuples ) );
Put_Line( "Fatal error, uncatched exception " & Exception_Name( The_Error ));
end;
Drop_Query( dBase, qID );
Finalize( dBase );
end TestDB;
|
