246 lines
6.2 KiB
JavaScript
246 lines
6.2 KiB
JavaScript
db = db.getSiblingDB('kspace_accounting');
|
|
db.createUser({
|
|
user: 'kspace_accounting',
|
|
pwd: 'salakala',
|
|
roles: [{
|
|
role: 'readWrite',
|
|
db: 'kspace_accounting'
|
|
}]
|
|
});
|
|
|
|
db.createCollection("member");
|
|
var mc = db.getCollection("member");
|
|
mc.insertOne({
|
|
_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
billing_aliases: [],
|
|
billing_entity: null,
|
|
first_name: 'Mickey',
|
|
full_name: 'Mickey Mouse',
|
|
member: true,
|
|
joined: ISODate('2020-09-05T00:00:00.000Z'),
|
|
last_name: 'Mouse',
|
|
mail_alias: 'mickey.mouse@k-space.ee',
|
|
tier: 'resident',
|
|
type: 'person',
|
|
username: 'mickey.mouse',
|
|
rules_acknowledged: [],
|
|
ad: {
|
|
username: 'mickey',
|
|
provisioned: true,
|
|
enabled: true
|
|
},
|
|
full_name_normalized: 'mickey mouse',
|
|
enabled: true,
|
|
hosted: {},
|
|
mail: 'mickey.mouse@disney.com',
|
|
access: {
|
|
floor: true,
|
|
board: true
|
|
},
|
|
slack: {
|
|
user_id: 'U0199999999',
|
|
real_name: 'Mickey Mouse',
|
|
last_seen: ISODate('2020-11-01T19:47:18.935Z'),
|
|
enabled: true
|
|
},
|
|
rules_acked: '2020-10-30',
|
|
profile: {
|
|
blurb: '-',
|
|
phone: '',
|
|
'public': false,
|
|
homepage: '',
|
|
show_personal_mail: false,
|
|
show_phone: false,
|
|
show_payments: false
|
|
},
|
|
onboarding: {
|
|
rules_acked: '2020-10-30'
|
|
},
|
|
trust: {}
|
|
});
|
|
|
|
|
|
db.createCollection("cashflow");
|
|
var cc = db.getCollection("cashflow");
|
|
cc.insertOne({
|
|
_id: ObjectId('5fa86192dcd888848c2b7e9a'),
|
|
member_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
peer_account: 'membership',
|
|
timestamp: '2020-02-05',
|
|
type: 'cost',
|
|
amount: -30,
|
|
exempted: 0,
|
|
full_name: 'Mickey Mouse',
|
|
transaction_id: 0
|
|
});
|
|
|
|
cc.insertOne({
|
|
_id: ObjectId('5faee1b8dcd888848cac8576'),
|
|
reference: '202001211229999999-177699999',
|
|
type: 'transaction',
|
|
amount: 100,
|
|
comment: 'clubhouse membership',
|
|
credit_debit: 'crdt',
|
|
peer_account: 'EE999999999999999999',
|
|
peer_name: 'MICKEY MOUSE',
|
|
peer_name_normalized: 'mickey mouse',
|
|
self_account: 'EE888888888888888888',
|
|
timestamp: '2020-01-21',
|
|
category: 'membership-fee',
|
|
member: 'Mickey Mouse',
|
|
member_id: ObjectId('603f9fb06154de0006f6f537')
|
|
});
|
|
|
|
db.createCollection("eventlog");
|
|
var ec = db.getCollection("eventlog");
|
|
ec.insertOne({
|
|
_id: ObjectId('5f932b3995f5d0644a6c4ab6'),
|
|
started: ISODate('2020-10-23T19:12:57.281Z'),
|
|
finished: ISODate('2020-10-23T19:13:02.729Z'),
|
|
component: 'motion-detect',
|
|
camera: 'backdoor',
|
|
action: 'event',
|
|
bla: ISODate('2020-10-23T19:12:57.281Z'),
|
|
timestamp: ISODate('2020-10-23T19:12:57.281Z'),
|
|
event: 'motion-detected'
|
|
});
|
|
ec.insertOne({
|
|
_id: ObjectId('603656f5206d5c1a866fe5dd'),
|
|
component: 'doorboy',
|
|
timestamp: ISODate('2021-02-24T13:39:01.000Z'),
|
|
door: 'back',
|
|
event: 'card-swiped',
|
|
success: true,
|
|
token: {
|
|
uid_hash: 'b6d99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999963'
|
|
},
|
|
inventory: {
|
|
owner: {
|
|
foreign_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
display_name: 'Mickey Mouse'
|
|
}
|
|
}
|
|
});
|
|
ec.insertOne({
|
|
_id: ObjectId('6037f4d28600bbde320dfefa'),
|
|
method: 'web',
|
|
approved: true,
|
|
duration: 5,
|
|
component: 'doorboy',
|
|
type: 'open-door',
|
|
door: 'ground',
|
|
member_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
member: 'Mickey Mouse',
|
|
timestamp: ISODate()
|
|
});
|
|
|
|
db.createCollection("inventory");
|
|
var ic = db.getCollection("inventory");
|
|
ic.insertOne({
|
|
_id: ObjectId('5f9869e8dcd888848c81a4fb'),
|
|
locker: {
|
|
number: 69,
|
|
total_keys: 2
|
|
},
|
|
first_seen: ISODate('2020-10-27T18:41:44.624Z'),
|
|
inventory: {
|
|
owner: 'K-SPACE MTÜ',
|
|
claimable: true,
|
|
managed: true,
|
|
lendable: false,
|
|
usable: true,
|
|
owner: {
|
|
foreign_id: ObjectId('604f9fb06154de0006f6f537'),
|
|
display_name: 'K-SPACE MTÜ'
|
|
},
|
|
user: {
|
|
foreign_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
display_name: 'Mickey Mouse'
|
|
}
|
|
},
|
|
type: 'locker'
|
|
});
|
|
ic.insertOne({
|
|
_id: ObjectId('6036ced95fd58dbdc3be5970'),
|
|
mac: '94:83:c4:00:35:6e',
|
|
first_mech: 'netpoller',
|
|
first_seen: ISODate('2021-02-24T22:10:22.727Z'),
|
|
inventory: {
|
|
managed: true,
|
|
claimable: true
|
|
},
|
|
ip: [
|
|
'172.17.2.8'
|
|
],
|
|
comment: 'Museum',
|
|
last_seen: ISODate(),
|
|
nic_vendor: 'GL Technologies (Hong Kong) Limited',
|
|
'switch': {
|
|
hostname: 'sw_cyber',
|
|
ip: '172.23.0.141',
|
|
port: 'ether3'
|
|
},
|
|
type: 'machine',
|
|
vlan: {
|
|
number: 2,
|
|
name: 'VLAN0002_SEC'
|
|
}
|
|
});
|
|
ic.insertOne({
|
|
_id: ObjectId('5f9869e8dcd888848c81a46e'),
|
|
mac: '00:1b:77:03:b6:88',
|
|
action: 'AP-STA-DISCONNECTED',
|
|
ap: 'comfast-927960',
|
|
comment: 'Music machine',
|
|
first_seen: ISODate('2020-10-22T15:18:32.585Z'),
|
|
hostname: 'libre',
|
|
inventory: {
|
|
owner: {
|
|
foreign_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
display_name: 'Mickey Mouse'
|
|
},
|
|
managed: true,
|
|
claimable: true
|
|
},
|
|
ip: [
|
|
'172.16.208.29',
|
|
'2001:bb8:4008:1:b01f:c92:4cd2:45c9'
|
|
],
|
|
last_component: 'dhcp',
|
|
last_seen: ISODate(),
|
|
nic_vendor: 'Intel Corporate',
|
|
presence_detection: false,
|
|
radio: {
|
|
channel: 36,
|
|
ap: 'comfast-927960',
|
|
action: 'AP-STA-CONNECTED',
|
|
name: 'wlan0-1',
|
|
ssid: 'k-space.ee zoo'
|
|
},
|
|
claimable: true,
|
|
'switch': {
|
|
hostname: 'sw_chaos',
|
|
ip: '172.23.0.121',
|
|
port: 'ether1'
|
|
},
|
|
vlan: {
|
|
number: 1,
|
|
name: 'VLAN0001_PUB + bridge trunk'
|
|
},
|
|
type: 'machine'
|
|
});
|
|
ic.insertOne({
|
|
"type": "token",
|
|
"component": "doorboy",
|
|
token: {
|
|
"uid_hash": "b6d99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999963",
|
|
"enabled": true
|
|
},
|
|
inventory: {
|
|
owner: {
|
|
foreign_id: ObjectId('603f9fb06154de0006f6f537'),
|
|
display_name: 'Mickey Mouse'
|
|
}
|
|
}
|
|
});
|