• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

TypeScript sqlite.SQLiteObject类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了TypeScript中@ionic-native/sqlite.SQLiteObject的典型用法代码示例。如果您正苦于以下问题:TypeScript SQLiteObject类的具体用法?TypeScript SQLiteObject怎么用?TypeScript SQLiteObject使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



在下文中一共展示了SQLiteObject类的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的TypeScript代码示例。

示例1: resolve

 this.openDatabase().then((db: SQLiteObject) => {
   db.executeSql(query, []).then(() => {
     resolve();
   }).catch((err) => {
     reject("Error while deleting record from table!");
   })
 }).catch((err) => {
开发者ID:sqlite-sync,项目名称:SQLite-sync.com,代码行数:7,代码来源:sqlite-sync.ts


示例2: resolve

                        (connection: SQLiteObject) => {
                            connection.executeSql(sql, paramSQL).then(
                                (result) => {
                                    //console.log("===== Select tb_stepsumassure success size " + result.rows.length);
                                    responseM.size = result.rows.length;
                                    responseM.status = 0;
                                    if (result.rows.length > 0) {

                                        let objMs: Array<StepSumAssureM> = [];
                                        var len = result.rows.length;
                                        for (var index = 0; index < len; index++) {
                                            let objM: StepSumAssureM  = result.rows.item(index);
                                            objMs.push(objM);
                                        }

                                        responseM.data = objMs;
                                        resolve(responseM);
                                    }
                                    else {
                                        responseM.size = 0;
                                        responseM.status = 0;
                                        resolve(responseM);
                                    }
                                }
                                , (error) => {
                                    console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_stepsumassure error " + error.message);
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:30,代码来源:stepsumassure-service.ts


示例3: function

 this.openDatabase().then((db: SQLiteObject) => {
   db.transaction((tx: any) => {
     Object.keys(data)
       .sort()
       .forEach(function(v,i){
         if(i !== 0){
           tx.executeSql(data[v],[], function (transaction, result) {
             console.log("Creating object " + v + "...");
           }, function (transaction, error) {
             console.log("Object " + v + ": " + error.message + " (Code " + error.code + ")");
           });
         }
       });
   })
   .then((res) => {
     this.getTables().then((data) => {
       resolve(data);
     })
     .catch((err) => {
       reject("Error while getting data from table!");
     });
   })
   .catch((err) => {
     reject("Error while reinitializing subscriber!");
   });
 });
开发者ID:sqlite-sync,项目名称:SQLite-sync.com,代码行数:26,代码来源:sqlite-sync.ts


示例4: resolve

                        (connection: SQLiteObject) => {
                            connection.executeSql(sql, paramSQL).then(
                                (result) => {
                                    //console.log("===== Select tb_packagedetail success size " + result.rows.length);
                                    responseM.size = result.rows.length;
                                    responseM.status = 0;
                                    if (result.rows.length > 0) {

                                        let objMs: Array<PackageDetailM> = [];
                                        var len = result.rows.length;
                                        for (var index = 0; index < len; index++) {
                                            let objM: PackageDetailM  = result.rows.item(index);
                                           // console.log("CCCCCCCCC " + JSON.stringify(objM));
                                            objMs.push(objM);
                                        }

                                        responseM.data = objMs;
                                        responseM.size = objMs.length;
                                        resolve(responseM);
                                    }
                                    else {
                                        responseM.size = 0;
                                        responseM.status = 0;
                                        resolve(responseM);
                                    }
                                }
                                , (error) => {
                                    console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Select tb_packagedetail error " + error.message);
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:32,代码来源:package-detail-service.ts


示例5: resolve

                            (connection: SQLiteObject) => {
                                connection.executeSql(sql, paramSQL).then(
                                    (result) => {
                                        //console.log("===== SELECT Agent SUCCESS size " + result.rows.length);
                                        responseM.size = result.rows.length;
                                        responseM.status = 0;

                                        //console.log("BBBB = " + JSON.stringify(result.rows.item()));

                                        if (result.rows.length > 0) {
                                            let agents: Array<AgentModel> = [];
                                            var len = result.rows.length;
                                            for (var index = 0; index < len; index++) {
                                                agents.push(result.rows.item(index));
                                            }

                                            responseM.data = agents;
                                            resolve(responseM);
                                        }
                                        else {
                                            responseM.size = 0;
                                            responseM.status = 0;
                                            resolve(responseM);
                                        }
                                    }
                                    , (error) => {
                                        console.log("===== SELECT Agent ERROR " + error.message);
                                        reject(error);
                                    }
                                )
                            }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:31,代码来源:agent-service.ts


示例6: resolve

                        (connection: SQLiteObject) => {
                            connection.executeSql(sql, paramSQL).then(
                                (result) => {
                                    console.log("===== Select tb_riderdetail success size " + result.rows.length);
                                    responseM.size = result.rows.length;
                                    responseM.status = 0;
                                    if (result.rows.length > 0) {

                                        let riderDetailMs: Array<RiderDetailM> = [];
                                        var len = result.rows.length;
                                        for (var index = 0; index < len; index++) {
                                            let riderDetailM: RiderDetailM  = result.rows.item(index);
                                            riderDetailMs.push(riderDetailM);
                                        }

                                        responseM.data = riderDetailMs;
                                        resolve(responseM);
                                    }
                                    else {
                                        responseM.size = 0;
                                        responseM.status = 0;
                                        resolve(responseM);
                                    }
                                }
                                , (error) => {
                                    console.log("===== Select tb_riderdetail error " + error.message);
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:30,代码来源:riderdetail-service.ts


示例7: resolve

                        (connection: SQLiteObject) => {
                            connection.executeSql(sql, paramSQL).then(
                                (result) => {
                                    responseM.size = result.rows.length;
                                    responseM.status = 0;
                                    if (result.rows.length > 0) {

                                        let subDistrictMs: Array<ProvinceModel> = [];

                                        var len = result.rows.length;
                                        for (var index = 0; index < len; index++) {
                                            subDistrictMs.push(result.rows.item(index));
                                        }

                                        responseM.data = subDistrictMs;
                                        resolve(responseM);
                                    }
                                    else {
                                        responseM.size = 0;
                                        responseM.status = 0;
                                        resolve(responseM);
                                    }
                                }
                                , (error) => {
                                    console.log("===== Select tb_province error " + error.message);
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:29,代码来源:province-service.ts


示例8: KEY

                        (connection: SQLiteObject) => {
                            let sql: string = `CREATE TABLE IF NOT EXISTS ` + TB_SQLITE.tb_mcaapplications + 
                            `(
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,

                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,

                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,
                                xx TEXT, xx TEXT, xx TEXT, xx TEXT, xx TEXT,

                                PRIMARY KEY (xx)
                            );`;

                            connection.executeSql(sql, []).then(
                                (result) => {
                                    console.log("Create table " + TB_SQLITE.tb_mcaapplications + " successfully.");
                                    resolve(result);
                                }
                                , (error) => {
                                    console.log("!!!!!!!!!!!!!!!!!!!!!!!! ==> Create table " + TB_SQLITE.tb_mcaapplications + " error.");
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:33,代码来源:mcaapplications-servicel.ts


示例9: resolve

                        (connection: SQLiteObject) => {
                            connection.executeSql(sql, paramSQL).then(
                                (result) => {
                                    
                                    responseM.status = 0;
                                    if (result.rows.length > 0) {

                                        let quatationMs: Array<QuotationModel> = [];
                                        var len = result.rows.length;
                                        for (var index = 0; index < len; index++) {
                                            
                                            let quotationM: QuotationModel  = result.rows.item(index);

                                            //console.log("quotationM Select XML = " + JSON.stringify(quotationM));
                                            quatationMs.push(quotationM);
                                        }

                                        responseM.size = quatationMs.length;
                                        responseM.data = quatationMs;
                                        resolve(responseM);
                                    }
                                    else {
                                        responseM.data = [];
                                        responseM.size = 0;
                                        responseM.status = 0;
                                        resolve(responseM);
                                    }
                                }
                                , (error) => {
                                    console.log("===== Select tb_quatation error " + JSON.stringify(error));
                                    reject(error);
                                }
                            )
                        }
开发者ID:warozz,项目名称:D3VMobiz,代码行数:34,代码来源:quotation-service.ts


示例10: usuario

 this.deleteUser().then( () => {
   return db.executeSql('insert into usuario (name, email, address, neighborhood, postalCode, city, state, password, dateofbirth, _id) values (?,?,?,?,?,?,?,?,?,?)', [user.name, user.email, user.address, user.neighborhood, user.postalCode, user.city, user.state, user.password, user.dateofbirth, user._id])
   .then( data => {
     console.log(data);
   })
   .catch(error => console.log(error)); 
 });      
开发者ID:SrTristao,项目名称:avisemeapp,代码行数:7,代码来源:sqlservice.ts



注:本文中的@ionic-native/sqlite.SQLiteObject类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
TypeScript sqlite-porter.SQLitePorter类代码示例发布时间:2022-05-28
下一篇:
TypeScript sqlite.SQLite类代码示例发布时间:2022-05-28
热门推荐
热门话题
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap