English 中文(简体)
iphone table view delete entry and update app engine db
原标题:

I have a tableview with data, that i post to the app engine database. Whenever i delete an entry in the table, i want to delelte the item in the app engine database as well. How do i know which entry to delete?

I was thinking of this:

for every item i save in the GAE store, i make a reference to a model with the iphone unique device id. for every item i save in the GAE store, i insert a UUID for iphone db & app engine db.

So my query would be something like this ex:

del item where unique device id = ####
and item UUID = ####

I dont want to login to app engine, thats why i am using the unique device id.

My only concern is performance, GAE has to lookup device id and the UUID, i dont know if this wil be a problem?

Best solution would be if just could delete it by its db.Key(), but i dont know how to do that, because when i post the data to GAE i dont know what key it generated.

Could anyone give me some advice?

最佳回答

The approach you suggest is reasonable. If you specify the UUID as your key name, you can delete it directly. To create an entity with a key name, do:

MyEntity(key_name=a_string, ...)

To delete an entity by key name (without fetching it first), do:

db.delete(db.Key.from_path("MyEntity", a_string))

There s no need to have both a UUID and a device ID - the UUID is sufficient to ensure uniqueness across all devices.

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签