winmain / querio Goto Github PK

Key points
Table.scala:

def _primaryKey: Option[Field[Int, Int]]
TableGenerator.scala:

 val primaryKey: Option[InnerCol] = if (primaryKeyNames.nonEmpty) {
      val pkName = primaryKeyNames.head
      val pk = columns.find(_.rs.name == pkName).getOrElse(sys.error(s"Field for primary key not found in ${table.cat}.${table.name}"))
      if (pk.shortScalaType == "Int") Some(pk) else None
    } else None

If condition1 and condition2 are Conditions, sometimes one need something like condition1 && !condition2, but ! does not supported in current version.

For example:

class MutableDbVehicle extends MutableTableRecord[DbVehicle] {
  var id: Int = _
  var extId: Int = _

  def _table = DbVehicle
  def _primaryKey: Int = id
  def _setPrimaryKey($: Int): Unit = id = $

  var updateFilter: VehUpdateFilter = _
}

In this code invoking DatabaseGenerator will ends with deleting line var updateFilter

querio ver 0.6.5

fetchOne() returns Some(null) instead of None

Current LocalDateTimeField and TimestampField both store datetime with default timezone, need field for storing UTC datetime