1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
/***************************************************************************
** xSQLIndex.cpp $Revision: 1.6 $ - $Name: V2-18 $
** SQL Table Index Keeper
**
** Copyright (C) 1996 Joseph Croft <jcroft@unicomp.net>
**
** This library is free software; you can redistribute it and/or
** modify it under the terms of the GNU Library General Public
** License as published by the Free Software Foundation; either
** version 2 of the License, or (at your option) any later version.
**
** This library is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
** Library General Public License for more details.
**
** You should have received a copy of the GNU Library General Public
** License along with this library; if not, write to the Free
** Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**
***************************************************************************/
#include <stdio.h>
#include <stdlib.h>
#include <qstring.h>
#include <qdict.h>
#include "xSQLIndex.h"
xSQLFieldDef fields[] =
{
{sqlPlain, "indexes.tablename", "", NULL, 0},
{sqlPlain, "indexes.index", "", NULL, 0}
};
xSQLIndex::xSQLIndex() : xSQLBase(fields)
{
}
xSQLIndex::~xSQLIndex()
{
}
QString xSQLIndex::nextIndex(int database, QString &table)
{
QDict<QString> fields, data, links;
QList<QString> sort;
QString rv;
char buf[20];
int x;
links.insert("indexes.tablename", &table);
if (query(database, fields, links, sort) == TRUE)
{
data = getRow(1);
// data.toFirst();
x = strtol((const char *)*data.find("indexes.index"), NULL, 10);
if (x > 0)
{
x++;
sprintf(buf, "%d", x);
rv = buf;
data.replace("indexes.index", &rv);
update(database, data, links);
}
}
return(rv);
}
|
