It turned out to be easy enough: create table mytable ( id bigint not null constraint DF_mytblid default next value for mainseq, code varchar(20) not null ) or if the table is already created: alter table mytable add constraint DF_mytblid default next value for mainseq for id (thank you Matt Strom for the correction!)
Yes, it is possible. You can override the default generator name with the @SequenceGenerator annotation. Base class @MappedSuperclass public abstract class PersistentEntity implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = “default_gen”) protected Long id = 0L; public Long getId() { return id; } public void setId(Long id) … Read more
Create a trigger: CREATE TRIGGER trg_mytable_bi BEFORE INSERT ON mytable FOR EACH ROW BEGIN DECLARE nseq INT; SELECT COALESCE(MAX(seq), 0) + 1 INTO nseq FROM mytable WHERE account = NEW.account; SET NEW.seq = nseq; END;
The following function allows the user to request that every nth element nth of a vector x either be (1) replaced with a empty character placeholder (empty = TRUE; default) or (2) omitted from the vector (empty = FALSE). Additionally, it provides the option of requesting the inverse (inverse = TRUE; not default) of the … Read more
You can use Enumerable.Range(0, 10);. Example: var seq = Enumerable.Range(0, 10); MSDN page here.
You can use Hibernate Dialect API for Database independence as follow class SequenceValueGetter { private SessionFactory sessionFactory; // For Hibernate 3 public Long getId(final String sequenceName) { final List<Long> ids = new ArrayList<Long>(1); sessionFactory.getCurrentSession().doWork(new Work() { public void execute(Connection connection) throws SQLException { DialectResolver dialectResolver = new StandardDialectResolver(); Dialect dialect = dialectResolver.resolveDialect(connection.getMetaData()); PreparedStatement preparedStatement = … Read more
You can use a generator expression: >>> l = [1, 3, 7, 2, 6, 8, 10] >>> sum(1 for i in l if i % 4 == 3) 2 or even >>> sum(i % 4 == 3 for i in l) 2 which uses the fact that True == 1 and False == 0. Alternatively, … Read more
You could just use the same Win32 API function that SQL Server uses: UuidCreateSequential and apply some bit-shifting to put the values into big-endian order. And since you want it in C#: private class NativeMethods { [DllImport(“rpcrt4.dll”, SetLastError=true)] public static extern int UuidCreateSequential(out Guid guid); } public static Guid NewSequentialID() { //Code is released into … Read more
Python 3 version of the code from the old Python documentation: >>> # Find runs of consecutive numbers using groupby. The key to the solution >>> # is differencing with a range so that consecutive numbers all appear in >>> # same group. >>> from itertools import groupby >>> from operator import itemgetter >>> data … Read more
sequenceName is the name of the sequence in the DB. This is how you specify a sequence that already exists in the DB. If you go this route, you have to specify the allocationSize which needs to be the same value that the DB sequence uses as its “auto increment”. Usage: @GeneratedValue(generator=”my_seq”) @SequenceGenerator(name=”my_seq”,sequenceName=”MY_SEQ”, allocationSize=1) If … Read more