[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-commits
Subject: playground/office/kraft
From: Klaas Freitag <freitag () suse ! de>
Date: 2006-12-31 21:14:53
Message-ID: 1167599693.853939.12316.nullmailer () svn ! kde ! org
[Download RAW message or body]
SVN commit 618278 by freitag:
fixed database creation on startup
M +5 -3 database/create_schema.sql
M +7 -7 kange.kdevelop
M +10 -1 src/kraftdb.cpp
--- trunk/playground/office/kraft/database/create_schema.sql #618277:618278
@@ -1,7 +1,7 @@
-DROP DATABASE IF EXISTS kraft;
-CREATE DATABASE kraft DEFAULT CHARACTER SET "utf8";
+# DROP DATABASE IF EXISTS kraft;
+# CREATE DATABASE kraft DEFAULT CHARACTER SET "utf8";
-use kraft;
+# use kraft;
CREATE TABLE preisArten (
@@ -225,3 +225,5 @@
INSERT INTO kraftsystem ( dbschemaversion ) VALUES ( 1 );
+# message Database created.
+
--- trunk/playground/office/kraft/kange.kdevelop #618277:618278
@@ -12,7 +12,7 @@
</keywords>
<projectdirectory>.</projectdirectory>
<absoluteprojectpath>false</absoluteprojectpath>
- <description></description>
+ <description/>
<ignoreparts>
<part>kdevsnippet</part>
<part>kdevfilelist</part>
@@ -78,11 +78,11 @@
<kdevdebugger>
<general>
<dbgshell>libtool</dbgshell>
- <programargs></programargs>
- <gdbpath></gdbpath>
- <configGdbScript></configGdbScript>
- <runShellScript></runShellScript>
- <runGdbScript></runGdbScript>
+ <programargs/>
+ <gdbpath/>
+ <configGdbScript/>
+ <runShellScript/>
+ <runGdbScript/>
<breakonloadinglibs>true</breakonloadinglibs>
<separatetty>false</separatetty>
<floatingtoolbar>false</floatingtoolbar>
@@ -139,7 +139,7 @@
<headerCompletionDelay>250</headerCompletionDelay>
</codecompletion>
<creategettersetter>
- <prefixGet></prefixGet>
+ <prefixGet/>
<prefixSet>set</prefixSet>
<prefixVariable>m_,_</prefixVariable>
<parameterName>theValue</parameterName>
--- trunk/playground/office/kraft/src/kraftdb.cpp #618277:618278
@@ -236,9 +236,18 @@
if( KMessageBox::warningYesNo( parent,
i18n( "The Kraft System Table was not found in \
database %1."
" Do you want me to rebuild the database?\n"
- "WARNING: ALL YOUR DATA WILL BE \
DESTROYED!").arg( KatalogSettings::dbFile() ), + \
"WARNING: ALL YOUR DATA WILL BE DESTROYED!") + .arg( \
KatalogSettings::dbFile() ),
i18n("Database Rebuild") ) == KMessageBox::Yes ) {
emit statusMessage( i18n( "Creating Database..." ) );
+
+ if ( m_db->tables().size() > 0 ) {
+ QString allTables = QString( "DROP TABLE %1;" ).arg( m_db->tables().join( ", " \
) ); + kdDebug() << "Erasing all tables " << allTables << endl;
+ QSqlQuery q;
+ q.exec( allTables );
+ }
+
int allCmds = 0;
int goodCmds = playSqlFile( "create_schema.sql", allCmds );
if ( goodCmds == allCmds ) {
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic