<reponame>gve-sw/Cisco_Collab_Endpoints_Feedback_to_database<gh_stars>1-10
"""Copyright (c) 2020 Cisco and/or its affiliates.

This software is licensed to you under the terms of the Cisco Sample
Code License, Version 1.1 (the "License"). You may obtain a copy of the
License at

               https://developer.cisco.com/docs/licenses

All use of the material herein must be in accordance with the terms of
the License. All rights not expressly granted by the License are
reserved. Unless required by applicable law or agreed to separately in
writing, software distributed under the License is distributed on an "AS
IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
or implied.
"""

import sqlite3 as sql

from config import DATABASE_FILE, TABLE_NAME

# Creating a new db file to store the new table, or connecting if already exists
conn = sql.connect(DATABASE_FILE)
print("Opened database successfully")

# Create the feedbacks table
conn.execute(
    'CREATE TABLE '+TABLE_NAME+' (feedbackId INTEGER PRIMARY KEY AUTOINCREMENT, systemInfo TEXT, callInfo TEXT, ratingScore int, ratingDesc TEXT, feedbackTime TEXT, feedbackNotes TEXT)')
print("Table created successfully")

conn.close()

"""Copyright (c) 2020 Cisco and/or its affiliates.

This software is licensed to you under the terms of the Cisco Sample
Code License, Version 1.1 (the "License"). You may obtain a copy of the
License at

               https://developer.cisco.com/docs/licenses

All use of the material herein must be in accordance with the terms of
the License. All rights not expressly granted by the License are
reserved. Unless required by applicable law or agreed to separately in
writing, software distributed under the License is distributed on an "AS
IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
or implied.
"""

import sqlite3 as sql

from config import DATABASE_FILE, TABLE_NAME

# Creating a new db file to store the new table, or connecting if already exists
conn = sql.connect(DATABASE_FILE)
print("Opened database successfully")

# Create the feedbacks table
conn.execute(
    'CREATE TABLE '+TABLE_NAME+' (feedbackId INTEGER PRIMARY KEY AUTOINCREMENT, systemInfo TEXT, callInfo TEXT, ratingScore int, ratingDesc TEXT, feedbackTime TEXT, feedbackNotes TEXT)')
print("Table created successfully")

conn.close()
Copyright (c) 2020 Cisco and/or its affiliates.
 
 This software is licensed to you under the terms of the Cisco Sample
 Code License, Version 1.1 (the "License"). You may obtain a copy of the
 License at
 
                https://developer.cisco.com/docs/licenses
 
 All use of the material herein must be in accordance with the terms of
 the License. All rights not expressly granted by the License are
 reserved. Unless required by applicable law or agreed to separately in
 writing, software distributed under the License is distributed on an "AS
 IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
 or implied. # Creating a new db file to store the new table, or connecting if already exists # Create the feedbacks table