Revision 9335
Added by Aaron Marcuse-Kubitza almost 12 years ago
| lib/sh/db.sh | ||
|---|---|---|
| 20 | 20 |
|
| 21 | 21 |
alias mk_select='mk_table_esc |
| 22 | 22 |
declare query="$(rtrim "${query:-SELECT ${cols:-*} ${cols:+
|
| 23 |
}FROM $table_esc${filter:+
|
|
| 24 |
WHERE $filter |
|
| 25 |
}}${limit:+
|
|
| 26 |
LIMIT $limit}")"
|
|
| 23 |
}FROM $table_esc |
|
| 24 |
${filter:+WHERE $filter
|
|
| 25 |
}}${limit:+LIMIT $limit
|
|
| 26 |
}")" |
|
| 27 | 27 |
' |
| 28 | 28 |
|
| 29 | 29 |
fi # load new aliases |
Also available in: Unified diff
lib/sh/db.sh: mk_select: constructed queries: in ${var:+if_true} syntax, put the newline at the end of the if_true value instead of the beginning, so that each ${var:+if_true} expression starts at the beginning of a line