regex101: PCRE2 (PHP) Match Workspace

\Gstart of current search

Branch Reset Group(?|(?:(?:\s+)(*MARK:T_WHITESPACE))|(?:(?:\/\/[^\n]*\n)(*MARK:T_COMMENT))|(?:(?:(?<=\b)true\b)(*MARK:T_BOOL_TRUE))|(?:(?:(?<=\b)false\b)(*MARK:T_BOOL_FALSE))|(?:(?:(?<=\b)null\b)(*MARK:T_NULL))|(?:(?:(?<=\b)Project\b)(*MARK:T_PROJECT))|(?:(?:(?<=\b)Table\b)(*MARK:T_TABLE))|(?:(?:(?<=\b)as\b)(*MARK:T_TABLE_ALIAS))|(?:(?:(?<=\b)(Indexes|indexes)\b)(*MARK:T_TABLE_INDEXES))|(?:(?:(Ref|ref))(*MARK:T_TABLE_REF))|(?:(?:(?<=\b)TableGroup\b)(*MARK:T_TABLE_GROUP))|(?:(?:(?<=\b)(Enum|enum)\b)(*MARK:T_ENUM))|(?:(?:(?<=\b)(primary\ske|pk)\b)(*MARK:T_TABLE_SETTING_PK))|(?:(?:(?<=\b)unique\b)(*MARK:T_TABLE_SETTING_UNIQUE))|(?:(?:(?<=\b)increment\b)(*MARK:T_TABLE_SETTING_INCREMENT))|(?:(?:(?<=\b)default\b)(*MARK:T_TABLE_SETTING_DEFAULT))|(?:(?:(?<=\b)null\b)(*MARK:T_TABLE_SETTING_NULL))|(?:(?:(?<=\b)not\snull\b)(*MARK:T_TABLE_SETTING_NOT_NULL))|(?:(?:(?<=\b)cascade\b)(*MARK:T_REF_ACTION_CASCADE))|(?:(?:(?<=\b)restrict\b)(*MARK:T_REF_ACTION_RESTRICT))|(?:(?:(?<=\b)set\snull\b)(*MARK:T_REF_ACTION_SET_NULL))|(?:(?:(?<=\b)set\default\b)(*MARK:T_REF_ACTION_SET_DEFAULT))|(?:(?:(?<=\b)no\saction\b)(*MARK:T_REF_ACTION_NO_ACTION))|(?:(?:(?<=\b)delete\b)(*MARK:T_REF_ACTION_DELETE))|(?:(?:(?<=\b)update\b)(*MARK:T_REF_ACTION_UPDATE))|(?:(?:note:)(*MARK:T_SETTING_NOTE))|(?:(?:(?<=\b)Note\b)(*MARK:T_NOTE))|(?:(?:[0-9]+\.[0-9]+)(*MARK:T_FLOAT))|(?:(?:[0-9]+)(*MARK:T_INT))|(?:(?:('{3}|["']{1})([^'"][\s\S]*?)\1)(*MARK:T_QUOTED_STRING))|(?:(?:(`{1})([\s\S]+?)\1)(*MARK:T_EXPRESSION))|(?:(?:[a-zA-Z0-9_]+)(*MARK:T_WORD))|(?:(?:\\n)(*MARK:T_EOL))|(?:(?:$)(*MARK:T_LPAREN))|(?:(?:$)(*MARK:T_RPAREN))|(?:(?:{)(*MARK:T_LBRACE))|(?:(?:})(*MARK:T_RBRACE))|(?:(?:\[)(*MARK:T_LBRACK))|(?:(?:\])(*MARK:T_RBRACK))|(?:(?:\>)(*MARK:T_GT))|(?:(?:\<)(*MARK:T_LT))|(?:(?:,)(*MARK:T_COMMA))|(?:(?::)(*MARK:T_COLON))|(?:(?:\-)(*MARK:T_MINUS))|(?:(?:\.)(*MARK:T_DOT))|(?:(?:.+?)(*MARK:T_UNKNOWN)))

1st Alternative(?:(?:\s+)(*MARK:T_WHITESPACE))

Non-Capturing Group(?:(?:\s+)(*MARK:T_WHITESPACE))

Non-Capturing Group(?:\s+)

\s+a Unicode whitespace character, repeated at least once

(*MARK:T_WHITESPACE)marks this position as T_WHITESPACE so the matching path can be identified later

2nd Alternative(?:(?:\/\/[^\n]*\n)(*MARK:T_COMMENT))

Non-Capturing Group(?:(?:\/\/[^\n]*\n)(*MARK:T_COMMENT))

Non-Capturing Group(?:\/\/[^\n]*\n)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Negated Character Class[^\n]*

*matches any number of characters outside the set below:

\na line-feed (newline) character (ASCII 10)

(*MARK:T_COMMENT)marks this position as T_COMMENT so the matching path can be identified later

3rd Alternative(?:(?:(?<=\b)true\b)(*MARK:T_BOOL_TRUE))

Non-Capturing Group(?:(?:(?<=\b)true\b)(*MARK:T_BOOL_TRUE))

Non-Capturing Group(?:(?<=\b)true\b)

Positive Lookbehind(?<=\b)

\ba Unicode word boundary

truethe literal text true (case sensitive)

\ba Unicode word boundary

(*MARK:T_BOOL_TRUE)marks this position as T_BOOL_TRUE so the matching path can be identified later

4th Alternative(?:(?:(?<=\b)false\b)(*MARK:T_BOOL_FALSE))

Non-Capturing Group(?:(?:(?<=\b)false\b)(*MARK:T_BOOL_FALSE))

Non-Capturing Group(?:(?<=\b)false\b)

Positive Lookbehind(?<=\b)

\ba Unicode word boundary

falsethe literal text false (case sensitive)

\ba Unicode word boundary

(*MARK:T_BOOL_FALSE)marks this position as T_BOOL_FALSE so the matching path can be identified later

5th Alternative(?:(?:(?<=\b)null\b)(*MARK:T_NULL))

Non-Capturing Group(?:(?:(?<=\b)null\b)(*MARK:T_NULL))

Non-Capturing Group(?:(?<=\b)null\b)

Positive Lookbehind(?<=\b)

\ba Unicode word boundary

nullthe literal text null (case sensitive)

\ba Unicode word boundary

(*MARK:T_NULL)marks this position as T_NULL so the matching path can be identified later

6th Alternative(?:(?:(?<=\b)Project\b)(*MARK:T_PROJECT))

Non-Capturing Group(?:(?:(?<=\b)Project\b)(*MARK:T_PROJECT))

Non-Capturing Group(?:(?<=\b)Project\b)

Positive Lookbehind(?<=\b)

\ba Unicode word boundary

Projectthe literal text Project (case sensitive)

\ba Unicode word boundary

(*MARK:T_PROJECT)marks this position as T_PROJECT so the matching path can be identified later

7th Alternative(?:(?:(?<=\b)Table\b)(*MARK:T_TABLE))

Non-Capturing Group(?:(?:(?<=\b)Table\b)(*MARK:T_TABLE))

8th Alternative(?:(?:(?<=\b)as\b)(*MARK:T_TABLE_ALIAS))

9th Alternative(?:(?:(?<=\b)(Indexes|indexes)\b)(*MARK:T_TABLE_INDEXES))

10th Alternative(?:(?:(Ref|ref))(*MARK:T_TABLE_REF))

11th Alternative(?:(?:(?<=\b)TableGroup\b)(*MARK:T_TABLE_GROUP))

12th Alternative(?:(?:(?<=\b)(Enum|enum)\b)(*MARK:T_ENUM))

13th Alternative(?:(?:(?<=\b)(primary\ske|pk)\b)(*MARK:T_TABLE_SETTING_PK))

14th Alternative(?:(?:(?<=\b)unique\b)(*MARK:T_TABLE_SETTING_UNIQUE))

15th Alternative(?:(?:(?<=\b)increment\b)(*MARK:T_TABLE_SETTING_INCREMENT))

16th Alternative(?:(?:(?<=\b)default\b)(*MARK:T_TABLE_SETTING_DEFAULT))

17th Alternative(?:(?:(?<=\b)null\b)(*MARK:T_TABLE_SETTING_NULL))

18th Alternative(?:(?:(?<=\b)not\snull\b)(*MARK:T_TABLE_SETTING_NOT_NULL))

19th Alternative(?:(?:(?<=\b)cascade\b)(*MARK:T_REF_ACTION_CASCADE))

20th Alternative(?:(?:(?<=\b)restrict\b)(*MARK:T_REF_ACTION_RESTRICT))

21st Alternative(?:(?:(?<=\b)set\snull\b)(*MARK:T_REF_ACTION_SET_NULL))

22nd Alternative(?:(?:(?<=\b)set\default\b)(*MARK:T_REF_ACTION_SET_DEFAULT))

23rd Alternative(?:(?:(?<=\b)no\saction\b)(*MARK:T_REF_ACTION_NO_ACTION))

24th Alternative(?:(?:(?<=\b)delete\b)(*MARK:T_REF_ACTION_DELETE))

25th Alternative(?:(?:(?<=\b)update\b)(*MARK:T_REF_ACTION_UPDATE))

26th Alternative(?:(?:note:)(*MARK:T_SETTING_NOTE))

27th Alternative(?:(?:(?<=\b)Note\b)(*MARK:T_NOTE))

28th Alternative(?:(?:[0-9]+\.[0-9]+)(*MARK:T_FLOAT))

29th Alternative(?:(?:[0-9]+)(*MARK:T_INT))

30th Alternative(?:(?:('{3}|["']{1})([^'"][\s\S]*?)\1)(*MARK:T_QUOTED_STRING))

31st Alternative(?:(?:(`{1})([\s\S]+?)\1)(*MARK:T_EXPRESSION))

32nd Alternative(?:(?:[a-zA-Z0-9_]+)(*MARK:T_WORD))

33rd Alternative(?:(?:\\n)(*MARK:T_EOL))

34th Alternative(?:(?:\()(*MARK:T_LPAREN))

35th Alternative(?:(?:\))(*MARK:T_RPAREN))

36th Alternative(?:(?:{)(*MARK:T_LBRACE))

37th Alternative(?:(?:})(*MARK:T_RBRACE))

38th Alternative(?:(?:\[)(*MARK:T_LBRACK))

39th Alternative(?:(?:\])(*MARK:T_RBRACK))

40th Alternative(?:(?:\>)(*MARK:T_GT))

41st Alternative(?:(?:\<)(*MARK:T_LT))

42nd Alternative(?:(?:,)(*MARK:T_COMMA))

43rd Alternative(?:(?::)(*MARK:T_COLON))

44th Alternative(?:(?:\-)(*MARK:T_MINUS))

45th Alternative(?:(?:\.)(*MARK:T_DOT))

46th Alternative(?:(?:.+?)(*MARK:T_UNKNOWN))

Global pattern flags

s modifier: single line. Allows a dot to match line terminators

u modifier: unicode. Treats the pattern and subject as UTF-16

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

g modifier: global. Finds all matches instead of stopping after the first

Search reference

Regular Expression

\G(?|(?:(?:\s+)(*MARK:T_WHITESPACE))|(?:(?:\/\/[^\n]*\n)(*MARK:T_COMMENT))|(?:(?:(?<=\b)true\b)(*MARK:T_BOOL_TRUE))|(?:(?:(?<=\b)false\b)(*MARK:T_BOOL_FALSE))|(?:(?:(?<=\b)null\b)(*MARK:T_NULL))|(?:(?:(?<=\b)Project\b)(*MARK:T_PROJECT))|(?:(?:(?<=\b)Table\b)(*MARK:T_TABLE))|(?:(?:(?<=\b)as\b)(*MARK:T_TABLE_ALIAS))|(?:(?:(?<=\b)(Indexes|indexes)\b)(*MARK:T_TABLE_INDEXES))|(?:(?:(Ref|ref))(*MARK:T_TABLE_REF))|(?:(?:(?<=\b)TableGroup\b)(*MARK:T_TABLE_GROUP))|(?:(?:(?<=\b)(Enum|enum)\b)(*MARK:T_ENUM))|(?:(?:(?<=\b)(primary\ske|pk)\b)(*MARK:T_TABLE_SETTING_PK))|(?:(?:(?<=\b)unique\b)(*MARK:T_TABLE_SETTING_UNIQUE))|(?:(?:(?<=\b)increment\b)(*MARK:T_TABLE_SETTING_INCREMENT))|(?:(?:(?<=\b)default\b)(*MARK:T_TABLE_SETTING_DEFAULT))|(?:(?:(?<=\b)null\b)(*MARK:T_TABLE_SETTING_NULL))|(?:(?:(?<=\b)not\snull\b)(*MARK:T_TABLE_SETTING_NOT_NULL))|(?:(?:(?<=\b)cascade\b)(*MARK:T_REF_ACTION_CASCADE))|(?:(?:(?<=\b)restrict\b)(*MARK:T_REF_ACTION_RESTRICT))|(?:(?:(?<=\b)set\snull\b)(*MARK:T_REF_ACTION_SET_NULL))|(?:(?:(?<=\b)set\default\b)(*MARK:T_REF_ACTION_SET_DEFAULT))|(?:(?:(?<=\b)no\saction\b)(*MARK:T_REF_ACTION_NO_ACTION))|(?:(?:(?<=\b)delete\b)(*MARK:T_REF_ACTION_DELETE))|(?:(?:(?<=\b)update\b)(*MARK:T_REF_ACTION_UPDATE))|(?:(?:note:)(*MARK:T_SETTING_NOTE))|(?:(?:(?<=\b)Note\b)(*MARK:T_NOTE))|(?:(?:[0-9]+\.[0-9]+)(*MARK:T_FLOAT))|(?:(?:[0-9]+)(*MARK:T_INT))|(?:(?:('{3}|["']{1})([^'"][\s\S]*?)\1)(*MARK:T_QUOTED_STRING))|(?:(?:(`{1})([\s\S]+?)\1)(*MARK:T_EXPRESSION))|(?:(?:[a-zA-Z0-9_]+)(*MARK:T_WORD))|(?:(?:\\n)(*MARK:T_EOL))|(?:(?:\()(*MARK:T_LPAREN))|(?:(?:\))(*MARK:T_RPAREN))|(?:(?:{)(*MARK:T_LBRACE))|(?:(?:})(*MARK:T_RBRACE))|(?:(?:\[)(*MARK:T_LBRACK))|(?:(?:\])(*MARK:T_RBRACK))|(?:(?:\>)(*MARK:T_GT))|(?:(?:\<)(*MARK:T_LT))|(?:(?:,)(*MARK:T_COMMA))|(?:(?::)(*MARK:T_COLON))|(?:(?:\-)(*MARK:T_MINUS))|(?:(?:\.)(*MARK:T_DOT))|(?:(?:.+?)(*MARK:T_UNKNOWN)))

New

Project test {
  database_type: 'PostgreSQL'
  Note: 'Description of the project'
}

//// -- LEVEL 1
//// -- Tables and References

// Creating tables
Table users as U {
  id int [pk, unique, increment] // auto-increment
  full_name varchar [not null, unique, default: 1]
  created_at timestamp
  country_code int
  type int
  note int
  Note: 'khong hieu duoc'
}

Table merchants {
  id int
}

Table countries {
  code int [pk]
  name varchar
  continent_name varchar
}

// Creating references
// You can also define relationship separately
// > many-to-one; < one-to-many; - one-to-one
Ref{
  U.country_code > countries.code
  merchants.country_code > countries.code
}

//----------------------------------------------//

//// -- LEVEL 2
//// -- Adding column settings

Table order_items {
  order_id int [ref: > orders.id]
  product_id int
  quantity int [default: 1] // default value
}

Ref: order_items.product_id > products.id

Table orders {
  id int [pk] // primary key
  user_id int [not null, unique]
  status varchar
  created_at varchar [note: '''When order created'''] // add column note
}

Table int {
  id int
}

//----------------------------------------------//

//// -- Level 3
//// -- Enum, Indexes

// Enum for 'products' table below
Enum products_status {
  out_of_stock
  in_stock
  running_low [note: 'less than 20'] // add column note
}

// Indexes: You can define a single or multi-column index
Table products {
  id int [pk]
  name varchar
  merchant_id int [not null]
  price int
  status products_status
  created_at datetime [default: `now()`]

  Indexes {
    (merchant_id, status) [name:'product_status', type: hash]
    id [unique]
  }
}

Ref: products.merchant_id > merchants.id // many-to-one

TableGroup hello_world {
    just_test
    just_a_test
}

Regular Expressions 101

Regular Expression

Substitution