blocks|key|130583|text|你可以试试QUnit+for+Google+Apps+Script。它是一个用于QUnit的patch，使用API+docs将其转换为Google+Apps脚本库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|130584|您所需要的只是一个脚本项目，该项目导入一个QUnit库(例如，具有项目键MxL38OxqIK-B73jyDTvCe-OBao7QLBR4j的那个库)，并具有一个doGet函数，该函数使用URL值和您自己的设置配置QUnit，加载一个运行测试的函数，最后返回QUnit.getHtml()。下面是一个示例：|style|CODE|130585|function+doGet(+e+)+{
++QUnit.urlParams(+e.parameter+);
++QUnit.config({+title:+"Unit+tests+for+my+project"+});
++QUnit.load(+myTests+);
++return+QUnit.getHtml();
};

//+Imports+the+following+functions:
//+ok,+equal,+notEqual,+deepEqual,+notDeepEqual,+strictEqual,
//+notStrictEqual,+throws,+module,+test,+asyncTest,+expect
QUnit.helpers(this);

function+myTests()+{
++module("dummy+module");

++test("dummy+test",+1,+function()+{
++++ok(true);
++});
}|code-block|syntax|javascript|130586|然后授权脚本，保存它的一个版本，发布脚本项目("Deploy+as+web+app")，并使用浏览器转到测试URL+(“最新代码”)。您的测试将运行，结果将通过HtmlService显示。您可以单击它们来查看它们的断言，但在撰写本文时，由于Caja+issue+1688的原因，您可能无法在Firefox20和21中执行此操作。|130587|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/simula-innovation/qunit/tree/gas/gas|1|http://qunitjs.com/|2|https://github.com/simula-innovation/qunit/compare/master...gas|3|https://script.google.com/macros/library/versions/d/MxL38OxqIK-B73jyDTvCe-OBao7QLBR4j|4|https://code.google.com/p/google-caja/issues/detail?id=1688^0|5|S|0|14|5|1|1A|5|2|1I|8|3|0|10|X|0|0|3C|F|4|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]|$A|18|B|19|1|1A]|$A|1B|B|1C|1|1D]|$A|1E|B|1F|1|1G]]|C|$]]|$1|D|3|E|5|6|7|1H|8|@$A|1I|B|1J|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|1K|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1L|8|@]|9|@$A|1M|B|1N|1|1O]]|C|$]]|$1|O|3|-4|5|6|7|1P|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]|10|$5|R|S|T|C|$U|11]]|12|$5|R|S|T|C|$U|13]]]]

You can try out <a href="https://github.com/simula-innovation/qunit/tree/gas/gas" rel="noreferrer">QUnit for Google Apps Script</a>. It is a <a href="https://github.com/simula-innovation/qunit/compare/master...gas" rel="noreferrer">patch</a> for <a href="http://qunitjs.com" rel="noreferrer">QUnit</a> turned into a Google Apps Script library with <a href="https://script.google.com/macros/library/versions/d/MxL38OxqIK-B73jyDTvCe-OBao7QLBR4j" rel="noreferrer">API docs</a>.

All you need is a script project that imports a QUnit library (for example the one with the project key <code>MxL38OxqIK-B73jyDTvCe-OBao7QLBR4j</code>) and has a doGet function that configures QUnit using URL parameters and optionally also with your own settings, loads a function that runs your tests, and finally returns QUnit.getHtml(). Here is an example:

<pre class="lang-js prettyprint-override"><code>function doGet( e ) {
 QUnit.urlParams( e.parameter );
 QUnit.config({ title: "Unit tests for my project" });
 QUnit.load( myTests );
 return QUnit.getHtml();
};

// Imports the following functions:
// ok, equal, notEqual, deepEqual, notDeepEqual, strictEqual,
// notStrictEqual, throws, module, test, asyncTest, expect
QUnit.helpers(this);

function myTests() {
 module("dummy module");

 test("dummy test", 1, function() {
 ok(true);
 });
}
</code></pre>

Then authorize the script, save a version of it, publish the script project ("Deploy as web app") and go to the test URL ("latest code") with your browser. Your tests will be run and results will be displayed via HtmlService. You can single-click on them to see their assertions, but as of writing this, you will probably not be able to do so in Firefox 20 and 21 due to <a href="https://code.google.com/p/google-caja/issues/detail?id=1688" rel="noreferrer">Caja issue 1688</a>.

blocks|key|130632|text|我创建了gas-unit+(https://code.google.com/p/gas-unit/)，并且在过去的几天里花了一些时间整理示例并添加了一个HTML+runner。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|130633|我自己一直在使用它来处理电子表格，我已经取得了相当的成功。我也一直在使用Jasmine进行非GAS客户端的js工作，我真的很喜欢。我怀念在gas-unit中轻松创建spy的能力，我更喜欢BDD风格的规范编写。|130634|gas-unit对我来说是一个很好的学习练习，它确实有效，尽管在作用域和闭包方面可能有一些未被发现的问题-这是我在DOM操作之外的第一个重要的js练习。|130635|我认为在GAS中测试的未来必须是QUnit+(正如Adam建议的那样)或Jasmine的端口。我快速查看了一下到茉莉港需要做些什么，但到目前为止还找不到时间来解决它。|130636|entityMap|0|LINK|mutability|MUTABLE|url|https://code.google.com/p/gas-unit/^0|E|Z|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

I created gas-unit (<a href="https://code.google.com/p/gas-unit/" rel="nofollow">https://code.google.com/p/gas-unit/</a>) and have spent a bit of time over the last few days tidying up the examples and adding a HTML test runner.

I have been using it myself for some spreadsheet manipulation I've been doing with reasonable success. I've also been using Jasmine for non-GAS client side js work and have really enjoyed that. I miss the ability in gas-unit to easily create spys and I favour the BDD style of specification writing.

gas-unit has been a great learning exercise for me and it does work although there may be undiscovered issues with scope and closure - this is my first significant js exercise outside of DOM manipulation.

I think the future for testing in GAS has to be with a port of QUnit (as Adam suggests) or Jasmine. I had a quick look at what it would take to port Jasmine but as yet have not been able to find the time to tackle it.

blocks|key|130686|text|我刚刚为我的google+spreadsheet+add-on开发和测试编写了另一个名为GasT的测试框架。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|130687|GasT是一个适用于Google+Apps脚本的TAP兼容测试框架。它提供了一种简单的方法来验证您编写的GAS程序是否按预期运行。https://github.com/huan/gast|offset|length|130688|我的目标是得到一个简单的点击工具，比如磁带(用于javascript)或蝙蝠(用于bash)。测试套件的格式非常清晰：|130689|var+gastLibUrl+=+'https://raw.githubusercontent.com/zixia/gast/master/src/gas-tap-lib.js'
eval(UrlFetchApp.fetch(gastLibUrl).getContentText())

var+test+=+GasTap.setPrintDriver('Logger')+

function+gast()+{

++test('do+calculation+right',+function+(t)+{++++
++++var+i+=+3+%2B+4
++++t.equal(i,+7,+'I+can+calc+3+%2B+4+=+7')
++})

++test('Spreadsheet+exist',+function+(t)+{
++++var+ss+=+SpreadsheetApp.openById('1TBJpvlW3WWney4rk1yW5N9bAP8dOMkWxI97dOtco-fc')
++++t.ok(ss,+'I+can+open+spreadsheet')
++})

++test.finish()
}|code-block|syntax|javascript|130690|希望有人会喜欢它。:)|130691|这里有一个在线版本，你可以在这里看看：https://docs.google.com/spreadsheets/d/19M2DY3hunU6tDQFX5buJmZ_f3E8VFmlqAtodyC-J8Ag/edit#gid=0&vpid=A1|130692|​|130693|📷|atomic|130694|130695|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/huan/gast|1|https://docs.google.com/spreadsheets/d/19M2DY3hunU6tDQFX5buJmZ_f3E8VFmlqAtodyC-J8Ag/edit#gid=0&vpid=A1|2|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6fcbd28fa0e4319286a226ada73a1ec4.png|imageAlt^0|0|1T|S|0|0|0|0|0|J|2U|1|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|F|3|G|5|6|7|1H|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1J|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1K|8|@]|9|@$D|1L|E|1M|1|1N]]|A|$]]|$1|Q|3|R|5|6|7|1O|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1P|8|@]|9|@$D|1Q|E|1R|1|1S]]|A|$]]|$1|V|3|R|5|6|7|1T|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]|16|$5|17|10|18|A|$19|1A|1B|-4]]]]

I just wrote another testing framework named GasT for my google spreadsheet add-on development &amp; testing.

GasT is a TAP-compliant testing framework for Google Apps Script. It provides a simple way to verify that the GAS programs you write behave as expected. <a href="https://github.com/huan/gast" rel="nofollow noreferrer">https://github.com/huan/gast</a>

My goal is to get a simple tap tool like tape(for javascript) or bats(for bash). the test suite format is quite clear:

<pre><code>var gastLibUrl = 'https://raw.githubusercontent.com/zixia/gast/master/src/gas-tap-lib.js'
eval(UrlFetchApp.fetch(gastLibUrl).getContentText())

var test = GasTap.setPrintDriver('Logger') 

function gast() {

 test('do calculation right', function (t) { 
 var i = 3 + 4
 t.equal(i, 7, 'I can calc 3 + 4 = 7')
 })

 test('Spreadsheet exist', function (t) {
 var ss = SpreadsheetApp.openById('1TBJpvlW3WWney4rk1yW5N9bAP8dOMkWxI97dOtco-fc')
 t.ok(ss, 'I can open spreadsheet')
 })

 test.finish()
}
</code></pre>

Hope someone will like it. :)

there's a online version, you can go to have a look on it here: <a href="https://docs.google.com/spreadsheets/d/19M2DY3hunU6tDQFX5buJmZ_f3E8VFmlqAtodyC-J8Ag/edit#gid=0&amp;vpid=A1" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/19M2DY3hunU6tDQFX5buJmZ_f3E8VFmlqAtodyC-J8Ag/edit#gid=0&amp;vpid=A1</a>

<a href="https://i.stack.imgur.com/JWasS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JWasS.png" alt="GasT - Google Apps Script Testing-framework, Test Anything Protocol compatible"></a>

blocks|key|130717|text|查看QUnitGS2+-一个使用最新版本的QUnit+(v2.10.1)的新应用程序脚本库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|130718|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check out QUnitGS2 - a new Apps Script library using the latest version of QUnit (v2.10.1).

I'm trying to get set up with unit tests for google app scripts, and I found two projects:

<a href="https://code.google.com/p/gas-unit/" rel="noreferrer">https://code.google.com/p/gas-unit/</a>
<a href="https://code.google.com/p/gasunit/" rel="noreferrer">https://code.google.com/p/gasunit/</a>

So I'm confused which to use :-)

I just had a go with the unhyphenated gasunit, which seems to expect that the script is embedded in a spreadsheet, which I am a little unclear on how to do ... and the scripts I want to test are web based scripts rather than spreadsheet ones

I had more luck testing the hyphenated gas-unit, which managed to send me both an email output of the test and generate a results page in my google site:

<a href="https://sites.google.com/site/testappscript2/TestResults" rel="noreferrer">https://sites.google.com/site/testappscript2/TestResults</a>

so I'm going to with gas-unit for the moment, but I'd really like to see some official testing framework incorporated by Google. In particular I'd like to find some way to get these scripts to be run with some frequency to send me the results. Also I'd love to get some BDD going; see my other posts:

<a href="https://stackoverflow.com/questions/15665106/how-to-get-cucumber-capybara-mechanize-to-work-against-external-non-rails-site">How to get Cucumber/Capybara/Mechanize to work against external non-rails site</a>
<a href="https://stackoverflow.com/questions/15681615/how-to-use-capybara-has-text">how to use capybara has_text</a>

Come on Google, you famously have "Testing Rocks, Debugging Sucks" in all your bathrooms? How about better testing support for Google Apps Scripts?

how to unit test google apps scripts?

我正在尝试为google应用程序脚本设置单元测试，我发现了两个项目： 所以我不知道该用哪一个:-)我刚刚尝试了一下没有连字符的gasunit，它似乎希望脚本嵌入到电子表格中，但我有点不清楚该怎么做……我要测试的脚本是基于web的脚本，而不是电子表格脚本我更幸运地测试了带连字符的gas-unit，它成功地向我发送了测试的...

问如何对google应用程序脚本进行单元测试？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何对google应用程序脚本进行单元测试？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何对google应用程序脚本进行单元测试？
EN