Comments (11)
Keep getting hit by 'TABLE NOT FOUND' exceptions, simply trying to save it to? is not supposed to create the table at this point? It seems to just randomly work if i do it often enough, but i dont know what im doing to suddenly make it create the table.
from sugar.
if you're using it as .jar, it still needs a constructor with context parameter. If you're using the latest code as library, you'd need the default empty constructor. I assume, its failing for this reason. Do give it a try and let me know.
from sugar.
I do already have context in the constructor do i not? I'm using the jar
from sugar.
Oh, i see what you meant, i just added the constructor back, still the same problem however!
from sugar.
You need something like this.
public FantasyStocksDB(Context ctx){
super(ctx);
}
—
Sent from Mailbox for iPad
On Thu, Jan 23, 2014 at 8:33 PM, Joe Scott [email protected]
wrote:
I do already have context in the constructor do i not? I'm using the jar
Reply to this email directly or view it on GitHub:
#63 (comment)
from sugar.
Yes, sorry, i got that straight after, please see my reply above however!
from sugar.
Further: just swapped to using the library version, no luck.
from sugar.
Cleared my apps data and reinstalled one last time and it worked. :/
changed nothing, i dont even know what's going on anymore. haha
from sugar.
It might be an upgrade issue. Meaning: you might have run the app initially without the FantasyStockDB class. So, the database got created, without the table. When you run the second time, it didn't find the upgrade script, hence, no table created.
Fresh install (or clearing data), created the tables afresh. That solved it.
I created a sample project using your class. You don't need it now, but anyway here it is :)
https://dl.dropboxusercontent.com/u/1629843/sugartest.zip
from sugar.
Sorry about the reopen, thank you! But while i've got you here, is there a good way of checking whether the table does in fact exist? or creating the table, but empty initially?
You see, when the user wants to add a stock and i need to update the value in the DB i need something like:
if(table.exists)
{
if(table.contains(stocksymbol)
{
update value at POS x
}
else
{
insert new value
}
}
else
{
create table
insert value
}
If that makes sense?
from sugar.
You don't really need to check if the table exists. Sugar takes care of creating the tables. If anything, it's only a development time issue. Once fixed, you can rely that it'd create the table on first launch.
For upgrades, you can follow the migration page here. http://satyan.github.io/sugar/migration.html
Unless, you have a very specific need of creating table on demand, I wouldn't recommend this approach.
from sugar.
Related Issues (20)
- Issue with Multiple Entitys
- Support for user specified ID's being used in the database instead of having them generated automatically.
- Android Studio 3.2.1 DB is no longer created HOT 3
- Is Sugar ORM library affected by the newly found SQLite vulnerability?
- update bug HOT 1
- [QUESTION] Where I can find the CI service?
- OneToMany Annotation
- Missing saveAll() for nested Table
- How read existing DB from assets folder? HOT 1
- Como deletar todos os dados de uma tabela e depois verificar se a tabela está vazia? HOT 1
- No such table with migration HOT 2
- ava.lang.NoSuchMethodException: <init> []
- SugarRecord Read / write separation
- bulk data not inserted completely
- Caused by: android.database.sqlite.SQLiteException: no such table: HOT 5
- *.db file is empty, but in application all the lines are shown.
- RuntimeException on start
- 我使用save来保存数据但是数据当中设置了不可重复字段会对其进行覆盖
- build failed when sync graddle HOT 1
- no such column when select
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 sugar.