Changes between Version 7 and Version 8 of UseCase216049

Timestamp:

12/17/23 02:25:45 (6 months ago)

Author:

216049

Comment:

--

UseCase216049

@@ -8 +8 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-insert into Lugje(l_ime, l_prezime, l_email, l_adresa, l_telefon, l_is_admin)
+insert into Lugje(l_ime, l_prezime, l_email, l_adresa, l_telefon, l_is_admin, l_lozinka)
+values ('Test', 'Test', 'test@test.com', 'test adresa 1', '070111222', false, 'tt');
 
-insert into Patnik(l_id)
+insert into Patnik(l_id);
   }}}
 }}}
@@ -17 +18 @@
   {{{#!sql
 insert into Dokument(d_broj_na_dok, d_koj_go_izdal, d_datum_izd, d_datum_ist, l_id)
+values ('A012345', 'MVR test', '2022-12-12', '2027-12-11', 5);
   }}}
 }}}
@@ -28 +30 @@
 
 === Чекор 2: Најава на патник
+
+{{{#!div style="font-size: 80%"
+  {{{#!sql
+select l_id from project.Lugje where l_email = 'test@test.com' and l_lozinka = 'tt';
+  }}}
+}}}
 
 [[Image(najava_216049.png)]]
@@ -43 +51 @@
   {{{#!sql
 insert into Bilet(l_id, tb_id, b_datum_kupuvanje)
+values (5, 1, now());
   }}}
 }}}
@@ -61 +70 @@
   {{{#!sql
 insert into Vozenje(vozenje_start, patnik_l_id, kacuva_pnl_id, dr_id, b_id)
-values (now(), 1, 2, 1, 1);
+values (now(), 5, 2, 1, 1);
 
   }}}