← Back to branch summary

~lintest/myrulib/trunk

« back to all changes in this revision

Viewing changes to sources/MyRuLib/FbFileReader.cpp

  • Committer: Kandrashin Denis
  • Date: 2013-08-15 21:43:04 UTC
  • Revision ID: git-v1:40071db69be9a64846c6969bd98ca4c475d3f1f9
Use original wxSQLite3 library

Show diffs side-by-side

added added

removed removed

Lines of Context:
sources/MyRuLib/FbFileReader.cpp
11
11
 
12
12
#include <wx/mimetype.h>
13
13
#include <wx/stdpaths.h>
14
 
#include <wx/wxsqlite3.h>
 
14
#include "wx/FbSQLite3.h"
15
15
 
16
16
bool FbTempEraser::sm_erase = true;
17
17
 
121
121
        FbCommonDatabase database;
122
122
        {
123
123
                wxString sql = wxT("SELECT md5sum, file_type FROM books WHERE id="); sql << id;
124
 
                wxSQLite3ResultSet result = database.ExecuteQuery(sql);
 
124
                FbSQLite3ResultSet result = database.ExecuteQuery(sql);
125
125
                if (!result.NextRow()) return;
126
126
                m_md5sum = result.GetString(0).Lower();
127
127
                m_filetype = result.GetString(1).Lower();
160
160
        wxString root = wxGetApp().GetLibPath();
161
161
        wxString sql = wxT("SELECT DISTINCT id_archive,file_name,file_path,1,id_archive*id_archive FROM books WHERE id=?1 UNION ");
162
162
        sql << wxT("SELECT DISTINCT id_archive,file_name,file_path,2,id_archive*id_archive FROM files WHERE id_book=?1 ORDER BY 4,5");
163
 
        wxSQLite3Statement stmt = database.PrepareStatement(sql);
 
163
        FbSQLite3Statement stmt = database.PrepareStatement(sql);
164
164
        stmt.Bind(1, id);
165
 
        wxSQLite3ResultSet result = stmt.ExecuteQuery();
 
165
        FbSQLite3ResultSet result = stmt.ExecuteQuery();
166
166
        while ( result.NextRow() ) {
167
167
                bool primary = result.GetInt(3) == 1;
168
168
                wxString file_name = result.GetString(1);
170
170
                if (file_name.IsEmpty()) continue;
171
171
                if (int arch = result.GetInt(0)) {
172
172
                        wxString sql = wxT("SELECT id,file_name,file_path FROM archives WHERE id="); sql << arch;
173
 
                        wxSQLite3ResultSet result = database.ExecuteQuery(sql);
 
173
                        FbSQLite3ResultSet result = database.ExecuteQuery(sql);
174
174
                        if (result.NextRow()) {
175
175
                                wxString arch_name = result.GetString(1);
176
176
                                if (primary) m_message = GetError(file_name, arch_name);
515
515
        int folder = - database.NewId(FB_NEW_DOWNLOAD);
516
516
        {
517
517
                wxString sql = wxT("UPDATE states SET download=? WHERE md5sum=?");
518
 
                wxSQLite3Statement stmt = database.PrepareStatement(sql);
 
518
                FbSQLite3Statement stmt = database.PrepareStatement(sql);
519
519
                stmt.Bind(1, folder);
520
520
                stmt.Bind(2, md5sum);
521
521
                ok = stmt.ExecuteUpdate();
522
522
        }
523
523
        if (!ok) {
524
524
                wxString sql = wxT("INSERT INTO states(download, md5sum) VALUES (?,?)");
525
 
                wxSQLite3Statement stmt = database.PrepareStatement(sql);
 
525
                FbSQLite3Statement stmt = database.PrepareStatement(sql);
526
526
                stmt.Bind(1, folder);
527
527
                stmt.Bind(2, md5sum);
528
528
                stmt.ExecuteUpdate();