// jadralci_mongo.js
// Uporaba: mongosh --file jadralci_mongo.js  (ali v mongosh: load('jadralci_mongo.js'))

use("jadralci");  // pravilna oblika v mongosh

// Počisti, če že obstaja
db.Jadralec.drop();
db.Coln.drop();
db.Rezervacija.drop();

// Podatki
db.Jadralec.insertMany([
  {jid: 22, ime: "Darko",  rating: 7,  starost: 45.0},
  {jid: 29, ime: "Borut",  rating: 1,  starost: 33.0},
  {jid: 31, ime: "Lojze",  rating: 8,  starost: 55.5},
  {jid: 32, ime: "Andrej", rating: 8,  starost: 25.5},
  {jid: 58, ime: "Rajko",  rating: 10, starost: 35.0},
  {jid: 64, ime: "Henrik", rating: 7,  starost: 35.0},
  {jid: 71, ime: "Zdravko",rating: 10, starost: 16.0},
  {jid: 74, ime: "Henrik", rating: 9,  starost: 35.0},
  {jid: 85, ime: "Anže",   rating: 3,  starost: 25.5},
  {jid: 95, ime: "Bine",   rating: 3,  starost: 63.5}
]);

db.Coln.insertMany([
  {cid: 101, ime: "Elan",         dolzina: 34, barva: "modra"},
  {cid: 102, ime: "Elan",         dolzina: 34, barva: "rdeca"},
  {cid: 103, ime: "Sun Odyssey",  dolzina: 37, barva: "zelena"},
  {cid: 104, ime: "Bavaria",      dolzina: 50, barva: "rdeca"}
]);

db.Rezervacija.insertMany([
  {jid: 22, cid: 101, dan: new Date("2006-10-10")},
  {jid: 22, cid: 102, dan: new Date("2006-10-10")},
  {jid: 22, cid: 103, dan: new Date("2006-10-08")},
  {jid: 22, cid: 104, dan: new Date("2006-10-07")},
  {jid: 31, cid: 102, dan: new Date("2006-11-10")},
  {jid: 31, cid: 103, dan: new Date("2006-11-06")},
  {jid: 31, cid: 104, dan: new Date("2006-11-12")},
  {jid: 64, cid: 101, dan: new Date("2006-09-05")},
  {jid: 64, cid: 102, dan: new Date("2006-09-08")},
  {jid: 74, cid: 103, dan: new Date("2006-09-08")}
]);

// Indeksi (po vnosu)
db.Jadralec.createIndex({ jid: 1 }, { unique: true, name: "uniq_jid" });
db.Coln.createIndex({ cid: 1 }, { unique: true, name: "uniq_cid" });
db.Rezervacija.createIndex(
  { jid: 1, cid: 1, dan: 1 },
  { unique: true, name: "uniq_rezervacija" }
);

// Kratek check
print("Št. jadralcev:", db.Jadralec.countDocuments({}));
print("Št. čolnov:", db.Coln.countDocuments({}));
print("Št. rezervacij:", db.Rezervacija.countDocuments({}));