Esempi in Python per SimpleSQLite.verify_attr_existence

Esempio n. 1

def main():
    table_name = "sample_table"
    con = SimpleSQLite("sample.sqlite", "w")
    con.create_table_from_data_matrix(table_name, ["attr_a", "attr_b"], [[1, "a"], [2, "b"]])

    con.verify_attr_existence(table_name, "attr_a")
    try:
        con.verify_attr_existence(table_name, "not_existing")
    except AttributeNotFoundError as e:
        print(e)
    try:
        con.verify_attr_existence("not_existing", "attr_a")
    except DatabaseError as e:
        print(e)

Esempio n. 2

File: sample_verify_attribute_existence.py Progetto: yedan2010/SimpleSQLite

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

from __future__ import print_function

from simplesqlite import (SimpleSQLite, TableNotFoundError,
                          AttributeNotFoundError)

table_name = "sample_table"
con = SimpleSQLite("sample.sqlite", "w")
con.create_table_from_data_matrix(table_name=table_name,
                                  attr_name_list=["attr_a", "attr_b"],
                                  data_matrix=[[1, "a"], [2, "b"]])

con.verify_attr_existence(table_name, "attr_a")
try:
    con.verify_attr_existence(table_name, "not_existing")
except AttributeNotFoundError as e:
    print(e)
try:
    con.verify_attr_existence("not_existing", "attr_a")
except TableNotFoundError as e:
    print(e)

Esempio n. 3

File: sample_verify_attribute_existence.py Progetto: thombashi/SimpleSQLite

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

from __future__ import print_function

from simplesqlite import AttributeNotFoundError, SimpleSQLite, TableNotFoundError


table_name = "sample_table"
con = SimpleSQLite("sample.sqlite", "w")
con.create_table_from_data_matrix(table_name, ["attr_a", "attr_b"], [[1, "a"], [2, "b"]])

con.verify_attr_existence(table_name, "attr_a")
try:
    con.verify_attr_existence(table_name, "not_existing")
except AttributeNotFoundError as e:
    print(e)
try:
    con.verify_attr_existence("not_existing", "attr_a")
except TableNotFoundError as e:
    print(e)