Menagment_Electric_Cars/init.sql at main · effectiveone/Menagment_Electric_Cars · GitHub

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
// init.js

// Dodaj użytkownika admina
db.users.insertOne({
  mail: 'admin@example.com',
  username: 'admin',
  password: 'admin12',
  isAdmin: true,
});

// Dodaj zgłoszenia
// Dodaj dodatkowe zadania
db.task.insertMany([
  {
    title: 'Charging Station Maintenance',
    description:
      'Perform regular maintenance on electric vehicle charging stations.',
    time: '3 hours',
    coinsToEarn: 8,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
  {
    title: 'Software Update for Fleet Vehicles',
    description:
      'Update the software for the electric fleet vehicles to the latest version.',
    time: '5 hours',
    coinsToEarn: 12,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
  {
    title: 'Electric Car Inspection',
    description:
      'Conduct inspections on electric cars to ensure they meet safety standards.',
    time: '4 hours',
    coinsToEarn: 9,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
  {
    title: 'Implement New Charging Strategies',
    description:
      'Research and implement innovative charging strategies for electric vehicles.',
    time: '6 hours',
    coinsToEarn: 15,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
  {
    title: 'Organize Electric Car Showcase Event',
    description:
      'Plan and organize an event to showcase the latest electric car models.',
    time: '8 hours',
    coinsToEarn: 20,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
  {
    title: 'Organize Electric Car Showcase Event',
    description:
      'Plan and organize an event to showcase the latest electric car models.',
    time: '8 hours',
    coinsToEarn: 20,
    status: 'pending',
    responsivePerson: 'admin@example.com',
  },
]);

db.ElectricCars.insertMany([
  {
    make: 'Tesla',
    model: 'Model S',
    range: '370 miles',
    price: '$79,990',
    reservations: [],
  },
  {
    make: 'Nissan',
    model: 'Leaf',
    range: '150 miles',
    price: '$31,600',
    reservations: [],
  },
  {
    make: 'Chevrolet',
    model: 'Bolt EV',
    range: '259 miles',
    price: '$31,995',
    reservations: [],
  },
  {
    make: 'BMW',
    model: 'i3',
    range: '153 miles',
    price: '$44,450',
    reservations: [],
  },
  {
    make: 'Audi',
    model: 'e-tron',
    range: '204 miles',
    price: '$65,900',
    reservations: [],
  },
  {
    make: 'Hyundai',
    model: 'Kona Electric',
    range: '258 miles',
    price: '$36,990',
    reservations: [],
  },
  {
    make: 'Jaguar',
    model: 'I-PACE',
    range: '234 miles',
    price: '$69,900',
    reservations: [],
  },
]);