absurder-sql 0.1.23

AbsurderSQL - SQLite + IndexedDB that's absurdly better than absurd-sql
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152

# Integration Test Scripts

## WASM → Native Interoperability Test

**Script:** `test_wasm_to_native_interop.py`

### Purpose

This script proves complete bidirectional compatibility between WASM and native code by:

1. **Creating a database in the browser** using WASM/IndexedDB
2. **Exporting to a SQLite .db file** 
3. **Querying the file with native Rust code** (rusqlite)

This validates that:
- **[✓]** WASM can create valid, spec-compliant SQLite files
- **[✓]** Native tools can read WASM-created databases
- **[✓]** Data integrity is maintained (special characters, types, etc.)
- **[✓]** Full round-trip compatibility works

### Prerequisites

1. **Python 3.8+** with pip
2. **Rust and Cargo** installed
3. **Node.js and npm** for running the Vite dev server
4. **Playwright browsers** installed

### Setup

```bash
# Install Python dependencies
cd scripts
pip install -r requirements.txt

# Install Playwright browsers
playwright install chromium

# Make script executable (optional)
chmod +x test_wasm_to_native_interop.py
```

### Usage

```bash
# From the root of the repository
# Make sure Vite dev server is NOT running (script expects port 3000 to be free)

# Run the test
python scripts/test_wasm_to_native_interop.py
```

Or use the npm script (if added to package.json):

```bash
npm run test:interop
```

### What It Does

1. **Starts Playwright** and launches Chromium
2. **Navigates to the Vite app** at `http://localhost:3000`
3. **Waits for WASM initialization** and Database class availability
4. **Creates a test database** with 4 users (various data types and special characters)
5. **Exports the database** to bytes using `exportToFile()`
6. **Saves the .db file** to `test-output/wasm_exported.db`
7. **Creates a temporary Rust project** with rusqlite dependency
8. **Compiles and runs Rust code** that:
   - Opens the exported .db file
   - Queries all rows
   - Verifies data integrity
   - Checks special character preservation
9. **Reports success/failure**

### Expected Output

```
======================================================================
WASM → Native Interoperability Test
======================================================================

[BROWSER] Starting Playwright browser automation...
[NAV] Navigating to http://localhost:3000...
[WAIT] Waiting for WASM to initialize...
[DB] Creating test database with sample data...
[OK] Exported 12288 bytes from browser
[SAVE] Saved database to: test-output/wasm_exported.db

[Rust] Running Rust verification with rusqlite...
[BUILD] Compiling Rust verification code...
[OK] Successfully opened WASM-created database with rusqlite
  Row 1: Alice O'Brien | alice@example.com | 30 | 1234.56
  Row 2: Bob "The Builder" | bob@example.com | 25 | 9876.54
  Row 3: Charlie 你好 | charlie@example.com | 35 | 5555.55
  Row 4: Diana [emoji] | diana@example.com | 28 | 7777.77
[OK] Successfully queried 4 rows from WASM-created database
[OK] Special characters preserved correctly

======================================================================
[SUCCESS] WASM -> Native interoperability verified!
======================================================================

Exported database saved at: /path/to/test-output/wasm_exported.db
You can inspect it with: sqlite3 test-output/wasm_exported.db
```

### Inspecting the Output

After a successful run, you can manually inspect the exported database:

```bash
# Open with sqlite3 CLI
sqlite3 test-output/wasm_exported.db

# Run queries
sqlite> .tables
sqlite> SELECT * FROM users;
sqlite> .schema users
sqlite> .quit
```

Or with any SQLite browser/tool.

### Troubleshooting

**Port 3000 already in use:**
- Make sure the Vite dev server is not already running
- Or modify the script to use a different port

**Playwright browsers not installed:**
```bash
playwright install chromium
```

**Rust/Cargo not found:**
```bash
# Install Rust
curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh
```

**Script fails at export:**
- Check that WASM build is up to date: `wasm-pack build --target web --out-dir pkg`
- Ensure the vite app is properly configured

### Integration with CI/CD

This script can be added to GitHub Actions or other CI/CD pipelines to continuously verify WASM-native compatibility:

```yaml
- name: Test WASM to Native Interop
  run: |
    python scripts/test_wasm_to_native_interop.py
```