def _format_output(self, output): if output.endswith('\n'): output = output[:-1] return decode_from_system(output)
from robot.utils import decode_from_system CREATION_SCRIPT = """\ CREATE TABLE libraries (id INTEGER PRIMARY KEY, name TEXT, arguments TEXT, last_updated REAL); CREATE TABLE keywords (name TEXT, doc TEXT, arguments TEXT, library_name TEXT, library INTEGER, FOREIGN KEY(library) REFERENCES libraries(id)); """#创建脚本 DATABASE_FILE = os.path.join(decode_from_system(SETTINGS_DIRECTORY), 'librarykeywords.db') #数据库文件 def _create_database(): #创建数据库 print 'Creating librarykeywords database to "%s"' % DATABASE_FILE connection = sqlite3.connect(DATABASE_FILE) connection.executescript(CREATION_SCRIPT) connection.commit() connection.close() def _validate_database(): #数据库验证 connection = sqlite3.connect(DATABASE_FILE) connection.execute(
from robot.utils import decode_from_system CREATION_SCRIPT = """\ CREATE TABLE libraries (id INTEGER PRIMARY KEY, name TEXT, arguments TEXT, last_updated REAL); CREATE TABLE keywords (name TEXT, doc TEXT, arguments TEXT, library_name TEXT, library INTEGER, FOREIGN KEY(library) REFERENCES libraries(id)); """ DATABASE_FILE = os.path.join(decode_from_system(SETTINGS_DIRECTORY), 'librarykeywords.db') def _create_database(): print 'Creating librarykeywords database to "%s"' % DATABASE_FILE connection = sqlite3.connect(DATABASE_FILE) connection.executescript(CREATION_SCRIPT) connection.commit() connection.close() def _validate_database(): connection = sqlite3.connect(DATABASE_FILE) connection.execute('select id, name, arguments, last_updated from libraries') connection.execute('select name, doc, arguments, library_name, library from keywords') connection.close()