Comments (1)
I would also like to know. Does not look like there is an option t set it as the code has checks like this:
if (!table._internal && (l.indexOf("_") === 0 || l.match(/\s/g) !== null || l.match(/[\(\)\]\[\.]/g) !== null)) {
rej({ error: "Invalid Table Name " + table.name + "! https://docs.nanosql.io/setup/data-models", query: _this.query });
return;
}
if (!modelData[0] || modelData[0].match(/[\(\)\]\[\.]/g) !== null || modelData[0].indexOf("_") === 0) {
hasError = true;
rej({ error: "Invalid Data Model at " + (table.name + "." + col) + "! https://docs.nanosql.io/setup/data-models", query: _this.query });
}
If I alter the code to exclude the check for the undescore prefix then it works perfectly fine. Maybe one of the adapters does not like it, in which case it would be possible to then add a config for it to allow it.
UPDATE: So after further investigation it seems that nano-sql uses underscores internally for table creation (I observed with SQLite) and it disallows using underscores for table and db names so as to avoid collisions most probably..
from nano-sql.
Related Issues (20)
- NODERAWFS error for some adapters
- Cannot insert a record with an id of 0 (zero) if the id field is a primary key
- Index does not be built correctly.
- [HELP] Increment value HOT 1
- TTL feature always status time -1
- Incorrect behavior with joins and filters
- jsLoad not respect unique index
- Bug with select from HOT 2
- foreignKey: onUpdate support HOT 1
- copy database
- nSQL: Can't do a query before the database is connected! HOT 1
- Can't query tables after restart, log parsing error HOT 1
- [Meta] Is this project still maintained? HOT 3
- LOG file "backs up" every change to a row HOT 1
- Selection of date types with undefined values
- Adding support for WebExtensions
- Support for Capacitor?
- Remove WebSQL usage and/or method calls from this repository
- Does nanoSQL work correctly on Safari s it does on Chrome?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nano-sql.