-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmain.cpp
65 lines (61 loc) · 2.27 KB
/
main.cpp
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
#include <QtGui/QApplication>
#include <QtSql>
#include "GradesDatabaseManager.h"
#include "CoursesDatabaseManager.h"
#include "mainwindow.h"
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
/*QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/home/harshit/my.sqlite.db");
bool ok = db.open();
qDebug() << "Trying to connect.......\n";
if(ok)
{
/*qDebug() << "Connected !!!";
QString Query("SELECT * FROM depth_courses");
QSqlQuery query(Query, db);
query.exec();
//QSqlQuery insertQuery(QString("INSERT INTO logindetails VALUES ( 'secy' , 'secy' , 1"), db);
//insertQuery.exec();ug()<<query.size();
while( query.next() )
{
//qDebug()<<"INSIDE LOOP";
//qDebug()<<query.value(0).toInt()<<endl;
qDebug()<<query.value(0).toString();
//QString createQuery = QString("CREATE TABLE ").append(query.value(0).toString()).append(" ( rollNo char(10) NOT NULL, grade char(2) NOT NULL, year int NOT NULL, semester int NOT NULL)");
//QString createQuery = QString("CREATE TABLE table ( rollNo int )");
//QSqlQuery create_query(createQuery, db);
//create_query.exec();
}
}
/*int i;
QStringList list = db.tables();
for(i=0;i<list.count();i++)
qDebug()<<list.at(i);
qDebug()<<list.count();*/
//db.exec(Query);\
//qDebug()<<"TRYING TO GET THE COURSES";
/*CoursesDatabaseManager *dbm = CoursesDatabaseManager::Instance();
//qDebug()<<"INSTANCE CREATED";
QList<Course> list = dbm->findCourses(4);
qDebug()<<"GOT THE COURSES";
int i;
for(i=0;i<list.count();i++)
{
qDebug()<<list.at(i).getName();
}*/
//}
// GradesDatabaseManager::Instance()->enterGrade(EnterSubjectGradeQuery("cs21001", "11CS30014", "EX"));
MainWindow w;
/*QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("/home/harshit/my.sqlite.db");
bool ok = db.open();
if(ok)
{
db.exec(QString("CREATE TABLE CS30014 (rollNo String NOT NULL)"));
}*/
w.show();
//w.close();
return a.exec();
}