Hi Ladies and Gentlemen, I have completed some SQL operation code for database, note that they are not perfect because I'm a bit busy this week, any comments or suggestion are welcome.
1. feed operation 1.1 add feed // id = null, link = null, description = null, pubdate = null, image = null, count = null insert into feed values ( id , source , title , link , description , pubdate , image, count ) 1.2 modify feed update feed set title = ?, source = ? where id = ? // end-users can only modify these two values update feed set link = ?, description = ?, pubdate = ? where id = ? // these values automaticly update by feed source update feed set image = ? where id = ? // image path, for offline use update feed set count = ? where id = ? // a number which how many times user views this feed 1.3 delete feed delete from feed where id = ? 2. article operation 2.1 add article // most of the values come from feed xml files insert into article values ( id , title , link , description , pubdate , status , favourite , image , guid , feed_id ) 2.2 modify article update article set status = ? where id = ? // 0 for unread, 1 for read, 2 for read later update article set favourite = ? where id = ? // 0 for not, 1 for favourite update article set image = ? where id = ? // image path, for offline use 2.3 delete article delete from article where id = ? 3. tag operation 3.1 add tag insert into tag values ( id, name ) 3.2 modify tag update tag set name = ? where id = ? 3.3 delete tag delete from tag where id = ? 4. feed_tag operation 4.1 add feed_tag insert into feed_tag values ( id , feed_id , tag_id ) 4.2 modify feed_tag (no need) 4.3 delete feed_tag delete from feed_tag where id = ? 5. settings operation // only one row is needed to save all settings, values will be initial after create table 5.1 modify settings update settings set current_database_version = ? where id = 1 update settings set database_last_updated = ? where id = 1 update settings set view_mode = ? where id = 1 update settings set update_interval = ? where id = 1 update settings set network_mode = ? where id = 1 6. operation for testing 6.1 clear table delete from ? // ? is table name 6.2 drop table drop table if exists ? Cheers, Joey
-- Mailing list: https://launchpad.net/~ubuntu-touch-coreapps Post to : [email protected] Unsubscribe : https://launchpad.net/~ubuntu-touch-coreapps More help : https://help.launchpad.net/ListHelp
