Question: Create a Sqlite database sending in the following query at the beginning of your program if the database doesn't exist (use the os module to
Create a Sqlite database sending in the following query at the beginning of your program if the database doesn't exist (use the os module to check to see if a file exists). CREATE TABLE storage(curtime TEXT, line TEXT) You can use the following query to insert values into the database: INSERT INTO storage (curtime, line) values ('', line); With appropriate values for your values. You will need to create a string by concatenating your values before you pass the INSERT statement into the execute method. There are a number of ways to do this, so be sure to look up examples online.. You should be getting the current time each time you enter a value into the database and pass that in for the value of curtime. The following will get you the current time with high precision. import datetime current_time = datetime.datetime.now().time()
So I'm extracting information from a website, which I've done, but am having trouble completing the task listed above. I'm currently using Python 3.5.3. Please provide solution code.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
