Whats default query to set when database.generateQueries is false?

E-Solution5 years ago

Hi,

I want to use traccar with custom db schema, now i need to find default query for below

INFO: Query not provided: database.selectUsers
INFO: Query not provided: database.selectUserUsers
INFO: Query not provided: database.selectGroups
INFO: Query not provided: database.selectUserGroups
INFO: Query not provided: database.selectUserDevices
INFO: Query not provided: database.selectGeofences
INFO: Query not provided: database.selectUserGeofences
INFO: Query not provided: database.selectGroupGeofences
INFO: Query not provided: database.selectDeviceGeofences
INFO: Query not provided: database.selectCalendars
INFO: Query not provided: database.selectUserCalendars
INFO: Query not provided: database.selectMaintenances
INFO: Query not provided: database.selectUserMaintenances
INFO: Query not provided: database.selectGroupMaintenances
INFO: Query not provided: database.selectDeviceMaintenances
INFO: Query not provided: database.selectNotifications
INFO: Query not provided: database.selectUserNotifications
INFO: Query not provided: database.selectGroupNotifications
INFO: Query not provided: database.selectDeviceNotifications
INFO: Query not provided: database.selectAttributes
INFO: Query not provided: database.selectUserAttributes
INFO: Query not provided: database.selectGroupAttributes
INFO: Query not provided: database.selectDeviceAttributes
INFO: Query not provided: database.selectDrivers
INFO: Query not provided: database.selectUserDrivers
INFO: Query not provided: database.selectGroupDrivers
INFO: Query not provided: database.selectDeviceDrivers
INFO: Query not provided: database.selectCommands
INFO: Query not provided: database.selectUserCommands
INFO: Query not provided: database.selectGroupCommands
INFO: Query not provided: database.selectDeviceCommands

I already browse the source code but cannot found it,

can anyone advice where i can find the default query?

Anton Tananaev5 years ago

Queries are generated.

E-Solution5 years ago

Hi Anton,

Is that posible to overwrite all the required query through traccar.xml like below?

<entry key='database.selectGroups'>
    SELECT * FROM bf_groups;
</entry>
Anton Tananaev5 years ago

Yes, it's possible to override all queries.