Fossil

Check-in [e983a7dc93]
Login

Check-in [e983a7dc93]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:For "fossil chat backup", when transfering content from the transfer table into the repository, be explicit about column names, as the column names might be in a different order.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: e983a7dc93296217125440af60edfe2c8f54fc43d328e490b75bcba5e8eeaba4
User & Date: drh 2022-02-18 20:32:27.987
Context
2022-02-18
20:49
Rename the "fossil chat backup" command to "fossil chat pull". ... (check-in: 8ee8f03a77 user: drh tags: trunk)
20:32
For "fossil chat backup", when transfering content from the transfer table into the repository, be explicit about column names, as the column names might be in a different order. ... (check-in: e983a7dc93 user: drh tags: trunk)
20:25
Add the "fossil chat backup" command and the "/chat-backup" webpage to support it. ... (check-in: 1827a31487 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/chat.c.
︙︙
1083
1084
1085
1086
1087
1088
1089
1090



1091
1092
1093
1094
1095
1096
1097

                             blob_size(&down), blob_size(&down), 0);
      if( rc ){
        fossil_fatal("cannot open patch database: %s", sqlite3_errmsg(g.db));
      }
      nChat = db_int(0, "SELECT count(*) FROM chatbu.chat");
      fossil_print("Got %d new records, %d bytes\n", nChat, blob_size(&down));
      db_multi_exec(
        "REPLACE INTO repository.chat SELECT * FROM chatbu.chat;"



      );
    }
  }else if( strcmp(g.argv[2],"url")==0 ){
    /* Show the URL to access chat. */
    fossil_print("%s/chat\n", zUrl);
  }else{
    fossil_fatal("no such subcommand \"%s\".  Use --help for help", g.argv[2]);








|
>
>
>








1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100

                             blob_size(&down), blob_size(&down), 0);
      if( rc ){
        fossil_fatal("cannot open patch database: %s", sqlite3_errmsg(g.db));
      }
      nChat = db_int(0, "SELECT count(*) FROM chatbu.chat");
      fossil_print("Got %d new records, %d bytes\n", nChat, blob_size(&down));
      db_multi_exec(
        "REPLACE INTO repository.chat(msgid,mtime,lmtime,xfrom,xmsg,"
                                     "fname,fmime,mdel,file)"
        " SELECT msgid,mtime,lmtime,xfrom,xmsg,fname,fmime,mdel,file"
          " FROM chatbu.chat;"
      );
    }
  }else if( strcmp(g.argv[2],"url")==0 ){
    /* Show the URL to access chat. */
    fossil_print("%s/chat\n", zUrl);
  }else{
    fossil_fatal("no such subcommand \"%s\".  Use --help for help", g.argv[2]);
︙︙