mirror of
https://github.com/featurebasedb/featurebase.git
synced 2026-08-28 02:44:59 +00:00
468461fbcf
* Support Drop Table in serverless (include Snapshotter, Writelogger) * Finish Database methods Things like: - `Databases` - `DatabaseByID` - `DatabaseByName` - `DropDatabase` * Change Poller to use NodeService instead of its own map Instead of the Poller maintaining its own map of Addresses to poll, this commit changes the Poller to use the NodeService interface to get all known nodes from the Controller. The next commit needs to: Next, the logic in the boltdb NodeService implementation was moved to the boltdb Balancer implementation. That way, the Balancer can be the source of truth for all things nodes/workers/jobs. * Move NodeService from Controller to Balancer This commit moves the implementation of the NodeService into the Balancer, and aligns `Balancer.AddWorker` with `NodeService.CreateNode` so that they stay in sync. (Same for `Balancer.RemoveWorker` and `NodeService.DeleteNode`). * fix import of private repo * Fix go vet issues * Fix bug in DeregisterNode We need to remove the node from the NodeService even if it's not assigned to a database. The logic had a bug in it. This also adds some no-op implementations for SnapshotService and WriteloggerService. If a directory was not configured for that, then the computer node would panic on trying to read from the Snapshotter upon receiving a Directive. * queryer response content-type: json * Add support for NULL to WriteloggerDir and SnapshotterDir configs This commit changes the way WriteLoggerDir and SnapshotterDir are handled. If value is empty `""`, an error will be returned on computer startup. If value is `"NULL"`, a no-op implementation of the service will be used. This would be for a case that wanted to run serverless on-prem with no durable storage. Finally, any other value will be used as the directory to use. Some things which aren't considered here and may result in unexpected behavior: - a value with spaces `" "` - any "null" which is not "NULL"... like lowercase. * Finish the DropTable test * Change "disable service" value to case-insensitive "off" This commit also removes an unnecessary sleep in the tests. * Fix docker-compose variables for IDK test Co-authored-by: Matthew Jaffee <jaffee@pilosa.com>
112 lines
3.6 KiB
Go
112 lines
3.6 KiB
Go
package defs
|
|
|
|
import "github.com/featurebasedb/featurebase/v3/pql"
|
|
|
|
var Unkeyed TableTest = unkeyed
|
|
|
|
var unkeyed = TableTest{
|
|
name: "unkeyed",
|
|
Table: tbl(
|
|
"unkeyed",
|
|
srcHdrs(
|
|
srcHdr("_id", fldTypeID),
|
|
srcHdr("an_int", fldTypeInt, "min 0", "max 100"),
|
|
srcHdr("an_id_set", fldTypeIDSet),
|
|
srcHdr("an_id", fldTypeID),
|
|
srcHdr("a_string", fldTypeString),
|
|
srcHdr("a_string_set", fldTypeStringSet),
|
|
srcHdr("a_decimal", fldTypeDecimal2),
|
|
),
|
|
srcRows(
|
|
srcRow(int64(1), int64(11), []int64{11, 12, 13}, int64(101), "str1", []string{"a1", "b1", "c1"}, float64(123.45)),
|
|
srcRow(int64(2), int64(22), []int64{21, 22, 23}, int64(201), "str2", []string{"a2", "b2", "c2"}, float64(234.56)),
|
|
srcRow(int64(3), int64(33), []int64{31, 32, 33}, int64(301), "str3", []string{"a3", "b3", "c3"}, float64(345.67)),
|
|
srcRow(int64(4), int64(44), []int64{41, 42, 43}, int64(401), "str4", []string{"a4", "b4", "c4"}, float64(456.78)),
|
|
),
|
|
),
|
|
SQLTests: []SQLTest{
|
|
{
|
|
// Select all.
|
|
name: "select-all",
|
|
SQLs: sqls(
|
|
"select * from unkeyed",
|
|
"select _id, an_int, an_id_set, an_id, a_string, a_string_set, a_decimal from unkeyed",
|
|
),
|
|
ExpHdrs: hdrs(
|
|
hdr("_id", fldTypeID),
|
|
hdr("an_int", fldTypeInt),
|
|
hdr("an_id_set", fldTypeIDSet),
|
|
hdr("an_id", fldTypeID),
|
|
hdr("a_string", fldTypeString),
|
|
hdr("a_string_set", fldTypeStringSet),
|
|
hdr("a_decimal", fldTypeDecimal2),
|
|
),
|
|
ExpRows: rows(
|
|
row(int64(1), int64(11), []int64{11, 12, 13}, int64(101), "str1", []string{"a1", "b1", "c1"}, pql.NewDecimal(12345, 2)),
|
|
row(int64(2), int64(22), []int64{21, 22, 23}, int64(201), "str2", []string{"a2", "b2", "c2"}, pql.NewDecimal(23456, 2)),
|
|
row(int64(3), int64(33), []int64{31, 32, 33}, int64(301), "str3", []string{"a3", "b3", "c3"}, pql.NewDecimal(34567, 2)),
|
|
row(int64(4), int64(44), []int64{41, 42, 43}, int64(401), "str4", []string{"a4", "b4", "c4"}, pql.NewDecimal(45678, 2)),
|
|
),
|
|
Compare: CompareExactUnordered,
|
|
SortStringKeys: true,
|
|
},
|
|
{
|
|
// Select all with top.
|
|
name: "select-all-with-top",
|
|
SQLs: sqls(
|
|
"select top(2) * from unkeyed",
|
|
),
|
|
ExpHdrs: hdrs(
|
|
hdr("_id", fldTypeID),
|
|
hdr("an_int", fldTypeInt),
|
|
hdr("an_id_set", fldTypeIDSet),
|
|
hdr("an_id", fldTypeID),
|
|
hdr("a_string", fldTypeString),
|
|
hdr("a_string_set", fldTypeStringSet),
|
|
hdr("a_decimal", fldTypeDecimal2),
|
|
),
|
|
ExpRows: rows(
|
|
row(int64(1), int64(11), []int64{11, 12, 13}, int64(101), "str1", []string{"a1", "b1", "c1"}, pql.NewDecimal(12345, 2)),
|
|
row(int64(2), int64(22), []int64{21, 22, 23}, int64(201), "str2", []string{"a2", "b2", "c2"}, pql.NewDecimal(23456, 2)),
|
|
),
|
|
Compare: CompareExactUnordered,
|
|
SortStringKeys: true,
|
|
},
|
|
{
|
|
// Select all with where on each field.
|
|
name: "select-all-with-where",
|
|
SQLs: sqls(
|
|
"select * from unkeyed where an_int = 22",
|
|
"select * from unkeyed where a_string = 'str2'",
|
|
"select * from unkeyed where an_id = 201",
|
|
),
|
|
ExpHdrs: hdrs(
|
|
hdr("_id", fldTypeID),
|
|
hdr("an_int", fldTypeInt),
|
|
hdr("an_id_set", fldTypeIDSet),
|
|
hdr("an_id", fldTypeID),
|
|
hdr("a_string", fldTypeString),
|
|
hdr("a_string_set", fldTypeStringSet),
|
|
hdr("a_decimal", fldTypeDecimal2),
|
|
),
|
|
ExpRows: rows(
|
|
row(int64(2), int64(22), []int64{21, 22, 23}, int64(201), "str2", []string{"a2", "b2", "c2"}, pql.NewDecimal(23456, 2)),
|
|
),
|
|
Compare: CompareExactOrdered,
|
|
SortStringKeys: true,
|
|
},
|
|
},
|
|
PQLTests: []PQLTest{
|
|
{
|
|
name: "options",
|
|
Table: "unkeyed",
|
|
PQLs: []string{"Options(Count(Row(an_id_set=1)), shards=[0])"},
|
|
ExpHdrs: hdrs(
|
|
hdr("count", fldTypeID),
|
|
),
|
|
ExpRows: rows(
|
|
row(int64(0)),
|
|
),
|
|
},
|
|
},
|
|
}
|