python sqllite自动增量仍然在插入时要求id字段

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了python sqllite自动增量仍然在插入时要求id字段，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4131字，纯文字阅读大概需要6分钟。

内容图文

我正在尝试将sqllite自动增量功能与python结合使用.从我在网上阅读的内容中,您只需要特定的ID INTEGER PRIMARY KEY AUTOINCREMENT或其他内容,然后插入并且不指定id列.但是,当我的脚本插入一个值时,它给我一个错误,它仅指定3列而不是4列,这意味着它正在寻找我指定id列,因此我对如何执行自动增量感到有些困惑.

    cur.execute("""CREATE TABLE ROOMS(ID INTEGER PRIMARY KEY AUTOINCREMENT, 
                       NAME TEXT, 
                       TAGLINE TEXT,
                       DATE DATE)""")



    cur.execute("""INSERT INTO ROOMS 
                    VALUES(?,?,?)""" , ( name, tagline, str(creation_date) ))
    conn.commit()

表ROOMS有4列,但提供了3个值

完整的代码

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Copyright [current year] the Melange authors.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
# 
#   http://www.apache.org/licenses/LICENSE-2.0
# 
# Unless required by applicable law or agreed to 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.
# See the License for the specific language governing permissions and
# limitations under the License.

from multiprocessing import Pool, Process
from datetime import datetime
import boto3
import sys
import os
import argparse
import logging
import logging.config
from bottle import route, run
from boto.cloudformation.stack import Output
import json
import socket
import sqlite3 as lite

def connect_db():
    con = None
    con = lite.connect('master.db')
    cur = con.cursor() 
    objects = []
    objects.append(con)
    objects.append(cur)
    return objects

def create_chatroom(name, tagline, cur, conn):
        #create the message room for the name of the room you are creating.
        try:
            cur.execute("""CREATE TABLE %s (ID INTEGER PRIMARY KEY AUTOINCREMENT, 
                           ROOM_ID INT, 
                           ROOM_MESSAGE TEXT, 
                           USER_ID INT,
                           DATE DATE)""" % name)
        except Exception as e:
            logger.info('%s already exist' % name)

        creation_date = datetime.now()
        #insert id,name,tagline,date
        cur.execute("""INSERT INTO ROOMS 
                        VALUES(?,?,?)""" , ( name, tagline, str(creation_date) ))
        conn.commit()
        logger.info('created room %s!' % name) 

def init_tables (conn, cur):
    try:
        cur.execute("""CREATE TABLE ROOMS(ID INTEGER PRIMARY KEY AUTOINCREMENT, 
                           NAME TEXT, 
                           TAGLINE TEXT,
                           DATE DATE)""")

        cur.execute("""CREATE TABLE USERS(ID INTEGER PRIMARY KEY AUTOINCREMENT, 
                           FIRSTNAME TEXT, 
                           LASTNAME TEXT,
                           HEADLINE TEXT,
                           PHONE TEXT,
                           EMAIL TEXT,
                           PASSWORD TEXT,
                           DATE DATE)""")

        cur.execute("""CREATE TABLE FRIENDS(ID INTEGER PRIMARY KEY AUTOINCREMENT, 
                           IDFIRST INT, 
                           IDSECOND INT,
                           DATE DATE)""")  
        conn.commit()
        logger.info('Successfully Created Tables!') 
    except:
        logger.info('Tables already exist!')    

def setup_db(logger):
    try:
        logger.info('Building Database Tables.') 
        init_db = connect_db()

        con = init_db[0]
        cur = init_db[1]
        #inital tables
        try:
            init_tables (con, cur)
        except Exception as e:
            logger.info('Tables Exist.')

        try:
            create_chatroom('Lobby', 'Insight is the future', cur, con)
        except Exception as e:
            logger.info('Lobby already exist %s ' % e)

        try:    
            cur.execute('SELECT ID FROM ROOMS WHERE NAME="Lobby"')   
            id = cur.fetchone() 
            welcome_date = datetime.datetime
            cur.execute("INSERT INTO Lobby VALUES(?,?,?,?)" , (id, 'Welcome to the Insight Lobby!', '1',str(welcome_date),))  
        except Exception as e:
            logger.info('%s' % e)

        con.commit()
        con.close()
    except Exception as e:
        logger.info(str(e))
        pass

@route('/get_chat/<name>')
def get_status( name="Get Loading Status"):
    values = name.split('&')
    room = values[0]
    init_db = connect_db()

    con = init_db[0]
    cur = init_db[1] 
    cur.execute('SELECT * FROM %s' % str(room))
    values = cur.fetchall()   
    return values


if __name__ == '__main__':
    url = os.path.dirname(os.path.realpath(__file__)) + '/logging.ini'
    logging.config.fileConfig(url)
    logger = logging.getLogger('root')    
    setup_db(logger)
    #ip_address = socket.gethostbyname(socket.gethostname())
    run(host='127.0.0.1', port=8001, debug=True)

解决方法:

该表有4列,您要插入的列少于该列.

您需要指定要插入的列：

INSERT INTO ROOMS(NAME, TAGLINE, DATE) VALUES(?,?,?)

您未插入任何内容的列将获得默认值,例如如果未指定其他默认值,则为NULL.主键列中的NULL使数据库为您生成一个ID.

或者,只需在ID列中插入一个显式NULL：

INSERT INTO ROOMS VALUES(NULL,?,?,?)

内容总结

以上是互联网集市为您收集整理的python sqllite自动增量仍然在插入时要求id字段全部内容，希望文章能够帮你解决python sqllite自动增量仍然在插入时要求id字段所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端