import os

	def __init__(self, name):

		self.userid = self.get_user_id(name)

		if self.userid == None:

			self.userid = self.create_user(name)

		else:

			self.userid = self.userid[0]

	def get_user_id(self, name):

		self.crs.execute("""

			SELECT id FROM users

			WHERE name = %s;

			""" % (sql_quote(name),))

		return self.crs.fetchone()

	def create_user(self, name):

		id = self.get_next_id('users')

		self.crs.execute("""

			INSERT INTO users(id, name)

			VALUES (%d, %s);

			""" % (id, sql_quote(name)))

		self.crs.execute("""

			INSERT INTO keywords(id, userid, name)

			VALUES (0, %d, '--');

			""" %(id,))

		self.crs.execute("""

			INSERT INTO db_sequence(seq_name, userid, nextid)

			VALUES ('keywords', %d, 1);

			""" %(id,))

		self.crs.execute("""

			INSERT INTO db_sequence(seq_name, userid, nextid)

			VALUES ('bookmarks', %d, 0);

			""" %(id,))

		self.cnx.commit()

		return id

	def delete_user(self, userid):

		self.crs_execute("""

			DELETE FROM users WHERE id = %d;

			DELETE FROM bookmarks_keywords WHERE userid = %d;

			DELETE FROM bookmarks WHERE userid = %d;

			DELETE FROM keywords WHERE userid = %d;

			DELETE FROM db_sequence WHERE userid = %d;

			""" % (userid,userid,userid,userid,userid))

			INSERT INTO bookmarks(id, userid, url, name, ldesc, added)

			VALUES (%d, %d, %s, %s, %s, %s);

			INSERT INTO bookmarks_keywords(bookmark, keyword, userid)

			VALUES (%d, 0, %d);

			""" % (id, self.userid, sql_quote(bk.url),

			sql_quote(bk.added),

			id, self.userid))

			WHERE userid = %d AND (id = %d

			""" % (self.userid, ids.pop(),)

		qry = qry + ");"

			WHERE userid = %d AND id = %d;

			sql_quote(bk.added), self.userid, bk.id))

			WHERE userid = %d AND bookmark = %d AND

			keyword <> 0;""" % (self.userid, id))

				bookmarks_keywords(bookmark, keyword, userid)

				VALUES (%d, %d, %d);""" % (id, kw, self.userid))

			WHERE userid = %d AND bookmark = %d;

			WHERE userid = %d AND id = %d;

			""" % (self.userid, id, userid, id))

			INSERT INTO keywords(id, userid, name)

			VALUES (%d, %d, %s);

			""" % (id, self.userid, sql_quote(name)))

			WHERE userid = %d AND id = %d;

			""" % (self.userid, id))

			WHERE bookmarks_keywords.userid = %d

			AND keywords.id = bookmarks_keywords.keyword

			""" % (self.userid, bk_id))

			WHERE userid = %d AND id = %d;

			""" % (sql_quote(name), self.userid, id))

			WHERE keyword = %d AND userid = %d;

			WHERE id = %d AND userid = %d;

			""" % (id, self.userid, id, self.userid))

			userid = %d

			  WHERE userid = %d AND keyword = %d ))

			""" % (into_id, merge_id, self.userid,

			self.userid, merge_id))

		"""Return a list of doublets [id, keyword, count]."""

		self.crs.execute("""SELECT k.id, k.name

			FROM keywords k

			WHERE userid = %d

			ORDER BY k.id;""" % (self.userid,))

		res = self.crs.fetchall()

		return res

	def get_keywords_count(self):

		"""Return a list of doublets [id, count].

Does with a count of zero are ignored."""

		self.crs.execute("""SELECT bk.keyword, COUNT(bk.keyword)

			FROM bookmarks_keywords bk

			WHERE bk.userid = %d

			GROUP BY bk.keyword

			ORDER BY bk.keyword;""" % (self.userid,))

		res = self.crs.fetchall()

		if not res:

			res = [[0,0]]

		return res

		  AND bookmarks_keywords.userid = %d

		qry = basic_qry % (has_kw[0], self.userid)

			qry = qry + ("INTERSECT " + basic_qry % (kw, self.userid))

			qry = qry + ("EXCEPT " + basic_qry % (kw, self.userid))

		if seq_name == 'users':

			userid = -1

		else:

			userid = self.userid

			db_sequence.seq_name = '%s'

			AND db_sequence.userid = %d

			FOR UPDATE;

			""" % (seq_name,userid))

			WHERE seq_name = '%s'

			AND userid = %d;

			""" % (id+1, seq_name, userid))

def connect(username):

	return MyDbConnexion(username)