title: Is there a way to input columns into a db iteratively with python sqlite3?
body: <pre class="lang-py prettyprint-override"><code>def db_include(path, filename):
      full_file_path = path + filename
      patterns = pattern_retrieval(full_file_path)
      db_file = 'sequencesdb.db'
      conn = sqlite3.connect(db_file)
      try:
          c = conn.cursor()
          columns = list()
          columns_data = list()
          #create table
          for key, value in patterns.items():
              columns.append(key)
              columns_data.append(value)
          #create column names
          c.execute('''CREATE TABLE IF NOT EXISTS sequences ()''')
  </code></pre>
  <blockquote>
  <p>The pattern_retrieval function returns a dictionary</p>
  </blockquote>
  <blockquote>
  <p>The dictionary is stored in patterns variable</p>
  </blockquote>
  <blockquote>
  <p>now I want to create a table called sequences in sequences.db but I want each column to have the name of a key in the patterns variable.This is to help me then insert ints into each column after creating the db.</p>
  </blockquote>
  <p>PATTERNS_DB SCHEMA</p>
  <p>sequences table</p>
  <p>|pattern1|pattern2|pattern3|</p>
  <p>|42      | 67     |  78</p>
  <p>But I want to do all this programatically.</p>