Tag is not getting added to the URL

[amolkahat]

~/T/s/p/p/ca >>> readit -v                                                      
+====+==========================================+======+============+==========+
| ID |                   URL                    | TAG  |    DATE    |   TIME   |
+====+==========================================+======+============+==========+
| 1  |    https://github.com/xxx/xxx            | None | 2018-05-17 | 15:03:25 |
+----+------------------------------------------+------+------------+----------+
~/T/s/p/p/ca >>> readit -t github https://github.com/keon/algorithms            
******************************* 
This URL is already bookmarked.
 ******************************
+====+==========================================+======+============+==========+
| ID |                   URL                    | TAG  |    DATE    |   TIME   |
+====+==========================================+======+============+==========+
| 1  |    https://github.com/xxx/xxx            | None | 2018-05-17 | 15:03:25 |
+----+------------------------------------------+------+------------+----------+
~/T/s/p/p/ca >>> readit -v 
+====+==========================================+======+============+==========+
| ID |                   URL                    | TAG  |    DATE    |   TIME   |
+====+==========================================+======+============+==========+
| 2  |    https://github.com/xxx/xxx            | None | 2018-05-17 | 15:03:25 |
+----+------------------------------------------+------+------------+----------+
~/T/s/p/p/ca >>> readit -tl 
+================+
| Available TAGs |
+================+
|      None      |
+----------------+
~/T/s/p/p/ca >>> 

[ganeshhubale]

[ganesh@localhost ~]$ readit -v
Database is empty.
[ganesh@localhost ~]$ readit -a https://github.com/projectreadit/readit
Bookmarked.
[ganesh@localhost ~]$ readit -v
+====+==========================================+======+============+==========+
| ID |                   URL                    | TAG  |    DATE    |   TIME   |
+====+==========================================+======+============+==========+
| 9  | https://github.com/projectreadit/readit  | None | 2018-05-17 | 22:29:23 |
+----+------------------------------------------+------+------------+----------+
[ganesh@localhost ~]$ readit -t github https://github.com/keon/algorithms
Bookmarked.
[ganesh@localhost ~]$ readit -v
+====+========================================+========+============+==========+
| ID |                  URL                   |  TAG   |    DATE    |   TIME   |
+====+========================================+========+============+==========+
| 9  | https://github.com/projectreadit/readi |  None  | 2018-05-17 | 22:29:23 |
|    |                   t                    |        |            |          |
+----+----------------------------------------+--------+------------+----------+
| 10 |   https://github.com/keon/algorithms   | github | 2018-05-17 | 22:29:50 |
+----+----------------------------------------+--------+------------+----------+
[ganesh@localhost ~]$ readit -tl
+================+
| Available TAGs |
+================+
|      None      |
+----------------+
|     github     |
+----------------+

@amolkahat

• I have performed same commands and above is the result. Please review and suggest changes.
• This is recently released version v0.2 of readit tool.
• If particular URL is already present in database with None value of tag then it will not be added with new tag name because URL field in database table is UNIQUE. Please refer below result:

[ganesh@localhost ~]$ readit -v
+====+========================================+========+============+==========+
| ID |                  URL                   |  TAG   |    DATE    |   TIME   |
+====+========================================+========+============+==========+
| 9  | https://github.com/projectreadit/readi |  None  | 2018-05-17 | 22:29:23 |
|    |                   t                    |        |            |          |
+----+----------------------------------------+--------+------------+----------+
| 10 |   https://github.com/keon/algorithms   | github | 2018-05-17 | 22:29:50 |
+----+----------------------------------------+--------+------------+----------+
[ganesh@localhost ~]$ readit -t myproject https://github.com/projectreadit/readit
******************************* 
This URL is already bookmarked.
 ******************************
+====+==========================================+======+============+==========+
| ID |                   URL                    | TAG  |    DATE    |   TIME   |
+====+==========================================+======+============+==========+
| 9  | https://github.com/projectreadit/readit  | None | 2018-05-17 | 22:29:23 |
+----+------------------------------------------+------+------------+----------+
[ganesh@localhost ~]$ 

[amolkahat]

@ganeshhubale I agree upon the UNIQUE URL field. But if you want to tag you should do that.
Suppose currently I tagged this link as Github but later on, I want to move this to the data_structure so tagging should be changeable for the bookmark.

[amolkahat]

@ganeshhubale You have any plan on multiple tagging?

[ganeshhubale]

Yes. I will add multiple tag features to one URL. But then I need to remove UNIQUE constraint of URL column.

[amolkahat]

@ganeshhubale I don't think you need to remove the UNIQUE constraint of the URL column. Instead, you need to implement database logic with multiple tables.