#!/usr/bin/env python
# encoding: utf-8

import os, time
from urllib import quote
try:
	import sqlite3
except ImportError:
	from pysqlite2 import dbapi2 as sqlite3

def infDoor(name):
	try:
		doorways = []
		names = []
		connect = sqlite3.connect('system/%s.gp' % name)
		connect.text_factory = str
		cursor = connect.cursor()
		cursor.execute('select keyword,name from mygroup') 
		for row in cursor: 
			doorways.append(row[0].decode('utf_8'))
			names.append(row[1].decode('utf_8'))
		return doorways, names
	except Exception,msg:
		print msg

def isItValid(name,doorway):
	doorways, names = infDoor(name)
	if doorway in names:
		return True, doorways, names
	else:
		return False, [], []