ubuntu-touch-coreapps team mailing list archive

[Joey Chan <qqworini@xxxxxxxxx>]

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