Skip to content

Instantly share code, notes, and snippets.

View zidarsk8's full-sized avatar
🐢

Miha Zidar zidarsk8

🐢
38 followers · 12 following
  • Slovenia
View GitHub Profile
@zidarsk8
zidarsk8 / delete.sql
Created January 29, 2017 00:15
CREATE temporary table if not exists ass_rel_ids as (
SELECT rel.id
FROM assessments AS obj
JOIN relationships AS rel ON (
(rel.source_type="Assessment" AND
rel.source_id=obj.id AND
rel.destination_type NOT IN ("Audit", "Comment", "OrgGroup", "Section", "AccessGroup", "System", "Contract", "DataAsset", "Regulation", "Snapshot", "Threat", "Objective", "Document", "Control", "Product", "Vendor", "Risk", "Facility", "Process", "Clause", "Standard", "Policy", "Person", "Market")) OR
(rel.destination_type="Assessment" AND
rel.destination_id=obj.id AND
rel.source_type NOT IN ("Audit", "Comment", "OrgGroup", "Section", "AccessGroup", "System", "Contract", "DataAsset", "Regulation", "Snapshot", "Threat", "Objective", "Document", "Control", "Product", "Vendor", "Risk", "Facility", "Process", "Clause", "Standard", "Policy", "Person", "Market")))
@zidarsk8
zidarsk8 / clear-docker.sh
Last active January 20, 2017 00:17
#!/bin/bash
# Delete all containers
if [ -n "$(docker ps -a -q)" ]; then
docker stop $(docker ps -a -q)
docker rm $(docker ps -a -q)
fi
# Delete all images
@zidarsk8
zidarsk8 / snapshot_objects_prep.sql
Last active December 2, 2016 07:21
-- MySQL dump 10.13 Distrib 5.5.53, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: ggrcdev
-- ------------------------------------------------------
-- Server version 5.5.53-0ubuntu0.14.04.1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@zidarsk8
zidarsk8 / request-response.json
Created November 17, 2016 13:34
-------------------- >> begin captured stdout << ---------------------
################################################################################
request data:
[
{
"filters": {
"expression": {
"left": {
"left": {
"left": "child_type",
@zidarsk8
zidarsk8 / response.json
Created November 17, 2016 13:32
-------------------- >> begin captured stdout << ---------------------
[
{
"Snapshot": {
"count": 3,
"total": 3,
"values": [
{
"child_id": 26,
"child_type": "Market",
@zidarsk8
zidarsk8 / emails.sql
Created November 10, 2016 16:59
-- MySQL dump 10.13 Distrib 5.5.53, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: ggrcdev
-- ------------------------------------------------------
-- Server version 5.5.53-0ubuntu0.14.04.1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@zidarsk8
zidarsk8 / gist:c680ac0455ddbcde37be4e05ff0c550a
Created October 11, 2016 12:28
object generation WITHOUT hmtl cleanup (0, 1 and 5, object properties) values are 4 character strings (str(number))
generate empty model: Control : 0.062584
generate empty model: Process : 0.227454
generate empty model: Program : 0.193430
generate empty model: AccessGroup : 0.176899
generate empty model: Assessment : 0.153280
generate empty model: Person : 0.153514
generate model with title dict: Control : 0.129530
generate model with title dict: Process : 0.258653
@zidarsk8
zidarsk8 / gist:8d8b5fcd441cc150be1dc470ad2fe30f
Created October 7, 2016 23:02
vagrant@4a9f4b8ee0f4 /vagrant
$ python ormtest.py
SQLAlchemy ORM: Total time for 10 records 1.83095216751 secs
SQLAlchemy ORM bulk save objects: Total time for 10 records 1.7470998764 secs
SQLAlchemy Core: Total time for 10 records 1.82306408882 secs
SQLAlchemy Single: Total time for 10 records 0.45939707756 secs
vagrant@4a9f4b8ee0f4 /vagrant
$ python ormtest.py
SQLAlchemy ORM: Total time for 100 records 15.5339519978 secs
SQLAlchemy ORM bulk save objects: Total time for 100 records 15.4684011936 secs
@zidarsk8
zidarsk8 / gist:04041a7fca4a4a2b43ffb4418420e296
Created October 1, 2016 14:09
AccessGroup - * * * * * * * * * * * * * * * * * * * * * * * * *
Assessment - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AssessmentTemplate - * * * * * * * * * * * *
Audit - * * * * * * * * * * * * * * * * * * * *
AuditObject - * * * * * * *
Categorization - * * * * * * *
CategoryBase - * * * * * * * * *
ControlCategory - * * * *
@zidarsk8
zidarsk8 / gist:791b5ae0efe93d2174ed7ab328edbfae
Created September 22, 2016 20:52
2016-09-22 20:52:26,039 INFO sqlalchemy.engine.base.Engine SELECT programs.id AS programs_id, programs.context_id AS programs_context_id
FROM programs
INFO 2016-09-22 20:52:26,039 sqlalchemy.engine.base.Engine SELECT programs.id AS programs_id, programs.context_id AS programs_context_id
FROM programs
2016-09-22 20:52:26,040 INFO sqlalchemy.engine.base.Engine ()
INFO 2016-09-22 20:52:26,040 sqlalchemy.engine.base.Engine ()