string SQLUpdateCommand :: MakeSetClause( const CSVRow & row ) const {
string sc;
for ( unsigned int i = 0; i < DataCols().size(); i++ ) {
unsigned int fi = DataCols().at( i ).mField;
if ( fi >= row.size() ) {
CSVTHROW( "Required field " << fi + 1 << " missing from input" );
}
if ( sc != "" ) {
sc += ", ";
}
string field = EmptyToNull( row[fi] );
sc += DataCols().at(i).mColName
+ " = "
+ (( DoSQLQuote( i ) && ! NoNullQuote( field ) )
? ALib::SQuote( ALib::SQLQuote( field ) )
: field );
}
return "SET " + sc;
}
string SQLCommand :: MakeWhereClause( const CSVRow & row ) const {
string wc;
for ( unsigned int i = 0; i < WhereCols().size(); i++ ) {
unsigned int wi = WhereCols().at( i ).mField;
if ( wi >= row.size() ) {
CSVTHROW( "Required field " << wi + 1 << " missing in input" );
}
if ( wc != "" ) {
wc += " AND ";
}
string field = EmptyToNull( row[wi] );
wc += WhereCols().at(i).mColName
+ (field == "NULL" ? " IS " : " = " )
+ ( (DoSQLQuote( i ) && ! NoNullQuote( field ))
? ALib::SQuote( ALib::SQLQuote( field ) )
: field );
}
return "WHERE " + wc;
}
static void DeserializePrefs(const char *prefsTxt, SerializableGlobalPrefs& globalPrefs,
FileHistory& fh, Favorites *favs)
{
BencObj *obj = BencObj::Decode(prefsTxt);
if (!obj || obj->Type() != BT_DICT)
goto Exit;
BencDict *prefs = static_cast<BencDict *>(obj);
BencDict *global = prefs->GetDict(GLOBAL_PREFS_STR);
if (!global)
goto Exit;
DeserializeStruct(gGlobalPrefInfo, dimof(gGlobalPrefInfo), &globalPrefs, global);
free(globalPrefs.prevSerialization);
globalPrefs.prevSerialization = global->Encode();
int weekDiff = GetWeekCount() - globalPrefs.openCountWeek;
globalPrefs.openCountWeek = GetWeekCount();
BencArray *fileHistory = prefs->GetArray(FILE_HISTORY_STR);
if (!fileHistory)
goto Exit;
size_t dlen = fileHistory->Length();
for (size_t i = 0; i < dlen; i++) {
BencDict *dict = fileHistory->GetDict(i);
assert(dict);
if (!dict) continue;
DisplayState *state = DeserializeDisplayState(dict, globalPrefs.globalPrefsOnly);
if (state) {
// "age" openCount statistics (cut in in half after every week)
state->openCount >>= weekDiff;
fh.Append(state);
}
}
BencArray *favsArr = prefs->GetArray(FAVS_STR);
if (!favsArr)
goto Exit;
for (size_t i = 0; i < favsArr->Length(); i += 2) {
BencString *filePathBenc = favsArr->GetString(i);
BencArray *favData = favsArr->GetArray(i+1);
if (!filePathBenc || !favData)
break;
ScopedMem<WCHAR> filePath(filePathBenc->Value());
for (size_t j = 0; j < favData->Length(); j += 2) {
// we're lenient about errors
BencInt *pageNoBenc = favData->GetInt(j);
BencString *nameBenc = favData->GetString(j + 1);
if (!pageNoBenc || !nameBenc)
break;
int pageNo = (int)pageNoBenc->Value();
ScopedMem<WCHAR> name(nameBenc->Value());
favs->AddOrReplace(filePath, pageNo, EmptyToNull(name));
}
}
Exit:
delete obj;
}
void ConnectToNetworkDrive(const string& NewDir)
{
string strRemoteName;
DriveLocalToRemoteName(DRIVE_REMOTE_NOT_CONNECTED,NewDir[0],strRemoteName);
string strUserName, strPassword;
GetStoredUserName(NewDir[0], strUserName);
NETRESOURCE netResource;
netResource.dwType = RESOURCETYPE_DISK;
netResource.lpLocalName = UNSAFE_CSTR(NewDir);
netResource.lpRemoteName = UNSAFE_CSTR(strRemoteName);
netResource.lpProvider = 0;
DWORD res = WNetAddConnection2(&netResource, nullptr, EmptyToNull(strUserName.data()), 0);
if (res == ERROR_SESSION_CREDENTIAL_CONFLICT)
res = WNetAddConnection2(&netResource, nullptr, nullptr, 0);
if (res)
{
for (;;)
{
if (!GetNameAndPassword(strRemoteName, strUserName, strPassword, nullptr, GNP_USELAST))
break;
res = WNetAddConnection2(&netResource, strPassword.data(), EmptyToNull(strUserName.data()), 0);
if (!res)
break;
Global->CatchError();
if (res != ERROR_ACCESS_DENIED && res != ERROR_INVALID_PASSWORD && res != ERROR_LOGON_FAILURE)
{
Message(MSG_WARNING, 1, MSG(MError), GetErrorString().data(), MSG(MOk));
break;
}
}
}
}
string SQLInsertCommand :: CreateValues( const CSVRow & row ) const {
string vals = "";
for ( unsigned int i = 0; i < DataCols().size(); i++ ) {
unsigned int fi = DataCols().at(i).mField;
if ( fi >= row.size() ) {
CSVTHROW( "Required field " << fi + 1 << " missing from input" );
}
if ( vals != "" ) {
vals += ", ";
}
string field = EmptyToNull( row[fi] );
vals += ( DoSQLQuote( i ) && ! NoNullQuote( field ) )
? ALib::SQuote( ALib::SQLQuote( field ) )
: field;
}
return " VALUES( " + vals + ")";
}
static void DeserializePrefs(const char *prefsTxt, SerializableGlobalPrefs& globalPrefs,
FileHistory& fh, Favorites *favs)
{
BencObj *obj = BencObj::Decode(prefsTxt);
if (!obj || obj->Type() != BT_DICT)
goto Exit;
BencDict *prefs = static_cast<BencDict *>(obj);
BencDict *global = prefs->GetDict(GLOBAL_PREFS_STR);
if (!global)
goto Exit;
Retrieve(global, TOOLBAR_VISIBLE_STR, globalPrefs.toolbarVisible);
Retrieve(global, TOC_VISIBLE_STR, globalPrefs.tocVisible);
Retrieve(global, FAV_VISIBLE_STR, globalPrefs.favVisible);
Retrieve(global, SIDEBAR_DX_STR, globalPrefs.sidebarDx);
Retrieve(global, TOC_DY_STR, globalPrefs.tocDy);
Retrieve(global, PDF_ASSOCIATE_DONT_ASK_STR, globalPrefs.pdfAssociateDontAskAgain);
Retrieve(global, PDF_ASSOCIATE_ASSOCIATE_STR, globalPrefs.pdfAssociateShouldAssociate);
Retrieve(global, ESC_TO_EXIT_STR, globalPrefs.escToExit);
Retrieve(global, USE_SYS_COLORS_STR, globalPrefs.useSysColors);
Retrieve(global, BG_COLOR_STR, globalPrefs.bgColor);
Retrieve(global, ENABLE_AUTO_UPDATE_STR, globalPrefs.enableAutoUpdate);
Retrieve(global, REMEMBER_OPENED_FILES_STR, globalPrefs.rememberOpenedFiles);
Retrieve(global, GLOBAL_PREFS_ONLY_STR, globalPrefs.globalPrefsOnly);
Retrieve(global, SHOW_RECENT_FILES_STR, globalPrefs.showStartPage);
Retrieve(global, DISPLAY_MODE_STR, globalPrefs.defaultDisplayMode);
Retrieve(global, ZOOM_VIRTUAL_STR, globalPrefs.defaultZoom);
Retrieve(global, WINDOW_STATE_STR, globalPrefs.windowState);
Retrieve(global, WINDOW_X_STR, globalPrefs.windowPos.x);
Retrieve(global, WINDOW_Y_STR, globalPrefs.windowPos.y);
Retrieve(global, WINDOW_DX_STR, globalPrefs.windowPos.dx);
Retrieve(global, WINDOW_DY_STR, globalPrefs.windowPos.dy);
Retrieve(global, INVERSE_SEARCH_COMMANDLINE, globalPrefs.inverseSearchCmdLine);
Retrieve(global, ENABLE_TEX_ENHANCEMENTS_STR, globalPrefs.enableTeXEnhancements);
Retrieve(global, VERSION_TO_SKIP_STR, globalPrefs.versionToSkip);
RetrieveRaw(global, LAST_UPDATE_STR, globalPrefs.lastUpdateTime);
const char *lang = GetRawString(global, UI_LANGUAGE_STR);
const char *langCode = trans::ValidateLanguageCode(lang);
if (langCode)
globalPrefs.currentLanguage = langCode;
Retrieve(global, FWDSEARCH_OFFSET, globalPrefs.fwdSearch.offset);
Retrieve(global, FWDSEARCH_COLOR, globalPrefs.fwdSearch.color);
Retrieve(global, FWDSEARCH_WIDTH, globalPrefs.fwdSearch.width);
Retrieve(global, FWDSEARCH_PERMANENT, globalPrefs.fwdSearch.permanent);
Retrieve(global, CBX_RIGHT2LEFT, globalPrefs.cbxR2L);
Retrieve(global, OPEN_COUNT_WEEK_STR, globalPrefs.openCountWeek);
int weekDiff = GetWeekCount() - globalPrefs.openCountWeek;
globalPrefs.openCountWeek = GetWeekCount();
BencArray *fileHistory = prefs->GetArray(FILE_HISTORY_STR);
if (!fileHistory)
goto Exit;
size_t dlen = fileHistory->Length();
for (size_t i = 0; i < dlen; i++) {
BencDict *dict = fileHistory->GetDict(i);
assert(dict);
if (!dict) continue;
DisplayState *state = DeserializeDisplayState(dict, globalPrefs.globalPrefsOnly);
if (state) {
// "age" openCount statistics (cut in in half after every week)
state->openCount >>= weekDiff;
fh.Append(state);
}
}
BencArray *favsArr = prefs->GetArray(FAVS_STR);
if (!favsArr)
goto Exit;
for (size_t i = 0; i < favsArr->Length(); i += 2) {
BencString *filePathBenc = favsArr->GetString(i);
BencArray *favData = favsArr->GetArray(i+1);
if (!filePathBenc || !favData)
break;
ScopedMem<WCHAR> filePath(filePathBenc->Value());
for (size_t j = 0; j < favData->Length(); j += 2) {
// we're lenient about errors
BencInt *pageNoBenc = favData->GetInt(j);
BencString *nameBenc = favData->GetString(j + 1);
if (!pageNoBenc || !nameBenc)
break;
int pageNo = (int)pageNoBenc->Value();
ScopedMem<WCHAR> name(nameBenc->Value());
favs->AddOrReplace(filePath, pageNo, EmptyToNull(name));
}
}
Exit:
delete obj;
}