go-ozzo / ozzo-dbx

A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.
MIT License
638 stars 91 forks source link

Try to add more example related to "Query Conditions" #56

Open byanjiong opened 6 years ago

byanjiong commented 6 years ago

The intro page provides limited examples on the query conditions, as a newbie, I don't really know how to use it for complex conditions...

How about adding more examples? E.g.:

// id = 100 OR id = 73
// id = 200 AND (status="publish" OR status="edit")
// id != 100 OR ( name IN("james", "robert", "mike") )

something like this will help us to construct complex conditions easily... ^_^

and possible provide some examples related to timestamp operation, e.g. less than 24 hours, more than 3 days...

I can write plain SQL statement, however, when trying to use function to wrap it, then hardly have idea how to get it done... Hoping for some (more complex and real-life) examples...

Sorry for asking a newbie question... 抱歉... :)

Thanks...