sqlite driver suppor save

[lusson-luo]

1. What version of Go and system type/arch are you using?

go 1.20

2. What version of GoFrame are you using?

gf 2.4.2

3. Can this issue be re-produced with the latest release?

yes

4. What did you do?

sqilte driver don't allow to insert and replace

Save operation is not supported by sqlite driver
1. Save operation is not supported by sqlite driver
   1).  github.com/gogf/gf/contrib/drivers/sqlite/v2.(*Driver).DoInsert
        /Users/marxluo/go/src/lusson.cc/gogf/gf/contrib/drivers/sqlite/sqlite.go:183

actually, sqlite support this feature in 3.24.0（2018）https://www.sqlite.org/releaselog/3_24_0.html
so， sqilte driver should allow save method

5. What did you expect to see?

sqilte driver should allow save method

6. What did you see instead?

no

[gqcn]

@lusson-luo It's great! It then needs some contributor make the pr.

[github-actions]

Hello @lusson-luo. We like your proposal/feedback and would appreciate a contribution via a Pull Request by you or another community member. We thank you in advance for your contribution and are looking forward to reviewing it!
你好 @lusson-luo。我们喜欢您的提案/反馈，并希望您或其他社区成员通过拉取请求做出贡献。我们提前感谢您的贡献，并期待对其进行审查。

[lusson-luo]

有两个思路可以实现，1. 采用 insert or replace 方式替代 save 方法。2. 采用 insert ... CONFLICT(xxx) set xxx=xxx。
第二种方式有个问题，sqlite 需要指明冲突的键名，不能冲突就替换，目前无法知道哪些列是冲突，用不了。
第一种方式replace目前有相关，sqlite 的save直接调用 replace 也行，改动最小。
@gqcn 您看看采取那种方式比较好
insert ... CONFLICT 参考教程：https://www.sqlite.org/lang_upsert.html

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

There are two ideas to achieve this. 1. Use insert or replace method instead of save method. 2. Use insert ... CONFLICT(xxx) set xxx=xxx.
There is a problem with the second method. SQLite needs to specify the conflicting key name. If it cannot conflict, replace it. Currently, it is impossible to know which columns are conflicting and cannot be used.
The first method, replace, is currently relevant. SQLite's save can also call replace directly, with minimal changes.
@gqcn Which approach is better?
insert... CONFLICT reference tutorial: https://www.sqlite.org/lang_upsert.html