我们从Python开源项目中,提取了以下43个代码示例,用于说明如何使用sqlite3.SQLITE_SELECT。
def authorizer_func(action, table, column, sql_location, ignore): print('\nauthorizer_func({}, {}, {}, {}, {})'.format( action, table, column, sql_location, ignore)) response = sqlite3.SQLITE_OK # be permissive by default if action == sqlite3.SQLITE_SELECT: print('requesting permission to run a select statement') response = sqlite3.SQLITE_OK elif action == sqlite3.SQLITE_READ: print('requesting access to column {}.{} from {}'.format( table, column, sql_location)) if column == 'details': print(' ignoring details column') response = sqlite3.SQLITE_IGNORE elif column == 'priority': print(' preventing access to priority column') response = sqlite3.SQLITE_DENY return response
def authorizer_cb(action, arg1, arg2, dbname, source): if action != sqlite.SQLITE_SELECT: return sqlite.SQLITE_DENY if arg2 == 'c2' or arg1 == 't2': return sqlite.SQLITE_DENY return sqlite.SQLITE_OK
def authorizer_cb(action, arg1, arg2, dbname, source): if action != sqlite.SQLITE_SELECT: raise ValueError if arg2 == 'c2' or arg1 == 't2': raise ValueError return sqlite.SQLITE_OK
def authorizer_cb(action, arg1, arg2, dbname, source): if action != sqlite.SQLITE_SELECT: return 0.0 if arg2 == 'c2' or arg1 == 't2': return 0.0 return sqlite.SQLITE_OK
def authorizer_cb(action, arg1, arg2, dbname, source): if action != sqlite.SQLITE_SELECT: return 2**32 if arg2 == 'c2' or arg1 == 't2': return 2**32 return sqlite.SQLITE_OK
def sql_auth(sqltype, arg1, arg2, dbname, source): if sqltype in (sqlite3.SQLITE_READ, sqlite3.SQLITE_SELECT, SQLITE_FUNCTION): return sqlite3.SQLITE_OK else: return sqlite3.SQLITE_DENY