sqlrcrud.h

// Copyright (c) 1999-2018 David Muse
// See the file COPYING for more information.
 
#ifndef SQLRCRUD_H
#define SQLRCRUD_H
 
#include <sqlrelay/private/sqlrcrudincludes.h>
 
class SQLRCLIENT_DLLSPEC sqlrcrud : public mvccrud {
        public:
                sqlrcrud();
 
                ~sqlrcrud();
 
 
                void    setSqlrConnection(sqlrconnection *con);
 
                void    setSqlrCursor(sqlrcursor *cur);
 
 
                void    setTable(const char *table);
 
                void    setIdSequence(const char *idsequence);
 
                const char      *getTable();
 
                const char      *getIdSequence();
 
 
                bool    buildQueries();
 
 
                void    setPrimaryKeyColumn(const char *primarykey);
 
                void    setAutoIncrementColumn(const char *autoinc);
 
                const char      *getPrimaryKeyColumn();
 
                const char      *getAutoIncrementColumn();
 
                void    setCreateQuery(const char *createquery);
 
                void    setReadQuery(const char *readquery);
 
                void    setUpdateQuery(const char *updatequery);
 
                void    setDeleteQuery(const char *deletequery);
 
                const char      *getCreateQuery();
 
                const char      *getReadQuery();
 
                const char      *getUpdateQuery();
 
                const char      *getDeleteQuery();
 
 
                void    setReadQueryContainsPartialWhere(
                                                bool containspartial);
 
                void    setReadQueryContainsPartialOrderBy(
                                                bool containspartial);
 
                void    setUpdateQueryContainsPartialWhere(
                                                bool containspartial);
 
                void    setDeleteQueryContainsPartialWhere(
                                                bool containspartial);
 
                bool    getReadQueryContainsPartialWhere();
 
                bool    getReadQueryContainsPartialOrderBy();
 
                bool    getUpdateQueryContainsPartialWhere();
 
                bool    getDeleteQueryContainsPartialWhere();
 
 
                bool    doCreate(const char * const *columns,
                                        const char * const *values,
                                        const char * const *types);
 
                bool    doCreate(dictionary<const char *, const char *> *kvp);
 
                bool    doCreate(jsondom *j);
 
                bool    doRead(const char *criteria,
                                        const char *sort,
                                        uint64_t skip);
 
                bool    doRead(jsondom *j);
 
                bool    doUpdate(const char * const * columns,
                                        const char * const *values,
                                        const char * const *types,
                                        const char *criteria);
 
                bool    doUpdate(dictionary<const char *, const char *> *kvp,
                                                        const char *criteria);
 
                bool    doUpdate(jsondom *j);
 
                bool    doDelete(const char *criteria);
 
                bool    doDelete(jsondom *j);
 
                const char      *getErrorMessage();
 
                int64_t         getErrorCode();
 
                uint64_t        getAffectedRows();
 
                scalarcollection<uint64_t>      *getAffectedRowsScalar();
 
                listcollection<uint64_t>        *getAffectedRowsList();
 
                dictionarycollection<const char *, uint64_t>
                                        *getAffectedRowsDictionary();
 
                tablecollection<uint64_t>       *getAffectedRowsTable();
 
                scalarcollection<const char *>  *getFirstFieldScalar();
 
                listcollection<const char *>    *getFirstRowList();
 
                dictionarycollection<const char *, const char *>
                                                *getFirstRowDictionary();
 
                listcollection<const char *>    *getFirstColumnList();
 
                tablecollection<const char *>   *getResultSetTable();
 
        #include <sqlrelay/private/sqlrcrud.h>
};
 
#endif