| #!/usr/bin/env python | |
| # encoding: utf-8 | |
| import sqlite3 | |
| import sys | |
| con = None | |
| try: | |
| con = sqlite3.connect('test.db') | |
| # does vim python omni complete can complete 'cursor()' after 'con' ??? | |
| cur = con.cursor() | |
| cur.execute('SELECT SQLITE_VERSION()') | |
| data = cur.fetchone() | |
| print("SQLite version is %s " % data) | |
| except sqlite3.Error as e: | |
| print("Error ", e) | |
| sys.exit(1) | |
| finally: | |
| if con: | |
| con.close() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment