YAML - Revision history

Heth: /* examples */

2025-03-22T15:13:46Z

‎examples

Heth: /* Strings */

2025-03-20T06:16:07Z

‎Strings

Heth: /* Scalars */

2023-12-12T09:26:46Z

‎Scalars

Heth: /* Scalars */

2023-12-12T09:25:26Z

‎Scalars

Heth at 09:22, 12 December 2023

2023-12-12T09:22:07Z

Heth at 08:47, 12 December 2023

2023-12-12T08:47:21Z

Heth: Created page with "=Structure= ==Block and flow style== ===Block style=== '''Lists:''' fruits: - apple - banana - orange '''Maps:''' "

2023-12-12T08:42:51Z

Created page with "=Structure= ==Block and flow style== ===Block style=== '''Lists:''' <source lang=yaml> fruits: - apple - banana - orange </source> '''Maps:''' <source lang=yaml> </source>"

New page

=Structure=
==Block and flow style==
===Block style===
'''Lists:'''
<source lang=yaml>
fruits:
- apple
- banana
- orange
</source>
'''Maps:'''
<source lang=yaml>

</source>

@@ Line 64: / Line 64: @@
    equipment: >
      CREATE TABLE `equipment` (
-         `hostname_id`   INT NOT NULL AUTO_INCREMENT,
+         `host_id`           INT NOT NULL AUTO_INCREMENT,
          `hostname`              VARCHAR(128) DEFAULT NULL,
          `name`                  VARCHAR(128) DEFAULT NULL,
-         `date_created`  date DEFAULT NULL,
+         `date_created`          TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
          `community`             VARCHAR(128) DEFAULT NULL,
          `snmp_ver`              TINYINT DEFAULT NULL,
-         `interval`              INT UNSIGNED DEFAULT NULL,
+         `periodic`              INT DEFAULT NULL,
-         PRIMARY KEY (`hostname_id`),
+         PRIMARY KEY (`host_id`),
          UNIQUE(`hostname`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
@@ Line 79: / Line 79: @@
          `oid`                   VARCHAR(256),
          `easyname`              VARCHAR(64),
-         `description`   VARCHAR(512),
+         `description`           VARCHAR(512),
           PRIMARY KEY (`oid_id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-# Only numeric data allowed in this version
+# Consider change oid in oids to oid basenames and use oid_instance as last digit(s) - unless Null
    probes: >
      CREATE TABLE `probes` (
          `probe_id`              INT NOT NULL AUTO_INCREMENT,
-         `oid`                   INT NOT NULL,
+         `host_id`               INT NOT NULL,
-         `hostname`              INT NOT NULL,
+         `oid_id`                INT NOT NULL,
          PRIMARY KEY (`probe_id`),
-         CONSTRAINT `fk_oid_id` FOREIGN KEY (`oid`) REFERENCES `oids` (`oid_id`),
+         CONSTRAINT `fk_oid_id` FOREIGN KEY (`oid_id`) REFERENCES `oids` (`oid_id`),
-         CONSTRAINT `fk_hostname` FOREIGN KEY (`hostname`) REFERENCES `equipment` (`hostname_id`)
+         CONSTRAINT `fk_host_id` FOREIGN KEY (`host_id`) REFERENCES `equipment` (`host_id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
    probe_data: >
      CREATE TABLE `probe_data` (
          `probe_data_id` INT NOT NULL AUTO_INCREMENT,
-         `probe`         INT NOT NULL,
+         `probe_id`         INT NOT NULL,
          `timestamp`     BIGINT NOT NULL,
          `value`         BIGINT NOT NULL,
          PRIMARY KEY (`probe_data_id`),
-         CONSTRAINT `fk_probe` FOREIGN KEY (`probe`) REFERENCES `probes` (`probe_id`)
+         CONSTRAINT `fk_probe_id` FOREIGN KEY (`probe_id`) REFERENCES `probes` (`probe_id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
 </source>

← Older revision		Revision as of 06:16, 20 March 2025
Line 51:		Line 51:
	** Name:		** Name:

−	==~~Strings~~==	+	==examples==
		+	<source lang=yaml>
		+	db_connect:
		+	host: "127.0.0.1"
		+	user: "USERNAME"
		+	password: "PASSWORD"
		+	port: "3306"
		+	database: "nmsdb"
		+
		+	db_create:
		+	# Equipment - devices under network management
		+	equipment: >
		+	CREATE TABLE `equipment` (
		+	`hostname_id` INT NOT NULL AUTO_INCREMENT,
		+	`hostname` VARCHAR(128) DEFAULT NULL,
		+	`name` VARCHAR(128) DEFAULT NULL,
		+	`date_created` date DEFAULT NULL,
		+	`community` VARCHAR(128) DEFAULT NULL,
		+	`snmp_ver` TINYINT DEFAULT NULL,
		+	`interval` INT UNSIGNED DEFAULT NULL,
		+	PRIMARY KEY (`hostname_id`),
		+	UNIQUE(`hostname`)
		+	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
		+	oids: >
		+	CREATE TABLE `oids` (
		+	`oid_id` INT NOT NULL AUTO_INCREMENT,
		+	`oid` VARCHAR(256),
		+	`easyname` VARCHAR(64),
		+	`description` VARCHAR(512),
		+	PRIMARY KEY (`oid_id`)
		+	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
		+
		+
		+	# Only numeric data allowed in this version
		+	probes: >
		+	CREATE TABLE `probes` (
		+	`probe_id` INT NOT NULL AUTO_INCREMENT,
		+	`oid` INT NOT NULL,
		+	`hostname` INT NOT NULL,
		+	PRIMARY KEY (`probe_id`),
		+	CONSTRAINT `fk_oid_id` FOREIGN KEY (`oid`) REFERENCES `oids` (`oid_id`),
		+	CONSTRAINT `fk_hostname` FOREIGN KEY (`hostname`) REFERENCES `equipment` (`hostname_id`)
		+	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
		+
		+	probe_data: >
		+	CREATE TABLE `probe_data` (
		+	`probe_data_id` INT NOT NULL AUTO_INCREMENT,
		+	`probe` INT NOT NULL,
		+	`timestamp` BIGINT NOT NULL,
		+	`value` BIGINT NOT NULL,
		+	PRIMARY KEY (`probe_data_id`),
		+	CONSTRAINT `fk_probe` FOREIGN KEY (`probe`) REFERENCES `probes` (`probe_id`)
		+	) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
		+	</source>

@@ Line 35: / Line 35: @@
    Line1
    Line2
-**text6: >        #Multiline string - Removes new line chars
+**text6: >        #Multiline string - Convert new line to space
    Line1
    Line2

@@ Line 28: / Line 28: @@
 ==Scalars==
 *Strings
-**"This is a string"
+**text1: "This is a string"
-**'This is also a string'
+**text2: 'This is also a string'
-**This is a string too
+**text3: This is a string too
-**"2999"
+**text4: "2999"
 *Numbers
 **2999

@@ Line 24: / Line 24: @@
 <source lang=yaml>
 address: {street: "H.C. Andersens vej 9",  city: Viborg,  zip: 8800 }
-</source>
+==Strings==

@@ Line 9: / Line 9: @@
    - orange
 </source>
-'''Maps:'''
+'''Maps/dictionary:'''
 <source lang=yaml>
 </source>