Skip to content

Instantly share code, notes, and snippets.

@dLobatog

dLobatog/gist:2f382f1cd9adfed7581cda530b6defd7

Created August 2, 2019 16:36
Show Gist options
  • Save dLobatog/2f382f1cd9adfed7581cda530b6defd7 to your computer and use it in GitHub Desktop.
Save dLobatog/2f382f1cd9adfed7581cda530b6defd7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[35] pry(main)> parser.save_rule_references
RuleReference Load (0.5ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.8ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.4ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "https://www.niap-ccevs.org/Profile/PP.cfm"], ["label", "FAU_GEN.1.1.c"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-171.pdf"], ["label", "3.1.10"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://iase.disa.mil/stigs/cci/Pages/index.aspx"], ["label", "CCI-000057"], ["LIMIT", 1]]
RuleReference Load (0.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-53r4.pdf"], ["label", "AC-11(a)"], ["LIMIT", 1]]
RuleReference Load (0.4ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", ""], ["label", "FMT_MOF_EXT.1"], ["LIMIT", 1]]
RuleReference Load (1.1ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://iase.disa.mil/stigs/os/general/Pages/index.aspx"], ["label", "SRG-OS-000029-GPOS-00010"], ["LIMIT", 1]]
RuleReference Load (0.4ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://iase.disa.mil/stigs/cci/Pages/index.aspx"], ["label", "CCI-000366"], ["LIMIT", 1]]
RuleReference Load (3.3ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-53r4.pdf"], ["label", "SI-2(c)"], ["LIMIT", 1]]
RuleReference Load (0.7ms) SELECT "rule_references".* FROM "rule_references" WHERE "rule_references"."href" = $1 AND "rule_references"."label" = $2 ORDER BY "rule_references"."label" ASC LIMIT $3 [["href", "http://iase.disa.mil/stigs/os/general/Pages/index.aspx"], ["label", "SRG-OS-000480-GPOS-00227"], ["LIMIT", 1]]
RuleReference Create Many Without Validations Or Callbacks (4.3ms) INSERT INTO "rule_references" ("href","label") VALUES ('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('https://www.niap-ccevs.org/Profile/PP.cfm','FAU_GEN.1.1.c'),('http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-171.pdf','3.1.10'),('http://iase.disa.mil/stigs/cci/Pages/index.aspx','CCI-000057'),('http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-53r4.pdf','AC-11(a)'),('','FMT_MOF_EXT.1'),('http://iase.disa.mil/stigs/os/general/Pages/index.aspx','SRG-OS-000029-GPOS-00010'),('http://iase.disa.mil/stigs/cci/Pages/index.aspx','CCI-000366'),('http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-53r4.pdf','SI-2(c)'),('http://iase.disa.mil/stigs/os/general/Pages/index.aspx','SRG-OS-000480-GPOS-00227') ON CONFLICT DO NOTHING RETURNING "id"
=> #<struct ActiveRecord::Import::Result
failed_instances=[],
num_inserts=1,
ids=
["4aa9a2e3-35de-44e4-b7aa-df1295a2342d",
"cd525c56-840f-4a9d-af67-638419b40861",
"a3c48c67-3258-46aa-8ae0-cbcf8385c6f0",
"2b004a7e-3d4f-42a6-a947-580a275fe28d",
"dca9ce24-3350-4e01-903e-1b363ae83190",
"c86b407b-a38b-4cbe-8a02-8abed3b7ad25",
"93014015-ccd9-4f5e-b08f-ecc85230a283",
"934643a9-256c-4ac1-916f-35c0b21720aa",
"9216cd4d-e6b5-4479-b91b-ab6e9d39fa14",
"d7f766e2-5f86-4bf6-a8ca-108785309737",
"3931a5c6-adda-44ca-b715-1087f29382e9",
"02e8d68b-d444-4b33-bdae-1d924d001648",
"6656c764-e336-4a3e-843d-02375d4f39e6",
"ae9bcb65-3afa-4a63-8ce6-e71ba52f7e0d"],
results=[]>
[36] pry(main)> RuleReference.count
(1.5ms) SELECT COUNT(*) FROM "rule_references"
=> 14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment