a
b
c1c2
', 'p');
/*
┌───────┬──────────────────────────────┬──────┐
│ rowid │ html │ text │
├───────┼──────────────────────────────┼──────┤
│ 0 │
a
│ a │
│ 1 │
b
│ b │
│ 2 │
c1c2
│ c1c2 │
└───────┴──────────────────────────────┴──────┘
*/
```
--------------------------------
### Extract First Matching HTML Element with html_extract
Source: https://github.com/asg017/sqlite-html/blob/main/docs.md
The `html_extract` function takes an HTML document and a CSS selector, returning the full HTML of the first element that matches the selector. This is useful when you need the complete markup of a specific element, including its tags and attributes.
```sql
select html_extract('
Hello, world!
', 'b');
-- '
world!'
```
--------------------------------
### HTML Trimming
Source: https://context7.com/asg017/sqlite-html/llms.txt
Removes leading and trailing whitespace from text, useful for cleaning up HTML content.
```APIDOC
## html_trim(contents)
### Description
Removes leading and trailing whitespace from text, useful for cleaning html_text output.
### Method
SQL Function
### Endpoint
N/A
### Parameters
#### Path Parameters
None
#### Query Parameters
None
#### Request Body
None
### Request Example
```sql
select html_trim(" asdf ");
-- "asdf"
select html_trim('\n bb\n ');
-- "bb"
-- Combine with html_text for clean extraction
select html_trim(html_text("
empty space
", "p"));
-- "empty space"
```
### Response
#### Success Response (200)
Returns the trimmed string.
#### Response Example
`"asdf"`
```
--------------------------------
### Extract Links from HTML File (SQL)
Source: https://github.com/asg017/sqlite-html/blob/main/README.md
Extracts all anchor ('a') elements from an HTML file and retrieves their text content and 'href' attributes. It utilizes `readfile` to read the HTML content and `html_each` to iterate over matching elements.
```sql
select
text as name,
html_attribute_get(anchors, 'a', 'href') as href
from html_each(readfile('index.html'), 'a') as anchors
```
--------------------------------
### html_text(document, selector)
Source: https://context7.com/asg017/sqlite-html/llms.txt
Extracts the text content from the first matching element in an HTML document, similar to JavaScript's Node.textContent.
```APIDOC
## html_text(document, selector)
Extracts the text content from the first matching element, similar to JavaScript's Node.textContent property.
### SQL Example
```sql
-- Extract text from anchor tag
select html_text('
hello dog', 'a');
-- "dog"
-- Extract text from nested elements (combines all text)
select html_text('
', 'p');
-- "abc"
-- Extract entire document text when no selector provided
select html_text('
abc
');
-- "abc"
-- Returns NULL when selector doesn't match
select html_text('
asdf
', 'x');
-- NULL
```
```
--------------------------------
### Prepend Table Tag to HTML Content (SQL)
Source: https://github.com/asg017/sqlite-html/blob/main/docs.md
The html_table function prepends the string '
' to the provided content. This is essential for ensuring that HTML table rows () are correctly parsed by sqlite-html, as they are not valid HTML on their own.
```sql
select html_table('xyz');
-- "xyz"
-- Try removing the "html_table()" calls and see blank results
select
html_text(html_table(rows.html), 'td:nth-child(1)') as name,
html_text(html_table(rows.html), 'td:nth-child(2)') as age
from html_each('', 'tr') as rows;
/*
┌───────┬─────┐
│ name │ age │
├───────┼─────┤
│ Alex │ 1 │
│ Brian │ 2 │
│ Craig │ 3 │
└───────┴─────┘
*/
```
--------------------------------
### HTML Unescaping
Source: https://context7.com/asg017/sqlite-html/llms.txt
Converts HTML entities back to their original characters, reversing the effect of HTML escaping.
```APIDOC
## html_unescape(text)
### Description
Converts HTML entities back to their original characters.
### Method
SQL Function
### Endpoint
N/A
### Parameters
#### Path Parameters
None
#### Query Parameters
None
#### Request Body
None
### Request Example
```sql
select html_unescape('<a>');
-- ""
select html_unescape('<a');
-- ""`
```
--------------------------------
### Generate HTML Table with html_table
Source: https://github.com/asg017/sqlite-html/blob/main/docs.md
The `html_table` function is designed to generate an HTML table representation from a given HTML document. While the specific implementation details and expected input format are not fully detailed, it implies the ability to parse and structure tabular data found within HTML.
```sql
-- Example usage for html_table would go here, but is not provided in the source text.
```
--------------------------------
### Query HTML Elements with html_each
Source: https://github.com/asg017/sqlite-html/blob/main/docs.md
The `html_each` function is a table function that iterates over HTML elements matching a CSS selector. It returns a table with columns for the element's HTML (`html`) and its text content (`text`). The input document and selector are hidden parameters. This function is useful for extracting multiple pieces of information from an HTML structure.
```sql
CREATE TABLE html_each(
html TEXT, -- HTML of the extracted element
text TEXT, -- textContent of the HTML element
document TEXT hidden, -- input HTML document
selector TEXT hidden -- input CSS selector
);
sqlite> select * from html_each('
'
-- Children can be text or HTML
select html_element('p', null, "text node"); -- '
![](\"https://images.dog.ceo/breeds/groenendael/n02105056_4600.jpg\")