Databases
StackOverflow2013
Postsdbo
POHow to skip over columns in SQLite using Python?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to skip over columns in SQLite using Python?
    primarykey
    data
    text
    <p>I'm very new to python and I have a basic python script where I need to insert values from a CSV file into an SQLite database using Python. I've done that part successfully, however, I need to not include columns 26, 27 and 28 out of 29. Whenever I try to do this, it just skips over the entire row, however I only want it to skip that specific column in general. I tried to not include the columns when creating the table originally however, I would get an error each time when I ran the script </p> <p>This is the code I'm working with with regards to this process: </p> <pre><code>import sys, sqlite, csv try: cx = sqlite.connect("database") except sqlite.Error, errmsg: print "Could not open the database file: " + str(errmsg) sys.exit() #create the table try: cu = cx.cursor() cu.execute('DROP TABLE IF EXISTS table_name') sql = """ CREATE TABLE table_name(col1 TEXT, col2 TEXT, col3 TEXT, col4 TEXT, col5 TEXT, col6 TEXT, col7 TEXT, col8 TEXT, col9 TEXT, col10 TEXT, col11 TEXT, col12 TEXT, col13 TEXT, col14 TEXT, col15 TEXT, col16 TEXT, col17 TEXT, col18 TEXT, col19 TEXT, col20 TEXT, col21 TEXT, col22 TEXT, col23 TEXT, col24 TEXT, col25 TEXT, col26 TEXT, col27 TEXT, col28 TEXT, col29 TEXT); """ cu.execute(sql) cx.commit() except sqlite.Error, errmsg: print "Could not execute the query: " + str(errmsg) sys.exit() #Load the CSV file into the csv reader fin = open("test.csv", "rb") creader = csv.reader(fin, delimiter=',') # Interate through the CSV Reader, inserting each value into the database # NEW REVISION sql_insert = "INSERT INTO table_name VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,,,,%s);" for row in creader: cu.execute(sql_insert, row) print row fin.close() cx.commit() cx.close() </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1186173
    1. USuser1186173
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to skip over columns in SQLite using Python?
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POHow to skip over columns in SQLite using Python?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload