7 #include <sqlrelay/private/sqlrincludes.h>
28 const char *user,
const char *password,
29 int32_t retrytime, int32_t tries);
42 void setConnectTimeout(int32_t timeoutsec,
49 void setAuthenticationTimeout(int32_t timeoutsec,
57 void setResponseTimeout(int32_t timeoutsec,
67 bool suspendSession();
75 uint16_t getConnectionPort();
83 const char *getConnectionSocket();
88 bool resumeSession(uint16_t port,
const char *socket);
98 const char *identify();
101 const char *dbVersion();
104 const char *dbHostName();
107 const char *dbIpAddress();
110 const char *serverVersion();
113 const char *clientVersion();
117 const char *bindFormat();
122 bool selectDatabase(
const char *database);
125 const char *getCurrentDatabase();
131 uint64_t getLastInsertId();
141 bool autoCommitOff();
166 const char *errorMessage();
172 int64_t errorNumber();
196 void debugPrintFunction(
int (*printfunction)
202 void setDebugFile(
const char *filename);
209 void setClientInfo(
const char *clientinfo);
212 const char *getClientInfo()
const;
214 #include <sqlrelay/private/sqlrconnection.h>
233 void setResultSetBufferSize(uint64_t rows);
238 uint64_t getResultSetBufferSize();
246 void dontGetColumnInfo();
249 void getColumnInfo();
255 void mixedCaseColumnNames();
258 void upperCaseColumnNames();
261 void lowerCaseColumnNames();
277 void cacheToFile(
const char *filename);
284 void setCacheTtl(uint32_t ttl);
288 const char *getCacheFileName();
299 bool getDatabaseList(
const char *wild);
304 bool getTableList(
const char *wild);
310 bool getColumnList(
const char *table,
const char *wild);
315 bool sendQuery(
const char *query);
320 bool sendQuery(
const char *query, uint32_t length);
324 bool sendFileQuery(
const char *path,
const char *filename);
329 void prepareQuery(
const char *query);
334 void prepareQuery(
const char *query, uint32_t length);
339 bool prepareFileQuery(
const char *path,
340 const char *filename);
345 void substitution(
const char *variable,
const char *value);
348 void substitution(
const char *variable, int64_t value);
351 void substitution(
const char *variable,
double value,
356 void substitutions(
const char **variables,
357 const char **values);
360 void substitutions(
const char **variables,
361 const int64_t *values);
364 void substitutions(
const char **variables,
365 const double *values,
366 const uint32_t *precisions,
367 const uint32_t *scales);
372 void inputBind(
const char *variable,
const char *value);
375 void inputBind(
const char *variable,
const char *value,
376 uint32_t valuelength);
379 void inputBind(
const char *variable, int64_t value);
386 void inputBind(
const char *variable,
double value,
393 void inputBind(
const char *variable,
394 int16_t year, int16_t month, int16_t day,
395 int16_t hour, int16_t minute, int16_t second,
396 int32_t microsecond,
const char *tz);
399 void inputBindBlob(
const char *variable,
404 void inputBindClob(
const char *variable,
409 void inputBinds(
const char **variables,
const char **values);
412 void inputBinds(
const char **variables,
413 const int64_t *values);
416 void inputBinds(
const char **variables,
417 const double *values,
418 const uint32_t *precisions,
419 const uint32_t *scales);
426 void defineOutputBindString(
const char *variable,
427 uint32_t bufferlength);
430 void defineOutputBindInteger(
const char *variable);
433 void defineOutputBindDouble(
const char *variable);
436 void defineOutputBindDate(
const char *variable);
439 void defineOutputBindBlob(
const char *variable);
442 void defineOutputBindClob(
const char *variable);
445 void defineOutputBindCursor(
const char *variable);
455 uint16_t countBindVariables()
const;
463 void validateBinds();
467 bool validBind(
const char *variable);
477 bool fetchFromBindCursor();
483 const char *getOutputBindString(
const char *variable);
487 int64_t getOutputBindInteger(
const char *variable);
491 double getOutputBindDouble(
const char *variable);
495 bool getOutputBindDate(
const char *variable,
502 int32_t *microsecond,
507 const char *getOutputBindBlob(
const char *variable);
511 const char *getOutputBindClob(
const char *variable);
515 uint32_t getOutputBindLength(
const char *variable);
519 sqlrcursor *getOutputBindCursor(
const char *variable);
525 bool openCachedResultSet(
const char *filename);
545 uint64_t totalRows();
554 uint64_t affectedRows();
559 uint64_t firstRowIndex();
566 bool endOfResultSet();
574 const char *errorMessage();
580 int64_t errorNumber();
587 void getNullsAsEmptyStrings();
592 void getNullsAsNulls();
597 const char *getField(uint64_t row, uint32_t col);
600 const char *getField(uint64_t row,
const char *col);
603 int64_t getFieldAsInteger(uint64_t row, uint32_t col);
606 int64_t getFieldAsInteger(uint64_t row,
const char *col);
609 double getFieldAsDouble(uint64_t row, uint32_t col);
612 double getFieldAsDouble(uint64_t row,
const char *col);
617 uint32_t getFieldLength(uint64_t row, uint32_t col);
620 uint32_t getFieldLength(uint64_t row,
const char *col);
626 const char *
const *getRow(uint64_t row);
630 uint32_t *getRowLengths(uint64_t row);
634 const char *
const *getColumnNames();
637 const char *getColumnName(uint32_t col);
640 const char *getColumnType(uint32_t col);
643 const char *getColumnType(
const char *col);
647 uint32_t getColumnLength(uint32_t col);
651 uint32_t getColumnLength(
const char *col);
659 uint32_t getColumnPrecision(uint32_t col);
667 uint32_t getColumnPrecision(
const char *col);
673 uint32_t getColumnScale(uint32_t col);
679 uint32_t getColumnScale(
const char *col);
683 bool getColumnIsNullable(uint32_t col);
687 bool getColumnIsNullable(
const char *col);
691 bool getColumnIsPrimaryKey(uint32_t col);
695 bool getColumnIsPrimaryKey(
const char *col);
699 bool getColumnIsUnique(uint32_t col);
703 bool getColumnIsUnique(
const char *col);
707 bool getColumnIsPartOfKey(uint32_t col);
711 bool getColumnIsPartOfKey(
const char *col);
715 bool getColumnIsUnsigned(uint32_t col);
719 bool getColumnIsUnsigned(
const char *col);
724 bool getColumnIsZeroFilled(uint32_t col);
729 bool getColumnIsZeroFilled(
const char *col);
734 bool getColumnIsBinary(uint32_t col);
739 bool getColumnIsBinary(
const char *col);
743 bool getColumnIsAutoIncrement(uint32_t col);
747 bool getColumnIsAutoIncrement(
const char *col);
751 uint32_t getLongest(uint32_t col);
755 uint32_t getLongest(
const char *col);
764 void suspendResultSet();
772 uint16_t getResultSetId();
777 bool resumeResultSet(uint16_t
id);
783 bool resumeCachedResultSet(uint16_t
id,
784 const char *filename);
790 void closeResultSet();
792 #include <sqlrelay/private/sqlrcursor.h>
Definition: sqlrclient.h:9
Definition: sqlrclient.h:218