// Move the record of the given applicant to a different column family. func (m *MembershipDB) moveRecordToTable( id, initiator, src_table, src_prefix, dst_table, dst_prefix string, ttl int32) error { var uuid cassandra.UUID var bmods map[string]map[string][]*cassandra.Mutation var now time.Time = time.Now() var member *MembershipAgreement var mutation *cassandra.Mutation = cassandra.NewMutation() var value []byte var timestamp int64 var err error uuid, err = cassandra.ParseUUID(id) if err != nil { return err } // First, retrieve the desired membership data. member, timestamp, err = m.GetMembershipRequest(id, src_table, src_prefix) if err != nil { return err } if dst_table == "membership_queue" && len(member.AgreementPdf) == 0 { return errors.New("No membership agreement scan has been uploaded") } // Fill in details concerning the approval. member.Metadata.ApproverUid = proto.String(initiator) member.Metadata.ApprovalTimestamp = proto.Uint64(uint64(now.Unix())) bmods = make(map[string]map[string][]*cassandra.Mutation) bmods[dst_prefix+string(uuid)] = make(map[string][]*cassandra.Mutation) bmods[dst_prefix+string(uuid)][dst_table] = make([]*cassandra.Mutation, 0) bmods[src_prefix+string(uuid)] = make(map[string][]*cassandra.Mutation) bmods[src_prefix+string(uuid)][src_table] = make([]*cassandra.Mutation, 0) value, err = proto.Marshal(member) if err != nil { return err } // Add the application protobuf to the membership data. bmods[dst_prefix+string(uuid)][dst_table] = append( bmods[dst_prefix+string(uuid)][dst_table], newCassandraMutationBytes("pb_data", value, &now, ttl)) // Delete the application data. mutation.Deletion = cassandra.NewDeletion() mutation.Deletion.Predicate = cassandra.NewSlicePredicate() mutation.Deletion.Predicate.ColumnNames = allColumns mutation.Deletion.Timestamp = ×tamp bmods[src_prefix+string(uuid)][src_table] = append( bmods[src_prefix+string(uuid)][src_table], mutation) return m.conn.AtomicBatchMutate(bmods, cassandra.ConsistencyLevel_QUORUM) }
func makeMutation(mmap map[string][]*cassandra.Mutation, cf, name string, value []byte, now time.Time) { var m *cassandra.Mutation = cassandra.NewMutation() var col *cassandra.Column = cassandra.NewColumn() col.Name = []byte(name) col.Value = value col.Timestamp = proto.Int64(now.UnixNano()) m.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() m.ColumnOrSupercolumn.Column = col mmap[cf] = append(mmap[cf], m) }
// Create a new mutation with the given name, value and time stamp. func newCassandraMutationBytes(name string, value []byte, now *time.Time, ttl int32) *cassandra.Mutation { var ret = cassandra.NewMutation() var col = cassandra.NewColumn() var now_long = int64(now.UnixNano()) col.Timestamp = &now_long col.Name = []byte(name) col.Value = value if ttl > 0 { col.TTL = &ttl } ret.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() ret.ColumnOrSupercolumn.Column = col return ret }
func (self *ProductEditAPI) ServeHTTP(w http.ResponseWriter, req *http.Request) { var buf *bytes.Buffer = new(bytes.Buffer) var specid string = req.PostFormValue("id") var uuid UUID var codes *Barcodes = new(Barcodes) var mmap map[string]map[string][]*cassandra.Mutation var tsprefix []byte var prod Product var mutations []*cassandra.Mutation var mutation *cassandra.Mutation var col *cassandra.Column var ire *cassandra.InvalidRequestException var ue *cassandra.UnavailableException var te *cassandra.TimedOutException var barcode string var now time.Time = time.Now() var err error var match bool numRequests.Add(1) numAPIRequests.Add(1) // Check the user is in the reqeuested scope. if !self.authenticator.IsAuthenticatedScope(req, self.scope) { numDisallowedScope.Add(1) http.Error(w, "You are not in the right group to access this resource", http.StatusForbidden) return } // Check if the product name has been specified. prod.Name = req.PostFormValue("prodname") if len(prod.Name) <= 0 { log.Print("Parsing product name: ", err) http.Error(w, "Product name empty", http.StatusNotAcceptable) return } prod.Price, err = strconv.ParseFloat(req.PostFormValue("price"), 64) if err != nil { log.Print("Parsing price: ", err) http.Error(w, "price: "+err.Error(), http.StatusNotAcceptable) return } prod.Stock, err = strconv.ParseUint(req.PostFormValue("stock"), 10, 64) if err != nil { log.Print("Parsing stock: ", err) http.Error(w, "stock: "+err.Error(), http.StatusNotAcceptable) return } // Check if the barcode has been given. If it was, it needs to be // numeric (EAN-13). If we find different types of barcodes we can // always revise this. for _, barcode = range req.PostForm["barcode"] { barcode = strings.Replace(barcode, " ", "", -1) if len(barcode) > 0 { match, err = regexp.MatchString("^[0-9]+$", barcode) if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } if match { codes.Barcode = append(codes.Barcode, barcode) } else { productEditErrors.Add("barcode-format-error", 1) http.Error(w, "Barcode should only contain numbers", http.StatusNotAcceptable) return } } } // Create column data for the product row. col = cassandra.NewColumn() col.Name = []byte("name") col.Value = []byte(prod.Name) col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) err = binary.Write(buf, binary.BigEndian, prod.Price) if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } col = cassandra.NewColumn() col.Name = []byte("price") col.Value = buf.Bytes() col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) buf = new(bytes.Buffer) err = binary.Write(buf, binary.BigEndian, prod.Stock) if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } col = cassandra.NewColumn() col.Name = []byte("stock") col.Value = buf.Bytes() col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) col = cassandra.NewColumn() col.Name = []byte("barcodes") col.Value, err = proto.Marshal(codes) if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) // If we're editing an existing product, re-use that UUID. Otherwise, // generate one. if len(specid) > 0 { uuid, err = ParseUUID(specid) } else { uuid, err = GenTimeUUID(&now) } if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } mmap = make(map[string]map[string][]*cassandra.Mutation) mmap[string(uuid)] = make(map[string][]*cassandra.Mutation) mmap[string(uuid)]["products"] = mutations // Create the entry in the products_byname index. mutations = make([]*cassandra.Mutation, 0) col = cassandra.NewColumn() col.Name = []byte("product") col.Value = uuid col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) mmap[prod.Name] = make(map[string][]*cassandra.Mutation) mmap[prod.Name]["products_byname"] = mutations // If a barcode has been given, specify it in the products_bybarcode // column. if len(barcode) > 0 { mmap[barcode] = make(map[string][]*cassandra.Mutation) mmap[barcode]["products_bybarcode"] = mutations } // Log a timeseries entry stating that the product has been present // at the time. mutations = make([]*cassandra.Mutation, 0) col = cassandra.NewColumn() col.Name = []byte("product-count") col.Value = buf.Bytes() // still the product count from above. col.Timestamp = now.Unix() mutation = cassandra.NewMutation() mutation.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mutation.ColumnOrSupercolumn.Column = col mutations = append(mutations, mutation) // Create the TS prefix: first the UUID, then the timestamp. buf = new(bytes.Buffer) err = binary.Write(buf, binary.BigEndian, now.UnixNano()) if err != nil { productEditErrors.Add(err.Error(), 1) http.Error(w, err.Error(), http.StatusInternalServerError) return } tsprefix = make([]byte, len(uuid)+buf.Len()+1) copy(tsprefix, uuid) tsprefix[len(uuid)] = ':' for i, v := range buf.Bytes() { tsprefix[len(uuid)+i+1] = v } mmap[string(tsprefix)] = make(map[string][]*cassandra.Mutation) mmap[string(tsprefix)]["product_tsdata"] = mutations // Now, write the mutations to the database. ire, ue, te, err = self.client.AtomicBatchMutate(mmap, cassandra.ConsistencyLevel_QUORUM) if ire != nil { log.Println("Invalid request: ", ire.Why) productEditErrors.Add(ire.Why, 1) return } if ue != nil { log.Println("Unavailable") productEditErrors.Add("unavailable", 1) return } if te != nil { log.Println("Request to database backend timed out") productEditErrors.Add("timeout", 1) return } if err != nil { log.Println("Generic error: ", err) productEditErrors.Add(err.Error(), 1) return } }
func main() { var cf string = "members" var config_file string var config_contents []byte var config membersys.MemberCreatorConfig var greatestUid uint64 = 1000 var now time.Time var noop, verbose bool var welcome *membersys.WelcomeMail var ld *ldap.Conn var sreq *ldap.SearchRequest var lres *ldap.SearchResult var entry *ldap.Entry var tlsconfig tls.Config var mmap map[string]map[string][]*cassandra.Mutation var db *cassandra.RetryCassandraClient var cp *cassandra.ColumnParent var pred *cassandra.SlicePredicate var kr *cassandra.KeyRange var kss []*cassandra.KeySlice var ks *cassandra.KeySlice var err error flag.StringVar(&config_file, "config", "", "Path to the member creator configuration file") flag.BoolVar(&noop, "dry-run", false, "Do a dry run") flag.BoolVar(&verbose, "verbose", false, "Whether or not to display verbose messages") flag.Parse() if len(config_file) == 0 { flag.Usage() return } config_contents, err = ioutil.ReadFile(config_file) if err != nil { log.Fatal("Unable to read ", config_file, ": ", err) } err = proto.Unmarshal(config_contents, &config) if err != nil { err = proto.UnmarshalText(string(config_contents), &config) } if err != nil { log.Fatal("Unable to parse ", config_file, ": ", err) } if config.WelcomeMailConfig != nil { welcome, err = membersys.NewWelcomeMail( config.WelcomeMailConfig) if err != nil { log.Fatal("Error creating WelcomeMail: ", err) } } tlsconfig.MinVersion = tls.VersionTLS12 tlsconfig.ServerName, _, err = net.SplitHostPort( config.LdapConfig.GetServer()) if err != nil { log.Fatal("Can't split ", config.LdapConfig.GetServer(), " into host and port: ", err) } if config.LdapConfig.CaCertificate != nil { var certData []byte certData, err = ioutil.ReadFile(config.LdapConfig.GetCaCertificate()) if err != nil { log.Fatal("Unable to read certificate from ", config.LdapConfig.GetCaCertificate(), ": ", err) } tlsconfig.RootCAs = x509.NewCertPool() tlsconfig.RootCAs.AppendCertsFromPEM(certData) } now = time.Now() if !noop { ld, err = ldap.DialTLS("tcp", config.LdapConfig.GetServer(), &tlsconfig) if err != nil { log.Fatal("Error connecting to LDAP server ", config.LdapConfig.GetServer(), ": ", err) } err = ld.Bind(config.LdapConfig.GetSuperUser()+","+ config.LdapConfig.GetBase(), config.LdapConfig.GetSuperPassword()) if err != nil { log.Fatal("Unable to bind as ", config.LdapConfig.GetSuperUser()+ ","+config.LdapConfig.GetBase(), " to ", config.LdapConfig.GetServer(), ": ", err) } defer ld.Close() sreq = ldap.NewSearchRequest( config.LdapConfig.GetBase(), ldap.ScopeWholeSubtree, ldap.NeverDerefAliases, 1000, 90, false, "(objectClass=posixAccount)", []string{"uidNumber"}, []ldap.Control{}) // Find the highest assigned UID. lres, err = ld.Search(sreq) if err != nil { log.Fatal("Unable to search for posix accounts in ", config.LdapConfig.GetBase(), ": ", err) } for _, entry = range lres.Entries { var uid string for _, uid = range entry.GetAttributeValues("uidNumber") { var uidNumber uint64 uidNumber, err = strconv.ParseUint(uid, 10, 64) if err != nil { log.Print("Error parsing \"", uid, "\" as a number: ", err) } else if uidNumber > greatestUid { greatestUid = uidNumber } } } } // Connect to Cassandra so we can get a list of records to be processed. db, err = cassandra.NewRetryCassandraClient( config.DatabaseConfig.GetDatabaseServer()) if err != nil { log.Fatal("Error connecting to Cassandra database at ", config.DatabaseConfig.GetDatabaseServer(), ": ", err) } err = db.SetKeyspace(config.DatabaseConfig.GetDatabaseName()) if err != nil { log.Fatal("Error setting keyspace: ", err) } cp = cassandra.NewColumnParent() cp.ColumnFamily = "membership_queue" pred = cassandra.NewSlicePredicate() pred.ColumnNames = [][]byte{[]byte("pb_data")} kr = cassandra.NewKeyRange() kr.StartKey = []byte("queue:") kr.EndKey = []byte("queue;") kss, err = db.GetRangeSlices(cp, pred, kr, cassandra.ConsistencyLevel_QUORUM) if err != nil { log.Fatal("Error getting range slice: ", err) } for _, ks = range kss { mmap = make(map[string]map[string][]*cassandra.Mutation) var csc *cassandra.ColumnOrSuperColumn for _, csc = range ks.Columns { var col *cassandra.Column = csc.Column var agreement membersys.MembershipAgreement var m *cassandra.Mutation if col == nil { continue } if string(col.Name) != "pb_data" { log.Print("Column selected was not as requested: ", col.Name) continue } err = proto.Unmarshal(col.Value, &agreement) if err != nil { log.Print("Unable to parse column ", col.Name, " of ", ks.Key, ": ", err) continue } if agreement.MemberData.Username != nil { var attrs *ldap.AddRequest greatestUid++ attrs = ldap.NewAddRequest("uid=" + asciiFilter(agreement.MemberData.GetUsername()) + "," + config.LdapConfig.GetNewUserSuffix() + "," + config.LdapConfig.GetBase()) attrs.Attribute("uidNumber", []string{ strconv.FormatUint(greatestUid, 10)}) attrs.Attribute("gecos", []string{ asciiFilter(agreement.MemberData.GetName())}) attrs.Attribute("shadowLastChange", []string{"11457"}) attrs.Attribute("shadowMax", []string{"9999"}) attrs.Attribute("shadowWarning", []string{"7"}) attrs.Attribute("gidNumber", []string{strconv.FormatUint( uint64(config.LdapConfig.GetNewUserGid()), 10)}) attrs.Attribute("objectClass", []string{ "account", "posixAccount", "shadowAccount", "top", }) attrs.Attribute("uid", []string{ asciiFilter(agreement.MemberData.GetUsername())}) attrs.Attribute("cn", []string{ asciiFilter(agreement.MemberData.GetUsername())}) attrs.Attribute("homeDirectory", []string{"/home/" + asciiFilter(agreement.MemberData.GetUsername())}) attrs.Attribute("loginShell", []string{ config.LdapConfig.GetNewUserShell()}) attrs.Attribute("userPassword", []string{ agreement.MemberData.GetPwhash(), }) agreement.MemberData.Id = proto.Uint64(greatestUid) if verbose { log.Print("Creating user: uid=" + agreement.MemberData.GetUsername() + "," + config.LdapConfig.GetNewUserSuffix() + "," + config.LdapConfig.GetBase()) } if !noop { var group string err = ld.Add(attrs) if err != nil { log.Print("Unable to create LDAP Account ", agreement.MemberData.GetUsername(), ": ", err) continue } for _, group = range config.LdapConfig.GetNewUserGroup() { var grpadd = ldap.NewModifyRequest("cn=" + group + ",ou=Groups," + config.LdapConfig.GetBase()) grpadd.Add("memberUid", []string{ agreement.MemberData.GetUsername()}) err = ld.Modify(grpadd) if err != nil { log.Print("Unable to add user ", agreement.MemberData.GetUsername(), " to group ", group, ": ", err) } } } } col.Value, err = proto.Marshal(&agreement) if err != nil { log.Print("Error marshalling agreement: ", err) continue } mmap["member:"+string(agreement.MemberData.GetEmail())] = make(map[string][]*cassandra.Mutation) mmap["member:"+string(agreement.MemberData.GetEmail())][cf] = make([]*cassandra.Mutation, 0) makeMutation(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "pb_data", col.Value, now) makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "name", agreement.MemberData.GetName(), now) makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "street", agreement.MemberData.GetStreet(), now) makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "city", agreement.MemberData.GetCity(), now) makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "country", agreement.MemberData.GetCountry(), now) makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "email", agreement.MemberData.GetEmail(), now) if agreement.MemberData.Phone != nil { makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "phone", agreement.MemberData.GetPhone(), now) } if agreement.MemberData.Username != nil { makeMutationString(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "username", agreement.MemberData.GetUsername(), now) } makeMutationLong(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "fee", agreement.MemberData.GetFee(), now) makeMutationBool(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "fee_yearly", agreement.MemberData.GetFeeYearly(), now) makeMutationLong(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "approval_ts", agreement.Metadata.GetApprovalTimestamp(), now) makeMutation(mmap["member:"+string(agreement.MemberData.GetEmail())], cf, "agreement_pdf", agreement.AgreementPdf, now) // Now, delete the original record. m = cassandra.NewMutation() m.Deletion = cassandra.NewDeletion() m.Deletion.Predicate = cassandra.NewSlicePredicate() m.Deletion.Predicate.ColumnNames = [][]byte{[]byte("pb_data")} m.Deletion.Timestamp = col.Timestamp mmap[string(ks.Key)] = make(map[string][]*cassandra.Mutation) mmap[string(ks.Key)]["membership_queue"] = []*cassandra.Mutation{m} // Write welcome e-mail to new member. if welcome != nil { err = welcome.SendMail(agreement.MemberData) if err != nil { log.Print("Error sending welcome e-mail to ", agreement.MemberData.GetEmail(), ": ", err) } } } // Apply all database mutations. err = db.BatchMutate(mmap, cassandra.ConsistencyLevel_QUORUM) if err != nil { log.Fatal("Error getting range slice: ", err) } } // Delete parting members. cp.ColumnFamily = "membership_dequeue" kr.StartKey = []byte("dequeue:") kr.EndKey = []byte("dequeue;") kss, err = db.GetRangeSlices(cp, pred, kr, cassandra.ConsistencyLevel_QUORUM) if err != nil { log.Fatal("Error getting range slice: ", err) } for _, ks = range kss { var csc *cassandra.ColumnOrSuperColumn mmap = make(map[string]map[string][]*cassandra.Mutation) for _, csc = range ks.Columns { var uuid cassandra.UUID var ldapuser string var col *cassandra.Column = csc.Column var agreement membersys.MembershipAgreement var attrs *ldap.ModifyRequest var m *cassandra.Mutation if col == nil { continue } if string(col.Name) != "pb_data" { log.Print("Column selected was not as requested: ", col.Name) continue } err = proto.Unmarshal(col.Value, &agreement) if err != nil { log.Print("Unable to parse column ", ks.Key, ": ", err) continue } if agreement.MemberData.Username == nil { continue } ldapuser = "******" + asciiFilter(agreement.MemberData.GetUsername()) + "," + config.LdapConfig.GetNewUserSuffix() + "," + config.LdapConfig.GetBase() if noop { log.Print("Would remove user ", ldapuser) } else { var groups []string var groups_differ bool var entry *ldap.Entry var group string sreq = ldap.NewSearchRequest( config.LdapConfig.GetBase(), ldap.ScopeWholeSubtree, ldap.NeverDerefAliases, 1000, 90, false, "(&(objectClass=posixGroup)(memberUid="+ asciiFilter(agreement.MemberData.GetUsername())+"))", []string{"cn"}, []ldap.Control{}) lres, err = ld.Search(sreq) if err != nil { log.Print("Error searching groups for user ", agreement.MemberData.GetUsername(), ": ", err) continue } for _, entry = range lres.Entries { var cn string var found bool cn = entry.GetAttributeValue("cn") if cn == "" { log.Print("No group name set for ", agreement.MemberData.GetUsername()) continue } groups = append(groups, cn) for _, group = range config.LdapConfig.GetNewUserGroup() { if cn == group { found = true } } for _, group = range config.LdapConfig.GetIgnoreUserGroup() { if cn == group { found = true } } if !found { groups_differ = true } } if groups_differ { log.Print("User is in other groups than expected: ", strings.Join(groups, ", ")) for _, group = range config.LdapConfig.GetNewUserGroup() { attrs = ldap.NewModifyRequest("cn=" + group + ",ou=Groups," + config.LdapConfig.GetBase()) attrs.Delete("memberUid", []string{ asciiFilter(agreement.MemberData.GetUsername())}) err = ld.Modify(attrs) if err != nil { log.Print("Error deleting ", agreement.MemberData.GetUsername(), " from ", group, ": ", err) } } } else { var dr = ldap.NewDelRequest(ldapuser, []ldap.Control{}) // The user appears to be only in the groups given in // the config. err = ld.Del(dr) if err != nil { log.Print("Unable to delete user ", ldapuser, ": ", err) } } } m = cassandra.NewMutation() m.Deletion = cassandra.NewDeletion() m.Deletion.Predicate = pred m.Deletion.Timestamp = col.Timestamp mmap[string(ks.Key)] = make(map[string][]*cassandra.Mutation) mmap[string(ks.Key)]["membership_dequeue"] = []*cassandra.Mutation{m} // 2 years retention. col.TTL = proto.Int32(720 * 24 * 3600) col.Timestamp = proto.Int64(now.UnixNano()) uuid = cassandra.UUIDFromBytes(ks.Key[len("dequeue:"):]) m = cassandra.NewMutation() m.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() m.ColumnOrSupercolumn.Column = col mmap["archive:"+string([]byte(uuid))] = make(map[string][]*cassandra.Mutation) mmap["archive:"+string([]byte(uuid))]["membership_archive"] = []*cassandra.Mutation{m} } // Apply all database mutations. err = db.BatchMutate(mmap, cassandra.ConsistencyLevel_QUORUM) if err != nil { log.Fatal("Error getting range slice: ", err) } } if verbose { log.Print("Greatest UID: ", greatestUid) } }
// Move a member record to the queue for getting their user account removed // (e.g. when they leave us). Set the retention to 2 years instead of just // 6 months, since they have been a member. func (m *MembershipDB) MoveMemberToTrash(id, initiator, reason string) error { var now time.Time = time.Now() var now_long uint64 = uint64(now.Unix()) var uuid cassandra.UUID var mmap map[string]map[string][]*cassandra.Mutation var member *MembershipAgreement var cp *cassandra.ColumnPath = cassandra.NewColumnPath() var cos *cassandra.ColumnOrSuperColumn var del *cassandra.Deletion = cassandra.NewDeletion() var mu *cassandra.Mutation var ts int64 var err error cp.ColumnFamily = "members" cp.Column = []byte("pb_data") uuid, err = cassandra.GenTimeUUID(&now) if err != nil { return err } cos, err = m.conn.Get( []byte(memberPrefix+id), cp, cassandra.ConsistencyLevel_QUORUM) if err != nil { return err } member = new(MembershipAgreement) err = proto.Unmarshal(cos.Column.Value, member) if err != nil { return err } del.Predicate = cassandra.NewSlicePredicate() del.Predicate.ColumnNames = allColumns del.Timestamp = cos.Column.Timestamp mu = cassandra.NewMutation() mu.Deletion = del mmap = make(map[string]map[string][]*cassandra.Mutation) mmap[memberPrefix+id] = make(map[string][]*cassandra.Mutation) mmap[memberPrefix+id]["members"] = []*cassandra.Mutation{mu} member.Metadata.GoodbyeInitiator = &initiator member.Metadata.GoodbyeTimestamp = &now_long member.Metadata.GoodbyeReason = &reason ts = now.UnixNano() cos.Column = cassandra.NewColumn() cos.Column.Name = []byte("pb_data") cos.Column.Timestamp = &ts cos.Column.Value, err = proto.Marshal(member) if err != nil { return err } mu = cassandra.NewMutation() mu.ColumnOrSupercolumn = cos mmap[dequeuePrefix+id] = make(map[string][]*cassandra.Mutation) mmap[dequeuePrefix+string([]byte(uuid))] = make(map[string][]*cassandra.Mutation) mmap[dequeuePrefix+string([]byte(uuid))]["membership_dequeue"] = []*cassandra.Mutation{mu} err = m.conn.AtomicBatchMutate( mmap, cassandra.ConsistencyLevel_QUORUM) return err }
// Update the membership fee for the given user. func (m *MembershipDB) SetMemberFee(id string, fee uint64, yearly bool) error { var now time.Time = time.Now() var mmap map[string]map[string][]*cassandra.Mutation var member *MembershipAgreement = new(MembershipAgreement) var cp *cassandra.ColumnPath = cassandra.NewColumnPath() var r *cassandra.ColumnOrSuperColumn var mu *cassandra.Mutation = cassandra.NewMutation() var ts int64 = now.UnixNano() var bdata []byte var err error cp.ColumnFamily = "members" cp.Column = []byte("pb_data") // Retrieve the protobuf with all data from Cassandra. r, err = m.conn.Get( append([]byte(memberPrefix), []byte(id)...), cp, cassandra.ConsistencyLevel_ONE) if err != nil { return err } // Decode the protobuf which was written to the column. err = proto.Unmarshal(r.Column.Value, member) if err != nil { return err } member.MemberData.Fee = &fee member.MemberData.FeeYearly = &yearly r.Column.Value, err = proto.Marshal(member) r.Column.Timestamp = &ts mmap = make(map[string]map[string][]*cassandra.Mutation) mmap[memberPrefix+id] = make(map[string][]*cassandra.Mutation) mmap[memberPrefix+id]["members"] = make([]*cassandra.Mutation, 0) mu.ColumnOrSupercolumn = cassandra.NewColumnOrSuperColumn() mu.ColumnOrSupercolumn.Column = r.Column mmap[memberPrefix+id]["members"] = append( mmap[memberPrefix+id]["members"], mu) bdata = make([]byte, 8) binary.BigEndian.PutUint64(bdata, fee) mu = newCassandraMutationBytes("fee", bdata, &now, 0) mmap[memberPrefix+id]["members"] = append( mmap[memberPrefix+id]["members"], mu) bdata = make([]byte, 1) if yearly { bdata[0] = 1 } else { bdata[0] = 0 } mu = newCassandraMutationBytes("fee_yearly", bdata, &now, 0) mmap[memberPrefix+id]["members"] = append( mmap[memberPrefix+id]["members"], mu) return m.conn.AtomicBatchMutate( mmap, cassandra.ConsistencyLevel_QUORUM) }