aboutsummaryrefslogtreecommitdiffstats
path: root/lib/orm/fixtures
diff options
context:
space:
mode:
Diffstat (limited to 'lib/orm/fixtures')
-rw-r--r--lib/orm/fixtures/common.xml100
-rw-r--r--lib/orm/fixtures/nist.xml31
-rw-r--r--lib/orm/fixtures/samples.xml117
-rw-r--r--lib/orm/fixtures/yp.xml65
4 files changed, 190 insertions, 123 deletions
diff --git a/lib/orm/fixtures/common.xml b/lib/orm/fixtures/common.xml
index 5f095372..97bbd8e9 100644
--- a/lib/orm/fixtures/common.xml
+++ b/lib/orm/fixtures/common.xml
@@ -1,27 +1,107 @@
<?xml version="1.0" encoding="utf-8"?>
<django-objects version="1.0">
- <!-- Set the common data sources (starts at 1) -->
+
+<!-- Set the common data settings (starts at 1) -->
+
+ <object model="orm.srtsetting" pk="1">
+ <field type="CharField" name="name">SRTOOL_FIXTURE_LIST_FALLBACK</field>
+ <field type="CharField" name="value">yp,nist</field>
+ </object>
+
+ <object model="orm.srtsetting" pk="10">
+ <field type="CharField" name="name">SRTOOL_DEFECT_UPDATE_FALLBACK</field>
+ <field type="CharField" name="value">bin/srtool_defect.py --update</field>
+ </object>
+ <object model="orm.srtsetting" pk="11">
+ <field type="CharField" name="name">SRTOOL_DEFECT_ADD_FALLBACK</field>
+ <field type="CharField" name="value">bin/srtool_defect.py --add</field>
+ </object>
+ <object model="orm.srtsetting" pk="12">
+ <field type="CharField" name="name">SRTOOL_DEFECT_DEL_FALLBACK</field>
+ <field type="CharField" name="value">bin/srtool_defect.py --del</field>
+ </object>
+ <object model="orm.srtsetting" pk="13">
+ <field type="CharField" name="name">SRTOOL_DEFECT_NEW_FALLBACK</field>
+ <field type="CharField" name="value">bin/srtool_defect.py --new</field>
+ </object>
+ <object model="orm.srtsetting" pk="14">
+ <field type="CharField" name="name">SRTOOL_DEFECT_SAMPLENAME_FALLBACK</field>
+ <field type="CharField" name="value">54321</field>
+ </object>
+
+<!-- Set the common data sources (starts at 1) -->
+
+<!-- Full production size keyword list
<object model="orm.datasource" pk="1">
<field type="CharField" name="data">triage_keywords</field>
<field type="CharField" name="source">common</field>
<field type="CharField" name="type">csv</field>
<field type="TextField" name="description">Table of keyword filters</field>
- <field type="FilePathField" name="file_path">data/keyword_filters.csv</field>
+ <field type="FilePathField" name="file_path">data/keyword_filters_full.csv</field>
<field type="TextField" name="url"></field>
+ <field type="CharField" name="lastModifiedDate">2018-03-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
</object>
-
- <!-- TEST DATA SOURCES -->
+-->
-<!--
- <object model="orm.datasource" pk="10">
- <field type="CharField" name="data">test</field>
+<!-- Debug size keyword list -->
+ <object model="orm.datasource" pk="1">
+ <field type="CharField" name="data">triage_keywords</field>
<field type="CharField" name="source">common</field>
<field type="CharField" name="type">csv</field>
- <field type="TextField" name="description">TEST: CVE composite status charts</field>
- <field type="FilePathField" name="file_path">data/test_data.csv</field>
+ <field type="TextField" name="description">Table of keyword filters</field>
+ <field type="FilePathField" name="file_path">data/keyword_filters.csv</field>
<field type="TextField" name="url"></field>
+ <field type="CharField" name="lastModifiedDate">2018-03-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ </object>
+<!-- -->
+
+ <object model="orm.datasource" pk="2">
+ <field type="CharField" name="data">backup_weekly</field>
+ <field type="CharField" name="source">common</field>
+ <field type="CharField" name="type">script</field>
+ <field type="TextField" name="description">Weekly archive database backup</field>
+ <field type="FilePathField" name="file_path"></field>
+ <field type="TextField" name="url"></field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command">bin/srtool_utils.py --backup-db-json</field>
+ </object>
+
+ <object model="orm.datasource" pk="3">
+ <field type="CharField" name="data">backup_daily</field>
+ <field type="CharField" name="source">common</field>
+ <field type="CharField" name="type">script</field>
+ <field type="TextField" name="description">Daily database backup (wheel)</field>
+ <field type="FilePathField" name="file_path"></field>
+ <field type="TextField" name="url"></field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">2</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command">bin/srtool_utils.py --backup-db-json-daily</field>
+ </object>
+
+<!-- Built-in Users : first user is default log-on user -->
+
+ <object model="orm.user" pk="1">
+ <field type="TextField" name="name">Guest</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">Guest</field>
+ <field type="IntegerField" name="access">0</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+ <object model="orm.user" pk="2">
+ <field type="TextField" name="name">SRTool</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">SRTool automation scripts</field>
+ <field type="IntegerField" name="access">3</field>
+ <field type="TextField" name="password"></field>
</object>
--->
</django-objects>
diff --git a/lib/orm/fixtures/nist.xml b/lib/orm/fixtures/nist.xml
index 3b65f2e5..b392e57b 100644
--- a/lib/orm/fixtures/nist.xml
+++ b/lib/orm/fixtures/nist.xml
@@ -9,27 +9,43 @@
<field type="TextField" name="description">NIST Common Weakness Enumeration Data</field>
<field type="FilePathField" name="file_path">data/nist-cwe-summary.html</field>
<field type="TextField" name="url">https://nvd.nist.gov/vuln/categories</field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command"></field>
</object>
- <!-- NIST data feeds: https://nvd.nist.gov/vuln/data-feeds#JSON_FEED -->
+
<object model="orm.datasource" pk="23">
<field type="CharField" name="data">cve</field>
<field type="CharField" name="source">nist</field>
- <field type="CharField" name="type">json</field>
+ <field type="CharField" name="type">script</field>
<field type="TextField" name="description">NIST JSON Data 2017</field>
<field type="FilePathField" name="file_path">data/nvdcve-1.0-2017.json</field>
<field type="TextField" name="url">https://static.nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-2017.json.gz</field>
+ <field type="TextField" name="meta_url">https://nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-2017.meta</field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command">bin/srtool_cve.py -n "NIST JSON Data 2017"</field>
</object>
+
<object model="orm.datasource" pk="24">
<field type="CharField" name="data">cve</field>
<field type="CharField" name="source">nist</field>
- <field type="CharField" name="type">json</field>
+ <field type="CharField" name="type">script</field>
<field type="TextField" name="description">NIST JSON Data 2018</field>
<field type="FilePathField" name="file_path">data/nvdcve-1.0-2018.json</field>
<field type="TextField" name="url">https://static.nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-2018.json.gz</field>
+ <field type="TextField" name="meta_url">https://nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-2018.meta</field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">3</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command">bin/srtool_cve.py -n "NIST JSON Data 2018"</field>
</object>
+
<!--
<object model="orm.datasource" pk="25">
<field type="CharField" name="data">cve</field>
@@ -44,10 +60,15 @@
<object model="orm.datasource" pk="26">
<field type="CharField" name="data">cve</field>
<field type="CharField" name="source">nist</field>
- <field type="CharField" name="type">json</field>
- <field type="TextField" name="description">NIST JSON Modified Data 2017</field>
+ <field type="CharField" name="type">script</field>
+ <field type="TextField" name="description">NIST JSON Modified Data</field>
<field type="FilePathField" name="file_path">data/nvdcve-1.0-modified.json</field>
<field type="TextField" name="url">https://static.nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-modified.json.gz</field>
+ <field type="TextField" name="meta_url">https://nvd.nist.gov/feeds/json/cve/1.0/nvdcve-1.0-modified.meta</field>
+ <field type="CharField" name="lastModifiedDate">0001-01-01 01:01:01</field>
+ <field type="IntegerField" name="update_frequency">2</field>
+ <field type="CharField" name="update_time">02:00:00</field>
+ <field type="TextField" name="command">bin/srtool_cve.py -n "NIST JSON Modified Data"</field>
</object>
</django-objects>
diff --git a/lib/orm/fixtures/samples.xml b/lib/orm/fixtures/samples.xml
index 0d22770a..04b865b0 100644
--- a/lib/orm/fixtures/samples.xml
+++ b/lib/orm/fixtures/samples.xml
@@ -1,25 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<django-objects version="1.0">
- <!-- Set up test data for Products -->
-
- <object model="orm.product" pk="1">
- <field type="CharField" name="name">Yocto Project</field>
- <field type="CharField" name="version">2.5 (Sumo)</field>
- <field type="CharField" name="profile"></field>
- </object>
- <object model="orm.product" pk="2">
- <field type="CharField" name="name">Yocto Project</field>
- <field type="CharField" name="version">2.4 (Rocko)</field>
- <field type="CharField" name="profile"></field>
- </object>
- <object model="orm.product" pk="3">
- <field type="CharField" name="name">Yocto Project</field>
- <field type="CharField" name="version">2.3 (Pyro)</field>
- <field type="CharField" name="profile"></field>
- </object>
-
-
<object model="orm.cve" pk="1">
<field type="CharField" name="name">CVE-2017-0000</field>
<field type="BooleanField" name="public">False</field>
@@ -94,12 +75,6 @@
<field type="DateField" name="date">2017-12-14</field>
<field type="TextField" name="author">Mark Hatle</field>
</object>
- <object model="orm.vulnerabilitycomments" pk="2">
- <field type="ForeignKey" name="vulnerability">1</field>
- <field type="TextField" name="comment">ACTION: User 'Paul Gortmaker' 'Bruce Ashfield' added</field>
- <field type="DateField" name="date">2017-12-14</field>
- <field type="TextField" name="author">Mark Hatle</field>
- </object>
<object model="orm.vulnerabilitycomments" pk="3">
<field type="ForeignKey" name="vulnerability">1</field>
<field type="TextField" name="comment">ACTION: Attachment 'PowerDNS Security Advisories 2018-02'</field>
@@ -166,7 +141,7 @@
<field type="IntegerField" name="priority">3</field>
<field type="IntegerField" name="status">5</field>
<field type="IntegerField" name="resolution">1</field>
- <field type="IntegerField" name="publishOLS">Reviewed - Publish</field>
+ <field type="IntegerField" name="publish">Reviewed - Publish</field>
<field type="CharField" name="release_version">2.5.1</field>
<field type="ForeignKey" name="product">1</field>
</object>
@@ -176,7 +151,7 @@
<field type="CharField" name="summary">(TEST) This is another defect</field>
<field type="IntegerField" name="priority">2</field>
<field type="IntegerField" name="status">0</field>
- <field type="IntegerField" name="publishOLS">Not Reviewed</field>
+ <field type="IntegerField" name="publish">Not Reviewed</field>
<field type="CharField" name="release_version"></field>
<field type="ForeignKey" name="product">1</field>
</object>
@@ -206,112 +181,38 @@
<field type="ForeignKey" name="defect">2</field>
</object>
- <!-- Set up default users -->
-
- <object model="orm.user" pk="1">
- <field type="TextField" name="name">Guest</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Guest</field>
- <field type="IntegerField" name="access">0</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="2">
- <field type="TextField" name="name">All</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">internal all access placeholder</field>
- <field type="IntegerField" name="access">0</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="3">
- <field type="TextField" name="name">Ross Burton</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Security Manager Yocto Project</field>
- <field type="IntegerField" name="access">1</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="4">
- <field type="TextField" name="name">Richard Purtie</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Security Manager Yocto Project (backup)</field>
- <field type="IntegerField" name="access">1</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="5">
- <field type="TextField" name="name">Mark Hatle</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Product Security Expert Wind River</field>
- <field type="IntegerField" name="access">2</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="6">
- <field type="TextField" name="name">Jason Wessel</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Product Security Expert WRLinux (backup)</field>
- <field type="IntegerField" name="access">2</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="7">
- <field type="TextField" name="name">Jefro Osier-Mixon</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Product Owner Yocto Project</field>
- <field type="IntegerField" name="access">1</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="8">
- <field type="TextField" name="name">Stephen Jolley</field>
- <field type="TextField" name="email"></field>
- <field type="TextField" name="role">Product Owner Yocto Project (backup)</field>
- <field type="IntegerField" name="access">1</field>
- <field type="TextField" name="password"></field>
- </object>
-
- <object model="orm.user" pk="9">
- <field type="TextField" name="name">David Reyna</field>
- <field type="TextField" name="email">david.reyna@windriver.com</field>
- <field type="TextField" name="role">Developer Wind River</field>
- <field type="IntegerField" name="access">1</field>
- <field type="TextField" name="password"></field>
- </object>
-
<!-- Set up default users to investigations -->
<object model="orm.investigationaccess" pk="1">
<field type="ForeignKey" name="investigation">1</field>
- <field type="ForeignKey" name="user">1</field>
+ <field type="ForeignKey" name="user">10</field>
</object>
<object model="orm.investigationaccess" pk="2">
<field type="ForeignKey" name="investigation">1</field>
- <field type="ForeignKey" name="user">2</field>
+ <field type="ForeignKey" name="user">11</field>
</object>
<object model="orm.investigationaccess" pk="3">
<field type="ForeignKey" name="investigation">1</field>
- <field type="ForeignKey" name="user">3</field>
+ <field type="ForeignKey" name="user">12</field>
</object>
<object model="orm.vulnerabilityaccess" pk="4">
<field type="ForeignKey" name="vulnerability">1</field>
- <field type="ForeignKey" name="user">2</field>
+ <field type="ForeignKey" name="user">10</field>
</object>
<object model="orm.vulnerabilityaccess" pk="5">
<field type="ForeignKey" name="vulnerability">1</field>
- <field type="ForeignKey" name="user">4</field>
+ <field type="ForeignKey" name="user">11</field>
</object>
<object model="orm.investigationnotification" pk="1">
<field type="ForeignKey" name="investigation">1</field>
- <field type="ForeignKey" name="user">5</field>
+ <field type="ForeignKey" name="user">12</field>
</object>
<object model="orm.vulnerabilitynotification" pk="2">
<field type="ForeignKey" name="vulnerability">1</field>
- <field type="ForeignKey" name="user">6</field>
+ <field type="ForeignKey" name="user">10</field>
</object>
</django-objects>
diff --git a/lib/orm/fixtures/yp.xml b/lib/orm/fixtures/yp.xml
new file mode 100644
index 00000000..38e0f875
--- /dev/null
+++ b/lib/orm/fixtures/yp.xml
@@ -0,0 +1,65 @@
+<?xml version="1.0" encoding="utf-8"?>
+<django-objects version="1.0">
+
+ <!-- Set up test data for Products -->
+
+ <object model="orm.product" pk="1">
+ <field type="CharField" name="name">Yocto Project</field>
+ <field type="CharField" name="version">2.5 (Sumo)</field>
+ <field type="CharField" name="profile"></field>
+ </object>
+ <object model="orm.product" pk="2">
+ <field type="CharField" name="name">Yocto Project</field>
+ <field type="CharField" name="version">2.4 (Rocko)</field>
+ <field type="CharField" name="profile"></field>
+ </object>
+ <object model="orm.product" pk="3">
+ <field type="CharField" name="name">Yocto Project</field>
+ <field type="CharField" name="version">2.3 (Pyro)</field>
+ <field type="CharField" name="profile"></field>
+ </object>
+
+ <!-- Set up default users -->
+
+ <object model="orm.user" pk="10">
+ <field type="TextField" name="name">Ross Burton</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">Security Manager Yocto Project</field>
+ <field type="IntegerField" name="access">3</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+ <object model="orm.user" pk="11">
+ <field type="TextField" name="name">Richard Purtie</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">Security Manager Yocto Project (backup)</field>
+ <field type="IntegerField" name="access">3</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+ <object model="orm.user" pk="12">
+ <field type="TextField" name="name">Mark Hatle</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">Product Security Expert Wind River</field>
+ <field type="IntegerField" name="access">2</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+ <object model="orm.user" pk="13">
+ <field type="TextField" name="name">Stephen Jolley</field>
+ <field type="TextField" name="email"></field>
+ <field type="TextField" name="role">Product Owner Yocto Project</field>
+ <field type="IntegerField" name="access">1</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+ <object model="orm.user" pk="14">
+ <field type="TextField" name="name">David Reyna</field>
+ <field type="TextField" name="email">david.reyna@windriver.com</field>
+ <field type="TextField" name="role">Developer Wind River</field>
+ <field type="IntegerField" name="access">1</field>
+ <field type="TextField" name="password"></field>
+ </object>
+
+</django-objects>
+
generated by cgit 1.2.3-korg (git 2.39.0) at 2024-04-30 18:28:59 +0000