ruby on rails - How to create record in console - ROLLBACK TO SAVEPOINT active_record_1? -


i'm new rails , not sure error here when trying create cost code:

[21] pry(main)> costcode => costcode(id: integer, biller_type: text, biller_id: integer, position: integer, parent_id: integer, code: text, name: text, updated_at: datetime, long_name_helper: text, deleted_at: datetime, sortable_code: text, created_at: datetime, standard_cost_code_id: integer)  [22] pry(main)> costcode.create(code: '87678', name: "hex")    (0.3ms)  savepoint active_record_1    (0.2ms)            set local procore.user_id='';           set local procore.company_id='';           set local procore.project_id='';    costcode exists (0.4ms)  select  1 one "cost_codes" ("cost_codes"."code" = '87678' , "cost_codes"."biller_type" null , "cost_codes"."biller_id" null , "cost_codes"."parent_id" null , "cost_codes"."deleted_at" null) limit 1    (0.2ms)  rollback savepoint active_record_1 => #<costcode:0x007ff4cd938ec8  id: nil,  biller_type: nil,  biller_id: nil,  position: nil,  parent_id: nil,  code: "87678",  name: "hex",  updated_at: nil,  long_name_helper: nil,  deleted_at: nil,  sortable_code: nil,  created_at: nil,  standard_cost_code_id: nil> [23] pry(main)>

how come record not save , error message alone provide enough detail know missing? or there else should looking model?

here code costcode model: 

    # table name: cost_codes     #     #  id                    :integer          not null, primary key     #  biller_type           :text     #  biller_id             :integer     #  position              :integer     #  parent_id             :integer     #  code                  :text     #  name                  :text     #  updated_at            :datetime     #  long_name_helper      :text     #  deleted_at            :datetime     #  sortable_code         :text     #  created_at            :datetime         not null     #  standard_cost_code_id :integer     #     # indexes     #     #  cost_codes_parent_id_index                     (parent_id)     #  idx_cost_codes_on_code_biller_null_parent      (code,biller_type,biller_id) unique     #  idx_cost_codes_on_code_biller_parent           (code,biller_type,biller_id,parent_id) unique     #  idxcost_codes_biller_id                        (biller_id)     #  index_cost_codes_on_biller_id_and_biller_type  (biller_id,biller_type)     #  index_cost_codes_on_standard_cost_code_id      (standard_cost_code_id)     #      class costcode < activerecord::base       class existingcostcodesforholder < standarderror       end        default_cost_codes = yaml.load_file(rails.root.join('config', 'cost_codes_17_division.yml'))        acts_as_procore_relatable       acts_as_tree # really, it's pro_tree       acts_as_paranoid        include changeeventcostcodescaching       include externaldatasupport       include replicasupport        origin_id_unique_within { |cost_code| ['company_id', cost_code.company.id] }        belongs_to :biller, :polymorphic => true       belongs_to :standard_cost_code       has_one    :erp_cost_code, class_name: "erp::costcode", foreign_key: :procore_cost_code_id, dependent: :destroy       has_many   :erp_sync_errors, class_name: 'erp::syncerror', as: :sync_item, dependent: :destroy       has_one    :erp_standard_cost_code, through: :standard_cost_code       has_many   :potential_change_orders       has_many   :quantity_logs       has_many   :generic_tool_items       has_many   :meeting_topics       has_many   :timecard_entries       has_many   :budget_forecast_modifications       has_many   :budget_line_items, :dependent => :restrict_with_error       has_many   :line_items, dependent: :restrict_with_error       has_one    :bid_item

when creating records, have make sure provide foreign keys passes validations.

in case:

you have 2 foreign key constraints:

belongs_to :biller, :polymorphic => true belongs_to :standard_cost_code

along database-level validations:

idx_cost_codes_on_code_biller_null_parent      (code,biller_type,biller_id) unique idx_cost_codes_on_code_biller_parent           (code,biller_type,biller_id,parent_id) unique

so have write create record:

costcode.create(biller: <biller instance>, standard_cost_code: <standardcostcode instance>, code: '87678', name: "hex")

make sure biller , standardcostcode persist.


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer
Read more

jquery - Responsive Navbar with Sub Navbar -

good day, forgive me nav vocabulary not best. if question confusing apologize. i'm working on navigation bar needs centered on page @ 768px , above. items in nav open (or perhaps toggle) subnav lives directly below. these nav should appear centered on page. i have been able work through responsive portion of nav bar, having main items align vertically , sub nav menu of each item roll out below, , gave them indent separation. working well. however, issue not responsive side, behavior @ width greater 768px. happens toggling menu's sub navigation pushes other main items down page below sub nav. here's code: $(document).ready(function () { //stick in fixed 100% height behind navbar don't wrap $('#slide-nav.navbar-inverse').after($('<div class="inverse" id="navbar-height-col"></div>')); $('#slide-nav.navbar-default').after($('<div id="navbar-height-col"></d
Read more