The entity consists of an entity ID, and an attribute list. The attribute list
could
be thought of as an array of integers or vector of integers, and the like.
The problem I'm encountering by my affinity towards object oriented is:
I dont want to keep 2 sets of data. One inside sqlite, and one to read
from sqlite and model it as an object.
It would be cool if I could store this object
in the database.
----- Original Message -----
From: "Ken" <kennethinbox-sql...@yahoo.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Thursday, September 10, 2009 8:45:11 AM GMT -08:00 US/Canada Pacific
Subject: Re: [sqlite] Question on converting objects into relational db
table might have columns, integer ID and BLOB entity.
But it would be better if you could fully describe the "Entity" internal types
instead of just a var arg...
--- On Thu, 9/10/09, Kavita Raghunathan <kavita.raghunat...@skyfiber.com> wrote:
> From: Kavita Raghunathan <kavita.raghunat...@skyfiber.com>
> Subject: [sqlite] Question on converting objects into relational db
> To: "sqlite-users" <sqlite-users@sqlite.org>
> Date: Thursday, September 10, 2009, 10:30 AM
>
> I have a very high level question, not dealing with bits
> and bytes of sqlite:
>
> I currently have an object called entity_list, that has a
> list of all entities on the system.
> While thinking about it, it sounds like a list of entities
> is like having a database. Would
> it be possible to transfer the object entity-list into a
> sqlite database ?
>
>
> How would my schema look ?
>
>
> I have enclosed an idea of how my class looks. Any links to
> useful information is
> appreciated!
>
>
> Kavita
>
>
> ---------------
>
> class entity_list
> {
> public:
> entity_list();
> ~entity_list();
> entity *get_specific_entity(int entity_id);
> entity *add_entity(int entity_id, void *attr_list,...);
> remove_entity(int entity_id);
> vector<entity*> m_entity_list;
>
>
> private:
> };
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
