QVector<CarInfo_tb> DBService::getAllCarInfo_tb()
{
QVector<CarInfo_tb> carInfos;
if(!database.open())
{
qDebug()<<database.lastError();
return QVector<CarInfo_tb>();
}
else
{
QString select_sql("select slm1,slm2,car_name from tb_car_info;");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
CarInfo_tb carInfo;
carInfo.slm1 = sql_query.value(0).toString();
carInfo.slm2 = sql_query.value(1).toString();
carInfo.carName = sql_query.value(2).toString();
carInfo.isValid = true;
carInfos.append(carInfo);
}
}
}
database.close();
return carInfos;
}
CarInfo_tb DBService::getCarInfo_tb(const QString& carName)
{
CarInfo_tb carInfo;
if(!database.open())
{
qDebug()<<database.lastError();
carInfo.isValid = false;
return carInfo;
}
else
{
QString select_sql("select slm1,slm2 from tb_car_info where car_name=?");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
sql_query.addBindValue(carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
carInfo.carName = carName;
carInfo.slm1 = sql_query.value(0).toString();
carInfo.slm2 = sql_query.value(1).toString();
carInfo.isValid = true;
break;
}
}
}
database.close();
return carInfo;
}
int SqliteDao::init(const char* data_file)
{
int ret = 0;
bool flag = false;
if (!is_init_)
{
ret = sqlite3_open(data_file, &sqlite_);
data_base_ = sqlite_;
if (SQLITE_OK != ret)
{
COM_WRITELOG(COMLOG_WARNING, "sqlite open failed error [%s]", sqlite3_errmsg(sqlite_));
}
else
{
int row_num = 0;
db_mm::SchemaManager* schema_manager = table_manager_->get_schema_manager();
int table_num = schema_manager->get_table_num();
for (int i = 0; i < table_num; i++)
{
db_mm::TableIndex* table_index = table_manager_->get_table_index(i);
db_mm::TableSchema* table_schema = schema_manager->get_table_schema(i);
if (0 != (ret = select_sql(table_schema)))
{
COM_WRITELOG(COMLOG_WARNING, "in sqlite_dao, sql err,sql[%s], ret[%d]", sql_, ret);
break;
}
else if (0 != (ret = get_data(table_schema, row_num)))
{
COM_WRITELOG(COMLOG_WARNING, "in sqlite_dao get_data error, ret[%d]", ret);
//如果表不存在，继续
ret = 0;
continue;
}
else
{
flag = true;
table_index->set_row_num(row_num);
}
}
}
is_init_ = true;
}
if (!flag)
{
ret = -1;
}
return ret;
}
int main(int argc, char* argv[])
{
if(argc <2) {
printf("select [select/insert]\n");
exit(1);
}
if(0 == strcmp(argv[1], "select")){
printf("execute select sql\n");
select_sql();
}
else if(0 == strcmp(argv[1], "stores")){
printf("execute stores\n");
stores_sql();
}
else if(0 == strcmp(argv[1], "insert")){
printf("execute insert the number is %d\n", atoi(argv[2]));
insert_sql(atoi(argv[2]));
}
return 0;
}
QVector<CarNuMap_tb> DBService::getAllCarNuMap_tb()
{
QVector<CarNuMap_tb> carNuMaps;
if(!database.open())
{
qDebug()<<database.lastError();
return QVector<CarNuMap_tb>();
}
else
{
QString select_sql("select car_nu_l,car_nu_g,car_name from tb_car_nu_map;");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
CarNuMap_tb carNuMap;
carNuMap.car_nu_l = sql_query.value(0).toInt();
carNuMap.car_nu_g = sql_query.value(1).toInt();
carNuMap.carName = sql_query.value(2).toString();
carNuMap.isValid = true;
carNuMaps.append(carNuMap);
}
}
}
database.close();
return carNuMaps;
}
CarNuMap_tb DBService::getCarNuMap_tb(const QString& carName)
{
CarNuMap_tb carNuMap;
if(!database.open())
{
qDebug()<<database.lastError();
carNuMap.isValid = false;
return carNuMap;
}
else
{
QString select_sql("select car_nu_l,car_nu_g from tb_car_nu_map where car_name=?");
QSqlQuery sql_query(database);
sql_query.prepare(select_sql);
sql_query.addBindValue(carName);
if(!sql_query.exec())
{
qDebug()<<sql_query.lastError();
}
else
{
while(sql_query.next())
{
carNuMap.carName = carName;
carNuMap.car_nu_l = sql_query.value(0).toInt();
carNuMap.car_nu_g = sql_query.value(1).toInt();
carNuMap.isValid = true;
break;
}
}
}
database.close();
return carNuMap;
}
