Synnefo » Pithos MS Client

                    //If the ID exists, update the status

                    if (StateExistsByID(objectInfo.UUID,connection))

                            "update FileState set FilePath=:path,FileStatus= :fileStatus, Checksum=:checksum, ShortHash=:shortHash,Version=:version,VersionTimeStamp=:versionTimeStamp where ObjectID = :objectID  ";                        

                    else if (StateExists(path, connection))

                        //If the ID doesn't exist, try to update using the path, and store the ID as well.

                        command.CommandText =

                            "update FileState set FileStatus= :fileStatus, ObjectID=:objectID, Checksum=:checksum, ShortHash=:shortHash,Version=:version,VersionTimeStamp=:versionTimeStamp where FilePath = :path  COLLATE NOCASE ";

        private bool StateExistsByID(string objectId,SQLiteConnection connection)

        {

            using (var command = new SQLiteCommand("Select count(*) from FileState where ObjectId=:id", connection))

            {

                command.Parameters.AddWithValue("id", objectId);

                var result = command.ExecuteScalar();

                return ((long)result >= 1);

            }

        }