首页 \ 问答 \ 在postgresql中生成自动ID(Generate auto ID in postgresql)

在postgresql中生成自动ID(Generate auto ID in postgresql)

用户表:

    ID  Name
    1   usr1
    2   usr2
    3   usr3

在上表中,ID是主键。 我的要求是在将数据插入表格时,我想只指定像INSERT INTO user VALUES('usr4')这样的名称。 执行查询后,有没有办法自动为'usr4'创建ID?

我试过串行数据类型。 为此,我们还必须指定关键字default,如INSERT INTO user VALUES(default,'usr4') 。 那么,有没有办法像INSERT INTO user VALUES('usr4') 。 注意:ID应该是唯一的。


User Table:

    ID  Name
    1   usr1
    2   usr2
    3   usr3

In the above table, ID is a primary key. My requirement is while inserting data into the table, I would like to specify only the name like INSERT INTO user VALUES('usr4'). After execute the query, Is there any way to automatically create ID for 'usr4'?

I tried with serial data type. For that also we have to specify the keyword default like INSERT INTO user VALUES(default,'usr4'). So, is there any way to do like INSERT INTO user VALUES('usr4'). NOTE: ID should be unique.


原文:https://stackoverflow.com/questions/35763115
更新时间:2024-01-12 18:01

最满意答案

您的示例应该稍微调整一下以使用QFileSystemModel

诀窍是声明checkedIndexes设置为mutable并在CFileSystemModel::data方法中更新它。

QVariant CFileSystemModel::data(const QModelIndex &index, int role) const
{
    if(role == Qt::CheckStateRole)
    {
        if (checkedIndexes.contains(index))
        {
            return checkedIndexes.contains(index) ? Qt::Checked : Qt::Unchecked;
        }
        else
        {
            int checked = Qt::Unchecked;

            QModelIndex parent = index.parent();
            while (parent.isValid())
            {
                if (checkedIndexes.contains(parent))
                {
                    checked = Qt::Checked;
                    break;
                }

                parent = parent.parent();
            }

            if (checked == Qt::Checked)
            {
                checkedIndexes.insert(parent);
            }

            return checked;
        }
    }
    else
    {
        return QFileSystemModel::data(index, role);
    }
}

在视图中打开目录节点时, QFileSystemModel开始加载新内容。 加载后,视图使用CFileSystemModel::data函数重新获取新数据,该函数检查是否检查了新节点的anchestors并返回正确的Qt::CheckStateRole值(并且还更新了checkedIndexes集)。


Your example should be tweaked a bit to use QFileSystemModel.

The trick is to declare the checkedIndexes set as mutable and update it inside the CFileSystemModel::data method.

QVariant CFileSystemModel::data(const QModelIndex &index, int role) const
{
    if(role == Qt::CheckStateRole)
    {
        if (checkedIndexes.contains(index))
        {
            return checkedIndexes.contains(index) ? Qt::Checked : Qt::Unchecked;
        }
        else
        {
            int checked = Qt::Unchecked;

            QModelIndex parent = index.parent();
            while (parent.isValid())
            {
                if (checkedIndexes.contains(parent))
                {
                    checked = Qt::Checked;
                    break;
                }

                parent = parent.parent();
            }

            if (checked == Qt::Checked)
            {
                checkedIndexes.insert(parent);
            }

            return checked;
        }
    }
    else
    {
        return QFileSystemModel::data(index, role);
    }
}

When you open a directory node in a view, QFileSystemModel starts to load new contents. After they are loaded, the view retieves new data using CFileSystemModel::data function, which checks if new nodes anchestors were checked and returns proper Qt::CheckStateRole value (and also updates the checkedIndexes set).

相关问答

更多

相关文章

更多

最新问答

更多
  • 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
  • 如何通过引用返回对象?(How is returning an object by reference possible?)
  • 矩阵如何存储在内存中?(How are matrices stored in memory?)
  • 每个请求的Java新会话?(Java New Session For Each Request?)
  • css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
  • 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
  • xcode语法颜色编码解释?(xcode syntax color coding explained?)
  • 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
  • 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
  • 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
  • 西安哪有PLC可控制编程的培训
  • 在Entity Framework中选择基类(Select base class in Entity Framework)
  • 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
  • 电脑二级VF有什么用
  • Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
  • 金华英语角.
  • 手机软件如何制作
  • 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
  • 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
  • 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
  • Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
  • 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
  • python的访问器方法有哪些
  • DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
  • 在Ruby中对组合进行排序(Sorting a combination in Ruby)
  • 网站开发的流程?
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。