(out *strings.Builder, schemaName string, oldSequence *storepb.SequenceMetadata, sequence *storepb.SequenceMetadata)
| 1644 | } |
| 1645 | |
| 1646 | func writeAlterSequence(out *strings.Builder, schemaName string, oldSequence *storepb.SequenceMetadata, sequence *storepb.SequenceMetadata) error { |
| 1647 | if _, err := fmt.Fprintf(out, "ALTER SEQUENCE \"%s\".\"%s\"", schemaName, sequence.Name); err != nil { |
| 1648 | return err |
| 1649 | } |
| 1650 | if sequence.DataType != "" { |
| 1651 | if _, err := fmt.Fprintf(out, "\n AS %s", sequence.DataType); err != nil { |
| 1652 | return err |
| 1653 | } |
| 1654 | } |
| 1655 | if sequence.Start != "" { |
| 1656 | if _, err := fmt.Fprintf(out, "\n START WITH %s", sequence.Start); err != nil { |
| 1657 | return err |
| 1658 | } |
| 1659 | } |
| 1660 | if sequence.Increment != "" { |
| 1661 | if _, err := fmt.Fprintf(out, "\n INCREMENT BY %s", sequence.Increment); err != nil { |
| 1662 | return err |
| 1663 | } |
| 1664 | } |
| 1665 | if sequence.MinValue != "" { |
| 1666 | if _, err := fmt.Fprintf(out, "\n MINVALUE %s", sequence.MinValue); err != nil { |
| 1667 | return err |
| 1668 | } |
| 1669 | } |
| 1670 | if sequence.MaxValue != "" { |
| 1671 | if _, err := fmt.Fprintf(out, "\n MAXVALUE %s", sequence.MaxValue); err != nil { |
| 1672 | return err |
| 1673 | } |
| 1674 | } |
| 1675 | if sequence.CacheSize != "" { |
| 1676 | if _, err := fmt.Fprintf(out, "\n CACHE %s", sequence.CacheSize); err != nil { |
| 1677 | return err |
| 1678 | } |
| 1679 | } |
| 1680 | if sequence.Cycle { |
| 1681 | if _, err := out.WriteString("\n CYCLE"); err != nil { |
| 1682 | return err |
| 1683 | } |
| 1684 | } else if _, err := out.WriteString("\n NO CYCLE"); err != nil { |
| 1685 | return err |
| 1686 | } |
| 1687 | if _, err := out.WriteString(";\n\n"); err != nil { |
| 1688 | return err |
| 1689 | } |
| 1690 | if oldSequence.GetComment() != sequence.GetComment() { |
| 1691 | return writeComment(out, fmt.Sprintf("SEQUENCE \"%s\".\"%s\"", schemaName, sequence.Name), sequence.GetComment()) |
| 1692 | } |
| 1693 | return nil |
| 1694 | } |
| 1695 | |
| 1696 | func writeAlterSequenceOwnedByNone(out *strings.Builder, schemaName, sequenceName string) error { |
| 1697 | _, err := fmt.Fprintf(out, "ALTER SEQUENCE \"%s\".\"%s\" OWNED BY NONE;\n\n", schemaName, sequenceName) |
no test coverage detected