#include "stockbasissqlmanager.h"

StockBasisSqlManager::StockBasisSqlManager()
{

}


StockBasisSqlManager::~StockBasisSqlManager()
{

}

QString StockBasisSqlManager::toInsertSql(_stocksInfo stock)
{
//    insert into stock_basis (code,name,blemind2,blemind3,listdate) value ('301099.SZ','C雅创','电子元件','电子元件','2021-11-22')
//            on DUPLICATE key update name = 'Ccv雅创',blemind2='电子元件'
    QString sql = QString("insert into stock_basis (code, name, blemind2,blemind3,listdate) "
                          "value(':code', ':name', ':blemind2',':blemind3',':listdate') on DUPLICATE key "
                          "update name = ':name',blemind2=':blemind2',blemind3=':blemind3',listdate=':listdate';");
    sql.replace(":code",stock.code);
    sql.replace(":name",stock.name);
    sql.replace(":blemind2",stock.blemind2);
    sql.replace(":blemind3",stock.blemind3);
    sql.replace(":listdate",stock.listDate);
    return sql;
}

QString StockBasisSqlManager::toDeleteSql()
{
    return "";
}

QString StockBasisSqlManager::toQuerySql()
{
    return "";
}