db
db copied to clipboard
upper
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Hi, I like upper.io since it works with both SQL and mongodb databases. However, I see gopkg.in/mgo.v2 being used still for mongo, and was wondering if there are any plans...
Would someone be able to direct me to the documents or give me a definite answer for this question? I would like to build the exact SQL below: ``` Select...
I just discovered a major problem with Upper.io. When fetching data (fetchRow in fetch.go), the data is being reset before data is loaded. For structs every field in the struct...
Hello: I create several transactions per second and after that use the Collection method of the tx. that triggers the PrimaryKey() and the sql to this method every time.. Can...
Sorry for this issue guys, i made my search and did not found anything, how can i use "$addToSet" and "$each" to update a document? I've seen [this issue](https://github.com/upper/db/issues/14) but...
This is my code in below, I want to append the where cond to my rawsql is it possible? or convert statement type to selector type? thx! ```golang stat :=...
how can I make a "INSERT ... SELECT Syntax", For example: ```sql INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; ``` the doc is https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
To replicate: * Create a transaction. * Begin and Commit the transaction. Then call close. * Call exec on the transaction. You will see a stacktrace along the lines of:...
I see that work has been done to add support for the JSON type in the MySQL driver (https://github.com/upper/db/pull/406) and it would be awesome if SQLite were to have similar...
Apologies if this has been done but I could not find it anywhere but would be handy to have a mock implementation of sqlbuilder.Database - esp. one that supported When...
