About Quark Server

Caution

Quark Server is deprecated. Please, use Quark Cloud instead.

Documentation

This documentation is for Quark 3.0.0 in development.

ℹ️ Note for users of Quark older 3.0.0

For older versions of Quark, please, search for README.md in the release commit with tag you want. We are currently working on a documentation system with multiple versions. Thank you.

Instructions

Instructions are used to create tables, query data, and much more.

`add column`

Adds a new column to a table

Permission: column.add

Parameters:

definition: column
table: str
generator: generator

Syntax:

add column (column: definition): table = str, generator = generator;

`change in`

Changes records match the condition

Permission: table.change

Parameters:

table: str
selector: selector
changer: changer

Syntax:

change in (str: table): selector = selector, changer = changer;

`change port to`

Changes the server port

Permission: server.port.change

Parameters:

port: int

Syntax:

change port to (int: port);

`clear database`

Deletes all the tables inside the database

Permission: database.clear

Parameters:

database: str

Syntax:

clear database (str: database);

`clear table`

Removes all the records from the table

Permission: table.clear

Parameters:

table: str

Syntax:

clear table (str: table);

`clone database`

Copies the database with all the contents

Permission: database.clone

Parameters:

prototype: str
destination: str

Syntax:

clone database (str: prototype): destination = str;

`clone database scheme`

Clones the database, but clears the tables

Permission: database.scheme

Parameters:

prototype: str
destination: str

Syntax:

clone database scheme (str: prototype): destination = str;

`clone table`

Clones the table

Permission: table.clone

Parameters:

prototype: str
destination: str

Syntax:

clone table (str: prototype): destination = str;

`clone table scheme`

Clones the table, but deletes the records

Permission: table.scheme

Parameters:

prototype: str
destination: str

Syntax:

clone table scheme (str: prototype): destination = str;

`create database`

Creates a database

Permission: database.create

Parameters:

name: str

Syntax:

create database (str: name);

`create table`

Creates a table

Permission: table.create

Parameters:

table: str
columns: list of column
records: list of record

Syntax:

create table (str: table): columns = list of column, records = list of record;

`create token`

Creates an access token

Permission: token.create

Parameters:

token: str
permissions: list of str

Syntax:

create token (str: token): permissions = list of str;

`_debug`

Does stuff for Quark developers. Don't use.

Permission: !unsafe.debug

Parameters:

json: str

Syntax:

_debug: json = str;

`delete column`

Deletes a column in a table

Permission: column.delete

Parameters:

name: str
table: str

Syntax:

delete column (str: name): table = str;

`delete database`

Deletes a database

Permission: database.delete

Parameters:

database: str

Syntax:

delete database (str: database);

`delete from`

Deletes records meet the condition

Permission: json.delete

Parameters:

table: str
selector: selector
skip: int
limit: int

Syntax:

delete from (str: table): selector = selector, skip = int, limit = int;

`delete table`

Deletes a table

Permission: table.delete

Parameters:

table: str

Syntax:

delete table (str: table);

`eval`

Evaluates the Quark QL entity.

Permission: !unsafe.eval

Parameters:

entity: ?

Syntax:

eval (?: entity);

`factory reset`

Resets the server to factory settings

Permission: !unsafe.factory-reset

Parameters:

Syntax:

factory reset;

`grant token`

Grants a token a permission

Permission: token.grand

Parameters:

token: str
permission: str

Syntax:

grant token (str: token): permission = str;

`insert into`

Inserts a new record to a table

Permission: table.insert

Parameters:

table: str
record: record

Syntax:

insert into (str: table): record = record;

`list columns in`

Lists columns in a table

Permission: column.list

Parameters:

table: str

Syntax:

list columns in (str: table);

`list databases`

Lists the databases

Permission: databases.list

Parameters:

Syntax:

list databases;

`list tables in`

Lists tables in a database

Permission: table.list

Parameters:

database: str

Syntax:

list tables in (str: database);

`redefine permissions for token`

Defines a new set of permissions for a token

Permission: token.redefine

Parameters:

token: str
permissions: list of str

Syntax:

redefine permissions for token (str: token): permissions = list of str;

`reload server`

Reloads the server

Permission: server.reload

Parameters:

Syntax:

reload server;

`rename column in`

Renames a column in a table

Permission: column.rename

Parameters:

table: str
old: str
new: str

Syntax:

rename column in (str: table): old = str, new = str;

`rename database`

Renames a database

Permission: database.rename

Parameters:

old: str
new: str

Syntax:

rename database: old = str, new = str;

`rename server to`

Renames the server

Permission: server.rename

Parameters:

new: str

Syntax:

rename server to (str: new);

`rename table`

Renames a table

Permission: table.rename

Parameters:

old: str
new: str

Syntax:

rename table: old = str, new = str;

`reorder columns in`

Changes the column order

Permission: column.reorder

Parameters:

table: str
order: list of str

Syntax:

reorder columns in (str: table): order = list of str;

`run command`

Runs a command

Permission: server.command

Parameters:

command: str

Syntax:

run command (str: command);

`schedule command`

Schedules a command

Permission: server.schedule.command

Parameters:

command: str
period: long

Syntax:

schedule command (str: command): period = long;

`schedule query`

Schedules a query

Permission: server.schedule.query

Parameters:

query: str
period: long

Syntax:

schedule query (str: query): period = long;

`select from`

Selects records from a table

Permission: json.select

Parameters:

table: str
selector: selector
skip: int
limit: int

Syntax:

select from (str: table): selector = selector, skip = int, limit = int;

`stop server`

Stop the server

Permission: server.stop

Parameters:

Syntax:

stop server;

`swap columns in`

Swaps two columns in a table

Permission: columns.swap

Parameters:

table: str
first: str
second: str

Syntax:

swap columns in (str: table): first = str, second = str;

`remove permission from token`

Removes a permission from a token

Permission: token.remove permission

Parameters:

token: str
permission: str

Syntax:

remove permission from token (str: token): permission = str;

`_describe instructions`

Describes all the instructions. Don't use.

Permission: any

Parameters:

Syntax:

_describe instructions;

`_describe constructors`

Describes all the constructors. Don't use.

Permission: any

Parameters:

Syntax:

_describe constructors;

`_hint next elements`

Hints the next elements for editor hints. Don't use.

Permission: any

Parameters:

query: str
caret position: int

Syntax:

_hint next elements: query = str, caret position = int;

`get server name`

Returns the server name

Permission: any

Parameters:

Syntax:

get server name;

`secret`

What does it do? Hm-m...

Permission: any

Parameters:

Syntax:

secret;

`add modifier to`

Adds a new table modifier

Permission: table.add modifier

Parameters:

table: str
column: str
modifier: modifier

Syntax:

add modifier to (str: table): column = str, modifier = modifier;

`list plugins`

Lists loaded plugins

Permission: server.plugins

Parameters:

Syntax:

list plugins;

`find in`

Quickly finds a record by a single field

Permission: table.find

Parameters:

table: str
finder: finder

Syntax:

find in (str: table): finder = finder;

`count in`

Counts records matching condition

Permission: table.count in

Parameters:

table: str
selector: selector

Syntax:

count in (str: table): selector = selector;

`_describe modifiers of`

Shows all the modifiers of the table. Don't use

Permission: table.describe modifiers

Parameters:

table: str

Syntax:

_describe modifiers of (str: table);

`clear scheduled commands`

Clears all the scheduled commands.

Permission: server.schedule.command.clear

Parameters:

Syntax:

clear scheduled commands;

`clear scheduled queries`

Clears all the scheduled queries.

Permission: server.schedule.query.clear

Parameters:

Syntax:

clear scheduled queries;

`get variable in`

Shows the variable value of the table

Permission: table.variable.get

Parameters:

table: str
name: str

Syntax:

get variable in (str: table): name = str;

`set variable in`

Sets a new value for a variable in the table

Permission: table.variable.set

Parameters:

table: str
name: str
value: ?

Syntax:

set variable in (str: table): name = str, value = ?;

`list variables in`

Shows all the variables inside the table

Permission: table.variable.list

Parameters:

table: str

Syntax:

list variables in (str: table);

`delete variable in`

Deletes a variable in the table

Permission: table.variable.delete

Parameters:

table: str
name: str

Syntax:

delete variable in (str: table): name = str;

`exclude from`

Excludes the records matches the finder

Permission: table.exclude

Parameters:

table: str
finder: finder

Syntax:

exclude from (str: table): finder = finder;

`get version`

Returns Quark's version

Permission: any

Parameters:

Syntax:

get version;

`var`

Defines a variable

Permission: var

Parameters:

name: str
value: ?

Syntax:

var (str: name): value = ?;

Constructors

Constructors can transform entities in both your instructions and tables. Use them for integers, strings, lists, and any other type of entities.

`abs: double`

Abs

Parameters:

arg0: double

Syntax:

double @abs(double: arg0)

`sin: double`

Sin

Parameters:

arg0: double

Syntax:

double @sin(double: arg0)

`cos: double`

Cos

Parameters:

arg0: double

Syntax:

double @cos(double: arg0)

`tan: double`

Tan

Parameters:

arg0: double

Syntax:

double @tan(double: arg0)

`atan2: double`

Atan2

Parameters:

arg0: double
arg1: double

Syntax:

double @atan2(double: arg0, double: arg1)

`sqrt: double`

Sqrt

Parameters:

arg0: double

Syntax:

double @sqrt(double: arg0)

`log: double`

Log

Parameters:

arg0: double

Syntax:

double @log(double: arg0)

`log10: double`

Log10

Parameters:

arg0: double

Syntax:

double @log10(double: arg0)

`pow: double`

Pow

Parameters:

arg0: double
arg1: double

Syntax:

double @pow(double: arg0, double: arg1)

`exp: double`

Exp

Parameters:

arg0: double

Syntax:

double @exp(double: arg0)

`min: double`

Min

Parameters:

arg0: double
arg1: double

Syntax:

double @min(double: arg0, double: arg1)

`max: double`

Max

Parameters:

arg0: double
arg1: double

Syntax:

double @max(double: arg0, double: arg1)

`floor: double`

Floor

Parameters:

arg0: double

Syntax:

double @floor(double: arg0)

`ceil: double`

Ceil

Parameters:

arg0: double

Syntax:

double @ceil(double: arg0)

`rint: double`

Rint

Parameters:

arg0: double

Syntax:

double @rint(double: arg0)

`round: int`

Round

Parameters:

arg0: float

Syntax:

int @round(float: arg0)

`add exact: long`

Add exact

Parameters:

arg0: long
arg1: long

Syntax:

long @add exact(long: arg0, long: arg1)

`decrement exact: int`

Decrement exact

Parameters:

arg0: int

Syntax:

int @decrement exact(int: arg0)

`increment exact: long`

Increment exact

Parameters:

arg0: long

Syntax:

long @increment exact(long: arg0)

`multiply exact: long`

Multiply exact

Parameters:

arg0: long
arg1: long

Syntax:

long @multiply exact(long: arg0, long: arg1)

`multiply high: long`

Multiply high

Parameters:

arg0: long
arg1: long

Syntax:

long @multiply high(long: arg0, long: arg1)

`unsigned multiply high: long`

Unsigned multiply high

Parameters:

arg0: long
arg1: long

Syntax:

long @unsigned multiply high(long: arg0, long: arg1)

`negate exact: int`

Negate exact

Parameters:

arg0: int

Syntax:

int @negate exact(int: arg0)

`subtract exact: long`

Subtract exact

Parameters:

arg0: long
arg1: long

Syntax:

long @subtract exact(long: arg0, long: arg1)

`fma: double`

Fma

Parameters:

arg0: double
arg1: double
arg2: double

Syntax:

double @fma(double: arg0, double: arg1, double: arg2)

`copy sign: double`

Copy sign

Parameters:

arg0: double
arg1: double

Syntax:

double @copy sign(double: arg0, double: arg1)

`signum: double`

Signum

Parameters:

arg0: double

Syntax:

double @signum(double: arg0)

`clamp: float`

Clamp

Parameters:

arg0: float
arg1: float
arg2: float

Syntax:

float @clamp(float: arg0, float: arg1, float: arg2)

`scalb: float`

Scalb

Parameters:

arg0: float
arg1: int

Syntax:

float @scalb(float: arg0, int: arg1)

`get exponent: int`

Get exponent

Parameters:

arg0: double

Syntax:

int @get exponent(double: arg0)

`floor mod: int`

Floor mod

Parameters:

arg0: int
arg1: int

Syntax:

int @floor mod(int: arg0, int: arg1)

`asin: double`

Asin

Parameters:

arg0: double

Syntax:

double @asin(double: arg0)

`acos: double`

Acos

Parameters:

arg0: double

Syntax:

double @acos(double: arg0)

`atan: double`

Atan

Parameters:

arg0: double

Syntax:

double @atan(double: arg0)

`cbrt: double`

Cbrt

Parameters:

arg0: double

Syntax:

double @cbrt(double: arg0)

`i e e eremainder: double`

i e e eremainder

Parameters:

arg0: double
arg1: double

Syntax:

double @ i e e eremainder(double: arg0, double: arg1)

`floor div: long`

Floor div

Parameters:

arg0: long
arg1: long

Syntax:

long @floor div(long: arg0, long: arg1)

`ceil div: long`

Ceil div

Parameters:

arg0: long
arg1: long

Syntax:

long @ceil div(long: arg0, long: arg1)

`ceil mod: long`

Ceil mod

Parameters:

arg0: long
arg1: long

Syntax:

long @ceil mod(long: arg0, long: arg1)

`power of two d: double`

Power of two d

Parameters:

arg0: int

Syntax:

double @power of two d(int: arg0)

`power of two f: float`

Power of two f

Parameters:

arg0: int

Syntax:

float @power of two f(int: arg0)

`sinh: double`

Sinh

Parameters:

arg0: double

Syntax:

double @sinh(double: arg0)

`cosh: double`

Cosh

Parameters:

arg0: double

Syntax:

double @cosh(double: arg0)

`tanh: double`

Tanh

Parameters:

arg0: double

Syntax:

double @tanh(double: arg0)

`hypot: double`

Hypot

Parameters:

arg0: double
arg1: double

Syntax:

double @hypot(double: arg0, double: arg1)

`expm1: double`

Expm1

Parameters:

arg0: double

Syntax:

double @expm1(double: arg0)

`log1p: double`

Log1p

Parameters:

arg0: double

Syntax:

double @log1p(double: arg0)

`to radians: double`

To radians

Parameters:

arg0: double

Syntax:

double @to radians(double: arg0)

`to degrees: double`

To degrees

Parameters:

arg0: double

Syntax:

double @to degrees(double: arg0)

`random: double`

Random

Parameters:

Syntax:

double @random

`divide exact: int`

Divide exact

Parameters:

arg0: int
arg1: int

Syntax:

int @divide exact(int: arg0, int: arg1)

`floor div exact: long`

Floor div exact

Parameters:

arg0: long
arg1: long

Syntax:

long @floor div exact(long: arg0, long: arg1)

`ceil div exact: long`

Ceil div exact

Parameters:

arg0: long
arg1: long

Syntax:

long @ceil div exact(long: arg0, long: arg1)

`to int exact: int`

To int exact

Parameters:

arg0: long

Syntax:

int @to int exact(long: arg0)

`multiply full: long`

Multiply full

Parameters:

arg0: int
arg1: int

Syntax:

long @multiply full(int: arg0, int: arg1)

`abs exact: long`

Abs exact

Parameters:

arg0: long

Syntax:

long @abs exact(long: arg0)

`ulp: double`

Ulp

Parameters:

arg0: double

Syntax:

double @ulp(double: arg0)

`next after: float`

Next after

Parameters:

arg0: float
arg1: double

Syntax:

float @next after(float: arg0, double: arg1)

`next up: double`

Next up

Parameters:

arg0: double

Syntax:

double @next up(double: arg0)

`next down: double`

Next down

Parameters:

arg0: double

Syntax:

double @next down(double: arg0)

`limit: int`

Limit

Parameters:

integer: int
min: int
max: int

Syntax:

int @limit(int: integer, int: min, int: max)

`between: boolean`

Between

Parameters:

min: int
integer: int
max: int

Syntax:

boolean @between(int: min, int: integer, int: max)

`count digits: int`

Count digits

Parameters:

integer: int

Syntax:

int @count digits(int: integer)

`index limit: int`

Index limit

Parameters:

integer: int
length: int

Syntax:

int @index limit(int: integer, int: length)

`positive modulus: int`

Positive modulus

Parameters:

integer: int
divisor: int

Syntax:

int @positive modulus(int: integer, int: divisor)

`now: date`

Now

Parameters:

Syntax:

date @now

`upper: str`

The string in upper case

Parameters:

string to uppercase: str

Syntax:

str @upper(str: string to uppercase)

`lower: str`

The string in lower case

Parameters:

string to lowercase: str

Syntax:

str @lower(str: string to lowercase)

`list: list`

A new list of values

Parameters:

values: ?

Syntax:

list @list(? varargs: values)

`yes: boolean`

The true value

Parameters:

Syntax:

boolean @yes

`no: boolean`

The false value

Parameters:

Syntax:

boolean @no

`concat: str`

Concatenated string

Parameters:

strings: str

Syntax:

str @concat(str varargs: strings)

`selector: selector`

The selector

Parameters:

selector lambda: str

Syntax:

selector @selector(str: selector lambda)

`and: boolean`

Result of and

Parameters:

booleans: boolean

Syntax:

boolean @and(boolean varargs: booleans)

`capitalize: str`

Capitalized string

Parameters:

string to capitalize: str

Syntax:

str @capitalize(str: string to capitalize)

`invert case: str`

The string with case inverted

Parameters:

string where to switch case: str

Syntax:

str @invert case(str: string where to switch case)

`count: int`

Number of elements inside the list

Parameters:

list to count elements: list of ?

Syntax:

int @count(list of ?: list to count elements)

`digit count: int`

Count of digits of the integer

Parameters:

integer: int

Syntax:

int @digit count(int: integer)

`e: float`

The value of 'e' math constant

Parameters:

Syntax:

float @e

`empty list of: list`

An empty list with specified type

Parameters:

type name of a new list: str

Syntax:

list @empty list of(str: type name of a new list)

`ends with: boolean`

Is string ends with the suffix

Parameters:

string: str
suffix: str

Syntax:

boolean @ends with(str: string, str: suffix)

`equals: boolean`

Are these objects equal

Parameters:

first object: ?
second object: ?

Syntax:

boolean @equals(?: first object, ?: second object)

`from binary string: int`

The value of the binary string

Parameters:

binary string to convert to integer: str

Syntax:

int @from binary string(str: binary string to convert to integer)

`from hex string: int`

The value of the hex string

Parameters:

hex string to convert to integer: str

Syntax:

int @from hex string(str: hex string to convert to integer)

`from octal string: int`

The value of the octal string

Parameters:

octal string to convert to integer: str

Syntax:

int @from octal string(str: octal string to convert to integer)

`greater: boolean`

Is the first number greater than the second

Parameters:

first number: float
second number: float

Syntax:

boolean @greater(float: first number, float: second number)

`greater or equals: boolean`

Is the first number greater than the second or equals to

Parameters:

first number: float
second number: float

Syntax:

boolean @greater or equals(float: first number, float: second number)

`is string empty: boolean`

Is the string empty

Parameters:

string: str

Syntax:

boolean @is string empty(str: string)

`join: list`

A joined list

Parameters:

first list: list of ?
more lists: list of ?

Syntax:

list @join(list of ?: first list, list of ? varargs: more lists)

`left trim: str`

The left trimmed string

Parameters:

string to trim: str

Syntax:

str @left trim(str: string to trim)

`length: int`

The length of the string

Parameters:

string to count characters in: str

Syntax:

int @length(str: string to count characters in)

`less: boolean`

Is the first number is less than the second

Parameters:

first number: float
second number: float

Syntax:

boolean @less(float: first number, float: second number)

`less or equals: boolean`

Is the first number is less than the second or equals to

Parameters:

first number: float
second number: float

Syntax:

boolean @less or equals(float: first number, float: second number)

`matches: boolean`

Is the string matches regex

Parameters:

string to check: str
regex lambda: str

Syntax:

boolean @matches(str: string to check, str: regex lambda)

`reverse string: str`

The reversed string

Parameters:

string to reverse: str

Syntax:

str @reverse string(str: string to reverse)

`or: boolean`

The result of or

Parameters:

booleans: boolean

Syntax:

boolean @or(boolean varargs: booleans)

`pi: float`

The value of pi constant

Parameters:

Syntax:

float @pi

`random between: int`

The random value

Parameters:

inclusive min: int
exclusive max: int

Syntax:

int @random between(int: inclusive min, int: exclusive max)

`repeat: str`

The repeated string

Parameters:

string to repeat: str
times to repeat: int

Syntax:

str @repeat(str: string to repeat, int: times to repeat)

`replace: str`

The string with replaced entries

Parameters:

string where to replace: str
string to be replaced: str
string to replace: str

Syntax:

str @replace(str: string where to replace, str: string to be replaced, str: string to replace)

`right trim: str`

The right trimmed string

Parameters:

string to trim: str

Syntax:

str @right trim(str: string to trim)

`sort: list`

The sorted list

Parameters:

list to sort: list

Syntax:

list @sort(list: list to sort)

`split: list`

The string parts

Parameters:

string to split: str
delimiter: str

Syntax:

list @split(str: string to split, str: delimiter)

`starts with: boolean`

Does the string start with the prefix

Parameters:

string: str
prefix: str

Syntax:

boolean @starts with(str: string, str: prefix)

`string contains: boolean`

Does the string contain the entry

Parameters:

string where to search: str
searching string: str

Syntax:

boolean @string contains(str: string where to search, str: searching string)

`to binary string: str`

The binary string

Parameters:

integer to convert to binary string: int

Syntax:

str @to binary string(int: integer to convert to binary string)

`to boolean: boolean`

The boolean

Parameters:

string to convert to boolean: str
default boolean value if conversation fails: boolean

Syntax:

boolean @to boolean(str: string to convert to boolean, optional boolean: default boolean value if conversation fails)

`to float: float`

The float

Parameters:

string to convert to float: str
default float value if conversation fails: float

Syntax:

float @to float(str: string to convert to float, optional float: default float value if conversation fails)

`to hex string: str`

The hex string

Parameters:

integer to convert to hex string: int

Syntax:

str @to hex string(int: integer to convert to hex string)

`to int: int`

The integer

Parameters:

string to convert to integer: str
default integer value if conversation fails: int

Syntax:

int @to int(str: string to convert to integer, optional int: default integer value if conversation fails)

`to octal string: str`

The octal string

Parameters:

integer to convert to octal string: int

Syntax:

str @to octal string(int: integer to convert to octal string)

`trim: str`

The trimmed string

Parameters:

string to trim: str

Syntax:

str @trim(str: string to trim)

`divide: float`

Fraction

Parameters:

number to divide: float
divisor: float

Syntax:

float @divide(float: number to divide, float: divisor)

`multiply: float`

The product

Parameters:

numbers to multiply: float

Syntax:

float @multiply(float varargs: numbers to multiply)

`not: boolean`

Negated value

Parameters:

boolean to invert: boolean

Syntax:

boolean @not(boolean: boolean to invert)

`subtract: float`

The difference

Parameters:

number to subtract from: float
numbers to subtract: float

Syntax:

float @subtract(float: number to subtract from, float varargs: numbers to subtract)

`sum: float`

The sum

Parameters:

numbers to sum: float

Syntax:

float @sum(float varargs: numbers to sum)

`record: record`

The record

Parameters:

values: ?

Syntax:

record @record(? varargs: values)

`changer: changer`

The record changer

Parameters:

column name to change: str
changer lambda: str

Syntax:

changer @changer(str: column name to change, str: changer lambda)

`null: any`

The null constant

Parameters:

type of null: str

Syntax:

nullable any @null(optional str: type of null)

`generator: generator`

The field generator

Parameters:

lambda: str

Syntax:

generator @generator(str: lambda)

`finder: finder`

The finder

Parameters:

column name: str
finding object: ?

Syntax:

finder @finder(str: column name, ?: finding object)

`date from stamp: date`

The date from unix timestamp

Parameters:

unix time stamp: long

Syntax:

date @date from stamp(long: unix time stamp)

`milliseconds: long`

The amount of milliseconds

Parameters:

milliseconds: long

Syntax:

long @milliseconds(long: milliseconds)

`seconds: long`

The amount of milliseconds

Parameters:

seconds: long

Syntax:

long @seconds(long: seconds)

`minutes: long`

The amount of milliseconds

Parameters:

minutes: long

Syntax:

long @minutes(long: minutes)

`hours: long`

The amount of milliseconds

Parameters:

hours: long

Syntax:

long @hours(long: hours)

`days: long`

The amount of milliseconds

Parameters:

days: long

Syntax:

long @days(long: days)

`weeks: long`

The amount of milliseconds

Parameters:

weeks: long

Syntax:

long @weeks(long: weeks)

`months: long`

The amount of milliseconds

Parameters:

months: long

Syntax:

long @months(long: months)

`years: long`

The amount of milliseconds

Parameters:

years: long

Syntax:

long @years(long: years)

`date from format: date`

The date from the format passed in

Parameters:

date format: str
formatted date: str

Syntax:

date @date from format(str: date format, str: formatted date)

`millisecond: long`

1 millisecond

Parameters:

Syntax:

long @millisecond

`second: long`

Milliseconds in 1 second

Parameters:

Syntax:

long @second

`minute: long`

Milliseconds in 1 minute

Parameters:

Syntax:

long @minute

`hour: long`

Milliseconds in 1 hour

Parameters:

Syntax:

long @hour

`day: long`

Milliseconds in 1 day

Parameters:

Syntax:

long @day

`week: long`

Milliseconds in 1 week

Parameters:

Syntax:

long @week

`month: long`

Milliseconds in 1 month

Parameters:

Syntax:

long @month

`year: long`

Milliseconds in 1 year

Parameters:

Syntax:

long @year

`cast: any`

Casted entity

Parameters:

casting entity: ?
cast type: str

Syntax:

any @cast(?: casting entity, str: cast type)

`var: any`

The value of the variable

Parameters:

variable name: str

Syntax:

any @var(str: variable name)

`require between: modifier`

The column modifier

Parameters:

min: float
max: float

Syntax:

modifier @require between(float: min, float: max)

`require constant: modifier`

The column modifier

Parameters:

Syntax:

modifier @require constant

`incrementing: modifier`

The column modifier

Parameters:

Syntax:

modifier @incrementing

`require negative: modifier`

The column modifier

Parameters:

Syntax:

modifier @require negative

`require not negative: modifier`

The column modifier

Parameters:

Syntax:

modifier @require not negative

`positive: modifier`

The column modifier

Parameters:

Syntax:

modifier @positive

`require not positive: modifier`

The column modifier

Parameters:

Syntax:

modifier @require not positive

`alpha dash dot underscore: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dash dot underscore

`alpha dash: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dash

`alpha dash numeric: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dash numeric

`alpha dash underscore: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dash underscore

`alpha dot: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dot

`alpha dot underscore: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha dot underscore

`alpha underscore: modifier`

The column modifier

Parameters:

Syntax:

modifier @alpha underscore

`email: modifier`

The column modifier

Parameters:

Syntax:

modifier @email

`not blank: modifier`

The column modifier

Parameters:

Syntax:

modifier @not blank

`required: modifier`

The column modifier

Parameters:

Syntax:

modifier @required

`regex: modifier`

The column modifier

Parameters:

Syntax:

modifier @regex

`hex color: modifier`

The column modifier

Parameters:

Syntax:

modifier @hex color

`url: modifier`

The column modifier

Parameters:

Syntax:

modifier @url

`unique: modifier`

The column modifier

Parameters:

Syntax:

modifier @unique

`default: modifier`

The column modifier

Parameters:

default value: ?

Syntax:

modifier @default(?: default value)

`id: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @id(str: column name, modifier varargs: modifiers)

`str: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @str(str: column name, modifier varargs: modifiers)

`int: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @int(str: column name, modifier varargs: modifiers)

`boolean: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @boolean(str: column name, modifier varargs: modifiers)

`float: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @float(str: column name, modifier varargs: modifiers)

`date: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @date(str: column name, modifier varargs: modifiers)

`long: column`

The column description

Parameters:

column name: str
modifiers: modifier

Syntax:

column @long(str: column name, modifier varargs: modifiers)

Commands

Commands helps with server interaction.

`/exit`

Stops the server so you will need to start it manually by launching 'Start Server.bat'. Note that ongoing processes will be halted.

Parameters:

Syntax:

exit

`/help`

Opens up the help menu contains all the commands with descriptions and syntax

Parameters:

command: STRING - If you need a help with some command (for example, you don't know the argument names or the command purpose), just add a command name to display the help
constructor: STRING - If you need a help with some constructor. just add the constructor name

Syntax:

help command <A command you need help with> constructor <A constructor you need help with>

`/change-log-level`

Takes a module with the name passed with 'for' argument and changes it's minimal log level to 'to' argument

Parameters:

for: STRING - A module that the minimal logging level should be changed for
to: STRING - A minimal logging level required to log

Syntax:

change-log-level for [module name] to [log level]

`/open-debug`

Opens up a debug dialog 'named'

Parameters:

for: STRING - The name of debug dialog you want to open

Syntax:

open-debug for [The name of debug dialog]

`/enable-debug`

Enables the debug logging for a module with name passed in the 'for' argument

Parameters:

for: STRING - A name of the module which log level should be switched to 'debug'

Syntax:

enable-debug for [The module name]

`/disable-debug`

Disables the debug for a module with name passed as the 'for' argument

Parameters:

for: STRING - The module name which log level should be switched back to 'info'

Syntax:

disable-debug for [The module name]

`/constructors`

Shows all the constructors available in this version of Quark QL

Parameters:

Syntax:

constructors

`/instructions`

Shows all the instructions available in this version of Quark QL

Parameters:

Syntax:

instructions

`/run`

Runs an instruction or a command

Parameters:

instruction: STRING - An instruction that should be run
command: STRING - A command that should be run

Syntax:

run instruction <An instruction to run> command <A command to run>

`/test`

Runs the small developers tests for Quark developers.

Parameters:

for: STRING - A name of the test to be run
json: STRING - A json for testing code. The usage of json passed differs from test to test.

Syntax:

test for [The test name] json <The test json>

`/eval`

Evaluates a Quark QL entity

Parameters:

expression: STRING - An expression to evaluate

Syntax:

eval expression [An expression]

`/modifiers`

Shows all the column modifiers provided by Quark

Parameters:

Syntax:

modifiers

`/install`

Creates all the necessary databases and tables for Quark Server to work. This command must never be called manually.

Parameters:

Syntax:

install

`/factory-reset`

Resets all the settings and databases to the before-use state.

Parameters:

Syntax:

factory-reset

`/repair`

Scans the Quark Server system files and creates them if needed.

Parameters:

Syntax:

repair

`/clear-maven-output`

Removes all the unnecessary files generated by Maven

Parameters:

Syntax:

clear-maven-output

`/list-scheduled-tasks`

Shows the list of all the scheduled tasks: queries and commands.

Parameters:

Syntax:

list-scheduled-tasks

`/reload`

Stops the Quark Server and starts it again. All the plugins will also be reloaded.

Parameters:

Syntax:

reload

`/clear`

Clears the server's console

Parameters:

Syntax:

clear

`/list`

Lists objects of type you specify

Parameters:

of: STRING - Type of objects you want to specify

Syntax:

list of [Object type]

`/format`

Formats the instruction that passed in

Parameters:

instruction: STRING - The instruction you want to be formatted

Syntax:

format instruction [The formatting instruction]

`//`

Reruns the last command with suggested name

Parameters:

Syntax:

`/clean-mode`

When Clean mode is enabled, the console is cleared after each command

Parameters:

Syntax:

clean-mode

quark-database/server

ErrorLooks like something went wrong!

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors 2

Uh oh!

Languages

Error
Looks like something went wrong!

Packages