splhack

MIT License

Copyright (c) Meta Platforms, Inc. and affiliates.

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

splhack

[ 99%] Linking CXX executable zig0
g++ -O3 -g -pipe -Wall -Wno-error -Wp,-D_FORTIFY_SOURCE=2 -fstack-protector --param=ssp-buffer-size=4 -fno-omit-frame-pointer -momit-leaf-frame-pointer -fno-reorder-blocks-and-partition -gz=none -Wl,-z,relro -fcommon -march=corei7 -mtune=skylake -nostdinc -grecord-gcc-switches -fdebug-prefix-map=zig_root=zig_root -fdebug-prefix-map=build=zig_root -O3 -DNDEBUG <libpaths...> -rdynamic CMakeFiles/zig0.dir/src/stage1/zig0.cpp.o -o zig0  zigcpp/libzigstage1.a zigcpp/libopt_c_util.a zigcpp/libembedded_softfloat.a zigcpp/libzigcpp.a -Wl,-Bstatic -lclangFrontendTool -lclangCodeGen -lclangFrontend -lclangDriver -lclangSerialization -lclangSema -lclangStaticAnalyzerFrontend -lclangStaticAnalyzerCheckers -lclangStaticAnalyzerCore -lclangAnalysis -lclangASTMatchers -lclangAST -lclangParse -lclangSema -lclangStaticAnalyzerFrontend -lclangStaticAnalyzerCheckers -lclangStaticAnalyzerCore -lclangAnalysis -lclangASTMatchers -lclangAST -lclangParse -lclangBasic -lclangEdit -lclangLex -lclangA

splhack

                                                                                                                                                                                       QUERY PLAN                                                                                                                                                                                        
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=2208.55..2463.59 rows=1 width=57) (actual time=22.030..36.003 rows=500 loops=1)
   ->  Nested Loop Semi Join  (cost=2208.55..2463.59 rows=1 width=57) (actual time=22.028..35.937 rows=500 loops=1)
         Join Filter: ((layer.pk_layer)::text = (l.pk_laye

splhack

                                                                                                                                                                                QUERY PLAN                                                                                                                                                                                
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Subquery Scan on t1  (cost=1054.66..1054.69 rows=1 width=57) (actual time=245.933..249.048 rows=500 loops=1)
   Filter: (t1.rank <= 500)
   Rows Removed by Filter: 6835
   ->  WindowAgg  (cost=1054.66..1054.68 rows=1 width=57) (actual time=245.932..248.679 rows=7335 loops=1)
         ->  Sort  (c

splhack

/*EXPLAIN ANALYZE*/
WITH sorted_job AS (
    SELECT
        ROW_NUMBER() OVER (ORDER BY job_resource.int_priority DESC, job.ts_started ASC) AS rank,
        job.pk_job                ,
        job.pk_folder             ,
        job.ts_started            ,
        job_resource.int_priority ,
        job_resource.int_cores    ,
        job_resource.int_max_cores,

splhack

/*EXPLAIN ANALYZE*/
SELECT rank, pk_job, int_priority, ts_started FROM ( 
    SELECT 
        ROW_NUMBER() OVER (ORDER BY job_resource.int_priority DESC, job.ts_started ASC) AS rank, 
        job.pk_job, 
        job_resource.int_priority,
        job.ts_started
    FROM 
        job            , 
        job_resource   , 

splhack

{
  "title": "Remote Desktop",
  "rules": [
    {
      "description": "Change command to control and option to command",
      "manipulators": [
        {
          "type": "basic",
          "from": {
            "key_code": "left_option",

splhack

--- ./src/main/resources/public/dtd/cjsl-1.11.dtd	2021-02-19 09:34:45.000000000 -0800
+++ ./src/main/resources/public/dtd/cjsl-1.12.dtd	2021-03-24 23:24:22.000000000 -0700
@@ -1,5 +1,5 @@
 <!-- ================================================================= -->
-<!-- SpiCue Job Spec DTD ver 1.11                                       -->
+<!-- SpiCue Job Spec DTD ver 1.12                                       -->
 <!-- [email protected]                                        -->
 <!-- ================================================================= -->
 
@@ -38,7 +38,7 @@

splhack

diff --git a/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql b/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
index c9d7714..ce78238 100644
--- a/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
+++ b/cuebot/src/main/resources/conf/ddl/postgres/migrations/V1__Initial_schema.sql
@@ -10,18 +10,19 @@ CREATE TABLE history_period_bak (
 CREATE TABLE frame_history (
     pk_frame_history VARCHAR(36) DEFAULT uuid_generate_v1() NOT NULL,
     pk_frame VARCHAR(36) NOT NULL,
     pk_layer VARCHAR(36) NOT NULL,
     pk_job VARCHAR(36) NOT NULL,

splhack

CREATE VIEW vs_show_resource (pk_show, int_cores) AS
  SELECT
        job.pk_show,
        SUM(int_cores) AS int_cores
    FROM
       job,
       job_resource
    WHERE
       job.pk_job = job_resource.pk_job