Re: [Banshee-List] development tips for Hyena query

[Gabriel Burt <gabriel burt gmail com>]

On Wed, Jan 19, 2011 at 9:12 AM, olivier dufour <olivier duff gmail com> wrote:
> HyenaSqliteCommand insert_video_command = new HyenaSqliteCommand
> (String.Format (@"
>     INSERT INTO Videos (VideoID, TrackID, Title)
>         SELECT null, TrackID, Title FROM CoreTracks WHERE PrimarySourceID =
> {0} AND ExternalID = 0", videoSource.DbId
> ));
> Is this request OK? Does the VideoId primary key will automaticly iterate on
> each record?

I know that removing the VideoID from the list of columns to insert
will do the trick.

> My issue how setup the ExternalId of DBTrackInfo in mass?

I can't think of a way to do it in bulk.

Gabriel