Adam,

I created a simple database in PostgreSQL called "foo" and used the
attached script and change log to add a new table to it.

You will need to install PostgreSQL and it's JDBC driver.

Please let me know if this works for you!


Thanks,
Bryan

On Sun, Mar 13, 2016 at 2:45 PM, Adam Wolk <adam.w...@tintagel.pl> wrote:

> On Sun, 13 Mar 2016 14:00:41 -0400
> "Bryan C. Everly" <br...@bceassociates.com> wrote:
>
> > Adam,
> >
> > Thanks for the feedback!
> >
> > I've attached a new tarball with some of the changes you recommend.
> > Unfortunately I am not upstream (this is an open source project my
> > company uses) so I have to have the patches in place.
> >
>
> That's ok. Still you can pester them to take the changes upstream ;)
>
> > Also, the WRKDIST = ${WRKDIR} part is needed because upstream named
> > their DISTNAME the way they did (with a -bin suffix on it).  Since I
> > have to declare DISTNAME that way to get it to download, if I didn't
> > remap WRKDIST, then it would be looking for a directory with a -bin
> > suffix on it in pobj.
> >
> > I am working with upstream to get them to take my manpage and if they
> > do, I'll remove it from the port in my maintenance for their next
> > release.
> >
>
> Great and thanks for fixing the section number.
>
> > Sorry about the root directory tarball.  I forgot the protocol on that
> > one.  :-)
> >
>
> That's ok.
>
> > Given all of that, what do you think of the new tarball with the
> > changes?
> >
>
>
> I like the changes and the port now 'works' on my side.
>
> First impressions are not great:
> $ liquibase --changeLogFile=1.json --url="" updateSQL
> Unexpected error running Liquibase: java.lang.RuntimeException: Cannot
> find database driver: Driver class was not specified and could not be
> determined from the url ()
>
> $ liquibase --changeLogFile=1.json
> --url="jdbc:mysql://localhost/dbname?useUnicode=true&characterEncoding=UTF-8"
> updateSQL
> Unexpected error running Liquibase: java.lang.RuntimeException: Cannot
> find database driver: com.mysql.jdbc.Driver
>
> 1.json is the content from
> http://www.liquibase.org/documentation/json_format.html
>
> Is there a way to test this port in a simple way?
>
> Regards,
> Adam
>
<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog";
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
    http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd";>

    <changeSet id="1" author="bob">
        <createTable tableName="department">
            <column name="id" type="int">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="active" type="boolean" defaultValueBoolean="true"/>
        </createTable>
    </changeSet>
</databaseChangeLog>

Attachment: migrate.sh
Description: Bourne shell script

Reply via email to