Comments (3)
Sorry for the long delay. Wow. Time under Android has been a real problem to keep up with. I've noted for some time that the SSSSSS
should have been SSS
but to change this would complete break backwards compatibility. You can certainly specify your own format although I'm not sure what .SSS would do with .321000
or .000321
.
Maybe the right thing to do here is to support a persister that extends the DateStringType and sees if the date is a .SSSSSS and handles it but also handles .SSS and writes new dates as .SSS.
Comments?
from ormlite-android.
That will probably work for backwards compatibility. My only worry is the performance impact of doing the check on each read?
From what I've seen the reads of .321000
reads as .321
and 0.000321
reads as .000
when the date format is set to .SSS
.
My solution to this was to simply use .SSS
for all my date fields and upgrade my DB to the new format (always fun to write string manipulations in SQLite)
from ormlite-android.
The detection of the 6 versus 3 digits and the position of the zeros is nothing compared to the work needed to convert the string date into a java Date
. I'm going to add it as a type.
from ormlite-android.
Related Issues (20)
- android ,执行update操作,总是返回0 HOT 4
- ORMLite Android - Prevent Upgrade inside catch HOT 2
- The connection pool for database has been unable to grant a connection in ORMLite 5.1 HOT 5
- Missing or reset data HOT 3
- getReadWriteConnection: SQLiteCantOpenDatabaseException unknown error (Sqlite code 14): Could not open database, (OS error - 13:Permission denied)
- Is there any way we can get a 5.2 release to benefit from a bugfix in core 5.2? HOT 1
- Feature Request: SupportSQLiteOpenHelper HOT 2
- Null variable AndroidLogBackend causes "Could not construct instance of helper class" HOT 2
- UpdateBuilder use Nonparametric statement cause sql injection problem HOT 3
- Exception when create object with string including single quote HOT 2
- log4j HOT 2
- how to join two table? HOT 2
- [Bug] Using Limit and Offset causes SQL exception. HOT 3
- Duplicate classes and files when depending on a project using ormlite-core HOT 6
- Can't use a dependency with ormlite annotations. HOT 3
- Does ormlite support In-Memory database? HOT 1
- R8 minifyEnabled proguard rules
- EXTERNAL DATA IN SQL QUERIES [SAST] [M7] [CWE-89]
- Security vulnerability - SQL injection
- dao.queryForId() returns null even though row exists HOT 5
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 ormlite-android.