Zheng Dayu comments

Results 7 comments of


                                            Zheng Dayu

Question about using LEFT OUTER JOIN in query building

@aarondl Do you have any plan on this issue?

Insert can NOT work well when composite primary keys on MySQL

I think the AUTO_INCREMENT `id` can guarantee the uniqueness in my case. I can make the second primary key `date` without default value. e.g. ```sql CREATE TABLE `demo` ( `id`...

Insert can NOT work well when composite primary keys on MySQL

`date` is used as partition key which has to be primary/unique key.

Upsert Problem on Multiple Columns Unique Key (MySQL)

I find it is because `sqlboiler-mysql` driver does not think multiple columns unique key as unique. https://github.com/volatiletech/sqlboiler/blob/84770d21d5a1eaa3ecf93cac0eced39b3c52d078/drivers/sqlboiler-mysql/driver/mysql.go#L195-L203 @aarondl Do you have any thought?

Upsert Problem on Multiple Columns Unique Key (MySQL)

After a quick investigation, I think mysql Upsert can still use `LastInsertID()`. The problem is mentioned in #177. If insert conflict and update the existing row to its current values...

scheduler can NOT enqueue job correctly sometimes

I found it was because of an incompatible problem between `static` and `dynamic` schedules. - Previously, I use static scheduler and load the schedules from a `yaml`. It works and...

scheduler can NOT enqueue job correctly sometimes

Yes, I think so. BTW I find `resque-scheduler` consuming memory increases a lot according to the number of schedules. In my case, I have ~30 schedules after migrated to dynamic...