Lines Matching refs:p
78 static void initText(DText *p){ in initText() argument
79 memset(p, 0, sizeof(*p)); in initText()
81 static void freeText(DText *p){ in freeText() argument
82 sqlite3_free(p->z); in freeText()
83 initText(p); in freeText()
94 static void appendText(DText *p, char const *zAppend, char quote){ in appendText() argument
99 len = nAppend+p->n+1; in appendText()
107 if( p->n+len>=p->nAlloc ){ in appendText()
109 p->nAlloc = p->nAlloc*2 + len + 20; in appendText()
110 zNew = sqlite3_realloc(p->z, p->nAlloc); in appendText()
112 freeText(p); in appendText()
115 p->z = zNew; in appendText()
119 char *zCsr = p->z+p->n; in appendText()
126 p->n = (int)(zCsr - p->z); in appendText()
129 memcpy(p->z+p->n, zAppend, nAppend); in appendText()
130 p->n += nAppend; in appendText()
131 p->z[p->n] = '\0'; in appendText()
178 static char **tableColumnList(DState *p, const char *zTab){ in tableColumnList() argument
191 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
238 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
263 rc = sqlite3_table_column_metadata(p->db,0,zTab,azRowid[j],0,0,0,0,0); in tableColumnList()
274 p->nErr++; in tableColumnList()
275 p->rc = SQLITE_NOMEM; in tableColumnList()
282 static void output_formatted(DState *p, const char *zFormat, ...){ in output_formatted() argument
288 p->xCallback(z, p->pArg); in output_formatted()
319 static void output_quoted_escaped_string(DState *p, const char *z){ in output_quoted_escaped_string() argument
324 output_formatted(p,"'%s'",z); in output_quoted_escaped_string()
336 p->xCallback("replace(", p->pArg); in output_quoted_escaped_string()
340 p->xCallback("replace(", p->pArg); in output_quoted_escaped_string()
343 p->xCallback("'", p->pArg); in output_quoted_escaped_string()
348 output_formatted(p, "%.*s", i, z); in output_quoted_escaped_string()
352 p->xCallback("'", p->pArg); in output_quoted_escaped_string()
360 p->xCallback(zNL, p->pArg); in output_quoted_escaped_string()
363 p->xCallback(zCR, p->pArg); in output_quoted_escaped_string()
365 p->xCallback("'", p->pArg); in output_quoted_escaped_string()
367 output_formatted(p, ",'%s',char(13))", zCR); in output_quoted_escaped_string()
370 output_formatted(p, ",'%s',char(10))", zNL); in output_quoted_escaped_string()
386 DState *p = (DState*)pArg; in dump_callback() local
396 p->xCallback("DELETE FROM sqlite_sequence;\n", p->pArg); in dump_callback()
398 p->xCallback("ANALYZE sqlite_schema;\n", p->pArg); in dump_callback()
402 if( !p->writableSchema ){ in dump_callback()
403 p->xCallback("PRAGMA writable_schema=ON;\n", p->pArg); in dump_callback()
404 p->writableSchema = 1; in dump_callback()
406 output_formatted(p, in dump_callback()
413 p->xCallback("CREATE TABLE IF NOT EXISTS ", p->pArg); in dump_callback()
414 p->xCallback(zSql+13, p->pArg); in dump_callback()
416 p->xCallback(zSql, p->pArg); in dump_callback()
418 p->xCallback(";\n", p->pArg); in dump_callback()
428 azTCol = tableColumnList(p, zTable); in dump_callback()
472 rc = sqlite3_prepare_v2(p->db, sSelect.z, -1, &pStmt, 0); in dump_callback()
474 p->nErr++; in dump_callback()
475 if( p->rc==SQLITE_OK ) p->rc = rc; in dump_callback()
478 p->xCallback(sTable.z, p->pArg); in dump_callback()
480 if( i ) p->xCallback(",", p->pArg); in dump_callback()
483 output_formatted(p, "%lld", sqlite3_column_int64(pStmt,i)); in dump_callback()
491 p->xCallback("1e999", p->pArg); in dump_callback()
493 p->xCallback("-1e999", p->pArg); in dump_callback()
495 output_formatted(p, "%!.20g", r); in dump_callback()
500 p->xCallback("NULL", p->pArg); in dump_callback()
504 output_quoted_escaped_string(p, in dump_callback()
512 p->xCallback("x'", p->pArg); in dump_callback()
518 p->xCallback(zWord, p->pArg); in dump_callback()
520 p->xCallback("'", p->pArg); in dump_callback()
525 p->xCallback(");\n", p->pArg); in dump_callback()
547 DState *p, /* Query context */ in output_sql_from_query() argument
562 p->rc = SQLITE_NOMEM; in output_sql_from_query()
563 p->nErr++; in output_sql_from_query()
566 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pSelect, 0); in output_sql_from_query()
569 output_formatted(p, "/**** ERROR: (%d) %s *****/\n", rc, in output_sql_from_query()
570 sqlite3_errmsg(p->db)); in output_sql_from_query()
571 p->nErr++; in output_sql_from_query()
578 p->xCallback(z, p->pArg); in output_sql_from_query()
580 p->xCallback(",", p->pArg); in output_sql_from_query()
581 p->xCallback((const char*)sqlite3_column_text(pSelect,i), p->pArg); in output_sql_from_query()
586 p->xCallback("\n;\n", p->pArg); in output_sql_from_query()
588 p->xCallback(";\n", p->pArg); in output_sql_from_query()
594 output_formatted(p, "/**** ERROR: (%d) %s *****/\n", rc, in output_sql_from_query()
595 sqlite3_errmsg(p->db)); in output_sql_from_query()
596 if( (rc&0xff)!=SQLITE_CORRUPT ) p->nErr++; in output_sql_from_query()
608 DState *p, in run_schema_dump_query() argument
618 sqlite3_exec(p->db, z, dump_callback, p, &zErr); in run_schema_dump_query()
621 output_formatted(p, "/****** %s ******/\n", zErr); in run_schema_dump_query()
623 p->nErr++; in run_schema_dump_query()