projects:elements_of_data_base_design
SCR #48
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SCR #49
0 ( Introduction and load for DEMO data file. MVP-FORTH)
1 PAGE CR CR CR CR
2 ." ELEMENTS OF DATA BASE DESIGN " CR
3 ." by" CR
4 ." Glen B. Haydon" CR CR
5 ." This demonstration data system provides a pattern for the "
6 CR ." further development of any type of data base. " CR
7
8 : PROCEED
9 CR CR 9 SPACES ." Enter Y to load screens "
10 KEY 89 = IF 50 58 DDUP INDEX CR THRU THEN ;
11
12 PROCEED
13
14 EXIT
15
SCR #50
0 ( File development l of 2 MVP-FORTH)
1 VARIABLE REC# 0 REC# ! ( holds the current record number )
2 VARIABLE OPEN 0 OPEN ! ( points to the current file descript)
3
4 : LAYOUT ( --- bytes/rec-2, bytes/block-1 )
5 OPEN @ 4 + D@ ;
6
7 : READ ( n --- ) ( n-th record is made current )
8 0 MAX DUP OPEN @ 2+ @ < 0=
9 IF ." FILE ERROR " QUIT THEN REC# ! ;
10
11 : RECORD ( n --- address of n-th record )
12 LAYOUT */MOD OPEN @ @ + BLOCK + UPDATE ;
13
14 : ADDRESS ( --- address of the current record )
15 REC# @ RECORD ;
MOUNTAIN VIEW PRESS FORTH VERSION 1.01.03
SCR #51
0 ( File development 2 of 2 MVP-FORTH)
1 : DFIELD
2 CREATE OVER , + ( Create data field and leave count )
3 DOES> @ ADDRESS + ; ( Leave address )
4
5 : TFIELD
6 CREATE OVER , DUP , + ( Create text field and leave count )
7 DOES> D@ ADDRESS + SWAP ; ( Leave addr and count )
8
9 : FILE ( Create a named storage allocation)
10 CREATE , ( Origin block )
11 1+ , ( Number of records in file )
12 DUP 1024 OVER / * , ( # nunber of bytes per block )
13 , ( # bytes per record )
14 DOES> OPEN ! ; ( When file name used, point to )
15 ( its descriptor parameters. )
SCR #52
0 ( Serial Day 1 of 3 MVP-FORTH)
l : D/ ( d, u --- d )
2 SWAP OVER /MOD >R SWAP U/MOD SWAP DROP R> ;
3 : D* ( d, u --- d )
4 DUP ROT * ROT ROT U* ROT + ;
5 : $-N ( c --- d )
6 WORD 0 0 ROT CONVERT DDROP ;
7
8 : TO.SERIAL.DAY ( d, d, d, --- u )
9 ROT DUP 3 < IF 13 + SWAP 1 -
10 ELSE 1 + SWAP THEN
11 52 - 365.25 ROT D* 100 D/ DROP
12 SWAP 30.6001 ROT D* 10000 D/ DROP + + ;
13
14 : ?DATE ." ( MM/DD/YY ) "
15 QUERY 47 $-N 47 $-N BL $-N TO.SERIAL.DAY ;
SCR #53
0 ( Serial Day 2 of 3 MVP-FORTH)
1
2 : YEARS ( serial-day --- test-year )
3 0 100 D* 36525 D/ DROP ;
4
5 : DAYS/YEARS ( year --- days )
6 0 36525 D* 100 D/ DROP ;
7
8 : TEST.YEARS ( serial-day, test-year --- year, days )
9 DDUP DAYS/YEARS - DUP 123 <
10 IF DROP 1- SWAP OVER DAYS/YEARS -
11 ELSE ROT DROP
12 THEN SWAP 52 + SWAP ;
13
14 : MONTHS ( days --- days, test-month )
15 DUP 3267963. ROT D* 10000 D/ 10000 D/ DROP ;
MOUNTAIN VIEW PRESS FORTH VERSION 1.01.03
SCR #54
0 ( Serial Day 3 of 3 MVP-FORTH)
l : DAYS.TO.M/D/Y ( years, days --- years, days, months )
2 MONTHS SWAP OVER 30.6001 ROT D* 10000
3 D/ DROP - SWAP DUP 13 >
4 IF 13 - ROT 1+ ROT ROT ELSE 1- THEN ;
5 ?DUP
6 : OUT.DATE ( years, days, months --- )
7 100 * + 0 100 D* ROT 0 D+
8 <# # # 47 HOLD # # 47 HOLD # # #> TYPE ;
9
10 : CONV.SERIAL ( serial-day --- years, days, months )
11 DUP YEARS TEST.YEARS DAYS.TO.M/D/Y ;
12
13 : .DATE ( serial-day --- )
14 ?DUP
15 IF CONV.SERIAL OUT.DATE ELSE ." 00/00/00" THEN ; EXIT
SCR #55
0 ( Factors for ?$AMOUNT & .$AMOUNT MVP-FORTH)
1
2 : 0SCALE ( u --- ) 100 D* ;
3
4 : 1SCALE ( u --- ) 10 D* ;
5
6 : 2SCALE ( u --- ) ;
7
8 : 3SCALE ( u --- ) ." Input error " ;
9
10 CREATE NSCALE
11 ' 0SCALE CFA , ' 1SCALE CFA , ' 2SCALE CFA , ' 3SCALE ,
12
13
14
15
SCR #56
0 ( ?$AMOUNT & .$AMOUNT MVP-FORTH)
1
2 : SCALE ( d --- )
3 DPL @ 3 MIN 2 * NSCALE + @ EXECUTE ;
4
5 : ?$AMOUNT ( --- double-cents )
6 QUERY BL WORD NUMBER DPL @ 0<
7 ABORT" INPUT ERROR" SCALE ;
8
9 8 CONSTANT $SIZE
10
11 : .$AMOUNT ( double-cents --- )
12 ( Print $ amount right justified in #SIZE spaces )
13 SWAP OVER DUP D+- <# # # 46 HOLD #S ROT SIGN #>
14 36 EMIT DUP $SIZE SWAP - SPACES TYPE ;
15 EXIT
MOUNTAIN VIEW PRESS FORTH VERSION 1.01.03
SCR #57
0 ( DEMO File - Record Generation MVP-FORTH)
1 0 2 DFIELD TAG ( a tag )
2 30 TFIELD NAME ( item name )
3 2 DFIELD DAY ( the date )
4 4 DFIELD DOLLAR ( a dollar amount)
5 200 ( number of records) 0 ( starting block <1024>)
6 FILE DEMO
7 : !NAME ( wait for name then store it in record )
8 NAME 32 FILL QUERY 1 TEXT PAD COUNT
9 NAME ROT MIN CMOVE UPDATE ;
10 : .NAME ( print name field ) NAME TYPE ;
11 ( The rest follow in the same way. )
12 : !DAY ?DATE DAY ! UPDATE ; : .DAY DAY @ .DATE ;
13 : !DOLLAR ?$AMOUNT DOLLAR D! UPDATE ;
14 : .DOLLAR DOLLAR D@ .$AMOUNT ;
15 : .REC CR REC# @ 3 .R 2 SPACES .NAME .DAY 2 SPACES .DOLLAR ;
SCR #58
0 ( DEMO File - CLEAR.DATA, INPUT, OUTPUT MVP -FORTH)
1
2 ( Clear especiall tag in the 0 record in file )
3 : CLEAR.DATA 0 READ TAG 1024 0 FILL UPDATE ;
4
5 ( Example of formatting for input )
6 : INPUT 0 READ TAG @ 1+ UPDATE DUP TAG ! READ
7 CR CR ." ENTER NAME --> " !NAME
8 CR ." ENTER DATE -->" !DAY ( has a format prompt)
9 CR ." ENTER AMOUNT --> " !DOLLAR
10 .REC UPDATE FLUSH ; ( Save this record on disk )
11
12 ( List files 1 through the number in TAG of 0 record )
13 : OUTPUT 0 READ TAG @ DUP 0= IF CR CR ." Empty file "
14 DROP ELSE 1+ 1 DO FORTH I READ .REC LOOP THEN CR CR ;
15 EXIT
SCR #59
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
MOUNTAIN VIEW PRESS FORTH VERSION 1.01.03
COLD MVP-FORTH VERSION 1.01.03
DR1 OK
49 LOAD
ELEMENTS OF DATA BASE DESIGN
by
Glen B. Haydon
This demonstration data system provides a pattern for the
further development of any type of data base.
Enter Y to load screens
50 ( File development 1 of 2 MVP-FORTH)
51 ( File development 2 of 2 MVP-FORTH)
52 ( Serial Day l of 3 MVP-FORTH)
53 ( Serial Day 2 of 3 MVP-FORTH)
54 ( Serial Day 3 of 3 MVP-FORTH)
55 ( Factors for ?$AMOUNT & .$AMOUNT MVP-FORTH)
56 ( ?$AMOUNT & .$AMOUNT MVP-FORTH)
57 ( DEMO File - Record Generation MVP-FORTH)
58 ( DEMO File - CLEAR.DATA, INPUT, OUTPUT MVP-FORTH)
50 51 52 53 54 55 56 57 58 OK
DEMO OK
CLEAR.DATA OK
OUTPUT
Empty file
OK
INPUT
ENTER NAME --> EZNITH
ENTER DATE --> ( MM/DD/YY ) 4/21/81
ENTER AMOUNT --> 18.50
1 EZNITH 04/21/81 $ 18.50OK
!NAME ZENITH OK
.REC
1 ZENITH 04/21/81 $ 18.50OK
UPDATE FLUSH OK
INPUT
ENTER NAME --> IB
ENTER DATE --> ( MM/DD/YY ) 04/21/81
ENTER AMOUNT --> 60.
2 IBM 04/21/81 $ 60.00OK
INPUT
ENTER NAME --> DEC
ENTER DATE --> ( MM/DD/YY ) 4/21/81
ENTER AMOUNT --> 103.5
3 DEC 04/21/81 $ 103.50OK
DECIMAL OK
0 READ ADDRESS 144 DUMP DECIMAL
C7FA 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .................
C80A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .................
C81A 0 0 0 0 0 0 0 0 5A 45 4E 49 54 48 20 20 .........ZENITH
C82A 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
C83A 20 20 20 20 20 20 E 2A 0 0 3A 7 0 0 49 42 .*..:..IB
C84A 4D 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 M
C85A 20 20 20 20 20 20 20 20 20 20 20 20 E 2A 0 0 .*..
C86A 70 17 0 0 44 45 43 20 20 20 20 20 20 20 20 20 p...DEC
C87A 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
OK
OK
OUTPUT
1 ZENITH 04/21/81 $ 18.50
2 IBM 04/21/81 $ 60.00
3 DEC 04/21/81 $ 103.50
OK
OK
OK
: STATEMENT CR CR 20 SPACES ." STATEMENT" CR CR OUTPUT
CR CR ." TOTAL VALUE " 33 SPACES 0 0 0 READ TAG @ 1+ 1
DO _ READ DOLLAR D@ D+ LOOP .$AMOUNT CR CR CR ; OK
OK
OK
STATEMENT
STATEMENT
1 ZENITH 04/21/81 $ 18.50
2 IBM 04/21/81 $ 60.00
3 DEC 04/21/81 $ 103.50
TOTAL VALUE $ 182.00
OK
projects/elements_of_data_base_design.txt · Zuletzt geändert: 2013-06-06 21:27 von 127.0.0.1