too many code reviews and not enough coding :) -igor
On Thu, Jun 7, 2012 at 11:26 AM, Philip Chapman <pchap...@pcsw.us> wrote: > Too many irons in that fire, Igor? :-P > > On Thu, Jun 7, 2012 at 11:16 AM, Igor Vaynberg <igor.vaynb...@gmail.com> > wrote: >> woops, wrong dev list. disregard :) >> >> -igor >> >> On Thu, Jun 7, 2012 at 10:37 AM, Igor Vaynberg <igor.vaynb...@gmail.com> >> wrote: >>> i needed a small break from staring at diffs all day, so i finished >>> the qa spike since it required just a little more code. here is how it >>> works: >>> >>> there is a academyart/schema maven project which generates the >>> querydsl meta entities based on the current aac schema. this project >>> is built by the Build and Test bamboo build after the same build has >>> already finished running dbevo against the database schemas. the >>> artifacts are then deployed under the 1.0-SNAPSHOT version, so we >>> should always have a up-to-date version in the maven repo. this also >>> means automated tests cannot run against older branches, not sure if >>> we need that or not. >>> >>> i added the schema project as a dependency to the Selenium2/commons >>> project so all automation projects inherit it. >>> >>> i added three configuration options to test suite properties >>> (config.properties) >>> DATABASE_URL, DATABASE_USERNAME, and DATABASE_PASSWORD. these are the >>> properties that will be used when establishing a connection to the >>> database. these properties can also be overridden by >>> net.ftlines.selenium.database.url, >>> net.ftlines.selenium.database.username, and >>> net.ftlines.selenium.database.password environment variables. there >>> were two config.properties files in the Selenium2 project. one in >>> commons and one in web submodules. i did not know which one was being >>> used so i added the properties to both. >>> >>> the database properties currently point to the port-forwarded >>> database. so, in order to use them as is you have to forward the >>> database you wish to use beforehand. you can use one of the >>> port-forward-*.sh scripts in academyart folder or forward one >>> yourself. >>> >>> i created a QueryFactory junit rule which acts as a helper for >>> creating query objects that can be used to execute queries and >>> installed it in the base class for automation tests. i also added a >>> couple of example queries to CourseDashboardTest. again, remember to >>> have the database forwarded or change the properties before running >>> the test. >>> >>> the code for integration and example queries is here: >>> https://fisheye.42lines.net/changelog/aaugit?cs=a61386823b090b561f3cc7cafe4c8aa96f9c1af8 >>> >>> querydsl docs are here: >>> http://www.querydsl.com/static/querydsl/2.6.0/reference/html/index.html >>> look under the querying sql section. >>> >>> you may want to remove the example queries soon since they will break >>> the ui bamboo build for that test. also, someone needs to work with >>> ops to setup the test suite properties to connect to some database to >>> run the ui tests against. >>> >>> youre welcome >>> >>> -igor > > > > -- > Philip A. Chapman > Java Software Development > Enterprise, Web, and Desktop
