정리

'Syntax'에 해당되는 글 3건

  1. syntax of cron
  2. SQLite - Syntax
  3. Syntax Highlighter 적용 방법

syntax of cron

저장소/Jenkins

출처: http://htmlpreview.github.io/?https://github.com/jenkinsci/jenkins/blob/master/core/src/main/resources/hudson/triggers/TimerTrigger/help-spec.html




This field follows the syntax of cron (with minor differences). Specifically, each line consists of 5 fields separated by TAB or whitespace:

MINUTE HOUR DOM MONTH DOW

MINUTE Minutes within the hour (0–59)

HOUR The hour of the day (0–23)

DOM The day of the month (1–31)

MONTH The month (1–12)

DOW The day of the week (0–7) where 0 and 7 are Sunday.

To specify multiple values for one field, the following operators are available. In the order of precedence,


* specifies all valid values

M-N specifies a range of values

M-N/X or */X steps by intervals of X through the specified range or whole valid range

A,B,...,Z enumerates multiple values

To allow periodically scheduled tasks to produce even load on the system, the symbol H (for “hash”) should be used wherever possible. For example, using 0 0 * * * for a dozen daily jobs will cause a large spike at midnight. In contrast, using H H * * * would still execute each job once a day, but not all at the same time, better using limited resources.


The H symbol can be used with a range. For example, H H(0-7) * * * means some time between 12:00 AM (midnight) to 7:59 AM. You can also use step intervals with H, with or without ranges.


The H symbol can be thought of as a random value over a range, but it actually is a hash of the job name, not a random function, so that the value remains stable for any given project.


Beware that for the day of month field, short cycles such as */3 or H/3 will not work consistently near the end of most months, due to variable month lengths. For example, */3 will run on the 1st, 4th, …31st days of a long month, then again the next day of the next month. Hashes are always chosen in the 1-28 range, so H/3 will produce a gap between runs of between 3 and 6 days at the end of a month. (Longer cycles will also have inconsistent lengths but the effect may be relatively less noticeable.)


Empty lines and lines that start with # will be ignored as comments.


In addition, @yearly, @annually, @monthly, @weekly, @daily, @midnight, and @hourly are supported as convenient aliases. These use the hash system for automatic balancing. For example, @hourly is the same as H * * * * and could mean at any time during the hour. @midnight actually means some time between 12:00 AM and 2:59 AM.


Examples:


# every fifteen minutes (perhaps at :07, :22, :37, :52)

H/15 * * * *

# every ten minutes in the first half of every hour (three times, perhaps at :04, :14, :24)

H(0-29)/10 * * * *

# once every two hours every weekday (perhaps at 9:38 AM, 11:38 AM, 1:38 PM, 3:38 PM)

H 9-16/2 * * 1-5

# once a day on the 1st and 15th of every month except December

H H 1,15 1-11 *

'저장소 > Jenkins' 카테고리의 다른 글

shared workspace plugin  (0) 2016.03.23
[LINK] Build Trigger  (0) 2016.03.23

SQLite - Syntax

저장소/VC++




SQLite is followed by unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQLite by listing all the basic SQLite Syntax.

Case Sensitivity

Important point to be noted is that SQLite is case insensitive, but there are some commands, which are case sensitive like GLOB and glob have different meaning in SQLite statements.

Comments

SQLite comments are extra notes, which you can add in your SQLite code to increase its readability and they can appear anywhere; whitespace can occur, including inside expressions and in the middle of other SQL statements but they can not be nested.

SQL comments begin with two consecutive "-" characters (ASCII 0x2d) and extend up to and including the next newline character (ASCII 0x0a) or until the end of input, whichever comes first.

You can also use C-style comments, which begin with "/*" and extend up to and including the next "*/" character pair or until the end of input, whichever comes first. C-style comments can span multiple lines.

sqlite>.help -- This is a single line comment

SQLite Statements

All the SQLite statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc., and all the statements end with a semicolon (;).

SQLite ANALYZE Statement:

ANALYZE;
or
ANALYZE database_name;
or
ANALYZE database_name.table_name;

SQLite AND/OR Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION-1 {AND|OR} CONDITION-2;

SQLite ALTER TABLE Statement:

ALTER TABLE table_name ADD COLUMN column_def...;

SQLite ALTER TABLE Statement (Rename):

ALTER TABLE table_name RENAME TO new_table_name;

SQLite ATTACH DATABASE Statement:

ATTACH DATABASE 'DatabaseName' As 'Alias-Name';

SQLite BEGIN TRANSACTION Statement:

BEGIN;
or
BEGIN EXCLUSIVE TRANSACTION;

SQLite BETWEEN Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name BETWEEN val-1 AND val-2;

SQLite COMMIT Statement:

COMMIT;

SQLite CREATE INDEX Statement :

CREATE INDEX index_name
ON table_name ( column_name COLLATE NOCASE );

SQLite CREATE UNIQUE INDEX Statement :

CREATE UNIQUE INDEX index_name
ON table_name ( column1, column2,...columnN);

SQLite CREATE TABLE Statement:

CREATE TABLE table_name(
   column1 datatype,
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
   PRIMARY KEY( one or more columns )
);

SQLite CREATE TRIGGER Statement :

CREATE TRIGGER database_name.trigger_name 
BEFORE INSERT ON table_name FOR EACH ROW
BEGIN 
   stmt1; 
   stmt2;
   ....
END;

SQLite CREATE VIEW Statement :

CREATE VIEW database_name.view_name  AS
SELECT statement....;

SQLite CREATE VIRTUAL TABLE Statement:

CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
or
CREATE VIRTUAL TABLE database_name.table_name USING fts3( );

SQLite COMMIT TRANSACTION Statement:

COMMIT;

SQLite COUNT Clause:

SELECT COUNT(column_name)
FROM   table_name
WHERE  CONDITION;

SQLite DELETE Statement:

DELETE FROM table_name
WHERE  {CONDITION};

SQLite DETACH DATABASE Statement:

DETACH DATABASE 'Alias-Name';

SQLite DISTINCT Clause:

SELECT DISTINCT column1, column2....columnN
FROM   table_name;

SQLite DROP INDEX Statement :

DROP INDEX database_name.index_name;

SQLite DROP TABLE Statement:

DROP TABLE database_name.table_name;

SQLite DROP VIEW Statement :

DROP INDEX database_name.view_name;

SQLite DROP TRIGGER Statement :

DROP INDEX database_name.trigger_name;

SQLite EXISTS Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name EXISTS (SELECT * FROM   table_name );

SQLite EXPLAIN Statement :

EXPLAIN INSERT statement...;
or 
EXPLAIN QUERY PLAN SELECT statement...;

SQLite GLOB Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name GLOB { PATTERN };

SQLite GROUP BY Clause:

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name;

SQLite HAVING Clause:

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name
HAVING (arithematic function condition);

SQLite INSERT INTO Statement:

INSERT INTO table_name( column1, column2....columnN)
VALUES ( value1, value2....valueN);

SQLite IN Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name IN (val-1, val-2,...val-N);

SQLite Like Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name LIKE { PATTERN };

SQLite NOT IN Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name NOT IN (val-1, val-2,...val-N);

SQLite ORDER BY Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION
ORDER BY column_name {ASC|DESC};

SQLite PRAGMA Statement:

PRAGMA pragma_name;

For example:

PRAGMA page_size;
PRAGMA cache_size = 1024;
PRAGMA table_info(table_name);

SQLite RELEASE SAVEPOINT Statement:

RELEASE savepoint_name;

SQLite REINDEX Statement:

REINDEX collation_name;
REINDEX database_name.index_name;
REINDEX database_name.table_name;

SQLite ROLLBACK Statement:

ROLLBACK;
or
ROLLBACK TO SAVEPOINT savepoint_name;

SQLite SAVEPOINT Statement:

SAVEPOINT savepoint_name;

SQLite SELECT Statement:

SELECT column1, column2....columnN
FROM   table_name;

SQLite UPDATE Statement:

UPDATE table_name
SET column1 = value1, column2 = value2....columnN=valueN
[ WHERE  CONDITION ];

SQLite VACUUM Statement:

VACUUM;

SQLite WHERE Clause:

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION;


Syntax Highlighter 적용 방법

저장소/잡다한거

예전에 적용했었는데 스킨을 바꾸니 안 된다.

찾아보니 안 된다네 ㅠㅠ

그래서 이번엔 정리하기로 한다.


잘 정리해놓으신 블로거님께 찬사를!! 덕분에 쉽게 적용했어요 ^^

출처 : http://periar.tistory.com/55



0. Syntax Highlighter를 다운 받자.

http://alexgorbatchev.com/SyntaxHighlighter/download/


1. 관리 페이지에서 HTML/CSS 편집을 열고


2. skin.html을 열고 </body>와 </html> 사이에 아래 내용을 추가

<script type="text/javascript" src="./images/shCore.js"></script> 

<script type="text/javascript" src="./images/shBrushAS3.js"></script> 

<script type="text/javascript" src="./images/shBrushBash.js"></script> 

<script type="text/javascript" src="./images/shBrushCpp.js"></script> 

<script type="text/javascript" src="./images/shBrushCSharp.js"></script> 

<script type="text/javascript" src="./images/shBrushCss.js"></script> 

<script type="text/javascript" src="./images/shBrushDelphi.js"></script> 

<script type="text/javascript" src="./images/shBrushDiff.js"></script> 

<script type="text/javascript" src="./images/shBrushGroovy.js"></script> 

<script type="text/javascript" src="./images/shBrushJava.js"></script> 

<script type="text/javascript" src="./images/shBrushJavaFX.js"></script> 

<script type="text/javascript" src="./images/shBrushJScript.js"></script> 

<script type="text/javascript" src="./images/shBrushPerl.js"></script>

<script type="text/javascript" src="./images/shBrushPhp.js"></script> 

<script type="text/javascript" src="./images/shBrushPlain.js"></script> 

<script type="text/javascript" src="./images/shBrushPowerShell.js"></script> 

<script type="text/javascript" src="./images/shBrushPython.js"></script>

<script type="text/javascript" src="./images/shBrushRuby.js"></script> 

<script type="text/javascript" src="./images/shBrushScala.js"></script>

<script type="text/javascript" src="./images/shBrushSql.js"></script>

<script type="text/javascript" src="./images/shBrushVb.js"></script> 

<script type="text/javascript" src="./images/shBrushXml.js"></script>

<script type="text/javascript" src="./images/shCore.js"></script> 

<script type="text/javascript" src="./images/shLegacy.js"></script> 

<link href="./images/shCore.css" rel="stylesheet" type="text/css"> 

<link href="./images/shThemeRDark.css" rel="stylesheet" type="text/css">

 

<script type="text/javascript"> 

    SyntaxHighlighter.all(); 

    dp.SyntaxHighlighter.HighlightAll('code'); 

</script>


3. style.css에 아래 내용 추가

div .syntaxhighlighter { overflow-y: hidden!important; overflow-x: auto!important; }


4. 파일 업로드로 가서 압축 해제한 Syntax Highlight 폴더 아래 scripts 폴더와 styles 폴더의 모든 파일을 올리자.


5. 끗!



적용 방법

글쓰기 누르고 코드 적용하려는 부분은 HTML을 열어 아래처럼 기록하면 된다.

<pre class="brush: cpp"> function foo()

{

if(counter &lt;= 10)

return;

// it works!

}

</pre>


그러면 이렇게 나온다.

function foo()
{
	if(counter <= 10)
		return;
	// it works!
}

우앙 끝!