summaryrefslogtreecommitdiffstats
path: root/database/sqlite/fieldmapping.h
Commit message (Collapse)AuthorAgeFilesLines
* SQLite3 eurephiadm fix: sorting lastlog based on session status didn't workDavid Sommerseth2010-11-261-1/+1
| | | | | | | | | | The eDBadminGetLastlog(...) function didn't parse the sortkeys string to match the database layout. In addition the field mapping for the openvpn_lastlog.sessionstatus field was wrong. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net> (cherry picked from commit 5581ba10af35b94e750596312a9782255084aaeb)
* Updated Copyright dates to include 2010David Sommerseth2010-05-251-1/+1
|
* Define certificate digests as ft_STRING_LOWERDavid Sommerseth2009-11-121-31/+31
| | | | This means this field will always be processed with lower case
* More doxygen comments in the sqlite3 driverDavid Sommerseth2009-09-111-0/+11
|
* sqlite3 driver: Implemented eDBadminBlacklist(...) function for blacklist ↵David Sommerseth2009-05-091-0/+12
| | | | management
* Fixed wrong database field name mapping for SQLite3David Sommerseth2009-05-071-1/+1
|
* Corrected the default filter setup and added the 'digest' fieldDavid Sommerseth2009-05-061-6/+7
|
* sqlite3 driver: Implemented listing of openvpn_attempts tableDavid Sommerseth2009-04-091-0/+12
|
* Added eDBfieldMapping field for filter typesDavid Sommerseth2009-04-051-49/+49
| | | | | | | | | | | | | | | | | | | This field will be used to determine what kind of filter logic to add when building SQL queries. The filter type is set in the fieldMapping field nodes as an attribute named 'filter'. Their values and the corresponding SQL conditions are: filter | SQL condition -----------------------+--------------- equals | = not-equals | != / NOT(...) less-than | < less-than-equals | <= greater-than | > greater-than-equals | >= -----------------------+--------------- The default value for each field is set in the eurephiadb_mapping.h
* Cleaned up some compiler warnings in edb-sqliteDavid Sommerseth2009-03-301-0/+12
|
* Added fieldMapping for the firewall access table (openvpn_accesses)David Sommerseth2009-03-281-0/+15
|
* Made the licence explicit GPLv2 onlyDavid Sommerseth2009-03-261-1/+1
|
* Cleaned up the code a little bitDavid Sommerseth2009-03-261-1/+2
| | | | | Made sure we only include needed include files and checked that the copyright headers are equal and correct
* Implemented the eDBadminGetLastLog(...) function in the SQLite3 driverDavid Sommerseth2009-03-241-0/+15
|
* Added support for editing the eurephia_adminaccess tableDavid Sommerseth2009-03-221-0/+7
| | | | Implemented eDBadminEditAdminAccess(...) function in db driver
* Added field mapping for the openvpn_usercerts tableDavid Sommerseth2008-12-251-0/+9
|
* Added field mapping for the certificates tableDavid Sommerseth2008-12-201-0/+11
|
* Enhanced table/field mapping and eDBmkMapping_USERINFO(...) to include ↵David Sommerseth2008-12-111-7/+7
| | | | possibility for table aliases
* Update field mapping to include data type. Improved ↵David Sommerseth2008-12-081-7/+7
| | | | | | | | | | | | | | sqlite_query_mapped(...) function The new sqlite_query_mapped(...) function will now consider the field type when formatting the data values for SQLite. In addition reserved words on the DATETIME data type will be preserved without quote encapsulation. Improved the sqlite_query_mapped(...) to also handle UPDATE, INSERT and DELETE in addition to SELECT. The function now needs two eDBfieldMap mappings. The first one will contain update/insert values, while the last one defines search criteria.
* Moved over from earlier commit to use unified db translationDavid Sommerseth2008-12-061-7/+8
| | | | | | | In other words, rewrote commit 6d4373e026b3f12c5685e45e35f9f060379ed0f3. Moved over all functions from that commit which could take advantage of the new API for unified table/field translation.
* Added sorting in db driver in eDBadminGetUserList(...). Improved comments.David Sommerseth2008-12-061-0/+34
generated by cgit (git 2.34.1) at 2025-09-03 11:32:37 +0000