Skip to content

Instantly share code, notes, and snippets.

@bifacil
Created December 3, 2019 18:36
Show Gist options
  • Save bifacil/5e2a6a8118cd7f7da71cd45ff99d2fd3 to your computer and use it in GitHub Desktop.
Save bifacil/5e2a6a8118cd7f7da71cd45ff99d2fd3 to your computer and use it in GitHub Desktop.
----------------
-- Converters --
----------------
[ACCESIBLE CONTENT]
ACTION
CHART
[COMPONENT CONTENT]
COMPONENT
CONTAINER
[FILE]
FILTER
[FOR EACH]
[FOR EACH DISTINCT VALUE]
[FOR EACH FILE]
HTML
[IF]
[JSON TABLE]
MARKDOWN
[SET]
[SET YAML]
[TABLE COLUMN]
[TABLE]
[TABLE ROW]
[TEXT NODE]
------------------------------------------------------------------------------------------
-- Components (https://bifacil.github.io/resources.crono.net/components/app-crono.cxml) --
------------------------------------------------------------------------------------------
[HEAD COMPONENTS]
[PAGE HEADER]
[HEADER 2]
[HEADER 3]
[HEADER 4]
PARAGRAPH
[PRIMARY PARAGRAPH]
[INFO PARAGRAPH]
[WARNING PARAGRAPH]
[SUCCESS PARAGRAPH]
[DANGER PARAGRAPH]
[MUTED PARAGRAPH]
LINK
[PRIMARY LINK]
[INFO LINK]
[WARNING LINK]
[SUCCESS LINK]
[DANGER LINK]
[DEFAULT LINK]
LIST
[ORDERED LIST]
[LIST ITEM]
LABEL
[PRIMARY LABEL]
[SUCCESS LABEL]
[INFO LABEL]
[WARNING LABEL]
[DANGER LABEL]
[DEFAULT LABEL]
ALERT
[SUCCESS ALERT]
[WARNING ALERT]
[DANGER ALERT]
[INFO ALERT]
CALLOUT
[SUCCESS CALLOUT]
[WARNING CALLOUT]
[DANGER CALLOUT]
[INFO CALLOUT]
[ACTION BUTTON]
[DEFAULT ACTION BUTTON]
[PRIMARY ACTION BUTTON]
[INFO ACTION BUTTON]
[WARNING ACTION BUTTON]
[DANGER ACTION BUTTON]
[SUCCESS ACTION BUTTON]
[LINK ACTION BUTTON]
BUTTON
[DEFAULT BUTTON]
[PRIMARY BUTTON]
[INFO BUTTON]
[WARNING BUTTON]
[DANGER BUTTON]
[SUCCESS BUTTON]
[LINK BUTTON]
[SUBMIT BUTTON]
[DEFAULT SUBMIT BUTTON]
[PRIMARY SUBMIT BUTTON]
[INFO SUBMIT BUTTON]
[WARNING SUBMIT BUTTON]
[DANGER SUBMIT BUTTON]
[SUCCESS SUBMIT BUTTON]
[LINK SUBMIT BUTTON]
DROPDOWN
[PRIMARY DROPDOWN]
[SUCCESS DROPDOWN]
[INFO DROPDOWN]
[WARNING DROPDOWN]
[DANGER DROPDOWN]
[DROPDOWN ITEM]
PANEL
[PRIMARY PANEL]
[INFO PANEL]
[SUCCESS PANEL]
[WARNING PANEL]
[DANGER PANEL]
[DEFAULT PANEL]
TABS
PILLS
[TAB ITEM]
[TAB CONTENT BASE]
[TAB CONTENT]
[TAB CONTENT AJAX]
MODAL
[MODAL SMALL]
[MODAL LARGE]
[MODAL AJAX]
[TABLE RESPONSIVE]
[DATA TABLE]
[PANEL TABLE]
FORMULARY
[FORM LABEL]
[INPUT TEXT]
[INPUT NUMBER]
[INPUT DATE]
[INPUT DATETIME-LOCAL]
[INPUT HIDDEN]
[INPUT SELECT]
[INPUT OPTION]
[INPUT CHECKBOX]
[INPUT RADIO]
[INPUT FILE]
[INPUT FILE PRIMARY]
[GRID ROW]
[GRID COLUMN 1]
[GRID COLUMN 2]
[GRID COLUMN 3]
[GRID COLUMN 4]
[GRID COLUMN 5]
[GRID COLUMN 6]
[GRID COLUMN 8]
[GRID COLUMN 9]
[GRID COLUMN 12]
[APP HEAD]
DOCUMENT
[LEFT MENU]
[MENU HOME ITEM]
[MENU ITEM]
[MENU ITEM DESPLEGABLE]
[SUBMENU ITEM]
[HOME SECTION]
[HOME BUTTON]
DEFAULTMARKDOWNTEMPLATE
-------------------
-- SQL Functions --
-------------------
abs
acos
ascii
asin
atan
atn2
avg
binary_checksum
cast
ceiling
charindex
checksum
checksum_agg
coalesce
col_length
col_name
collationproperty
columnproperty
columns_updated
concat
convert
cos
cot
count
count_big
current_time
current_timestamp
current_user
cursor_status
databaseproperty
databasepropertyex
datalength
dateadd
datediff
datefromparts
datename
datepart
datetime2fromparts
datetimefromparts
datetimeoffsetfromparts
day
db_id
db_name
degrees
difference
eomonth
exp
file_id
file_name
filegroup_id
filegroup_name
filegroupproperty
fileproperty
floor
format
formatmessage
fulltextcatalogproperty
fulltextserviceproperty
getansinull
getdate
getutcdate
grouping
grouping_id
has_dbaccess
host_id
host_name
ident_current
ident_incr
ident_seed
index_col
indexkey_property
indexproperty
is_member
is_srvrolemember
isdate
isnull
isnumeric
lag
lead
left
len
log
log10
lower
ltrim
max
min
month
newid
nullif
object_id
object_name
objectproperty
parse
parsename
patindex
permissions
pi
power
quotename
radians
rand
replace
replicate
reverse
right
round
rowcount_big
rtrim
scope_identity
serverproperty
session_user
sessionproperty
sign
sin
smalldatetimefromparts
soundex
space
sql_variant_property
sqrt
square
stats_date
stdev
stdevp
str
stuff
substring
sum
suser_sid
suser_sname
switchoffset
sysdatetime
sysdatetimeoffset
system_user
sysutcdatetime
tan
timefromparts
todatetimeoffset
trim
try_cast
try_convert
try_parse
typeproperty
unicode
upper
user_id
user_name
var
varp
year
---------------------
-- Crono Functions --
---------------------
addition
coalesce
Crono$Directory
Crono$DirectoryName
Crono$Download
Crono$FileName
Crono$FileNameWithoutExtension
Crono$HeaderProperty
Crono$IsoDate
Crono$MarkdownTitle
Crono$NiceUrlName
Crono$ReadFile
Crono$RfcDate
Crono$Route
datediff
divide
emptyifnull
left
maximum
md5
minimum
nameof
nullifempty
nullifzero
right
round
sha1
sha256
single
substraction
trim
valueof
zeroifnull
-----------------
-- Crono Views --
-----------------
Crono$CronoViews
TIME_TABLE
Crono$Dates
Crono$Indexes
Crono$IndexColumns
Crono$ForeignKeys
Crono$Countries
Crono$SpanishRegions
Crono$SpanishProvinces
Crono$SpanishCities
Crono$Months
Crono$Constraints
Crono$ConstraintsColumns
Crono$CronoFunctions
Crono$SqlFunctions
---------------
-- Terminals --
---------------
ADD
ALL
ALTER
AND
ANTI
APPLY
ARRAY
AS
ASC
ASSERT
AUTHORIZATION
AUTO_INCREMENT
AVGIF
BEGIN
BEGIN CATCH
BETWEEN
BREAK
BULK
BUSINESS
BY
CALCULATE
CASCADE
CASE
CAST
CATCH
CHECK
CLUSTERED
COLLATE
COLUMN
COLUMNS
COMBINE
COMMIT
COMPARE
CONCAT
CONSTRAINT
CONTAINS
CONVERT
COPY
COUNTIF
CREATE
Crono$Assertions
Crono$FileSqlContent
Crono$FileSystem
CRONO_CLEAN_CODE
CRONO_DESERIALIZE
CRONO_DESERIALIZE_INTO
CROSS
CURRENT
DATABASE
DECLARE
DEFAULT
DEFAULT-VALUE
DELETE
DELETE AND INSERT
DESC
DICTIONARY
DIFFERENCES
DIRECTORY
DISTINCT
DROP
EACH
ELEMENTAT(
ELSE
END
ENDS
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXPRESSION
EXPRESSION_LIST
FACT
FIFO
FILE
FILE_CONTENT
FILTER
FINALIZATION
FOLLOWING
for
FOREIGN
FROM
FULL
FUNCTION
GROUP
HAVING
IDENTITY
IF
IF(
IIF
IN
INCLUDE
INDEX
INDEXOF(
INFORMATION
INITIALIZATION
INNER
INSERT
INTEGERS
INTO
IS
JOIN
KEY
LEFT
LIFO
LIKE
LOAD
LOGGER
LOOKUP
MAIN
MATERIALIZE
MAXIF
MERGE
MERGE ALL
MINIF
mod
MTD
MULTI
NAMES
NEXT
NOCHECK
NO-MERGE
NONCLUSTERED
NONUNIQUE
NOT
NULL
OBJECT_TYPE
OFF
ON
OPENROWSET
OR
ORDER
OUT
OUTER
OUTPUT
OVER
PARAMETER_LIST
PARTITION
PER
PERCENT
PRECEDING
PREVIOUS
PRIMARY
PRINT
PROCEDURE
QTD
QUALIFY
RAISERROR
RANGE
REFERENCES
REPLACE
RETURN
RETURNS
RIGHT
ROLLBACK
ROUTINES
ROW
ROWS
SCHEMA
SELECT
SELECT_ALL
SEMI
SEPARATOR
SET
SET_PROPERTY_NAME_EQUAL
SNOWFLAKE
SQL
START
STARTS
STATEMENT
STATEMENTS
STRATEGY
SUMIF
SWITCH(
TABLE
TABLES
TD
THAT
THEN
THROW
TO
TOP
TRANSACTION
TRUNCATE
TRUNCATE AND INSERT
TRY
UNBOUNDED
UNDEFINED
UNION
UNIQUE
UNPIVOT
UPDATE
UPDATE ALL
UPDATE HISTORY
UPDATE STATISTICS
URI
USE
USING
VALUE
ValueOf
values
VIEW
WHEN
WHEN INSERT
WHEN MATCHED
WHEN MISSING
WHEN MODIFIED
WHEN NOT MATCHED BY SOURCE
WHEN NOT MATCHED THEN
WHEN UPDATE
WHERE
WHILE
WITH
WITH FULLSCAN
WITHOUT
YTD
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment