search

blastrain / rapidash

Go package for database record or other data caching
MIT License
81 stars 9 forks source link

Not working with varchar primary key #38

Open kirinse opened 4 years ago

kirinse commented 4 years ago 
    builder := rapidash.NewQueryBuilder("methods").
        Eq("code", code)
    tx.FindByQueryBuilder(builder, &method)

no rows found from db, but i am 100 percent sure there's record in database.

debug log:

{"level":"info","id":"bs5jqb3k3a68d31cfl8g","command":"get","type":"db","key":"SELECT `code`,`name`,`description`,`currency`,`type`,`amount_min`,`amount_max`,`created_at`,`updated_at`,`deleted_at` FROM `methods` WHERE `code` = ?","args":["\"CNYCC\""],"value":"[]","time":1594572076,"message":"<----get------[stash]-----[db]"}
{"level":"info","id":"bs5jqb3k3a68d31cfl8g","command":"set","type":"stash","key":"r/slc/methods/code#\"\\\"CNYCC\\\"\"","value":"nil","time":1594572076,"message":"----set------>[stash]     [server]"}
{"level":"info","id":"bs5jqb3k3a68d31cfl8g","command":"add","type":"server","key":"r/slc/methods/code#\"\\\"CNYCC\\\"\"/lock","value":"{ \"id\": bs5jqb3k3a68d31cfl8g, \"key\": r/slc/methods/code#\"\\\"CNYCC\\\"\", \"time\": 2020-07-13 00:41:16.140798 +0800 CST m=+6.040811516 }","time":1594572076,"message":"----add-------[stash]---->[server]"}
{"level":"info","id":"bs5jqb3k3a68d31cfl8g","command":"set","type":"server","key":"r/slc/methods/code#\"\\\"CNYCC\\\"\"","value":"nil","time":1594572076,"message":"----set-------[stash]---->[server]"}
{"level":"info","id":"bs5jqb3k3a68d31cfl8g","command":"delete","type":"server","key":"r/slc/methods/code#\"\\\"CNYCC\\\"\"/lock","time":1594572076,"message":"---delete-----[stash]---->[server]"}