rezich/sqlite

SQLite bindings, wrapper, and optional ORM, for Jai

sqlite's Issues

Verbose mode needs "stacking"

If you have a Model with a @autofetch @do_not_serialize field, and the associated fetch procedure runs SQL, then the Verbose output gets messed up, because there's no pushing/popping going on between the "nested" queries.

Cached(T) does not permit foreign keys to the same table

The Cached(T) interface seemed like a good idea, but it doesn't permit tables to have columns that are foreign keys to the same table.

A workaround using notes may be possible:

User :: struct { using #as model: Model;
    parent_id: s64; @fk=User
}

But this breaks a lot of the benefits that the ORM gives you, such as being able to fetch(*some_cached_user.parent).

Another possible solution: replace Cached(T) with Model.Cached, maybe? If we can get the model name out of it, that is, which we might not be able to.

Fetch procedures should be simpler

When you have a Model with a field that's @autofetch @do_not_serialize, it's quite verbose to execute a simple SQL command to get a value—this should be improved.