how do i query with the AND keyword using the sql:...
# generala
AoS
11/05/2019, 9:44 AMhow do i query with the AND keyword using the sql::selectfrom() function, all of the examples i found didn't include an AND keyword to the constraint expression
t
theopolis
11/05/2019, 1:44 PM
Are you developing an extension? If you're developing a table (in core) I would suggest against using the
SQL::SQL::SQLa
AoS
11/05/2019, 1:58 PMyes i am developing an extension, and i am trying to grab the local ip of the machine, which is rather hard when not using the sql:: apis.
AoS
11/05/2019, 1:59 PMand i would prefer not to send a dns query to google for resolving my main ip.
t
theopolis
11/05/2019, 3:12 PM
That makes sense. I don't have a good answer off the top of my head. I'd recommend investigating the implementation of
::selectAllFromselect * from interface_addressesa
AoS
11/05/2019, 5:23 PMcurrently my query looks like this
AoS
11/05/2019, 5:23 PMselect address from interface_addresses where address like '%.%' and friendly_name like '%local%' and (type='manual' or type='dhcp')
AoS
11/05/2019, 5:24 PMworks pretty well from kolide and now trying to implement it into the extension
AoS
11/05/2019, 5:25 PMwould be really glad for any insight or help on how to use SQL::SQL correctly
AoS
11/05/2019, 5:26 PMand in general if you need help with writing the core code api documentation ill be glad to help as i think it could get a slight revamp.
t
theopolis
11/05/2019, 9:55 PM
core code api documentationI agree. I think improving both the API and the documentation should be a prioritized goal for the next release. (could use help with it, as usual)
4 Views