tomalex0/SenchaTouch-v2-SqliteProxy — Issue #5: Excess fields in db
Author: JohanVandeplas
Created: 2012-03-09 09:19:27+00:00
State: open

In the method constructFields you fetch the fields from the model. But not only my model fields got added but these extra fields too:

```sql
parentId TEXT,
index INTEGER,
depth INTEGER,
expanded bool,
expandable bool,
checked auto,
leaf bool,
cls TEXT,
iconCls TEXT,
root boolean,
isLast boolean,
isFirst boolean,
allowDrop boolean,
allowDrag boolean,
loaded boolean,
loading boolean,
href TEXT,
hrefTarget TEXT,
qtip TEXT,
qtitle TEXT
```

This resulted in an error when trying to add a column called index...

I temporary solved this by explicitly setting the 'isTableField: true' parameter and removing the part where it could be undefined.

Line 158:

```JavaScript
if(f.config.isTableField || !Ext.isDefined(f.config.isTableField)){
/* ... */
}
```

I'm not 100% shure but this proxy doesn't support treedata (yet), am I right? I would like to add that support.

You have any idea how to get the hasMany or hasOne properties out?

I got an Event model the event model hasMany 'cost' and hasMany 'participant'

me.getModel().prototype returns the the model and I see cost and costStore, participant and participantStore but can't find an array containing the child objects (ex: ['cost', 'participant'] ).