1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

document.addEventListener('DOMContentLoaded', function() {
  getBookmarks();
});

var bookmarks;
function getBookmarks(){
	bookmarks = []
	chrome.bookmarks.getTree(function(result){

		for(var i=0;i<result.length;i++){
			reversBookmarks(result[i]);
		}
		syncBook();
  });
}

function reversBookmarks(result){
	if(result==null){
		return;
	}

	var bookmark = {
		id:result.id == null ? 0 : result.id,
		parentId:result.parentId == null ? 0 : result.parentId,
		index:result.index == null ? 0 : result.index,
		url:result.url == null ? 'None' : result.url,
		title:result.title == null ? 'None' : result.title
	}

	bookmarks.push(bookmark)

	if(result.children==null){
		return;
	}

	for(var i=0; i<result.children.length;i++){
		reversBookmarks(result.children[i]);
	}
}

function syncBook(){
	jsonStr = JSON.stringify({data:bookmarks});
	$.ajax({
		type: "post", url: "http://***/uploadBookmark", async: "true",
		data: {
			'key':new Date().toLocaleDateString(),
			'data':jsonStr
		}, success: function (data,status) {
			console.log(data);
			obj = JSON.parse(data);
			code = obj.code;
			count = obj.count;
			error = obj.error;			
			$('#loading').hide();
			if(code==0){
				$('#sync').text('OK!Synced '+count+' bookmarks.');
			}else{
				$('#sync').text('Failed! Error:'+error+' Status:'+status);
				$('#btnRetry').show();
			}
        }, error: function (error) {
                    $('#loading').hide();
			$('#sync').text('Failed! Error:'+error);
			$('#btnRetry').show();
                }
            });
}

1
2
3
4
5

@app.route('/uploadBookmark', methods=['POST'])
def uploadBookMark():
    key = request.form.get('key')
    data = request.form.get('data')
    return dbBookmark.saveBookMark(key, data)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

import json
import os
import sqlite3

PROJECT_ROOT = os.path.dirname(os.path.realpath(__file__))
DATABASE = os.path.join(PROJECT_ROOT, 'bookmark.chromeExtension')


def initDB():
    conn = None
    try:
        conn = sqlite3.connect(DATABASE)
        cursor = conn.cursor()
        cursor.execute(
            'CREATE TABLE bookmark (id INT PRIMARY KEY , parentId INT, indexId INT,url VARCHAR (20),title VARCHAR(20))')
        cursor.close()
        conn.commit()
    except BaseException as e:
        print e
    finally:
        if conn:
            conn.close()


def saveBookMark(key, data):
    bookMarks = json.loads(data)
    data = bookMarks.get('data')

    conn = None
    count = 0
    error = 'null'
    try:
        conn = sqlite3.connect(DATABASE)
        cursor = conn.cursor()
        sql = "DELETE FROM bookmark"
        cursor.execute(sql)
        for bookMark in data:
            id = bookMark.get('id')
            pId = bookMark.get('parentId')
            iId = bookMark.get('index')
            url = bookMark.get('url').encode('utf-8')
            title = bookMark.get('title').encode('utf-8').replace("'", " ")

            sql = "INSERT INTO bookmark (id,parentId,indexId,url,title) VALUES ('{}','{}','{}','{}','{}')" \
                .format(id, pId, iId, url, title)
            try:
                cursor.execute(sql)
                count = count + cursor.rowcount
            except Exception as e:
                print e
                error = e.message

        cursor.close()
        conn.commit()
    except Exception as e:
        error = e.message
    finally:
        if conn:
            conn.close()
        if count == 0:
            return '{"code":%d,"count":%d,"error":"%s"}' % (-1, count, error)
        else:
            return '{"code":%d,"count":%d,"error":"%s"}' % (0, count, error)