API tools faq
paste
Advertisement
Guest User

log

a guest
Dec 1st, 2023
22
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 71.77 KB | None | 0 0
raw download clone embed print report
  1. user@server:~/docker/sqlpage$ ./sqlpage.bin -h
  2. [2023-12-01T10:38:46.271Z DEBUG sqlpage] No .env file found, using only environment variables and configuration files
  3. [2023-12-01T10:38:46.272Z DEBUG sqlpage] Starting with the following configuration: AppConfig { database_url: "postgres://user:[email protected]:5432/db", max_database_pool_connections: None, database_connection_idle_timeout_seconds: None, database_connection_max_lifetime_seconds: None, sqlite_extensions: [], listen_on: 192.168.1.1:8080, port: None, database_connection_retries: 6, database_connection_acquire_timeout_seconds: 10.0, web_root: "/home/server/docker/sqlpage", allow_exec: false, max_uploaded_file_size: 5242880, https_domain: None, https_certificate_email: None, https_certificate_cache_dir: "/home/server/docker/sqlpage/sqlpage/https", https_acme_directory_url: "https://acme-v02.api.letsencrypt.org/directory" }
  4. [2023-12-01T10:38:46.272Z DEBUG sqlpage::webserver::database::connect] Connecting to a Postgres database on postgres://user:[email protected]:5432/db
  5. [2023-12-01T10:38:46.272Z INFO sqlpage::webserver::database::connect] Connecting to database: postgres://user:[email protected]:5432/db
  6. [2023-12-01T10:38:46.272Z DEBUG sqlpage::webserver::database::connect] Not creating a custom SQL database connection handler because "/home/server/docker/sqlpage/sqlpage/on_connect.sql" does not exist
  7. [2023-12-01T10:38:46.287Z DEBUG sqlpage::webserver::database::connect] Initialized database pool: Pool {
  8. size: 1,
  9. num_idle: 1,
  10. is_closed: false,
  11. options: PoolOptions {
  12. max_connections: 50,
  13. min_connections: 0,
  14. connect_timeout: 10s,
  15. max_lifetime: Some(
  16. 3600s,
  17. ),
  18. idle_timeout: Some(
  19. 1800s,
  20. ),
  21. test_before_acquire: true,
  22. },
  23. }
  24. [2023-12-01T10:38:46.297Z DEBUG sqlpage::filesystem] Using local filesystem only, could not initialize on-database filesystem. You can host sql files directly in your database by creating the following table: CREATE TABLE sqlpage_files(path VARCHAR(255) NOT NULL PRIMARY KEY, contents TEXT, last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
  25. The error while trying to use the database file system is: Failed to prepare SQL statement:
  26. SELECT last_modified >= $1 from sqlpage_files WHERE path = $2 LIMIT 1
  27. ⬆️
  28. line 1, character 33: error returned from database: relation "sqlpage_files" does not exist: relation "sqlpage_files" does not exist
  29. [2023-12-01T10:38:46.297Z DEBUG sqlparser::parser] parsing expr
  30. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("shell"))
  31. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 3, column: 16 } }
  32. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: component 2: ,
  33. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  34. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  35. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("SQLpage"))
  36. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 4, column: 15 } }
  37. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: title 2: ,
  38. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  39. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  40. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("/"))
  41. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 5, column: 9 } }
  42. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: link 2: ,
  43. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  44. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  45. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("en"))
  46. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 6, column: 10 } }
  47. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: lang 2: ,
  48. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  49. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  50. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("Welcome to SQLPage"))
  51. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 7, column: 26 } }
  52. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: description 2: ;
  53. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  54. [2023-12-01T10:38:46.298Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'shell' AS component, 'SQLpage' AS title, '/' AS link, 'en' AS lang, 'Welcome to SQLPage' AS description optimized to {"component": String("shell"), "title": String("SQLpage"), "link": String("/"), "lang": String("en"), "description": String("Welcome to SQLPage")}
  55. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  56. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("hero"))
  57. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 10, column: 15 } }
  58. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: component 2: ,
  59. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  60. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  61. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("It works !"))
  62. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 11, column: 18 } }
  63. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: title 2: ,
  64. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  65. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  66. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("If you can see this, then SQLPage v"))
  67. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 12, column: 43 } }
  68. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: || 1: sqlpage 2: .
  69. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 40
  70. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  71. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "sqlpage", quote_style: None }, Ident { value: "version", quote_style: None }]), args: [], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  72. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 13, column: 23 } }
  73. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: || 1: ' is running correctly on your server. Congratulations! ' 2: as
  74. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 40
  75. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 13, column: 23 } }
  76. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: || 1: ' is running correctly on your server. Congratulations! ' 2: as
  77. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 40
  78. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  79. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString(" is running correctly on your server. Congratulations! "))
  80. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 14, column: 63 } }
  81. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: description 2: ;
  82. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  83. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 14, column: 63 } }
  84. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: description 2: ;
  85. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  86. [2023-12-01T10:38:46.298Z DEBUG sqlpage::webserver::database::sql] Handling builtin function: version
  87. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  88. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("text"))
  89. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 18, column: 15 } }
  90. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: component 2: ,
  91. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  92. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  93. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("Get started"))
  94. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 19, column: 19 } }
  95. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: title 2: ;
  96. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  97. [2023-12-01T10:38:46.298Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'text' AS component, 'Get started' AS title optimized to {"component": String("text"), "title": String("Get started")}
  98. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  99. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("In order to get started, visit "))
  100. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 23, column: 42 } }
  101. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: contents 2: ;
  102. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  103. [2023-12-01T10:38:46.298Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'In order to get started, visit ' AS contents optimized to {"contents": String("In order to get started, visit ")}
  104. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  105. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("SQLPage's website"))
  106. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 24, column: 29 } }
  107. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: contents 2: ,
  108. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  109. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] parsing expr
  110. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("https://sql.ophir.dev/your-first-sql-website/"))
  111. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 25, column: 53 } }
  112. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] 0: as 1: link 2: ,
  113. [2023-12-01T10:38:46.298Z DEBUG sqlparser::parser] next precedence: 0
  114. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  115. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(Boolean(true))
  116. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 26, column: 10 } }
  117. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: italics 2: ;
  118. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  119. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'SQLPage''s website' AS contents, 'https://sql.ophir.dev/your-first-sql-website/' AS link, true AS italics optimized to {"contents": String("SQLPage's website"), "link": String("https://sql.ophir.dev/your-first-sql-website/"), "italics": Bool(true)}
  120. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  121. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString(". You can replace this page's contents by creating a file named "))
  122. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 27, column: 76 } }
  123. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents 2: ;
  124. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  125. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT '. You can replace this page''s contents by creating a file named ' AS contents optimized to {"contents": String(". You can replace this page's contents by creating a file named ")}
  126. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  127. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("index.sql"))
  128. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 28, column: 20 } }
  129. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents 2: ,
  130. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  131. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  132. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(Number("1", false))
  133. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 28, column: 35 } }
  134. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: code 2: ;
  135. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  136. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'index.sql' AS contents, 1 AS code optimized to {"contents": String("index.sql"), "code": Number(1)}
  137. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  138. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString(" in the folder where sqlpage is running (current working directory: "))
  139. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 29, column: 79 } }
  140. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents 2: ;
  141. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  142. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT ' in the folder where sqlpage is running (current working directory: ' AS contents optimized to {"contents": String(" in the folder where sqlpage is running (current working directory: ")}
  143. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  144. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "sqlpage", quote_style: None }, Ident { value: "current_working_directory", quote_style: None }]), args: [], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  145. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 30, column: 44 } }
  146. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents 2: ,
  147. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  148. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  149. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(Number("1", false))
  150. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 30, column: 59 } }
  151. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: code 2: ;
  152. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  153. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Handling builtin function: current_working_directory
  154. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  155. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString(")."))
  156. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 31, column: 13 } }
  157. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents 2: ;
  158. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  159. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT ').' AS contents optimized to {"contents": String(").")}
  160. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  161. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("You can customize your server's [configuration](https://github.com/lovasoa/SQLpage/blob/main/configuration.md)\nby creating a file in `"))
  162. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 33, column: 26 } }
  163. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: || 1: sqlpage 2: .
  164. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 40
  165. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  166. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "sqlpage", quote_style: None }, Ident { value: "current_working_directory", quote_style: None }]), args: [], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  167. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 33, column: 65 } }
  168. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: || 1: '/sqlpage/sqlpage.json`.' 2: as
  169. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 40
  170. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 33, column: 65 } }
  171. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: || 1: '/sqlpage/sqlpage.json`.' 2: as
  172. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 40
  173. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  174. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("/sqlpage/sqlpage.json`."))
  175. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 33, column: 94 } }
  176. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents_md 2: ;
  177. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  178. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 33, column: 94 } }
  179. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents_md 2: ;
  180. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  181. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Handling builtin function: current_working_directory
  182. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] parsing expr
  183. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("\nAlternatively, you can create a table called `sqlpage_files` in your database with the following columns: `path`, `contents`, and `last_modified`."))
  184. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 36, column: 149 } }
  185. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] 0: as 1: contents_md 2: ;
  186. [2023-12-01T10:38:46.299Z DEBUG sqlparser::parser] next precedence: 0
  187. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT '
  188. Alternatively, you can create a table called `sqlpage_files` in your database with the following columns: `path`, `contents`, and `last_modified`.' AS contents_md optimized to {"contents_md": String("\nAlternatively, you can create a table called `sqlpage_files` in your database with the following columns: `path`, `contents`, and `last_modified`.")}
  189. [2023-12-01T10:38:46.299Z DEBUG sqlpage::webserver::database::migrations] Applying migrations from '/home/server/docker/sqlpage/sqlpage/migrations'
  190. [2023-12-01T10:38:46.300Z INFO sqlpage::webserver::database::migrations] Found 1 migrations:
  191. [2023-12-01T10:38:46.300Z INFO sqlpage::webserver::database::migrations] [0001] create users table
  192. [2023-12-01T10:38:46.301Z INFO sqlx::postgres::notice] relation "_sqlx_migrations" already exists, skipping
  193. [2023-12-01T10:38:46.303Z DEBUG sqlpage] Starting server on 192.168.1.1:8080
  194. [2023-12-01T10:38:46.303Z INFO actix_server::builder] starting 4 workers
  195. [2023-12-01T10:38:46.303Z INFO actix_server::server] Actix runtime found; starting in Actix runtime
  196. [2023-12-01T10:38:46.306Z INFO sqlpage] Server started successfully.
  197. SQLPage is now running on http://192.168.1.1:8080/
  198. You can write your website's code in .sql files in /home/server/docker/sqlpage.
  199. [2023-12-01T10:38:52.710Z DEBUG sqlpage::webserver::http] Processing SQL request: "alert.sql"
  200. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] parsing expr
  201. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("list"))
  202. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 1, column: 15 } }
  203. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] 0: AS 1: component 2: ,
  204. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] next precedence: 0
  205. [2023-12-01T10:38:52.710Z DEBUG sqlparser::parser] parsing expr
  206. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("SQLPage"))
  207. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 1, column: 39 } }
  208. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: title 2: ;
  209. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  210. [2023-12-01T10:38:52.711Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'list' AS component, 'SQLPage' AS title optimized to {"component": String("list"), "title": String("SQLPage")}
  211. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  212. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("N1"))
  213. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 3, column: 13 } }
  214. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: title 2: ;
  215. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  216. [2023-12-01T10:38:52.711Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'N1' AS title optimized to {"title": String("N1")}
  217. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  218. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("alert"))
  219. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 6, column: 26 } }
  220. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: as 1: component 2: ,
  221. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  222. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  223. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("Error"))
  224. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 7, column: 26 } }
  225. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: as 1: title 2: ,
  226. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  227. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  228. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("Your cart is full."))
  229. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 8, column: 26 } }
  230. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: as 1: description 2: ,
  231. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  232. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  233. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("alert-circle"))
  234. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 9, column: 26 } }
  235. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: as 1: icon 2: ,
  236. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  237. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  238. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("red"))
  239. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 10, column: 26 } }
  240. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: as 1: color 2: ;
  241. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  242. [2023-12-01T10:38:52.711Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'alert' AS component, 'Error' AS title, 'Your cart is full.' AS description, 'alert-circle' AS icon, 'red' AS color optimized to {"component": String("alert"), "title": String("Error"), "description": String("Your cart is full."), "icon": String("alert-circle"), "color": String("red")}
  243. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  244. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("alert"))
  245. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 13, column: 13 } }
  246. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: component 2: ,
  247. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  248. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  249. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("Missing value update"))
  250. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 14, column: 28 } }
  251. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: title 2: ,
  252. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  253. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  254. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "mac", quote_style: None })
  255. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: DoubleColon, location: Location { line: 15, column: 8 } }
  256. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: :: 1: TEXT 2: ||
  257. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 50
  258. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: StringConcat, location: Location { line: 15, column: 15 } }
  259. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: || 1: ' older than 2 minutes' 2: AS
  260. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 40
  261. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  262. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString(" older than 2 minutes"))
  263. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 15, column: 42 } }
  264. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: description 2: ,
  265. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  266. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 15, column: 42 } }
  267. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: description 2: ,
  268. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  269. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  270. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("alert-circle"))
  271. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 16, column: 20 } }
  272. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: icon 2: ,
  273. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  274. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  275. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("red"))
  276. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 17, column: 11 } }
  277. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: AS 1: color 2: FROM
  278. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  279. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  280. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "mac", quote_style: None })
  281. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "HAVING", quote_style: None, keyword: HAVING }), location: Location { line: 22, column: 1 } }
  282. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] 0: HAVING 1: MAX 2: (
  283. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] next precedence: 0
  284. [2023-12-01T10:38:52.711Z DEBUG sqlparser::parser] parsing expr
  285. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  286. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "created_at", quote_style: None })
  287. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: RParen, location: Location { line: 23, column: 19 } }
  288. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: ) 1: < 2: NOW
  289. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  290. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "MAX", quote_style: None }]), args: [Unnamed(Expr(Identifier(Ident { value: "created_at", quote_style: None })))], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  291. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Lt, location: Location { line: 23, column: 21 } }
  292. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: < 1: NOW 2: (
  293. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 20
  294. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  295. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "NOW", quote_style: None }]), args: [], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  296. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Minus, location: Location { line: 23, column: 29 } }
  297. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: - 1: INTERVAL 2: '2 minutes'
  298. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 30
  299. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  300. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: SemiColon, location: Location { line: 23, column: 51 } }
  301. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: ; 1: select 2: 'table'
  302. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Interval(Interval { value: Value(SingleQuotedString("2 minutes")), leading_field: None, leading_precision: None, last_field: None, fractional_seconds_precision: None })
  303. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: SemiColon, location: Location { line: 23, column: 51 } }
  304. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: ; 1: select 2: 'table'
  305. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  306. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: SemiColon, location: Location { line: 23, column: 51 } }
  307. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: ; 1: select 2: 'table'
  308. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  309. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: SemiColon, location: Location { line: 23, column: 51 } }
  310. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: ; 1: select 2: 'table'
  311. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  312. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  313. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("table"))
  314. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 26, column: 16 } }
  315. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: as 1: component 2: ,
  316. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  317. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  318. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Value(Boolean(true))
  319. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 26, column: 35 } }
  320. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: as 1: search 2: ,
  321. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  322. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  323. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Value(Boolean(true))
  324. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "as", quote_style: None, keyword: AS }), location: Location { line: 26, column: 51 } }
  325. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: as 1: sort 2: ;
  326. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  327. [2023-12-01T10:38:52.712Z DEBUG sqlpage::webserver::database::sql] Optimised a static simple select to avoid a trivial database query: SELECT 'table' AS component, true AS search, true AS sort optimized to {"component": String("table"), "search": Bool(true), "sort": Bool(true)}
  328. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  329. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "mac", quote_style: None })
  330. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 28, column: 8 } }
  331. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: active1 2: ,
  332. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  333. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  334. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "active1", quote_style: None })
  335. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 29, column: 12 } }
  336. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: active2 2: ,
  337. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  338. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  339. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "active2", quote_style: None })
  340. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 30, column: 12 } }
  341. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: maxgraf 2: ,
  342. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  343. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  344. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "maxgraf", quote_style: None })
  345. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 31, column: 12 } }
  346. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: reactive1 2: ,
  347. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  348. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  349. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "reactive1", quote_style: None })
  350. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 32, column: 14 } }
  351. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: reactive2 2: ,
  352. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  353. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  354. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "reactive2", quote_style: None })
  355. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 33, column: 14 } }
  356. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: , 1: TO_CHAR 2: (
  357. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 0
  358. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  359. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] parsing expr
  360. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "created_at", quote_style: None })
  361. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: DoubleColon, location: Location { line: 34, column: 23 } }
  362. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] 0: :: 1: timestamp 2: ,
  363. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] next precedence: 50
  364. [2023-12-01T10:38:52.712Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Comma, location: Location { line: 34, column: 34 } }
  365. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] 0: , 1: 'DD-MM-YYYY HH24:MI:SS' 2: )
  366. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] next precedence: 0
  367. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] parsing expr
  368. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] prefix: Value(SingleQuotedString("DD-MM-YYYY HH24:MI:SS"))
  369. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: RParen, location: Location { line: 34, column: 59 } }
  370. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] 0: ) 1: AS 2: time
  371. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] next precedence: 0
  372. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] prefix: Function(Function { name: ObjectName([Ident { value: "TO_CHAR", quote_style: None }]), args: [Unnamed(Expr(Cast { expr: Identifier(Ident { value: "created_at", quote_style: None }), data_type: Timestamp(None, None), format: None })), Unnamed(Expr(Value(SingleQuotedString("DD-MM-YYYY HH24:MI:SS"))))], filter: None, null_treatment: None, over: None, distinct: false, special: false, order_by: [] })
  373. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "AS", quote_style: None, keyword: AS }), location: Location { line: 34, column: 61 } }
  374. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] 0: AS 1: time 2: FROM
  375. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] next precedence: 0
  376. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] parsing expr
  377. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] prefix: Identifier(Ident { value: "id", quote_style: None })
  378. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: Word(Word { value: "DESC", quote_style: None, keyword: DESC }), location: Location { line: 38, column: 8 } }
  379. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] 0: DESC 1: LIMIT 2: 2
  380. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] next precedence: 0
  381. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] parsing expr
  382. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] prefix: Value(Number("2", false))
  383. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] get_next_precedence() TokenWithLocation { token: SemiColon, location: Location { line: 39, column: 8 } }
  384. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] 0: ; 1: EOF 2: EOF
  385. [2023-12-01T10:38:52.713Z DEBUG sqlparser::parser] next precedence: 0
  386. [2023-12-01T10:38:52.713Z DEBUG sqlpage::webserver::http_request_info] Not parsing POST data from request without known content type
  387. [2023-12-01T10:38:52.713Z DEBUG sqlpage::webserver::http] Received a request with the following parameters: RequestInfo { path: "/alert.sql", get_variables: {}, post_variables: {}, uploaded_files: {}, headers: {"host": Single("192.168.1.1:8080"), "user-agent": Single("Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"), "pragma": Single("no-cache"), "cache-control": Single("no-cache"), "upgrade-insecure-requests": Single("1"), "accept-encoding": Single("gzip, deflate"), "accept-language": Single("en-US,en;q=0.5"), "accept": Single("text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8"), "connection": Single("keep-alive")}, client_ip: Some(10.210.1.8), cookies: {}, basic_auth: None, app_state: AppState }
  388. [2023-12-01T10:38:52.713Z DEBUG sqlpage::render] Handling header row: {"component":"list","title":"SQLPage"}
  389. [2023-12-01T10:38:52.713Z DEBUG sqlpage::render] Creating the shell component for the page
  390. [2023-12-01T10:38:52.713Z DEBUG sqlpage::render] Rendering the shell with properties: null
  391. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("language")], "language")))
  392. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "default", params: [PathAndJson { relative_path: Some("font_size"), value: Missing }, PathAndJson { relative_path: None, value: Constant(Number(18)) }], hash: {}
  393. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "default", params: [PathAndJson { relative_path: Some("title"), value: Missing }, PathAndJson { relative_path: None, value: Constant(String("SQLPage")) }], hash: {}
  394. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "static_path", params: [PathAndJson { relative_path: None, value: Constant(String("sqlpage.css")) }], hash: {}
  395. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "each", params: [PathAndJson { relative_path: None, value: Derived(Array []) }], hash: {}
  396. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("font"), value: Missing }], hash: {}
  397. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "static_path", params: [PathAndJson { relative_path: None, value: Constant(String("sqlpage.js")) }], hash: {}
  398. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "each", params: [PathAndJson { relative_path: None, value: Derived(Array []) }], hash: {}
  399. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("description")], "description")))
  400. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("norobot"), value: Missing }], hash: {}
  401. [2023-12-01T10:38:52.713Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("refresh"), value: Missing }], hash: {}
  402. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("theme"), value: Missing }], hash: {}
  403. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("title"), value: Missing }], hash: {}
  404. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("title"), value: Context(String("SQLPage"), ["title"]) }], hash: {}
  405. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("title")], "title")))
  406. [2023-12-01T10:38:52.714Z DEBUG sqlpage::render] <- Processing database row: {"title":"N1"}
  407. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("link"), value: Missing }], hash: {}
  408. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("active"), value: Missing }], hash: {}
  409. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("color"), value: Missing }], hash: {}
  410. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("icon"), value: Missing }], hash: {}
  411. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("title")], "title")))
  412. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("description")], "description")))
  413. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("description_md"), value: Missing }], hash: {}
  414. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("link"), value: Missing }], hash: {}
  415. [2023-12-01T10:38:52.714Z DEBUG sqlpage::render] <- Processing database row: {"component":"alert","title":"Error","description":"Your cart is full.","icon":"alert-circle","color":"red"}
  416. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  417. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "default", params: [PathAndJson { relative_path: Some("color"), value: Context(String("red"), ["color"]) }, PathAndJson { relative_path: None, value: Constant(String("info")) }], hash: {}
  418. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("dismissible"), value: Missing }], hash: {}
  419. [2023-12-01T10:38:52.714Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("important"), value: Missing }], hash: {}
  420. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("icon"), value: Context(String("alert-circle"), ["icon"]) }], hash: {}
  421. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "icon_img", params: [PathAndJson { relative_path: Some("icon"), value: Context(String("alert-circle"), ["icon"]) }], hash: {}
  422. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("title"), value: Context(String("Error"), ["title"]) }], hash: {}
  423. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("important"), value: Missing }], hash: {}
  424. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("title")], "title")))
  425. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("description"), value: Context(String("Your cart is full."), ["description"]) }], hash: {}
  426. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("description")], "description")))
  427. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("description_md"), value: Missing }], hash: {}
  428. [2023-12-01T10:38:52.715Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("link"), value: Missing }], hash: {}
  429. [2023-12-01T10:38:52.715Z DEBUG sqlpage::webserver::database::execute_queries] Acquired a database connection
  430. [2023-12-01T10:38:52.717Z DEBUG sqlpage::webserver::database::execute_queries] Finished query with result: AnyQueryResult { rows_affected: 0, last_insert_id: None }
  431. [2023-12-01T10:38:52.717Z DEBUG sqlpage::render] -> Query 1 finished
  432. [2023-12-01T10:38:52.717Z DEBUG sqlpage::render] <- Processing database row: {"component":"table","search":true,"sort":true}
  433. [2023-12-01T10:38:52.717Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("dismissible"), value: Missing }], hash: {}
  434. [2023-12-01T10:38:52.717Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  435. [2023-12-01T10:38:52.717Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("search"), value: Context(Bool(true), ["search"]) }], hash: {}
  436. [2023-12-01T10:38:52.718Z DEBUG sqlpage::render] <- Processing database row: {"mac":1010000094598,"active1":8560182,"active2":17109032,"maxgraf":0,"reactive1":1780083,"reactive2":2240656,"time":"01-12-2023 11:36:22"}
  437. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  438. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "each", params: [PathAndJson { relative_path: Some("this"), value: Derived(Object {"mac": Number(1010000094598), "active1": Number(8560182), "active2": Number(17109032), "maxgraf": Number(0), "reactive1": Number(1780083), "reactive2": Number(2240656), "time": String("01-12-2023 11:36:22")}) }], hash: {}
  439. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  440. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  441. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  442. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  443. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  444. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  445. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  446. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  447. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  448. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  449. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  450. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  451. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  452. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  453. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  454. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  455. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  456. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  457. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  458. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  459. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  460. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  461. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  462. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  463. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  464. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  465. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  466. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  467. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  468. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  469. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  470. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  471. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("../../sort"), value: Context(Bool(true), ["sort"]) }], hash: {}
  472. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  473. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  474. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "delay", params: [], hash: {}
  475. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("_sqlpage_css_class")], "_sqlpage_css_class")))
  476. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("_sqlpage_color"), value: Missing }], hash: {}
  477. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "each", params: [PathAndJson { relative_path: Some("this"), value: Derived(Object {"mac": Number(1010000094598), "active1": Number(8560182), "active2": Number(17109032), "maxgraf": Number(0), "reactive1": Number(1780083), "reactive2": Number(2240656), "time": String("01-12-2023 11:36:22")}) }], hash: {}
  478. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  479. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  480. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  481. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  482. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  483. [2023-12-01T10:38:52.718Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  484. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  485. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  486. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  487. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  488. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  489. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  490. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  491. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  492. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  493. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  494. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  495. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  496. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  497. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  498. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  499. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  500. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  501. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  502. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  503. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  504. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  505. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  506. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  507. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  508. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  509. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  510. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  511. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  512. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  513. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  514. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  515. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  516. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  517. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  518. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  519. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  520. [2023-12-01T10:38:52.719Z DEBUG sqlpage::render] <- Processing database row: {"mac":1000700365430,"active1":284904,"active2":262490,"maxgraf":0,"reactive1":52488,"reactive2":46937,"time":"01-12-2023 11:36:20"}
  521. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  522. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([Named("_sqlpage_css_class")], "_sqlpage_css_class")))
  523. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("_sqlpage_color"), value: Missing }], hash: {}
  524. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "each", params: [PathAndJson { relative_path: Some("this"), value: Derived(Object {"mac": Number(1000700365430), "active1": Number(284904), "active2": Number(262490), "maxgraf": Number(0), "reactive1": Number(52488), "reactive2": Number(46937), "time": String("01-12-2023 11:36:20")}) }], hash: {}
  525. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  526. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  527. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  528. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  529. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  530. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  531. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  532. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  533. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  534. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  535. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  536. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  537. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  538. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  539. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  540. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  541. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  542. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  543. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  544. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  545. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  546. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  547. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  548. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  549. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  550. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  551. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  552. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  553. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  554. [2023-12-01T10:38:52.719Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  555. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  556. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  557. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  558. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  559. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  560. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  561. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(true)) }], hash: {}
  562. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering value: Path(Local((0, "key", "@key")))
  563. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  564. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  565. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: None, value: Derived(Bool(false)) }], hash: {}
  566. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering value: Path(Relative(([], "this")))
  567. [2023-12-01T10:38:52.720Z DEBUG sqlpage::webserver::database::execute_queries] Finished query with result: AnyQueryResult { rows_affected: 2, last_insert_id: None }
  568. [2023-12-01T10:38:52.720Z DEBUG sqlpage::render] -> Query 2 finished
  569. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "flush_delayed", params: [], hash: {}
  570. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "if", params: [PathAndJson { relative_path: Some("footer"), value: Missing }], hash: {}
  571. [2023-12-01T10:38:52.720Z DEBUG handlebars::render] Rendering helper: "buildinfo", params: [PathAndJson { relative_path: None, value: Constant(String("CARGO_PKG_VERSION")) }], hash: {}
  572. [2023-12-01T10:38:52.720Z DEBUG sqlpage::webserver::http] Successfully finished rendering the page
  573. [2023-12-01T10:38:52.720Z INFO actix_web::middleware::logger] 10.210.1.8 "GET /alert.sql HTTP/1.1" 200 3960 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0" 0.010218
  574. [2023-12-01T10:38:52.737Z INFO actix_web::middleware::logger] 10.210.1.8 "GET /sqlpage.c0217f77774797c7.css HTTP/1.1" 200 102510 "http://192.168.1.1:8080/alert.sql" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0" 0.000251
  575. [2023-12-01T10:38:52.738Z INFO actix_web::middleware::logger] 10.210.1.8 "GET /sqlpage.bdf62dc5ea395378.js HTTP/1.1" 200 55133 "http://192.168.1.1:8080/alert.sql" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0" 0.000262
  576. [2023-12-01T10:38:52.762Z INFO actix_web::middleware::logger] 10.210.1.8 "GET /tabler-icons.9fce6d4d8d57d9e6.svg HTTP/1.1" 200 340154 "http://192.168.1.1:8080/alert.sql" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0" 0.008890
  577. [2023-12-01T10:38:52.985Z DEBUG sqlpage::webserver::http] Serving file: "/favicon.ico"
  578. [2023-12-01T10:38:52.986Z INFO actix_web::middleware::logger] 10.210.1.8 "GET /favicon.ico HTTP/1.1" 200 136214 "http://192.168.1.1:8080/alert.sql" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0" 0.000536
  579.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!