Pysqlite text data importing problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • klia
    New Member
    • Oct 2008
    • 14

    Pysqlite text data importing problem

    hey folks
    i am facing this problem in my following codes where i am trying to create a database using pysqlite and load data from text file where data is arranged in this form "Birthday2| 12/5/2008|HTC|this is my birthday"
    but i could connect to the database, create it into my current working directory but i can't load the data from my text file in same working directory, i don't know the exact syntax for doing that.

    Also can someone help to rename the file name to current date and time rather than user specified name.

    Thanks in advance

    Code:
    #Connecting to Database
    import os
    import sqlite3
    from pysqlite2 import dbapi2 as sqlite
    connection = sqlite.connect('Photos.db')
    memoryConnection = sqlite.connect(':memory:')
    cursor = connection.cursor()
    
    #Writing  Data to Database
    #Getting data from Text File
    
    TXT_FILE = os.getcwd() + "\\Photos.txt"
    cursor.execute('CREATE TABLE photos (Name VARCHAR(100) PRIMARY KEY, Date INTEGER, Make VARCHAR(50), Tag VARCHAR(100))') 
    cursor.execute('SEPARATOR "|"')
    cursor.execute('IMPORT Photos.txt Photos')
    connection.commit()
Working...