FX - Type @ Data transformation (ETL) @ MentDB Weak
Type
type is_booltype is_enumtype is_chartype is_datetype is_decimaltype is_emailtype is_urltype is_ipv4type is_ipv6type is_uuidtype is_jsontype is_ibantype is_bictype is_luhntype is_sirentype is_sirettype is_phone_frtype is_hourtype is_timetype is_hour_without_sectype is_integertype is_numbertype is_bytetype is_small_inttype is_medium_inttype is_inttype is_big_inttype is_floattype is_doubletype is_timestamptype is_valid_datetype is_valid_datetype is_valid_timetype is_valid_timestamptype is_valid_timestamptype is_varchar
type is_bool <value> <bool1> <bool2>
Description
Check if a value is equal to 'bool1' or 'bool2' and return a boolean.
Check if a value is equal to 'bool1' or 'bool2' and return a boolean.
Parameters
value: The value - String - required
bool1: The first boolean - String - required
bool2: The second boolean - String - required
value: The value - String - required
bool1: The first boolean - String - required
bool2: The second boolean - String - required
admin
type is_bool 1 1 0
mentdb
1
type is_enum <value> <values>
Description
Check if a value is one of the values of the enum and return a boolean.
Check if a value is one of the values of the enum and return a boolean.
Parameters
value: The value - String - required
values: The values - String - required
value: The value - String - required
values: The values - String - required
admin
type is_enum 1 1,2,3
mentdb
1
type is_char <value> <size>
Description
Check if the size of the string or character sent as parameter is correct.
Check if the size of the string or character sent as parameter is correct.
Parameters
value: The value - String - required
size: The authorized character size - Number - required
value: The value - String - required
size: The authorized character size - Number - required
admin
type is_char 1 1
mentdb
1
type is_date <date>
Description
Check if a value is a valid date in English format (example: 1980-06-18), returning a boolean (0 for false, 1 for true).
Check if a value is a valid date in English format (example: 1980-06-18), returning a boolean (0 for false, 1 for true).
Parameters
date: The date - String - required
date: The date - String - required
admin
type is_date "1980-06-18"
mentdb
1
type is_decimal <stringDecimal> <digitBeforeTheDecimalPoint> <digitAfterTheDecimalPoint>
Description
Check if a value is a decimal number and return a boolean.
Check if a value is a decimal number and return a boolean.
Parameters
stringDecimal: The string in decimal format - String - required
digitBeforeTheDecimalPoint: The number of digits before the decimal point - Number - required
digitAfterTheDecimalPoint: The number of digits after the decimal point - Number - required
stringDecimal: The string in decimal format - String - required
digitBeforeTheDecimalPoint: The number of digits before the decimal point - Number - required
digitAfterTheDecimalPoint: The number of digits after the decimal point - Number - required
admin
type is_decimal 12.23 4 5
mentdb
1
type is_email <emailAddress>
Description
Check if a value is an email address and return a boolean
Check if a value is an email address and return a boolean
Parameters
emailAddress: The email - String - required
emailAddress: The email - String - required
admin
type is_email "jim@innov-ai.com"
mentdb
1
type is_url <url>
Description
Check if a value is an URL (http, https, ftp, ftps, sftp) with a host.
Check if a value is an URL (http, https, ftp, ftps, sftp) with a host.
Parameters
url: The URL - String - required
url: The URL - String - required
admin
type is_url "https://www.mentdb.org/doc?id=1"
mentdb
1
type is_ipv4 <ip>
Description
Check if a value is an IPv4 address.
Check if a value is an IPv4 address.
Parameters
ip: The IP address - String - required
ip: The IP address - String - required
admin
type is_ipv4 "192.168.1.254"
mentdb
1
type is_ipv6 <ip>
Description
Check if a value is an IPv6 address.
Check if a value is an IPv6 address.
Parameters
ip: The IP address - String - required
ip: The IP address - String - required
admin
type is_ipv6 "2001:db8::1"
mentdb
1
type is_uuid <uuid>
Description
Check if a value is an UUID.
Check if a value is an UUID.
Parameters
uuid: The UUID - String - required
uuid: The UUID - String - required
admin
type is_uuid "3f2b8c1e-6a0d-4e5b-9c7a-1d2e3f4a5b6c"
mentdb
1
type is_json <json>
Description
Check if a value is a strict JSON (object, array or scalar).
Check if a value is a strict JSON (object, array or scalar).
Parameters
json: The JSON - String - required
json: The JSON - String - required
admin
type is_json "{\"a\":[1,2,true]}"
mentdb
1
type is_iban <iban>
Description
Check if a value is an IBAN (country length and mod 97 checksum, spaces allowed).
Check if a value is an IBAN (country length and mod 97 checksum, spaces allowed).
Parameters
iban: The IBAN - String - required
iban: The IBAN - String - required
admin
type is_iban "FR76 3000 6000 0112 3456 7890 189"
mentdb
1
type is_bic <bic>
Description
Check if a value is a BIC / SWIFT code (8 or 11 characters).
Check if a value is a BIC / SWIFT code (8 or 11 characters).
Parameters
bic: The BIC - String - required
bic: The BIC - String - required
admin
type is_bic "BNPAFRPPXXX"
mentdb
1
type is_luhn <number>
Description
Check the Luhn checksum (credit card number, SIREN, SIRET...), spaces allowed.
Check the Luhn checksum (credit card number, SIREN, SIRET...), spaces allowed.
Parameters
number: The number - String - required
number: The number - String - required
admin
type is_luhn "4111 1111 1111 1111"
mentdb
1
type is_siren <siren>
Description
Check if a value is a French SIREN (9 digits + Luhn), spaces allowed.
Check if a value is a French SIREN (9 digits + Luhn), spaces allowed.
Parameters
siren: The SIREN - String - required
siren: The SIREN - String - required
admin
type is_siren "732 829 320"
mentdb
1
type is_siret <siret>
Description
Check if a value is a French SIRET (14 digits + Luhn), spaces allowed.
Check if a value is a French SIRET (14 digits + Luhn), spaces allowed.
Parameters
siret: The SIRET - String - required
siret: The SIRET - String - required
admin
type is_siret "732 829 320 00074"
mentdb
1
type is_phone_fr <phone>
Description
Check if a value is a French phone number (0X, +33, 0033, DROM +262 +590 +594 +596; spaces, dots, dashes allowed).
Check if a value is a French phone number (0X, +33, 0033, DROM +262 +590 +594 +596; spaces, dots, dashes allowed).
Parameters
phone: The phone number - String - required
phone: The phone number - String - required
admin
type is_phone_fr "+262 692 12 34 56"
mentdb
1
type is_hour <stringHour>
Description
Check if a value is in time format (example: 12:35:56)
Check if a value is in time format (example: 12:35:56)
Parameters
stringHour: The time - String - required
stringHour: The time - String - required
admin
type is_hour "12:35:56"
mentdb
1
type is_time <stringHour>
Description
Check if a value is in time format (example: 12:35:56)
Check if a value is in time format (example: 12:35:56)
Parameters
stringHour: The time - String - required
stringHour: The time - String - required
admin
type is_time "12:35:56"
mentdb
1
type is_hour_without_sec <stringHour>
Description
Check if a value is in time format (example: 12:35). If the value is not in time format, or if it contains seconds, this function returns false.
Check if a value is in time format (example: 12:35). If the value is not in time format, or if it contains seconds, this function returns false.
Parameters
stringHour: The time - String - required
stringHour: The time - String - required
admin
type is_hour_without_sec "12:35:56"
mentdb
0
type is_integer <value> <size>
Description
Return true if 'size' is equal to the number of characters of 'value'.
Return true if 'size' is equal to the number of characters of 'value'.
Parameters
value: The value - String - required
size: The authorized character size - Number - required
value: The value - String - required
size: The authorized character size - Number - required
admin
type is_integer 1456 5
mentdb
1
type is_number <value>
Description
Return true if 'value' is a number, otherwise return 0.
Return true if 'value' is a number, otherwise return 0.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_number 1456
mentdb
1
type is_byte <value>
Description
Check if a value is a byte and return a boolean.
Check if a value is a byte and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_byte 13
mentdb
1
type is_small_int <value>
Description
Check if a value is a small integer and return a boolean.
Check if a value is a small integer and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_small_int 13000
mentdb
1
type is_medium_int <value>
Description
Check if a value is a medium integer and return a boolean.
Check if a value is a medium integer and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_medium_int 130000
mentdb
1
type is_int <value>
Description
Check if a value is an integer and return a boolean.
Check if a value is an integer and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_int 1300000
mentdb
1
type is_big_int <value>
Description
Check if a value is a big integer and return a boolean.
Check if a value is a big integer and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_big_int 1300000
mentdb
1
type is_float <value>
Description
Check if a value is a float number and return a boolean.
Check if a value is a float number and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_float 1300000.4
mentdb
1
type is_double <value>
Description
Check if a value is a double number and return a boolean.
Check if a value is a double number and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_double 1300000.4
mentdb
1
type is_timestamp <value>
Description
Check if a value is in timestamp format (example: '2009-06-18 12:00:00') and return a boolean.
Check if a value is in timestamp format (example: '2009-06-18 12:00:00') and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_timestamp "2009-06-18 12:00:00"
mentdb
1
type is_valid_date <dateToValidate>
Description
Check if a date is valid and return a boolean.
Check if a date is valid and return a boolean.
Parameters
dateToValidate: The date - String - required
dateToValidate: The date - String - required
admin
type is_valid_date "1980-06-18"
mentdb
1
type is_valid_date <dateToValidate> <format>
Description
Check if a date is valid and return a boolean.
Check if a date is valid and return a boolean.
Parameters
dateToValidate: The date - String - required
format: The date format - String - required
dateToValidate: The date - String - required
format: The date format - String - required
admin
type is_valid_date "1980-06-18" "yyyy-MM-dd"
mentdb
1
type is_valid_time <timeToValidate>
Description
Check if a time is valid and return a boolean.
Check if a time is valid and return a boolean.
Parameters
timeToValidate: The time (12:00:01) - String - required
timeToValidate: The time (12:00:01) - String - required
admin
type is_valid_time "12:00:01"
mentdb
1
type is_valid_timestamp <timestampToValidate>
Description
Check if a timestamp is valid and return a boolean.
Check if a timestamp is valid and return a boolean.
Parameters
timestampToValidate: The timestamp - String - required
timestampToValidate: The timestamp - String - required
admin
type is_valid_timestamp "1980-06-18 12:00:01"
mentdb
1
type is_valid_timestamp <timestampToValidate> <format>
Description
Check if a timestamp is valid and return a boolean.
Check if a timestamp is valid and return a boolean.
Parameters
timestampToValidate: The timestamp - String - required
format: The format (ex: yyyy MM dd HH:mm:ss) - String - required
timestampToValidate: The timestamp - String - required
format: The format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
type is_valid_timestamp "1980-06-18 12:00:01" "yyyy-MM-dd HH:mm:ss"
mentdb
1
type is_varchar <value> <size>
Description
Check if the size of the string or character sent as parameter is correct.
Check if the size of the string or character sent as parameter is correct.
Parameters
value: The value - String - required
size: The authorized character size - Number - required
value: The value - String - required
size: The authorized character size - Number - required
admin
type is_varchar 1 1
mentdb
1