tablelandnetwork / studio

Discover, design, deploy, and manage data driven web3 apps on Tableland.
https://studio.tableland.xyz
4 stars 1 forks source link

add sql identifier escape util #281

Closed joewagner closed 4 months ago

joewagner commented 4 months ago

This adds a util function that strips identifier characters off of strings. Here are some relevant sqlite docs for more detail: https://www.sqlite.org/lang_keywords.html

Of note is that I didn't include the single quote, ', since anything escaped in that way become a string literal (not an identifier).

vercel[bot] commented 4 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
studio ✅ Ready (Inspect) Visit Preview 💬 Add feedback May 30, 2024 3:58pm
joewagner commented 4 months ago

@asutula Here is the util function I've been using. Open to a more robust solution, but for now this should help get that bug fixed.

asutula commented 4 months ago

Incorporated this into #284