Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
> x
creating relation... [OK]
creating index (firstname)... [OK]
creating index (lastname)... [OK]
creating index (birthyear)... [OK]
subscribe index (firstname)... [OK]
subscribe index (lastname)... [OK]
subscribe index (birthyear)... [OK]
initializing relation [OK]

Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
> c
Alexei                                             <--> 784
brandau                                            <--> 448
Duschl                                             <--> 1008
duschl                                             <--> 112
duschl                                             <--> 1120
duschl                                             <--> 1232
Gates                                              <--> 560
Lutz                                               <--> 224
Mouse                                              <--> 336
Potschka                                           <--> 0
Schneider                                          <--> 896
Torvalds                                           <--> 672


Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
> 6
search for lastname: duschl
really want to delete this author/these authors? [y/n]
> y
delete author from lastname index... [OK]

Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
> a

primary file:
--------------------------------
item@:0
dead?: no
firstname:   Florian
lastname:    Potschka
yearOfBirth: 1983
--------------------------------------------------------------------------------


--------------------------------
item@:112
dead?: no
firstname:   Thomas
lastname:    Duschl
yearOfBirth: 1515
--------------------------------------------------------------------------------


--------------------------------
item@:224
dead?: no
firstname:   Martin
lastname:    Lutz
yearOfBirth: 1981
--------------------------------------------------------------------------------


--------------------------------
item@:336
dead?: no
firstname:   Mikcey
lastname:    Mouse
yearOfBirth: 1970
--------------------------------------------------------------------------------


--------------------------------
item@:448
dead?: no
firstname:   bernd
lastname:    brandau
yearOfBirth: 1973
--------------------------------------------------------------------------------


--------------------------------
item@:560
dead?: no
firstname:   Bill
lastname:    Gates
yearOfBirth: 1955
--------------------------------------------------------------------------------


--------------------------------
item@:672
dead?: no
firstname:   Linus
lastname:    Torvalds
yearOfBirth: 1953
--------------------------------------------------------------------------------


--------------------------------
item@:784
dead?: no
firstname:   Alex
lastname:    Alexei
yearOfBirth: 1077
--------------------------------------------------------------------------------


--------------------------------
item@:896
dead?: no
firstname:   Martin
lastname:    Schneider
yearOfBirth: 1212
--------------------------------------------------------------------------------


--------------------------------
item@:1008
dead?: yes
firstname:   Thomas
lastname:    Duschl
yearOfBirth: 1515
--------------------------------------------------------------------------------


--------------------------------
item@:1120
dead?: yes
firstname:   Franz
lastname:    duschl
yearOfBirth: 2222
--------------------------------------------------------------------------------


--------------------------------
item@:1232
dead?: yes
firstname:   Stefan
lastname:    duschl
yearOfBirth: 1717
--------------------------------------------------------------------------------


--------------------------------


Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
> c
Alexei                                             <--> 784
brandau                                            <--> 448
Duschl                                             <--> 112
Gates                                              <--> 560
Lutz                                               <--> 224
Mouse                                              <--> 336
Potschka                                           <--> 0
Schneider                                          <--> 896
Torvalds                                           <--> 672


Relations with indexes
=======================

0) create data structure
1) enter new author
-- search ---
2) search for author by firstname
3) search for author by lastname
4) search for author by birthyear
-- delete ---
5) delete author with search by firstname
6) delete author with search by lastname
7) delete author with search by birthyear
-- print ----
a) print primary file
b) print firstname index
c) print lastname index
d) print birthyear index
e) print all authors sorted by firstname
f) print all authors sorted by lastname
g) print all authors sorted by birthyear
-- test -----
x) Load test-data (bug1)
y) Load test-data (bug2)
-- bye ------
q) quit
>