View Issue Details

IDProjectCategoryView StatusLast Update
0000515Ecere SDKcompilerpublic2014-07-11 18:41
Reporterjerome Assigned To 
PriorityhighSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Target Version0.46 eC II 
Summary0000515: EDA Database Syntax and other Improvements
DescriptionWe need to make the special EDA eC Database syntax more consistent with eC code (Using an actual class definition).
I had written some sample code to see how it looks but I have yet to recover this piece of code.

- Not having to free strings when querying
- Container / Iterator integration
- Auto Increment ID in EDB and matching other SQLite driver features: Row::Find


TagsNo tags attached.

Activities

jerome

2010-07-28 17:36

administrator   ~0000284

Last edited: 2010-07-28 17:37

Some guesses at documenting the syntax we had in mind:


class RowStudyEntries : Row
{
   dbtable("StudyEntries");
   idclass(StudyEntry);

   StudyEntry id dbfield("ID");
   StudyInfo info dbfield("Info");
   DateTime addedTime dbfield("Added Time");
   String addedUID dbfield("Added UID");
}


dbfield could be optional, idclass could be optional and look for 'id'.
So could the dbtable?

jerome

2011-06-23 22:22

administrator   ~0000446

StudyEntry gives us a nice numeric ID, but e.g. when transferring data, it's useful to have a class that actually stores the information.

Perhaps we should auto generate both StudyEntry and StudyEntryID ?

2011-07-31 15:40

 

edaGuess.ec (270 bytes)

Issue History

Date Modified Username Field Change
2010-07-28 15:36 jerome New Issue
2010-07-28 15:37 jerome Description Updated
2010-07-28 17:36 jerome Note Added: 0000284
2010-07-28 17:37 jerome Note Edited: 0000284
2010-07-29 16:11 jerome Priority normal => high
2011-06-23 22:22 jerome Note Added: 0000446
2011-07-31 15:40 jerome File Added: edaGuess.ec
2012-03-08 16:51 redj Target Version => 0.45 Ginkakuji
2012-03-29 07:50 redj Category => eC Compiling Tools
2012-03-29 07:50 redj Project @2@ => Ecere SDK
2012-07-07 19:24 jerome Description Updated
2012-07-07 19:28 jerome Description Updated
2014-07-11 18:41 jerome Target Version 0.45 Ginkakuji => 0.46 eC II