def test_connect():
print("Standard Connection")
try:
# Connect to the DCRIS database with an option file
conn = Connect("dcris.txt")
# Get the connection cursor object
cursor = conn.cursor
# Define a SQL query
sql = "SELECT * FROM keyword"
# Execute the query from the connection cursor
cursor.execute(sql)
# Print the column names from the query result
print("Columns:")
print(cursor.column_names)
# Get and print the contents of the query results (raw results)
rows = cursor.fetchall()
print("Row count: {}".format(cursor.rowcount))
print("Data:")
for row in rows:
print(row)
# Close the Connect object
conn.close()
except Exception as e:
print(str(e))
'''
Created on 2019 M03 8
@author: liux8275
'''
from asgn03 import keyword_member_count
from Connect import Connect
v1 = 13
conn = Connect("dcris.txt")
print("keyword_id is None(sorted by keyword description)")
rows = keyword_member_count(conn)
for row in rows:
print(row)
print("\n")
print("keyword_id is {}(sorted by keyword description)".format(v1))
rows = keyword_member_count(conn, keyword_id=v1)
for row in rows:
print(row)
print("\n")
conn.close()
